Results 1 to 6 of 6
May 21, 2003, 02:25 #1
- Join Date
- Nov 2002
- North West, UK
- 0 Post(s)
- 0 Thread(s)
SQL works on the page but chokes the validator !
I ve got my page up and running and everything seems fine when viewed through a browser but when I try and validate the code (using Position Tech's validator) I get an mysql error.
It doesn't happen on all the sql just on a couple of bits, both of which work fine when pasted into phpMyadmin.
The code in question is :
$ticketlist4 = @mysql_query( "SELECT ParkName, Parkurl FROM TicketsParks WHERE ParkDestination=$did AND ID<>$pid ORDER BY ParkName");
and the response from the validator is : Error performing query: You have an error in your SQL syntax near 'AND ID<> ORDER BY ParkName'
Any ideas what's going on?