Warning: Variable $newrow is not an array or strin

[Anon]

The code looks like this (the lines that cause problems):

$result=mysql_query("SELECT takeaway FROM ads",$db);
if($newrow=mysql_fetch_field($result)) {
do {
$compare=str_replace("-","0",$newrow['takeaway']);

$takeaway is the third column in ads, it's a DATE column. I want to compare it with another date, therefore I want to replace "-" with "0" so it would be easy to compare. I've tried fetching the whole row, I tried ereg_replace, nothing seems to work, I keep getting this warning. First comes the error message and then comes this: 32000001001 3 ('takeaway' is the third column and the original date is 2000-01-01)
What to do? If you have suggestions, please let me know.
Thank you,
Kari V

[Anon]

Manuals are your friends.

-- Begin quote from manual --

mssql_fetch_field

(PHP3 , PHP4 )

mssql_fetch_field -- Get field information

Description

object mssql_fetch_field (int result [, int field_offset])

Returns an object containing field information.

-- End quote from manual --

So this function returns an OBJECT, not an array.

change to:

$newrow=mysq_fetch_array($result,MYSQL_ASSOC);

and get the value you want using this:

$the_field_i_wanted=$newrow["takeaway"];