Select from database
Posted: Fri May 18, 2012 3:37 am
Hi,
I have no idea why this is happening,
I have this code:
I am 100% sure that the $invoice does not exist in the logis table and I keep getting "Order Number exist".
Joe
I have no idea why this is happening,
I have this code:
Code: Select all
$sql = mysql_query("SELECT * FROM logis WHERE OrderNum ='$invoice' LIMIT 1");
$existCount = mysql_num_rows($sql);
//if Order Number does not exist add the file details into the table database
if ($existCount == 0)
{ echo "Order Number does not exist"; }
else if ($existCount > 0)
{ echo "Order Number exist"; }
Joe