Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
NEWBIE Question on Literals
Hi No I am not running into problems with PHP, I am echoing $sql and making sure that the query string is exactly as it should be. I have read in my pursuits on the internet that the problem may lie in the version of the MySQL, the MySQL documentation talks about Meta Characters but does not... -
NEWBIE Question on Literals
Thank you for you answers but, I am afraid the single escape does not work either i.e. SELECT * FROM tbWebs WHERE URL='www.site.com\?ID=123' I am using PHP to connect through to MySQL database and have come with a workable solution using the urlencode and urdecode functions. I am storing the... -
NEWBIE Question on Literals
Hi Thanks, just tried it, it does not work. I have a field which has urls (URL) in a table (tbWebs) eg: "www.site.com?ID=123" I want to be able to do a search whether such a URL exists by doing the following SELECT * FROM tbWebs WHERE URL='www.site.com?ID=123' I tried your... -
NEWBIE Question on Literals
Hi I have a COLUMN in a databse which stores a URL. I need to add new URLs WHERE there is no copy in the table. The Problem is the WHERE clause when it comes to a string which has a '?' mark. I am using PHP to pass the stuff to the MySQL database. How can I pass a '?' (question mark) to the...
