Display data from a table...

[jonny_boy]

... but only if the field contains data.

I am new to php and learning as I go. I am wondering if someone could post some sample code to show how to check if a field for a certain record contains data and if so, display that data and if not hide an area of code.

For example, if I were doing a simple output of data from a table on a page in a table, then if there was data in a certain field, I would show a row of the table with the definition and the contents of the field. If there is no data in the field, then that row would not appear.

Hope that makes sense...

[enterume]

you could try sth like this:

 
mysql_connect("host","username","pass"); 
mysql_select_db("dbname"); 

#query the db 
$query = "SELECT * FROM table"; 
$result = mysql_query($query) 
or die(mysql_error()); 

#display results 
while($i = mysql_fetch_row($result)) { 
  if (!empty($i[0]) { //the table column that you want it to have data
      echo "<tr><td>".$i[0]."</td>";
      echo "<td>".$i[1]."</td>";
      ......
   }
} 

reference: http://www.php.net/manual/en/function.empty.php

[jonny_boy]

Thanks. I'll give it a shot and see how it works.