odbc_fetch_row help plz

_rhod

I want to get two things from the fetch row, but i wont let me

$result = odbc_exec( $db, "$picturename", "$usernameup" );
$result2 = odbc_exec($db, "$usernameup");

$n=0;
print ( "<table border = 0 cellspacing = 0 width = 600>");
while ( odbc_fetch_row( $result))
{
$picname=odbc_result($result,1);
$usernameup=odbc_result($result2,1);
print ( "<tr> <td>Picture Name: $picname</td></tr><tr> <td>Picture Submitted By: $usernameup</td></tr>");
print("<tr><td><a href=\"http://127.0.0.1/$picname\"><img src=\"$picname\" height=\"200\" width=\"200\" target=\"_blank\"></a></td></tr> ");

}

print("</table>");

that's my code, and i have the variables printed out, but it will only show all the entries for $picname but will only show the first entry in the database for $usernameup. I thought i could fix it by:
while ( odbc_fetch_row( $result, $result2)). But it didn't work. I was wondering if theres another way of displaying all the entries for the $usernameup variable from the database.

Thanks for your time

bad76

hi,
if the content of dbs is one to one you can add this in the while:

while ( odbc_fetch_row( $result))
{
odbc_fetch_row( $result2);

but only if num_row of $result is equal than of $result2...