how to display if no records

teamfox20

Hello,

Can i get some help, i dont get how to add the code to show if there is no records found into my current code. Can someone please help 😕

<?php require_once('Connections/mysql.php'); ?>
<?php
mysql_select_db($database_mysql, $mysql);
$query_rslist = "SELECT * FROM users";
$rslist = mysql_query($query_rslist, $mysql) or die(mysql_error());
$row_rslist = mysql_fetch_assoc($rslist);
$totalRows_rslist = mysql_num_rows($rslist);

<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 2</title>
</head>

<body>

<?php do { ?>
<form method="POST" action="delete.php">

<div align="center">
  <table width="619" border="2" align="center" id="table1" style="border-collapse: collapse">
	<tr bgcolor="#0000FF">
			<td width="116">			    <?php echo $row_Recordset1['ID']; ?></td>
			<td width="154"><?php echo $row_Recordset1['user_name']; ?></td>
			<td width="159"><?php echo $row_Recordset1['event_date']; ?></td>
			<td width="47"><?php echo $row_rslist['EDIT']; ?></td>
	  <td width="109"><a href="delete.php?ID=<?php echo $row_rslist['ID']; ?>"><?php echo $row_rslist['DELETE']; ?></a> </td>
	</tr>
  </table>
</div>
</form>
<?php } while ($row_rslist = mysql_fetch_assoc($rslist)); ?>

</body>

</html>
<?php
mysql_free_result($rslist);
?>

chyan

you can used mysql_num_rows to check whether your table has
a record or not, if there is a no record, mysql_num_rows will be given 0 result example

$query_rslist = "SELECT * FROM users"; //this is your query
$result=mysql_query($query_rslist)
$count=mysql_num_rows($result) // count record on your query

then....

if($count=="0"){
echo "Sorry, there is no record"
}

good luck..😉

teamfox20

Im so stupid with this code...

can you show me where to place it, i cant get it to work

chyan

okay then ... I will try to help you

<?php require_once('Connections/mysql.php'); ?> 
<?php 
mysql_select_db($database_mysql, $mysql); 
$query_rslist = "SELECT * FROM users"; 
$rslist = mysql_query($query_rslist, $mysql) or die(mysql_error()); 
$count=mysql_num_rows($rslist);  // count you record 

if($count=="0"){ 
echo "Sorry, there is no record" ;
echo "<input type=button value=back ONCLICK=self.history.back();>"; 
}

$row_rslist = mysql_fetch_assoc($rslist); 
$totalRows_rslist = mysql_num_rows($rslist); 

<html> 

<head> 
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> 
<title>New Page 2</title> 
</head> 

<body> 

<?php do { ?> 
<form method="POST" action="delete.php"> 

<div align="center"> 
  <table width="619" border="2" align="center" id="table1" style="border-collapse: collapse"> 
    <tr bgcolor="#0000FF"> 
            <td width="116">                <?php echo $row_Recordset1['ID']; ?></td> 
            <td width="154"><?php echo $row_Recordset1['user_name']; ?></td> 
            <td width="159"><?php echo $row_Recordset1['event_date']; ?></td> 
            <td width="47"><?php echo $row_rslist['EDIT']; ?></td> 
      <td width="109"><a href="delete.php?ID=<?php echo $row_rslist['ID']; ?>"><?php echo $row_rslist['DELETE']; ?></a> </td> 
    </tr> 
  </table> 
</div> 
</form> 
<?php } while ($row_rslist = mysql_fetch_assoc($rslist)); ?> 

</body> 

</html> 
<?php 
mysql_free_result($rslist); 
?>

teamfox20

ALMOST PERFECT 😃

if($count=="0"){  

echo "Sorry, there is no record"  

echo "<input type=button value=back onCLICK=self.history.back();>";  

}

You forgot the ; after echo "Sorry, there is no record" other than that its GREAT!! thank you!

sam_nasser

i think this will work... i have tested it and everything is fine