Login to specified usernames

Hi all,

What I need to do, is add the zip code field to the code and when they log in - the page they go to has every user with the same zip code shown.

Does anyone know how to do this and point me in the right direction. Hopefully some helpful soul has done this before or can figure it out.

Thanks in advance.

Larry

It is not all that hard;

You table should become;

CREATE TABLE users (
username varchar(30),
zipp varchar(10)
password varchar(32));
(Note that the numberof characters depends on your location)

The insert would become:
$q = "INSERT INTO users VALUES ('$username', '$zippcode', '$password')";

And when the user is logged in you can:
$q = "SELECT * from users where zipp = $ThisUserZipp)";

Thanks I'll give it a try. That last line is something I wouldn't have figured out in a million years.

And when the user is logged in you can:
$q = "SELECT * from users where zipp = $ThisUserZipp)";

where should i add this code in register.php or login.php ????