Hi. I currently have the following select query in my PHP page.

PHP Code:

  <?$SQL = mysql_query("SELECT siteName FROM Sites");
  while($row = mysql_fetch_object($SQL)){?>  
    <tr>
      <td><?=$row->siteName;?></td>
    </tr>
  <?}?>

This quite simply gets the sitName value and creates a table row for each value. That is working fine.

However, there are only 15 entries in the table, but i want the results to create 24 rows. What i need is for the first 15 rows (or however many are in the table at that time) to display the siteName value, and the rest to be empty, or contain  

How would i do that?

PHP Code:

$query = mysql_query("SELECT siteName FROM Sites"); 
while ($row = mysql_fetch_assoc($query))
{
for ($i = 0; $i < 24; $i++)
     {
echo "<tr><td>".$row['siteName']."</td></tr>";
     }
} 


That should work

That didn't quite work easdesign.com. For each of the 15 entries in the database table, 24 rows were created - giving 360 rows. I need only 24 rows. The first 15 filled with the next value from the query, and the rest containing  

Oh yeah that.

PHP Code:

$query = mysql_query("SELECT siteName FROM Sites"); 
for ($j = 0; $row = mysql_fetch_assoc($query); $j++)
{
$tablerow[$j] = $row['siteName'];
}
$j = 0;

for ($i = 0; $i < 24; $i++)
{
echo "<tr><td>".$tablerow[$j]."</td></tr>";
$j = $j + 1;
} 


Now if you have more then 24 Site names it won't display anything over that. It's going to stop at 24 Results Period. Is that going to be a problem?

That is no problem at all. I always want exactly 24 rows regardless of how many entries there are.

I understand the logic behind your script, but for some reason, the array does not appear to be populating. Here is the code am using. (It is slightly different from the version i originally sent). I have added a line that displays the array. If you run the script, you can see the array is empty.

PHP Code:

   <? 
    $description=array();
    $price=array();
    $SQL = mysql_query("SELECT * FROM quotebreakdown WHERE projectID='$_REQUEST[projectID]' AND siteID='$_REQUEST[siteID]'"); 
    for ($j = 0; $details = mysql_fetch_assoc($SQL); $j++) {
      $description[$j] = $details->description;
    } 
    echo '<pre>'; print_r($description); echo '</pre>';?>

Here it is:

PHP Code:

$query = mysql_query("SELECT siteName FROM Sites"); 

$minrows = 24; $i=0; $res = true;
do{
    $row = mysql_fetch_object($query) ;
    if(($i>=$minrows) && (!$row->siteName)) { 
        $res = false;
    } else {
    echo "<tr><td>".$row->siteName."</td></tr>";
    $i++;
    }
} while ($res); 


That did the trick. Thanks for your help guys.

Hmm...
Do you want to kill your DB???

If you have, say, 3000 records in your db, this will get the 3000 records, and stop the parsing after 24...

Try to use a LIMIT clause in your query, you will at least prevent that...

SELECT siteName FROM Sites LIMIT 24 OFFSET 0

Thanks for the tip tripy. In reality i am going to have no more than 26-27 entries. It is just for a small system i am building that i intend to use at home.

It is good advice though, and i will include that as a matter of good practice.