diplaying only nut null fileds

[pcwizzzz]

Hi,
I'm having a problem when displaying the not null fileds.
Here is the piece of code that doesn't work:

  $sql2="SELECT * FROM preturi WHERE id_h=$idhh AND tip_cam LIKE '$tip_c[$i]'";
  $rez2=mysql_query($sql2);
  $row2=mysql_fetch_assoc($rez2);
   //header tabel
 if($row2['per']!="")
  {
      echo "<table border=1>";
      echo "<tr><th>Perioada</th>";
  }
    if($row2['sng']!="")
      {
        echo "<th>Pret in single</th>";
      }
    if($row2['dbl']!="")
      {
        echo "<th>Pret in duble</th>";
      }
      echo "</tr>";
      //continut tabel
  while($row2)
  {

  echo "<tr>";
  echo "<td>".$row2['per']."</td>";
  echo "<td>".$row2['sng']."</td>";
  echo "<td>".$row2['dbl']."</td>";
  echo "</tr>";
  }
  echo "</table>";
  mysql_free_result($rez2);

The problem is with while part, that's where my comp keeps thinking not showing anything. The rest i tested and seems ok.
Thanks

[cheese]

Hi pcwizzz,

How about looking at the problem this way......

<?php
//connect to the server

$sql_server = "yourserver";
$sql_username = "username";
$sql_password = "password";
$sql_database = "database";
global $sql_server;
global $sql_username;
global $sql_password;
global $sql_database;
$link = mysql_connect($sql_server, $sql_username, $sql_password)
        or die("Could not connect : " . mysql_error());
    mysql_select_db($sql_database) or die("Could not select database");

//the query

$query = mysql_query ("SELECT * FROM preturi WHERE id_h=$idhh AND tip_cam LIKE '$tip_c[$i]'") or die("Inside the appointments function - Bug Report Please." . mysql_error());

//top row of the on screen

print "<table>";
print "<tr>";
print "<td>Column 1</td>";
print "<td>Column 2</td>";
print "<td>Column 3</td>";
print "<td>Column 4</td>";
print "<td>Column 5</td>";
print "</tr>";

//prints the rows you want from the database to the onscreen table

while ($row = mysql_fetch_array($query, MYSQL_NUM))
{
if ($row[1] != '') //Change for your requirements - this would be second column in the datbase table
{
print "<tr>";
print "<td>". $row[0] ."</td>";
print "<td>". $row[1] ."</td>";
print "<td>". $row[2] ."</td>";
print "<td>". $row[3] ."</td>";
print "<td>". $row[4] ."</td>";
print "</tr>";
}
}

//close the onscreen table

print "</table>";
?>

Should do waht you want (I hope)

Cheers,

Neil.

[pcwizzzz]

Thanks,
But i have to check first to see which column is not null and then to output the header. Anyway, my code it worked finally but after i'd inserted some more data rows in the data base. Still working on it though.

[pcwizzzz]

I have another question regarding this piece of code.
So, first i check each row to determin the table's header:

if ($row[1]!="")
{
 echo "<th>Column 1</th>";
}
..................

then i loop through all the rows with

while($row=mysql_fetch_assoc($rez))
{

and then i have to show only the not null rows so i check again for all columns:

if ($row[1]!="")
{
echo "<td>".$row[1]."</td>";
}
.................

Does someone see a shorter way to write all this? I mean to loop somehow through all rows and columns so that to not check each of them one by one?
Just thinking it's too much code.
Thanks