I'm stucked here becouse it's not so clear which method to use to be sure that it works.
This is the echoes and what is happening :
SQL SELECT paymentID FROM payments WHERE InvoiceID = 1 AND invoiceDate = 2013-01-15 AND customerID = 1 // Error while accessing database
I did check on DB and the record is not present . So I would like to go to INSERT routine.
$sql_check_payment = "SELECT paymentID FROM payments
WHERE InvoiceID = [glo_invoiceNr] AND invoiceDate = [glo_invoiceDate] AND customerID = [glo_customerID]";
sc_lookup(check_payment, $sql_check_payment);
ECHO " check_payment " . {check_payment[0][0]} . " SQL " . $sql_check_payment ;
//" This is the result of SQL ->
if (false == {check_payment})
{
ECHO " // Error while accessing database";
}
elseif ({check_payment}->EOF)
{
Echo " HERE I WILL DO INSERT routine" ;
}
else
{
Echo " HERE I WILL DO UPDATE routine" ;
}
}
elseif ([yes_no] == 2)
{
[yes_no]=0;
echo " DO NOT MAKE NOTHING ";
}
Where is mistake ?? How is the right way to make this check ? Everytime is a nightmare for me.
Bye
This is the echoes and what is happening :
SQL SELECT paymentID FROM payments WHERE InvoiceID = 1 AND invoiceDate = 2013-01-15 AND customerID = 1 // Error while accessing database
I did check on DB and the record is not present . So I would like to go to INSERT routine.
$sql_check_payment = "SELECT paymentID FROM payments
WHERE InvoiceID = [glo_invoiceNr] AND invoiceDate = [glo_invoiceDate] AND customerID = [glo_customerID]";
sc_lookup(check_payment, $sql_check_payment);
ECHO " check_payment " . {check_payment[0][0]} . " SQL " . $sql_check_payment ;
//" This is the result of SQL ->
if (false == {check_payment})
{
ECHO " // Error while accessing database";
}
elseif ({check_payment}->EOF)
{
Echo " HERE I WILL DO INSERT routine" ;
}
else
{
Echo " HERE I WILL DO UPDATE routine" ;
}
}
elseif ([yes_no] == 2)
{
[yes_no]=0;
echo " DO NOT MAKE NOTHING ";
}
Where is mistake ?? How is the right way to make this check ? Everytime is a nightmare for me.
Bye
Comment