View Single Post
  #5 (permalink)  
Old 27-02-2008, 22:28
MortimerJazz MortimerJazz is offline
Member
 
Join Date: Nov 2007
Posts: 49
Default

Yeah, the database is being selected fine.

The only error message I'm getting is:
Code:
Query failed: Unknown column 'castle' in 'where clause'
I get that when I'm using the following MySQL:

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"
); 
The string 'castle' is what is passed in the header. It should be the value of the 'type' field rather than the name of the column
Reply With Quote