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 argumen

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 mysql

[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 expal