[Resolved] No Records Found

[neo100101]

I have written this query to display records if they exist and if they do not display the message featured in the else statement... Does anyone see what I've done wrong? It seems to go directly to the else statement?

<?
$query2 = "SELECT l_name, f_name, app_position FROM pharmacist WHERE Ph_ID = '$Ph_ID'";
$result2 = mysql_db_query($database, $query2, $connection) or die ("Error in query: $query2. " . mysql_error());
$p_row = mysql_fetch_array( $result2 );

if ($p_row = mysql_fetch_array( $result2 ))
{
do {
?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; padding-left: 10; padding-right: 10; padding-top: 2; padding-bottom: 2" bordercolor="#EEEEEE" width="50%" id="AutoNumber2" align="left">
<tr bgcolor = "#086AA3">
<td width="50%"><font class='b8w'>Last Name, First Name</td>
<td width="25%"><font class='b8w'>Position</td>
<td width="25%"><font class='b8w'>Details</td>
</tr>
<tr bgcolor = "<? echo $color; ?>">
<td width="50%"><? echo $p_row[l_name]; ?>,&nbsp;<? echo $p_row[f_name]; ?></td>
<td width="25%"><? echo $p_row[app_position]; ?>&nbsp;</td>
<td width="25%"><a href="#">Details</a></td>
</tr>
</table>
<?
} while ($p_row = mysql_fetch_array($result2));

}
else
{
?>
<p align='left'><font class='b8'><? echo "NO PHARMACISTS HAVE BEEN RECORDED FOR THIS PHARMACY"; ?>
<?
}
?>

[mrhappiness]

did you check that $query2 contains what you expect it to contain?

[neo100101]

yep... whenever I run the script without the if... else statement it comes up with records on the ID I'm testing. I thought it might be something with the syntax?

[mrhappiness]

i asked cause i wasn't able to find a debug output like

echo $query2;

and i tried hard to find one 😃

[neo100101]

🙁

echo $query2;
echo $result2;

SELECT l_name, f_name, app_position FROM pharmacist WHERE Ph_ID = '70175;'Resource id #8

Seems to be working like the other queries?

[mrhappiness]

you really search for "70175;"?

did you try the query in phpmyadmin?

[neo100101]

yep... seems to work, brings me back the data according to Ph_ID?

[neo100101]

<?
// open connection to database
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");
// get Pharmacy Details Information
$query2 = "SELECT l_name, f_name, app_position FROM pharmacist WHERE Ph_ID = '$Ph_ID'";
$result2 = mysql_db_query($database, $query2, $connection) or die ("Error in query: $query2. " . mysql_error());
$p_row = mysql_fetch_array( $result2 );

if ($result2 == 0)
{
echo "NO RECORDS FOUND FOR THIS PHARMACY";
}
else
{
?>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse; padding-left: 10; padding-right: 10; padding-top: 2; padding-bottom: 2" bordercolor="#EEEEEE" width="50%" id="AutoNumber2" align="left">
<tr bgcolor = "#086AA3">
<td width="50%"><font class='b8w'>Last Name, First Name</td>
<td width="25%"><font class='b8w'>Position</td>
<td width="25%"><font class='b8w'>Details</td>
</tr>
<tr bgcolor = "<? echo $color; ?>">
<td width="50%"><? echo $p_row[l_name]; ?>,&nbsp;<? echo $p_row[f_name]; ?></td>
<td width="25%"><? echo $p_row[app_position]; ?>&nbsp;</td>
<td width="25%"><a href="#">Details</a></td>
</tr>
</table>
<?
}
?>

I've reworked the initial query and it still doesn't seem to work... When I enter a record that should have no associative data instead of getting the "echo "NO RECORDS FOUND FOR THIS PHARMACY";" I get an empty table? 😕

[neo100101]

he he he 😃

if(mysql_num_rows($result2)==0) was the key for all those who read this thread 🙂

query works like a charm 🙂