Re: [php-list] Re: Query not working...switched servers

[Brian Cummiskey]

whoisquilty wrote:
> You have an error in your SQL syntax. Check the manual that corresponds to 
> your MySQL 
> server version for the right syntax to use near 'ORDER BY yearopen' at line 4
>   
Are you sure you have a field named yearopen?  :)
>
> Unfortunately, I can't find listed anywhere on my the phpMyAdmin site that 
> I'm using 
> anything that indicates what version of MySQL or PHP that is installed. The 
> version of 
> phpMyAdmin that is being used is 2.7.0.-pl2
>   
sometimes it says it on the front page on phpmyadmin.  if not, make a 
<?php php_info(); ?> script.  you can see it all there.