[PHP-DB] redirect a page

[Natividad Castro]

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

RE: [PHP-DB] redirect a page

[John Hughes]

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