List and show inputs based on database count

[studgate]

hey guys, I am having a small problem and I can't wrap my head around it.

I want users to be able to upload up 10 photos in the database and what I want to do

is check the database to see how many pics they have already and if they have

10, just show the photo with action items but if they have 7 for example,  show the

7 pictures and three upload fields, if they have 4, show the pics and 6 fields and so on...

 

let me know what you guys think and some help.

Thanks in advance guys, you always come through...

[codefossa]

$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result))
{
    echo '<img src="' . $row['image_url'] . '" />';
}

for ($i = 0; $i < (10 - mysql_num_rows($result)); $i++)
{
    echo '<input type="" name="" />';
}

echo '<input type="submit" />';

[studgate]

thanks Kira  for getting in the right direction, i know what I have to do now plus your code works fine, just need to modified to fill my needs.