variable problem

[ade]

$inputdate = "";// value comes from button release form post from flash
$query = "SELECT * FROM news WHERE (date = '$inputdate')";
$result = mysql_query($query,$link_id) or die ("Query failed");
$data = mysql_fetch_row($result);

the problem is that $inputdate value is actually a mySql date
so it has the format 2003-07-10, and it has to kept that format.

whats happening is that php that php sees the value 2003-07-10 as a maths operation and not a string

[trooper]

Have you specified the date field as being of type date?

GM

[ade]

yeah mysql field is set as date type

what happens is the $inputdate = 2003-07-10; yyyy-mm-dd

when i echo back its $inputdate = 1986; hence the query doesnt work

[trooper]

take the (date = '$inputdate') out of the ()

Oh and incidentally "date" is a reserved word in mysql change that field to something else

HTH

GM

[ade]

i've checked the mysql manual using date as a column name doesnt make a difference and it doesnt seem to be in the word reserved list, page 347 of the manual.

the thing actually works fine when i put a value for $inputdate and force it as a string

the problem is php not preserving the value as a string

[HalfaBee]

Maybe FLASH is not keeping the data as a date.
You may have to use another character to seperate the numbers and convert it back in php.

eg FLASH date = "2003|07|30";

php
$date = str_replace( "|","-",$date );

Halfabee

[Jack_Slocum]

what happens is the $inputdate = 2003-07-10;

That's cause that is a mathmatical expression. Put quotes around it so php knows it's a string.

$inputdate = 2003-07-10;

should be

$inputdate = '2003-07-10';

or

$inputdate = "2003-07-10";