[Resolved] searching with one word to find articles

[brockie99]

I am creating a feature on my site to allow the user to search through a list of articles that are stored in the mysql database, and pull up the results for them to view.
I am using an <input> box to allow the user to enter in their search word/s to search for an article. At the moment i am just searching through the names of the articles to find a result, but i am not sure if my SQL is correct.

	$select = mysql_query("SELECT * FROM article WHERE name = '$search';",$db);
				while ($myrow = mysql_fetch_array($select))
				{	
					printf("%s, ", $myrow["name"]);
				}

Where $search is the name of the input box

Can you help?

Thanks

[brockie99]

whoops, forgot to say that the names of the articles are more than one word in length, so the word that the user types in to search with must match any word in the sentence.
Thanks

[TheDefender]

Change the $POST to $GET if you are using the GET method instead of the POST method... Otherwise, this will work for you.

$select = mysql_query("SELECT * FROM article WHERE name LIKE '%".$_POST['search']."%'",$db); 

[brockie99]

still not getting any results. I am searching for a word in a sentence name that i put in to the database, so it should work. and i want it to display on the same page underneath the search box. Here is the code i have now:

<table width="30%" border="0">
<form action="membersArea.php" method="post">
<tr><td><input type="text" name="articleSearch"></td><td><input type="submit" name="search" value="Search"></td></tr>
</form>
</table>

<?php
			if ($search)
			{
				$db = mysql_connect("localhost", "******", "******");
				mysql_select_db("the-coff_maitland",$db);
				$select = mysql_query("SELECT * FROM article WHERE name LIKE '%".$_POST['search']."%'",$db);
				while ($myrow = mysql_fetch_array($select))
				{	
					printf("%s, ", $myrow["name"]);
				}
			}	
		?>	

Can't see what the problem is. i have even used the correct case(lower).
Thanks

[TheDefender]

Yeah, the case is fine, but the problem is your input name is not "search"... it's "articleSearch". Your submit button is named "search". Change it to the below code, and it should be fine...

<?php 
if ($search) 
{ 
    $db = mysql_connect("localhost", "******", "******"); 
    mysql_select_db("the-coff_maitland",$db); 
    $select = mysql_query("SELECT * FROM article WHERE name LIKE '%".$_POST['articleSearch']."%'",$db); 
    while ($myrow = mysql_fetch_array($select)) 
    {     

        printf("%s, ", $myrow["name"]); 
    } 
}     

?>

[brockie99]

haha, how dumb do i feel!!

thanks for that!!

[TheDefender]

Originally posted by brockie99
haha, how dumb do i feel!!

thanks for that!!

Not at all... We've all done it, and heck... I still do it 😃
Have a nice day/night.