If you really want to redirect and not just display a message that no
records were found, then this will work:
$num = mysql_numrows($result);
if ($num == 0)
{
header("Location: sorry.php");
exit;
} ELSE {
while ...
--- "Rankin, Randy" <[EMAIL PROTECTED]> wrote:
> Nato,
>
> Try something like this:
>
> $num = mysql_numrows($result);
> if ($num == 0)
>
> {
> echo "There were no records found.";
> }
> else
> while ...
>
> -----Original Message-----
> From: Natividad Castro [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 11:01 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] redirect a page
>
>
> 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
>
__________________________________________________
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
