[RESOLVED] or die isn't working.

Jazzy_Girl

Hi, can anyone see why this "or die" statement at the end isn't working when someone enters a name that isn't found? Right now if you put in a name that isn't in the database, the page just returns blank. And I would like an error to appear.

<?php
$con = mysql_connect("mysql","test","password")
OR die('Could not connect: ' . mysql_error());

mysql_select_db("test", $con) OR die(mysql_error());

if(!$POST){?><form action="" method="post>
<input type="text" size="12" name="name" value="<?=$POST['name'] ?>" />  <input type="submit" style="width:107px" value="Check name" /></form><?}
else{$modify = mysql_real_escape_string($_POST['name']);

$query = "SELECT name FROM checkname WHERE name = '$modify'";
$result = mysql_query($query) or die('Error in name.' . mysql_error());

The just above "or die," error after the query, won't appear, when a name in the database isn't found. Need to fix it. Thank you very much.

ClarkF1

If the name in the database isn't found it will just return an empty result set which you can check for using mysql_num_rows($result)

If the name isn't in the database it will equal 0

It won't return the output in the die statement unless there's an error in the query such as a syntax error

Jazzy_Girl

OK. Can someone please help with how I can use mysql_num_rows($result)
to launch an error message when the name isn't found? I looked at the phpmanual link, can't see any good examples for what I need. Thankuuuuu

ClarkF1

$con = mysql_connect("mysql","test","password")
OR die('Could not connect: ' . mysql_error());
mysql_select_db("test", $con) OR die(mysql_error());
if(!$_POST){?><form action="" method="post>
<input type="text" size="12" name="name" value="<?=$_POST['name'] ?>" />&nbsp;&nbsp;<input type="submit" style="width:107px" value="Check name" /></form><?}
else{$modify = mysql_real_escape_string($_POST['name']);
$query = "SELECT name FROM checkname WHERE name = '$modify'";
$result = mysql_query($query) or die('Error in name.' . mysql_error());

if (mysql_num_rows($result) == 0)
{
echo "$modify was not found in the database"; //or whatever error message you want
}
else
{
//whatever you are going to do to the name in the database if it is there goes here
}

Jazzy_Girl

Works perfectly, thanks!! Gifts on their way.