Sorry about the long code....
[PHP] <?php include("pass.php"); ?> [/PHP]
[HTML]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head><title>Agri Bonus</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../images/agridb.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="678" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#336699"><img src="../images/AB_BOTTOM.jpg" width="140" height="60"></td>
</tr>
<tr>
<td height="18" bgcolor="#D2E1F0">
<p align="center"><a href="admin.php">Admin</a> | <a href="admin-view-form.php">View a Membership</a> | <a href="admin-update-form.php">Update</a> |<a href="admin-dform.php"> Delete</a>| <a href="search.php">Search by Memberhip No </a>|<a href="globalsearch.php"> Global Search </a>|<a href="view.php"> View All Entries</a>| <a href="logout.php">Logout</a> </p>
</td>
</tr>
<tr>
<td height="280" align="center" valign="top" bgcolor="#FFFFFF">
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="46"><div align="center"><strong>Search for a Membership by a Membership Number</strong></div></td>
</tr>
<tr>
<td><div align="center"><form name="form" action="search.php" method="get">
<input name="q" id="q" type="text">
<input type="submit" name="Submit" value="Search" />
</form>
[/HTML]
[PHP]
<?php
// Get the search variable from URL
$var = @$_GET['q'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
// rows to return
$limit=10;
// check for an empty string and display a message.
if ($trimmed == "")
{
echo "<p>Please enter a search term.</p>";
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
include("database.php");
// Build SQL Query
$query = "select * from information where a1 like \"%$trimmed%\""; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
echo "<h4>Results</h4>";
echo "<p>Sorry, your search: "" . $trimmed . "" returned zero results</p>";
// google
echo "No Results was found, please try again";
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
// display what the person searched for
echo "<p>You searched for: "" . $var . ""</p>";
// begin to show results set
echo "Results <br/>";
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
echo "$count.) $title" ;
echo("<table width=\"670\" border=\"0\" align=\"center\" cellpadding=\"2\" cellspacing=\"2\" >
<tr>
<td height=\"31\"><span class=\"style1\">Registerded:</span> <span class=\"style2\">$row[a2]</span></td>
<td colspan=\"2\"><span class=\"style1\">Last Update:</span> $row[b2]</td>
</tr>
<tr>
<td width=\"283\">AgriBonues Lidnr./ Memership no </td>
<td colspan=\"2\"></td>
</tr>
<tr>
<td width=\"283\">Wagwoord / Password </td>
<td colspan=\"2\" class=\"style2\">$row[a3]</td>
</tr>
<tr>
<td>Titel / Title</td>
<td colspan=\"2\" class=\"style2\">$row[a4]</td>
</tr>
<tr>
<td>Voorletter(s)/Initial(s):</td>
<td colspan=\"2\" class=\"style2\">$row[a5]</td>
</tr>
<tr>
<td>Noemnaam/ First Name: </td>
<td colspan=\"2\" class=\"style2\">$row[a6]</td>
</tr>
<tr>
<td>Van / Surname</td>
<td colspan=\"2\" class=\"style2\">$row[a7]</td>
</tr>
<tr>
<td>ID Nr: </td>
<td colspan=\"2\" class=\"style2\">$row[a8]</td>
</tr>
<tr>
<td>Besigheidsnaam / Business Name </td>
<td colspan=\"2\" class=\"style2\">$row[a9]</td>
</tr>
<tr>
<td>Plaas naam / Farm Name </td>
<td colspan=\"2\" class=\"style2\">$row[a10]</td>
</tr>
<tr>
<td>E-Pos / E-mail</td>
<td colspan=\"2\" class=\"style2\">$row[a11]</td>
</tr>
<tr>
<td>Taalvoorkeur / Preferred Language </td>
<td colspan=\"2\"><span class=\"style2\">$row[a12] </span>Other:
<span class=\"style2\">$row[a13]</span></td>
</tr>
<tr>
<td>Posadres / Postal Address </td>
<td colspan=\"2\" class=\"style2\">$row[a14]</td>
</tr>
<tr>
<td>Telephone:</td>
<td colspan=\"2\" class=\"style2\">$row[a15]</td>
</tr>
<tr>
<td>Fax:</td>
<td colspan=\"2\" class=\"style2\">$row[a16]</td>
</tr>
<tr>
<td>Sel / Cell No </td>
<td colspan=\"2\" class=\"style2\">$row[a17]</td>
</tr>
<tr>
<td>Do you want sms text to you </td>
<td colspan=\"2\" class=\"style2\">$row[a18]</td>
</tr>
<tr>
<td>Landrosdistik / Magisterial distict </td>
<td colspan=\"2\" class=\"style2\">$row[a19]</td>
</tr>
<tr>
<td>Eskom Paalnr/pole no </td>
<td colspan=\"2\" class=\"style2\">$row[a20]</td>
</tr>
<tr>
<td>GPS koordinaat / co-ordinate </td>
<td colspan=\"2\" class=\"style2\">$row[a21]</td>
</tr>
<tr>
<td colspan=\"3\">Is jy 'n ladnbou boer, Are you an Agricultural Producer (Farmer)
<span class=\"style2\">$row[a22]</span></td>
</tr>
<tr>
<td>Aantal Arbeiders / No workers </td>
<td colspan=\"2\" class=\"style2\">$row[a23]</td>
</tr>
<tr>
<td> </td>
<td colspan=\"2\"> </td>
</tr>
<tr>
<td colspan=\"3\"><div align=\"center\">
<p><strong>Gewsproduksie / Crop Production <br>
</strong>Lys slegs 3... </p>
</div></td>
</tr>
<tr>
<td><strong>1. Somergraan /Summer grain: </strong></td>
<td class=\"style2\">$row[a24]</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td width=\"154\">Hectare</td>
<td width=\"209\">Insetverskaffers / suppliers </td>
</tr>
<tr>
<td class=\"style2\">1.1
$row[a25]</td>
<td width=\"154\" class=\"style2\">$row[a26]</td>
<td width=\"209\" class=\"style2\">$row[a27]</td>
</tr>
<tr>
<td class=\"style2\">1.2
$row[a28]</td>
<td class=\"style2\">$row[a29]</td>
<td class=\"style2\">$row[a30]</td>
</tr>
<tr>
<td class=\"style2\">1.3
$row[a31]</td>
<td class=\"style2\">$row[a32]</td>
<td class=\"style2\">$row[a33]</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><strong>2. Wintergraan/ Winter grain </strong></td>
<td class=\"style2\">$row[a34]</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Hectare</td>
<td>Insetverskaffers </td>
</tr>
<tr>
<td class=\"style2\">2.1
$row[a35]</td>
<td class=\"style2\">$row[a36]</td>
<td class=\"style2\">$row[a37]</td>
</tr>
<tr>
<td class=\"style2\">2.2
$row[a38]</td>
<td class=\"style2\">$row[a39]</td>
<td class=\"style2\">$row[a40]</td>
</tr>
<tr>
<td class=\"style2\">2.3
$row[a41]</td>
<td class=\"style2\">$row[a42]</td>
<td class=\"style2\">$row[a43]</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><strong>3. Oliesade / Oil seeds: </strong></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Hectare</td>
<td>Insetverskaffers </td>
</tr>
<tr>
<td class=\"style2\">3.1
$row[a44]</td>
<td class=\"style2\">$row[a45]</td>
<td class=\"style2\">$row[a46]</td>
</tr>
<tr>
<td class=\"style2\">3.2
$row[a47]</td>
<td class=\"style2\">$row[a48]</td>
<td class=\"style2\">$row[a49]</td>
</tr>
<tr>
<td class=\"style2\">3.3
$row[a50]</td>
<td class=\"style2\">$row[a51]</td>
<td class=\"style2\">$row[a52]</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><strong>4. Groente / Vegtables: </strong></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Hectare</td>
<td>Insetverskaffers </td>
</tr>
<tr>
<td class=\"style2\">4.1
$row[a53]</td>
<td class=\"style2\">$row[a54]</td>
<td class=\"style2\">$row[a55]</td>
</tr>
<tr>
<td class=\"style2\">4.2
$row[a56]</td>
<td class=\"style2\">$row[a57]</td>
<td class=\"style2\">$row[a58]</td>
</tr>
<tr>
<td class=\"style2\">4.3
$row[a59]</td>
<td class=\"style2\">$row[a60]</td>
<td class=\"style2\">$row[a61]</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td><strong>5. Vrugte & Neute / Fruits & Nuts </strong></td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td>Hectare</td>
<td>Insetverskaffers </td>
</tr>
<tr>
<td class=\"style2\">5.1
$row[a62]</td>
<td class=\"style2\">$row[a63]</td>
<td class=\"style2\">$row[a64]</td>
</tr>
<tr>
<td class=\"style2\">5.2
$row[a65]</td>
<td class=\"style2\">$row[a66]</td>
<td class=\"style2\">$row[a67]</td>
</tr>
<tr>
<td class=\"style2\">5.3
$row[a68]</td>
<td class=\"style2\">$row[a69]</td>
<td class=\"style2\">$row[a70]</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan=\"3\"><div align=\"center\"><strong>Diereproduksie</strong></div></td>
</tr>
<tr>
<td>6. Beeste / Cattle: </td>
<td class=\"style2\">$row[a71]</td>
<td>Hoeveel / Quantity:
<span class=\"style2\">$row[a72]</span></td>
</tr>
<tr>
<td>7. Skape / Sheep </td>
<td class=\"style2\">$row[a73]</td>
<td>Hoeveel / Quantity:
<span class=\"style2\">$row[a74]</span></td>
</tr>
<tr>
<td>8. Hoenders / Chickens </td>
<td class=\"style2\">$row[a75]</td>
<td>Hoeveel / Quantity:
<span class=\"style2\">$row[a76]</span></td>
</tr>
<tr>
<td>9. Varke / Pigs: </td>
<td class=\"style2\">$row[a77]</td>
<td>Hoeveel / Quantity:<span class=\"style2\"> $row[a78]</span></td>
</tr>
<tr>
<td>10. Wild / Game </td>
<td class=\"style2\">$row[a79]</td>
<td>Hoeveel / Quantity:
<span class=\"style2\">$row[a80]</span></td>
</tr>
<tr>
<td>11. Ander / Other </td>
<td class=\"style2\">$row[a81]</td>
<td>Hoeveel / Quantity:
<span class=\"style2\">$row[a82]</span></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td height=\"18\" colspan=\"3\"><div align=\"center\"><strong>Lys slegs u drie Grootste insetverskaffers / List only your three main input suppliers </strong></div></td>
</tr>
<tr>
<td><div align=\"center\" class=\"style2\">
$row[a83]
</div></td>
<td><div align=\"center\" class=\"style2\">
$row[a84]
</div></td>
<td><div align=\"center\" class=\"style2\">
$row[a85]
</div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td>Kooperasie / Landboubesigheid<br>
Co-op / Agricultural Business </td>
<td colspan=\"2\"><div align=\"center\">Lidnr. / Rek.nr. / folionr.<br>
Membership no / Acc no. / Folio </div></td>
</tr>
<tr>
<td class=\"style2\">1.
$row[a86]</td>
<td class=\"style2\">$row[a87]</td>
<td class=\"style2\">$row[a88]</td>
</tr>
<tr>
<td class=\"style2\">2.
$row[a89]</td>
<td class=\"style2\">$row[a90]</td>
<td class=\"style2\">$row[a91]</td>
</tr>
<tr>
<td class=\"style2\">3
$row[a92]</td>
<td class=\"style2\">$row[a93]</td>
<td class=\"style2\">$row[a94]</td>
</tr>
<tr>
<td class=\"style2\">4
$row[a95]</td>
<td class=\"style2\">$row[a96]</td>
<td class=\"style2\">$row[a97]</td>
</tr>
<tr>
<td class=\"style2\">5
$row[a98]</td>
<td class=\"style2\">$row[a99]</td>
<td class=\"style2\">$row[a100]</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td colspan=\"3\"><div align=\"center\"><strong>Agri will graag help / Agri want's to help </strong></div></td>
</tr>
<tr>
<td colspan=\"3\"><div align=\"center\" class=\"style2\">
$row[a101]
</div></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>");
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "<br />";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print " <a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a>  ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
// check to see if last page
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {
// not last page so give NEXT link
$news=$s+$limit;
echo " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";
}
$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo "<p>Showing results $b to $a of $numrows</p>";
?>
[/PHP]
[HTML]
</div></td>
</tr>
</table>
</td>
</tr>
<tr>
<td bgcolor="#336699"><div align="right"><img src="../images/AB_BOTTOM.jpg" width="140" height="60"></div></td>
</tr>
</table>
</body>
</html>
[/HTML]