[PHP] local v remote

2007-05-31 Thread blueboy
On my localhost this works fine $result= mysql_query(SELECT date_format(date, '%d/%m/%Y') as date, title, id, display FROM NEWS); while ($row = mysql_fetch_assoc($result)) { but on my remote i get a mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource Can someone

Re: [PHP] local v remote

2007-05-31 Thread Robin Vickery
On 31/05/07, blueboy [EMAIL PROTECTED] wrote: On my localhost this works fine $result= mysql_query(SELECT date_format(date, '%d/%m/%Y') as date, title, id, display FROM NEWS); 1. check return values, $result should not be false unless there's a problem. 2. if $result is false, check

Re: [PHP] local v remote

2007-05-31 Thread Richard Lynch
On Thu, May 31, 2007 4:50 am, blueboy wrote: On my localhost this works fine $result= mysql_query(SELECT date_format(date, '%d/%m/%Y') as date, title, id, display FROM NEWS); while ($row = mysql_fetch_assoc($result)) { but on my remote i get a mysql_fetch_assoc(): supplied argument is not