Re: [PHP] Re: local v remote

2007-05-31 Thread Richard Lynch
On Thu, May 31, 2007 8:07 am, M. Sokolewicz wrote: > In case you didn't know, 99% of code on this planet using mysql_query > does not supply the secondary argument as most code-bases don't use > > 1 > connection in the same script. That does not make it a Good Practice... I spent days fixing some

[PHP] Re: local v remote

2007-05-31 Thread M. Sokolewicz
Jared Farrish wrote: Jared Farrish 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 a

[PHP] Re: local v remote

2007-05-31 Thread Jared Farrish
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 exp

[PHP] Re: local v remote

2007-05-31 Thread Darren Whitlen
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 a valid MySQL result resource