View Single Post
  #1 (permalink)  
Old 27-02-2008, 21:37
MortimerJazz MortimerJazz is offline
Member
 
Join Date: Nov 2007
Posts: 49
Default MySQL driving me crazy - a server issue?

I'm transferring some php scripts from one server to my new eukhost.

However, for some reason the MySQL isn't working - and it's driving me mad!!

Here's the PHP I'm using:

PHP Code:
$recent_sql mysql_query("SELECT id, 
                            title, 
                            type, 
                            price,
                            description, 
                            hire, 
                            age, 
                            adults, 
                            requirements, 
                            overnight, 
                            picture, 
                            dim, 
                            gallerypics
                              FROM range 
                            WHERE type='$choice'
                            ORDER BY price ASC"
); 
I keep being told though that that "supplied argument is not a valid MySQL result resource."

Is there any reason behind the scenes why this wouldn't work? As I can't see anything wrong with it, and as I said it worked on my previous server.

ANY help would be REALLY appreciated!!
Reply With Quote