I need proper syntax/procedure for inserting a variable into a SELECT query...
Here's what I want to do:
Take this - $sql = 'SELECT name FROM galleries WHERE spec = XYZ'
where XYZ is a variable passed down from a query string.
What is the proper syntax/procedure for placing a variable in the above statement? I'm trying everything I can think of to no avail.
For what it's worth, I'm using MySQLi.
Thanks in advance for any help you can offer!
By hullabaloo in forum Database
Last Post: 06-10-2009, 06:32 AM
By vindhvp in forum Database
Last Post: 03-26-2009, 08:59 AM
By rkbnair in forum Database
Last Post: 01-15-2007, 05:52 PM
By Rab in forum VB Classic
Last Post: 07-25-2001, 01:45 PM
By Craig in forum Database
Last Post: 05-31-2000, 04:19 AM
Tags for this Thread
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL