using form to

[abda53]

i got a image hosting site, i want to offer where the person can share pictures if they wanted to..

im trying to use a form, just a one boxer, where you can enter a peresons email, or some other special $code, and then it will use that $code to grab the database where that $code is assigned to the user, and then do something like a... select * from user where code=$code and allow=Y.. and then display the pictures in a new page, where only the allowed pictures are shown, like a 3 by 6 page..

something to that effect..
basically i need help/directions on how to go about doing this. i never used a form in this manner

any help would be appreciated

[Pig]

Can you be more specific, or perhaps walk us through an example? Do you mean to say that you want visitors to have to know the name and a secret code to access one of your users pictures? And that if successful, you want to display all of the results in a 3x6 fashion?

<?php

if( !isset($user) || !isset($code) )
{
     echo("
          <form action=\"$_SERVER['PHP_SELF']\" method=get>
          <input type=text name=user>
          <input type=text name=code>
          <input type=submit value=go>
          </form>
     ");
}
else
{
     $result = mysql_query("SELECT user_id FROM user WHERE user_code='$code' AND user_uname='$user'");
     if( mysql_num_rows != 1 )
     {
          echo("That user/code combination was not found in our database.");
     }
     else
     {
          $row = mysql_fetch_row($result);
          $result = mysql_query("SELECT * FROM userimages WHERE userimages_user_id='$row[0]'");
     }
}

That will get you to the images. Read up on pagination to figure out how to spread them out over pages.

[abda53]

thats pretty much what im trying to go for thanks for putting me in the right direction