Testing for Empty Record

dcjones

Hi All,

I need to test for an empty record in a data table.

This is what I have: If the record is found carry on and execute the rest of the script, if member_id is empty redirect to another page. I am not to sure how to do this:

My Script (part)

$colname_owners = "-1";
if (isset($POST['pin'])) {
$colname_owners = (get_magic_quotes_gpc()) ? $POST['pin'] : addslashes($_POST['pin']);
}
mysql_select_db($database_baggageppin, $baggageppin);
$query_owners = sprintf("SELECT * FROM amember_baggagemembers WHERE member_id = %s", GetSQLValueString($colname_owners, "int"));
$owners = mysql_query($query_owners, $baggageppin) or die(mysql_error());
$row_owners = mysql_fetch_assoc($owners);
$totalRows_owners = mysql_num_rows($owners);

if (empty(member_id)) *load another script
else
continue with this script *

If anyone can help please.

OniLink

I'm not sure if this is correct, but wouldn't it be:

if (empty($row_owners['member_id'])) *load another script *

dcjones

Hi, and thanks for your reply.

I have changed the script to:

if (empty($row_owners['member_id'])) *load another script *

but if I want another page to load if "member_id" is empty how do I call the other page.

i.e.

if (empty($row_owners['member_id'])) "<a href="http://mydomain.com/null_return.php"></a>;

Thanks for any help.

OniLink

You could do this:

if (empty($row_owners['member_id'])) {
echo '<meta http-equiv="refresh" content="url=http://mydomain.com/null_return.php" />';
} else {
// continue

dcjones

Hi OniLink, thanks for your reply again,

I have used the code you kindly gave but it errors, please see below.

Parse error: parse error, unexpected $ in /homepages/41/d43000764/htdocs/baggagepin/baggage/agents/agents_search_results.php on line 266

Line 266 is the very last line in the script.

Any ideas what is happening.

Many thanks again.

bradgrafelman

Did you fill in the " // continue" part with what your script to do if the if() statement evaulates to FALSE ?

If you did, did you also add a closing '}' (OniLink didn't include one in his post) ?