mysql array troubles

[lives4him06]

I have the following code:

 $MAX_COLS=3;

$id = current ($HTTP_GET_VARS);

$query = "Select picture FROM pictures where id='jklassen'";
$result = mysql_query($query);

$query = "Select username FROM profiles where id='jklassen'";
$result = mysql_query($query);


echo "<table border ='0'>\n<tr>\n";
$i=0;
while($picture = mysql_fetch_array($result))
{
   if ($i % $MAX_COLS==0) 
	{
	   echo "<tr>\n";
	}
   extract($picture);
   echo "<td><a href='$username/$picture'><img src='$username/td_$picture'></a></td>\n";
   if (($i+1) % $MAX_COLS==0) 
   {
	   echo "</tr>\n";
	}
	$i++;
}
echo "</tr>\n</table>\n"; 

and the following contents of the database:

+-------+-------------------+----------+
| picID | picture | id |
+-------+-------------------+----------+
| 1 | homecoming(1).JPG | jklassen |
| 2 | homecoming(2).JPG | jklassen |
| 3 | 1.jpg | jklassen |
| 4 | beetle2.jpg | jklassen |
+-------+-------------------+----------+

the output is the following:

<table border ='0'>
<tr>
<tr>
<td><a href='lives4him06/Array'><img src='lives4him06/td_Array'></a></td>
</tr>
</table>

I want to place each picture in a table with 3 columns and as many rows as needed. But the pictures are not being read from the mysql array correctly. How do i fix this?

[georgeb]

notice these lines:

$query = "Select picture FROM pictures where id='jklassen'";
$result = mysql_query($query);

$query = "Select username FROM profiles where id='jklassen'";
$result = mysql_query($query);

echo "<table border ='0'>\n<tr>\n";
$i=0;
while($picture = mysql_fetch_array($result))

your second $query and $result are overwriting your first $query and $result, so in your while($picture = mysql_fetch_array($result)) statement, you're really saying fetch the array of matching pictures, but you're passing it the query that selects the profile. Make sense?

So change those lines to:

$query_pic = "Select picture FROM pictures where id='jklassen'";
$result_pic = mysql_query($query_pic);

$query_profile = "Select username FROM profiles where id='jklassen'";
$result_profile = mysql_query($query_profile);

echo "<table border ='0'>\n<tr>\n";
$i=0;
while($picture = mysql_fetch_array($result_pic))

hope that helps!