Results Issues

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
cupaball
Forum Commoner
Posts: 85
Joined: Sun Feb 12, 2006 1:46 pm

Results Issues

Post 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>';
  }
 
?>
 
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Results Issues

Post by jaoudestudios »

Yes, you have fetch twice.
Post Reply