A
Anonymous
Guest
Here's one that I use...
Code:
<center>
<?php
if(!$metode)
{
?>
<form method="post" action="<?php $PHP_SELF ?>">
Search by
<select name="metode">
<option selected value="field1">field1</option>
<option value="field2">field2</option>
<option value="field3">field3</option>
<option value="field4">field4</option>
</select>
<input type="text" name="search" size="25">
<input type="submit" value="Begin Searching!!">
</form>
<?php
}else{
?>
<form method="post" action="<?php $PHP_SELF ?>">
Search by
<select name="metode">
<option selected value="field1">field1</option>
<option value="field2">field2</option>
<option value="field3">field3</option>
<option value="field4">field4</option>
</select>
<input type="text" name="search" size="25">
<input type="submit" value="Begin Searching!!">
</form>
<?
include_once "ez_sql.php";
$query = mysql_query("SELECT * FROM `table` WHERE $metode
LIKE '%$search%' LIMIT 0, 30 ");
$num_rows=mysql_num_rows($query);
while ($row = mysql_fetch_array($query))
{
$field1=$row["field1"];
$field2=$row["field2"];
$field3=$row["field3"];
$field4=$row["field4"];
$field5=$row["field5"];
print ("
<center>
<form method=POST action=\"edit.php\">
<table width=500 cellspacing=0 cellpadding=0 border=1>
<tr>
<td>
<table width=500 cellspacing=0 cellpadding=0 border=0>
<tr>
<td><b>Field1</b></td>
<td><input type=text name=field1 value=\"$field1\"></td>
</tr>
<tr>
<td><b>Field2</b></td>
<td><input type=text name=field2 value=\"$field2\"></td>
</tr>
<tr>
<td><b>Field3</b></td>
<td><input type=text name=field3 value=\"$field3\"></td>
</tr>
<tr>
<td><b>Field4</b></td>
<td><input type=text name=field4 value=\"$field4\"></td>
</tr>
<tr>
<td colspan=2>
<input type=hidden name=field5 value=\"$field5\"></td>
</tr>
<tr>
<td colspan=2>
<center><input type=\"submit\" name=\"submit\" value=\"Edit\"></center>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
<br>
");
}
if(!$field5)
{
print "<center>No matches found.</center>";
}
else
{
print"$num_rows result(s) found.";
}
?>
<?php
}
?>
</center>