[SOLVED] help a noob please

[pazza86]

hi everyone.

 

I'm a bit of a self taught noob who is learning the ropes, but im having some problems with a script that im writing.  What I am trying to do is enter a search term in a field (movie name) on one page and compare the field against data in the database (whether it be spelt right or not) and the next page display the corresponding data on one page.  I believe that i have the page that displays the information correct I just need some help with the query.  Please see the below mentioned script exerts and give a noob a hand :

 

$result = mysql_query("SELECT * FROM movie WHERE mname = '%$mnsearch%'");

 

The above line when the submit button is clicked displays the table header information with no data in any cell.

 

$result = mysql_query("SELECT * FROM movie WHERE mname LIKE '%$mnsearch%'");

 

This line displays the table fine, the only problem being that it selects all of the data in the table, even when the movie name is spelt correctly.

 

Any help would be great.

cheers

 

 

 

[lovesmith]

Try this

 

$result = mysql_query("SELECT * FROM movie WHERE mname LIKE '%".$mnsearch."%'");

 

 

This will display all the result that contains the string $mnsearch holds.

[pazza86]

thanks for the help.

 

for some reason though that is doing the same thing as before - displays the data correctly, but it displays the entire contents of the table instead of matching the string  ???

[Daniel0]

All content as in all rows or all content as in all columns for a single/couple (of) row(s)?

[pazza86]

rows on content - it displays correctly, it is just displaying the incorrect data ???

[lovesmith]

rows on content - it displays correctly, it is just displaying the incorrect data ???

First you type the search item in the text box then press search button and it is posted to another location rite?

Try to find first whether $mnsearch is empty or not

 

Do like this where you post the form

echo "<script>

alert('".$mnsearch."');

</script>";

i m sure you get empty message box.

Your problem occurred because $mnsearch is an empty string.

[pazza86]

ok u are looking at the worlds biggest noob.  The problem all along (and thanks to lovesmith for prompting the validation code) was the fact that i was missing an equals sign in the form code for the name attribute .