[Resolved] "While" statement question

[curtisdw]

My program works great - it returns records when they are present, and nothing when, well there is nothing to return:

BUT -I want to return a message: "No records found" when there is nothing there - am I using the right statement or do I need a if/else loop instead... and if so how do I do that. Here is the code:

$result = mysql_query("SELECT FirstName,LastName,StreetAddress,City,State,Zip,Phone,Fax,Email,Website,PractitionerType,Specialty FROM Practitioners WHERE State='$State'");

echo "<table width='95%' border='0' cellspacing='2' cellpadding='2' class='body'>
<tr>
<td>";


while ($row = mysql_fetch_array($result))
{

	echo $row[FirstName];
	echo " ".$row[LastName]."<br>";
	echo $row[StreetAddress]."<br>";
	echo $row[City].", ";
	echo $row[State].".  ";
	echo $row[Zip]."<br>";
	echo $row[Phone]. " - ";
	echo "Fax:  ". $row[Fax] . "<br>";
	echo "<a href=\"mailto:".$row[Email]."\">" . $row[Email] . "</a><br>";
	echo "<a href=\"http://". $row[Website] . "\">" . $row[Website] . "</a><br>";
	echo "Type of Practitioner: " . $row[PractitionerType] . "<br>";
	echo "Specialty:  " . $row[Specialty] . "<br>";
	echo "<hr>";
	echo "</td>";
	echo "</tr>";

}
echo "</table>";[/COLOR]

[maxpup979]

check for numrows...then after the while and before the close table tag put an if statement--ie. if($rows<=0){echo "<tr><td> no rows found</td></tr>"}

[curtisdw]

Ok let me make sure I understand:

does the statement:
if($rows<=0){echo "<tr><td> no rows found</td></tr>"
}
Go right below the 'While' statement?
example:

while ($row = mysql_fetch_array($result))
{ if($rows<=0){echo "<tr><td> no rows found</td></tr>"}
~the rest of my 'echo $variables' statements

Or does that go another place? Thanks for your quick response thus far.

[LordShryku]

Originally posted by curtisdw
if($rows<=0){echo "<tr><td> no rows found</td></tr>"
}

How often do you return rows less than zero?

Anyway, here's what I would do....

$sql = "SELECT FirstName,
               LastName,
               StreetAddress,
               City,
               State,
               Zip,
               Phone,
               Fax,
               Email,
               Website,
               PractitionerType,
               Specialty 
        FROM   Practitioners 
        WHERE  State='".$State."'";

$result = mysql_query($sql); 
$rows = mysql_num_rows($result);

if($rows > 0) {
   echo "<table width=\"95%\" border=\"0\" cellspacing=\"2\" cellpadding=\"2\" class=\"body\"> 
           <tr> 
             <td>"; 

   while ($row = mysql_fetch_array($result)) {  

      echo  $row['FirstName']." ".$row['LastName']." 
            <br>".$row['StreetAddress']." 
            <br>".$row['City'].", ".$row['State'].". ".$row['Zip']." 
            <br>".$row['Phone']. " - Fax: ".$row['Fax']." 
            <br>" ."<a href=\"mailto:".$row['Email']."\">".$row['Email']."</a> 
            <br><a href=\"http://".$row['Website']."\">".$row['Website']."</a> 
            <br>Type of Practitioner: ".$row['PractitionerType']." 
            <br>Specialty: ".$row['Specialty']." 
            <br> 
            <hr> 
            </td> 
          </tr>";  

   }  

   echo "</table>";
}
else {
   echo "Not found";
}

[maxpup979]

To answer LordShryku's question--how often do you get rows less than 0?...only sometimes--a return of -1 for an error in a couple of older DB modules is not uncommon--Both MySQL and Postgres return false now though...😉

As for structure of where the if goes--
<table>
while(yadda){
}
if(rows<0) {#grin
echo "no records"}
echo "</table>"

[LordShryku]

Originally posted by maxpup979
To answer LordShryku's question--how often do you get rows less than 0?...only sometimes--a return of -1 for an error in a couple of older DB modules is not uncommon--Both MySQL and Postgres return false now though...😉

As for structure of where the if goes--
<table>
while(yadda){
}
if(rows<0) {#grin
echo "no records"}
echo "</table>"

Upgrade.

:p 😃

[curtisdw]

Ok let me make sure I understand:

does the statement:
if($rows<=0){echo "<tr><td> no rows found</td></tr>"
}
Go right below the 'While' statement?
example:

while ($row = mysql_fetch_array($result))
{ if($rows<=0){echo "<tr><td> no rows found</td></tr>"}
~the rest of my 'echo $variables' statements

Or does that go another place? Thanks for your quick response thus far.

[curtisdw]

Thank you for the help. That worked great.