[RESOLVED] got a php variable in my query but it's not working...

[inso_]

Hello,

quite new to php i'm afraid, so this might be a pretty stupid question... Anyway, this is my query (or part of it):

$query_recordset_ketcan = "SELECT * FROM programs WHERE zender = 'ketcan' AND date = '$checkdate' ORDER BY id ASC";

and the $checkdate has:

<?php
$checkdate = date('Y-m-d');
?>

but it just doesn't seem to work...

The idea is that the $checkdate takes the date in that format from the server & compare that with the value in the database.

Thanks in advance for any help given!

[laserlight]

How does it not work?

[inso_]

well, i'm not getting any output at all from that query... beats me 😕

Works fine:
$query_recordset_ketcan = "SELECT * FROM programs WHERE zender = 'ketcan' ORDER BY id ASC";

Doesn't do anything:
$query_recordset_ketcan = "SELECT * FROM programs WHERE zender = 'ketcan' AND date = '$checkdate' ORDER BY id ASC";

[laserlight]

Print out $query_recordset_ketcan. What is the output?

[inso_]

hmm, feel like a real newbie now... but if you ment for me to do
<?php
print $query_recordset_ketcan
?>

then the result was this: SELECT * FROM programs WHERE zender = 'ketcan' AND date = '' ORDER BY id ASC

so it seems the variable is not there for some reason 😕

EDIT: :o putting the variable above the query helped... hides

[laserlight]

Good to see that you solved it. Remember to mark this thread as resolved using the thread tools.