incomplet result

pcwizzzz

Hi there,
My sql query works ok but when it comes to output i dont get the first row. I think this is happening cause i first check to see which row is not empty so that to output the table hearder and then i loop through query but i dont figure out how to write it other way. Please give me a hint.

$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 "<b><font color=#DC143C size=2>".$tip_c[$i]."</font>";
      echo "<table border=1 class=tab>";
      echo "<tr><th>Perioada</th>";
  }
.............
while($row2=mysql_fetch_assoc($rez2))
    {
      echo "<tr>";
      echo "<td><center>".$row2['per']."&nbsp"."</td>";

  if($row2['sng']!="")
  {
  echo "<td><center>".$row2['sng']."&nbsp".$row2['moneda']."</td>";
  }
.........
    }

Thanks

devinemke

you need to call [man]mysql_data_seek[/man]

pcwizzzz

Thanks alot.

tekky

I fail to see why he should use mysql_data_seek, he should just eliminate that line of code properly

$sql2="SELECT * FROM preturi WHERE id_h=$idhh AND tip_cam LIKE '$tip_c[$i]'";
  $rez2=mysql_query($sql2);
//instead of this --  $row2=mysql_fetch_assoc($rez2);
if (mysql_num_rows($rez2) > 0) //check for more than 0 results
  //header tabel
 //this becomes obsolete -- if($row2['per']!="")
  {   echo "<b><font color=#DC143C size=2>".$tip_c[$i]."</font>";
      echo "<table border=1 class=tab>";
      echo "<tr><th>Perioada</th>";
  }
.............
while($row2=mysql_fetch_assoc($rez2)) //do your normal loop and you no longer miss the 1st row ;)
    {
      echo "<tr>";
      echo "<td><center>".$row2['per']."&nbsp"."</td>";

  if($row2['sng']!="")
  {
  echo "<td><center>".$row2['sng']."&nbsp".$row2['moneda']."</td>";
  }
.........
    }

and if your concern isnt 0 results but " " columns, then you should negate them in the query so you never recieve them

pcwizzzz

It's working with mysql_data_seek. I think you didn't get me well. I dont need to check for more than 0 rows but to check which column has data and to display them. I have different types of prices for each hotel and i need to display for each hotel only those prices that fits to it (not null). Checking which column contains data i actually loop once through the result so that the next loop to display data starts from the second row.