Hi to all,
I have a search form where users can search for a specific record; up to now
is working fine, but what I would like to do is: if the record is not found,
redirect them to another page that says that record was not found. Can
anybody tell me how to do this? I already tried using this statement
if ( !mysql_fetch_array($result) ) {
include file // this the page that I want to redirect them, but it doen't
work
}
I would like to execute the first statement it's false:
e.g if name doesn't match with anything in the table, redirect to another
page
else execute the whole query.
$query = mysql_query("SELECT * from 150bk where trim(NAME) like '%" .
$legal_name . "%'");
while($query_data = mysql_fetch_array($query))
{
$id = trim($query_data[ID]);
$name = trim($query_data[NAME]);
$tracking_num = trim($query_data[TRACKING_NUMBER]);
$census = trim($query_data[CENSUS_NUM]);
$name_dba = trim($query_data[NAME_DBA]);
}
Any help, it's greatly appreciate
Thanks
Nato
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
