[SOLVED] Mysql Where datefield = dataparam in PHP

[silas101]

Hi there.

 

i have 2 forms. form 1 inputs a string exactly 2009-01-05

 

second form has DateFrom field as

$dfrom = $_POST['datefrom'];

  (which is correct to use)?

$dto = $dateto;    (which is correct to use)?

 

i have sql query as

$result = mysql_query("SELECT branch_name,Date

FROM 'Payments'

WHERE Date = {$dfrom}

ORDER BY Branch,Date desc");

 

if i take out the where.. query gets results

if i use date value in where...eg '2009-07-17' it returns results

i am thinking the $dfrom parameter is getting no value and that is why i get no error and just empty results.

 

how do i get the value of the datefield on the previous form into my query?

 

Thank you sooooooo much

[rhodesa]

You need quotes around it:

$result = mysql_query("SELECT branch_name,Date
FROM 'Payments'
WHERE Date = '{$dfrom}'
ORDER BY Branch,Date desc");

[silas101]

Thank youuuuuuuuuuuuuuuuuuuuuuuuuuuu

 

you are the savior of this man.

 

if ever you are in Africa, South Africa, remember to find me and i will organize a free car wash for your rented vehicle....

 

Thank you