redirection depending on form input

[Anon]

I intend on using a form with one field, as below:

<form name=redirect action=login.php method=post>
<input type=text name=username>
</form>

what i then want to happen is for the username to be looked up in a database
and then the page will redirect to

mywebsite/gallery/index.php?cat_id=3&action=images

the corresponding cat_id value will be used, i.e.

mywebsite/gallery/index.php?cat_id=('$cat_id')&action=images

or however you do it.

the 2 rows are called "name" and "cat_id"

I've got the calling the database (i.e. 1st 3 lines of code) and the redirect bit, but i'm not sure about what to use in between, to get the data and how to inset the cat_id value into the redirect url!

thanks for any help in advance

Matt

[Anon]

first

Your sql satement

$sql="select * from table whwre userid='$userid' and password='$password'";

$result=mysql_query($sql);
$num=mysql_num_rows($result);

if($num !=0)
{
header("Location: mywebsite/gallery/index.php?cat_id=3&action=images");
}
else
{
echo("error");
}

if this is not so.. then please explain a bit your problem..

[Anon]

THIS BIT:

header("Location: mywebsite/gallery/index.php?cat_id=3&action=images");

the cat_id=3 needs to be relatvie i.e. cat_id=(the actually cat_id value for that specific user!!!

so i need to get that value from the database as well and redirect acording to the corresponding username!!!

gettit?

thanks

Matt