Simple IF/ELSE statements. Please Help!!!

[PcGeniusProductions]

Hi guys.

I am trying to create an addon for my chat script, and so far so good. I am stuck with a rather embarresingly simple PHP Statement.

 

The script below works fine, but I want it to display "Empty" if there are no SQL Results. E.g. If it returns values, then the Column is not empty, if it does not, the column IS empty, so display [echo "Empty";]

 

I cannot seem to do this. Here is my code. I will be grateful for any tips you can give me.

 

<?php
$sql = "SELECT column FROM table WHERE is_online = 1";
$results = mysql_query($sql);
$newline = "<br />";
while($row = mysql_fetch_array($results)) {
  echo "" . $row['column'] . "" . $newline . "";
}
?>

[GingerRobot]

Try using mysql_num_rows:

 

<?php
$sql = "SELECT column FROM table WHERE is_online = 1";
$results = mysql_query($sql);
if(mysql_num_rows($results) > 0){
  $newline = "<br />";
  while($row = mysql_fetch_array($results)) {
    echo "" . $row['column'] . "" . $newline . "";
  }
}else{
  echo 'Empty';
}
?>

[PcGeniusProductions]

Aha! This is what I was doing wrong. I had the "else" part setup OK. I just never told it what the else was reffering from. (if that makes sense )

 

GingerRobot, this is perfect. thank you very much!

 

Regards, Reece.

[zeeli]

Try this:

<?php
$sql = "SELECT column FROM table WHERE is_online = 1";
$results = mysql_query($sql);
$num_rows = mysql_num_rows($results);
$newline = "<br />";
if($num_rows > 0) {
  while($row = mysql_fetch_array($results)) {
    echo "" . $row['column'] . "" . $newline . "";
  }
} else {
  echo "Empty";
}
?>

 

EDIT: GingerRobot beat me 

 

Regards,

zEeLi

[PcGeniusProductions]

Hey Zeeli.

Regardless of who got there first, I am still very grateful for your willingness to help out.

 

I tried the scrips and they both work as I needed. Thanks guys