Page 1 of 1

MySQL Query

Posted: Wed May 19, 2004 6:21 am
by Niko
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

Posted: Wed May 19, 2004 6:23 am
by dull1554

Code: Select all

$result = mysql_query("SELECT * FROM tblOrders WHERE orderPaymentReceived = '".$s0urce."'");

Even too much

Posted: Wed May 19, 2004 7:06 am
by Lord Sauron

Code: Select all

<?php


$result = mysql_query("SELECT * FROM tblOrders WHERE orderPaymentReceived = ".$s0urce.";", "Cannot perform Query");

?>