[RESOLVED] Simple search script

[karemel]

Making my first steps into php, I've managed to get data out of a database 😃 . Then I started copying examples I'd seen for simple searches, so far I've got (which doesn't work):

<form method="POST" action="">
Search Word: <input type="text" name="search">
<input type="SUBMIT" value="Search!">
</form>
<?php

$connection = mysql_connect("localhost","username","password");
mysql_select_db("database",$connection);

$result = mysql_query("SELECT column1,column2 FROM table WHERE column1 LIKE '%$search%' OR column2 LIKE '%$search%'",$connection);

if($search){

while ($row = mysql_fetch_row($result))
{
for ($i=0; $i<mysql_num_fields($result); $i++)
echo $row[$i] . " ";
echo "<br />";
}
mysql_close($connection);
}
?>

I also tried this example (but I couldn't get it to work 😕 ):
http://www.phpfreaks.com/quickcode/Basic_MySQL_Search/12.php

[bogu]

U should add this line:

$result = mysql_query("SELECT column1,column2 FROM table WHERE column1 LIKE '%$search%' OR column2 LIKE '%$search%'",$connection);

in your if ..
And above if, u should add this:

$search = false;
if (!empty($_POST['search'])) $search = $_POST['search'];

[RedMaster]

Im not sure, but it is not nessessery to inform the query with the connection($connection)...
Try to use that

$result = mysql_query("SELECT column1,column2 FROM table WHERE column1 LIKE '%$search%' OR column2 LIKE '%$search%'");

Instead of

$result = mysql_query("SELECT column1,column2 FROM table WHERE column1 LIKE '%$search%' OR column2 LIKE '%$search%'",$connection);

[karemel]

It worked - Thankyou bogu , thankyou RedMaster

[bogu]

Now u can mark your thread RESOLVED.