Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Originally posted by zuessh $sql = "select * from phptest where name = Test";
$sql = "select * from phptest where name = "Test";
You need to quote strings. Remember that if you doing this via PHP and you are holding your query in a variable first then you'll need to either delimit the speachmarks or user single quotes, so
$query = "select * from phptest where name = \"test\"";
$query = "select * from phptest where name = 'test'";
As for SQL resources, I'm not sure really, what do you get if you just google for "SQL tutorial"? I'd guess that you might hit some good material at universities as basic SQL seems a favourite on many computing related degrees.