louis_coetzee Posted June 25, 2009 Share Posted June 25, 2009 $query = pg_query("SELECT 'STOCK'.'DESCRIPTION' FROM 'STOCK' WHERE 'STOCK'.'DESCRIPTION' LIKE '$queryString%' LIMIT 10"); I get an error here. maby my syntax is wrong Link to comment https://forums.phpfreaks.com/topic/163631-please-help-me-fix-this-pg_query/ Share on other sites More sharing options...
chmpdog Posted June 25, 2009 Share Posted June 25, 2009 what is the error? Link to comment https://forums.phpfreaks.com/topic/163631-please-help-me-fix-this-pg_query/#findComment-863364 Share on other sites More sharing options...
louis_coetzee Posted June 25, 2009 Author Share Posted June 25, 2009 what is the error? The Error: Query failed: ERROR: column "$queryString%" does not exist at character 76 in /usr/www/dir/dir/dir/suggest.php on line 20 ERROR: There was a problem with the query. Link to comment https://forums.phpfreaks.com/topic/163631-please-help-me-fix-this-pg_query/#findComment-863372 Share on other sites More sharing options...
gevans Posted June 25, 2009 Share Posted June 25, 2009 Try it like this; $query = pg_query("SELECT `STOCK`.`DESCRIPTION` FROM `STOCK` WHERE `STOCK`.`DESCRIPTION` LIKE '$queryString%' LIMIT 10"); Link to comment https://forums.phpfreaks.com/topic/163631-please-help-me-fix-this-pg_query/#findComment-863374 Share on other sites More sharing options...
louis_coetzee Posted June 25, 2009 Author Share Posted June 25, 2009 nope! not working Link to comment https://forums.phpfreaks.com/topic/163631-please-help-me-fix-this-pg_query/#findComment-863377 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.