Page 1 of 1

Results Issues

Posted: Sat Jan 10, 2009 12:06 pm
by cupaball
Does anyone know why my results are missing the first result?

Code: Select all

 
<?php
mysql_select_db($database_connUser);
        
$result = mysql_query("SELECT * FROM port_tb WHERE design_type='website' ORDER BY date_enter DESC")
or die(mysql_error());
 
$row = mysql_fetch_array( $result );
 
while($row = mysql_fetch_array($result))
  {
echo '<div class="port">'; 
echo '<a class="thickbox" href="../' .$row['large_pic'].'">'; 
echo '<img src="../' .$row['small_pic'].'" alt="' .$row['comp_name']. '" />';
echo '</a>';
echo '<p>' .$row['comp_name']. '</p>';
echo '<p>' .$row['design_type']. '</p>';
echo '</li>';
echo '</div>';
  }
 
?>
 

Re: Results Issues

Posted: Sat Jan 10, 2009 12:43 pm
by jaoudestudios
Yes, you have fetch twice.