search no results

NTGre

hello Again!!!
& Happy new year to All👍

i m trying to make a search page.
the code is.....

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php
include("config.inc.php");


if(isset($_GET['search']))
{
$search = $_GET['search'];
}

$keywords = explode(" ", $search);

$query = "SELECT photo_id,photo_filename,photo_caption,photo_category,Gerne,First,Last,elm1,photo_category1,date_submited,enddate FROM gallery_photos " .
"WHERE First LIKE '%".$keywords['0']."%'";

for ($i=1; $i<count($keywords); $i++) {
$query = $query." OR First LIKE '%".$keywords[$i]."%'";
}

$result = mysql_query($query) or die(mysql_error());
?>
<center>
<form method="GET" action="search1.php">
<b>Search:</b> <input type="text" name="search" size="20" />
<input type="submit" value="Search!" />
</form>
<table width="50%" style="border:1px solid #000000;">
<?php
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td style='border-bottom: 1px solid #000000;'>";
echo "<b>".$row['photo_caption']."</b>";
echo "<p>".$row['First']."</p>";
echo "<p>".$row['Last']."</p>";
echo "<p>".$row['photo_filename']."</p>";
echo "<p>".$row['photo_category1']."</p>";
echo "<p>".$row['enddate']."</p>";
echo "<b>".$row['date_submited']."</b>";
echo "</td>";
echo "</tr>";
}
?>
</td>
</tr>
</table>
<a href="HTMLinput.htm">Add new record to our DataBank.</a>
</center>
</body>
</html>

when i first load this page i m geting all the results of my table gallery_photos
but when im using the search field i dont get any results or errors😕

Can any1 Help me pls????

bpat1434

Seems to me your code should be like this:

<?php // This is just to get the highlighting right ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php
include("config.inc.php");


if(isset($_GET['search']))
{
	$search = $_GET['search'];
	?>
	<center>
	<table width="50%" style="border:1px solid #000000;">
	<?php
	$keywords = explode(" ", $search);

$query = "SELECT photo_id,photo_filename,photo_caption,photo_category,Gerne,First,Last,elm1,photo_category1,date_submited,enddate FROM gallery_photos " .
"WHERE First LIKE '%".$keywords['0']."%'";

for ($i=1; $i<count($keywords); $i++) {
	$query .= " OR First LIKE '%".$keywords[$i]."%'";
}

$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
	echo "<tr>";
	echo "<td style='border-bottom: 1px solid #000000;'>";
	echo "<b>".$row['photo_caption']."</b>";
	echo "<p>".$row['First']."</p>";
	echo "<p>".$row['Last']."</p>";
	echo "<p>".$row['photo_filename']."</p>";
	echo "<p>".$row['photo_category1']."</p>";
	echo "<p>".$row['enddate']."</p>";
	echo "<b>".$row['date_submited']."</b>";
	echo "</td>";
	echo "</tr>";
}
?>
</td>
</tr>
</table>
</center>
<?php
}
?>
<center>
<form method="GET" action="search1.php">
<b>Search:</b> <input type="text" name="search" size="20" />
<input type="submit" value="Search!" />
</form>
<a href="HTMLinput.htm">Add new record to our DataBank.</a>
</center>
</body>
</html>

~Brett

NTGre

that was FAST!!!

but seems that i got and another problem :eek:

i want the keywords to search in all the fields for results
i mean in...

photo_id,photo_filename,photo_caption,photo_category,Gerne,First,Last,elm1,photo_category1,date_submited,enddate FROM gallery_photos

i must change this ??-->"WHERE First LIKE ????

bpat1434

yes

To be something like:

WHERE First LIKE '%$keywords[0]%' OR photo_id LIKE....

Repeat that for each field.

~Brett

NTGre

yes !!! is working 🙂

one more LAST question .......i THINK🙂

This part

for ($i=1; $i<count($keywords); $i++) {
        $query .= " OR First LIKE '%".$keywords[$i]."%'";

if i understand right, counts the keywords and if there are more than 1 searches for the 2nd word in the results or in the entire table???

bpat1434

it counts the keywords: yes

If there are more than 1: It searches for it in the field

This query would search each field for each keyword:

$query = "SELECT photo_id,photo_filename,photo_caption,photo_category,Gerne,First,Last,elm1,photo_category1,date_submited,enddate FROM gallery_photos " .
    "WHERE First LIKE '%".$keywords['0']."%'";

for ($i=1; $i<count($keywords); $i++) {
    $kw = $keywords[$i];
    $query .= " OR First LIKE '%".$kw."%' 
    OR Last LIKE '%".$kw."%' 
    OR elm1 LIKE '%".$kw."%' 
    OR photo_category1 LIKE '%".$kw."%' 
    OR photo_caption LIKE '%".$kw."%' 
    OR photo_category LIKE '%".$kw."%' 
    OR photo_filename LIKE '%".$kw."%'";
}

~Brett

NTGre

is not working 🙁
when i search for 2words im geting this msg

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR First LIKE '%test%' OR Last LIKE '%test%'

bpat1434

That was just a guess, I don't normally search with mySQL, so I can't say for sure.

Have you googled it? Or tried reading the mySQL manual?

~Brett

NTGre

I will !!!
thnx anyway 😉