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 > a > valid MySQL result resource > > Can someone expalin the problem? PHP version problem? The problem is probably that you never even managed to connect to the MySQL database in the first place... But it could be something else entirely. We can't tell you, but you can find out by using the mysql_error() function a lot. -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php