[itssami]

Hey, I created a page album.php, it shows all the images of a user xxx. and its url is like album.php?nick=xxx. Now suppose there are 2 images in this user album, one image id is 111 and second image id is 112.now how i can link to the each image of the album so that it looks like , album.php?nick=xxx&image_id=111. and album.php?nick=xxx&image_id=112.
I hope you understand it.

[Nico]

You will have to post your code.

[itssami]

okay its here..please have a look.

PHP Code:

<?

ob_start();

include("config.php");

if (!$_GET[nick])

{

$getuser = mysql_query("SELECT * from users order by id asc");

while ($user = mysql_fetch_array($getuser))

{



echo ("<a href=\"album1.php?nick=$user[username]\">$user[username]</a><br />\n");



}

}

ELSE

{

$getuser = mysql_query("SELECT * from pictures where username = '$_GET[nick]'");

$usernum = mysql_num_rows($getuser);

if ($usernum == 0)

{

echo ("User Not Found");

}



else

{

while ($row = mysql_fetch_array($getuser)) { 

echo "<a href='funnypics/$row[link]' target='_blank'><img src=funnypics/$row[link] width='200px'></a><br>";



}

}

}

?>

[gorivo]

What are the fields of mysql tables `users` and `pictures` ?

[itssami]

i was just testing thats why i just created 2 tables, it can be done by only one table , users and in users i made the columns the user id, password, email, and image_id, etc. i hope you understand this.