MySQL Query
Posted: Wed May 19, 2004 6:21 am
Im creating a recordset filters on orderPaymentReceived,
The code below works fine.
However i need to replace the "y" with a varible, $source which will hold with y or n.
$result = mysql_query("SELECT * FROM tblOrders WHERE orderPaymentReceived = 'y'");
//---------------------------------------------------
My previous attempt
$result = mysql_query("SELECT * FROM tblOrders WHERE orderPaymentReceived = ". $source);
Dosnt work.
ANy ideas
The code below works fine.
However i need to replace the "y" with a varible, $source which will hold with y or n.
$result = mysql_query("SELECT * FROM tblOrders WHERE orderPaymentReceived = 'y'");
//---------------------------------------------------
My previous attempt
$result = mysql_query("SELECT * FROM tblOrders WHERE orderPaymentReceived = ". $source);
Dosnt work.
ANy ideas