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?

[sabu]

Well, the problem here starts where you make two queries instead of one. The second one, using the same variable names, cancels out the first one.

What you should do, and I can't help you directly without knowing more about the 'profiles' table, is look into the JOIN or INNER JOIN sql syntaxes, perhaps.

Your second problem is that you used extract($picture), which I feel is a bit dodgy, but whatever happened you ended up with an array anyway. Remember that $picture is the mysql array, perhaps you'd have more luck with something like this:

   echo "<td><a href='".$picture["username"]."/".$picture["picture"]."'><img src='".$picture["username"]."/td_".$picture["picture"]."'></a></td>\n";

Once you've got the joined array working.

[jannoy]

first thing is that it will not display corret query since

$query variable was already used.

try
use INNER JOINT QUery

$qry=" select * from table1 INNER join tabl2e on table1.id=table2.user_id where table2.id='jklassen';