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 :
where $pid and $did are passed in the url.
$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?