| Colin Copland 2006-05-23, 6:58 pm |
| X-No-Archive: Yes
Hi,
I am trying to write my first php script to query an SQL db. The db is
simple and has only two rows term and description. The search page is
so that the user can search for a technical term and get a small
description.
So far I have added a few records to the db and have simple script that
works fine. The only thing I would like to add is if the searched for
value is not in the term row then a error message should be returned. I
have tried to add in a else statement but have had no luck so far.
Search page (http://www.fullyconnected.co.uk/search.shtml)
===========
<form method="post" action="search.php">
<blockquote>
<p>Enter term to search for
<input type=text name='enteredterm' size=20 maxlength=20>
<input type=submit class="loginButton">
<input name="Reset" type="reset" class="loginButton"
value="Reset" />
</p>
</blockquote>
</form>
Search script (ttp://www.fullyconnected.co.uk/search.php)
=============
<?php
$con = mysql_connect("localhost","********","********");
if (!$con)
{die('Unable to connect to database: ' . mysql_error());
}
mysql_select_db("fullycon_search", $con);
$result = mysql_query("SELECT * FROM `Search` WHERE `term` =
'$enteredterm'");
while($row = mysql_fetch_array($result))
{
echo $row['term'];
echo "<br />";
echo $row['description'];
}
?>
db
==
Simple databse called fullycon_search with a table called search
containing two fields, term and description.
I would like to add in a else statement so that if the term searched for
is not in the db it would display a simple error message. Having tried
many times I cannot seem to get the syntax correct for the else
statement. Can anyone help? If anyone needs to try a sample search a
couple of terms in the table are cisco, linux, windows, stow......
It's all still very much a work in progress at present!
Thanks,
Colin
|