so far I have this on the search page
<form method="post" action="test.php">
<input name="search" type="text">
<input type="submit">
</form>
and this on the results page
<?php
$connect = @mysql_connect("localhost", "", "");
if (!$connect) {
echo( "<p>Unable to connect to the " .
"database server at this time.</p>" );
}
if (! @mysql_select_db("jokes") ) {
echo( "<p>Unable to locate the joke " .
"database at this time.</p>" );
}
?>
<?php
$query = "SELECT * FROM jokes WHERE id='$search'";
$result = @($query);
if (!$result) {
echo("<p>no result</p>");
exit();
}
while ( $row = mysql_fetch_array($result) ) {
echo("<p>" .$row["JokeText"].$row["JokeText1"].$row["id"]. "</p>");
}
?>
not returning any results though?? any pointers
