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
Can someone expalin the problem? PHP version problem?
No. It's MySQL problem.
If it works fine locally, then make sure the table structure is the same
on your remote database as it is on your local database.
---
mysql_query("SELECT date_format(date, '%d/%m/%Y') as date, title,
id, display FROM NEWS") or die(mysql_error());
---
Using that die statement will also help while debugging your script as
it will print out any errors that are caused by your SQL statement.
Which you then ask some mysql people if that is the case.
Darren
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
