SELECT query problem

rvdb86 · #1 (**permalink**) 12-01-08, 09:02

Hi hope some one can help me!
Let me quickly describe what I am trying to do. I have a stock system and I want to have a simple search where the user sumbits the poduct name, then the script find the product name in the tbl_products and returns the results.

I have the following SELECT query:

Code:

//This code runs if the form has been submitted
if (isset($_POST['submit'])) { 

$search_product = $_POST['search_product'];

// now we search the products table 
$query = "SELECT * FROM tbl_products WHERE product_name = $search_product";
$result = mysql_query($query)
	or die ("Search Query Fault");

For some reason this doesn't work

Any suggestions?

shammat · #2 (**permalink**) 12-01-08, 09:12

Quote:

Originally Posted by rvdb86

I have the following SELECT query:

I don't see a SQL query, you only posted PHP code.

What happens if you run the query without PHP?
Did you print the real SQL query that gets executed?

product_name sounds like the column could be a VARCHAR column.

Shouldn't $search_product be quoted then with single quotes inside the PHP code (note that I don't know PHP).

At least this would be necessary without PHP (because character literals need to be enclosed in single quotes)

mike_bike_kite · #3 (**permalink**) 12-01-08, 09:21

You don't have quotes around the product name that's being sent to MySQL.

Code:

$query = "SELECT * FROM tbl_products WHERE product_name = '$search_product'";

You could also increase the functionality of the search by allowing the user to just enter a part of the product name using the following SQL :

Code:

$query = "SELECT * FROM tbl_products WHERE product_name like '%$search_product%'";

It wouldn't be a bad idea if you showed the SQL being executed when you get a fail ie :

Code:

$result = mysql_query($query)	or die ("Search Query Fault : $query");

You could also add the error message as well.

EDIT : Sorry shammat - you must of posted while I was typing.

shammat · #4 (**permalink**) 12-01-08, 09:37

Quote:

Originally Posted by mike_bike_kite

EDIT : Sorry shammat - you must of posted while I was typing.

Happens to me all the time...

rvdb86 · #5 (**permalink**) 12-01-08, 10:14

hey guys, thanks so much
all i can offer you in return is my gratitude!

Internet Services

Web Development

Digital Marketing

Consumer Tech