using POST for search query

[seanisean]

I think its the syntax i'm not getting here using the post variable in the query something like this:

$name = $_POST['name'];

$get_name = mysql_query("SELECT * FROM name WHERE whatever LIKE '%$name%' LIMIT $from, $max_results");

this doesnt work and other methods ive tried dont work either ie'$name' $name '{$_POST['name']}' etc....

i think im just not getting the text value assigned properly in the query but hey i dont really know

any help appreciated

sean

[Piranha]

It is an easy mistake, you haven't selected where the database should search.

$get_name = mysql_query("SELECT * FROM name WHERE here you should insert the column you search LIKE '%$name%' LIMIT $from, $max_results");

I think you should use [man]mysql_real_escape_string[/man] to all variables to avoid database injection.

[seanisean]

sorry i just edited that it was a typo and not the problem

sean

[Piranha]

try this:

First store the sql in a variable, then echo it and test it in another programs such as PHPmyadmin. There you will get some more information. But normally it is possible to spot the problem when you echo the sql string.