November 22nd, 2012, 10:13 AM
Please can any one show me and error with that query
query('SELECT name, teacher, console\, price FROM games WHERE
console=\'Xbox\' OR console='\PS2\' ORDER BY Price DESC LIMIT 0,10');
November 22nd, 2012, 10:41 AM
November 22nd, 2012, 10:42 AM
You didn't escape the single quote properly at the beginning of PS2. I'm not sure why you are escaping a comma between console and price.
Also, not perl.
November 22nd, 2012, 10:44 AM
Looks like a PHP SQL query. Moving.
November 22nd, 2012, 11:01 AM
you don't need all the escaping if you just use double quotes for the string:
`console` IN ('Xbox', 'PS2')