Authorizing From A mySQL Database

Can someone help me it really has been a while since I have done any sort of
PHP and even back then I was still learning.
So anyway my problem is that I have the following script which I am trying
to get to work to authorize a username and password then if it's correct
write a cookie.

The script is as follows:

//Start of script//

<?php
require("vars.php");
require("functions.php");
mysql_connect($db_host, $db_username, $db_pwd) or die("couldnt connect");;
mysql_select_db($db_name) or die("nah could select");

$query="SELECT * FROM wkd_members WHERE username='$uid'";

mysql_query($query);
if($md5_pwd == $query[1]){
setcookie("admin[0]", $uid, time()+3600);;
setcookie("admin[1]", $md5_pwd, time()+3600);;
header("Location: in.php");

} else {

echo('un and pwd incorrect');

}


mysql_close();
?>

//End of script//

The database is structures as follows:

Table: wkd_members
username | password

Any help would be greatly appreciated.

--
-- > The_Jester <--

-------------------------------------------

"Laying a carpet is... very much like making love to a beautiful woman.
You check the dimensions, lay her out on the floor, pin her down, walk all
over her.
If you're adventurous - like me - you might like to try an underlay." -
Swiss Tony

In article <_UXTa.6917$T77.744820@newsfep2-win.server.ntli.net>,
The_Jester <The_Jester@ntlworld.com> wrote:

> Any help would be greatly appreciated.

I used the method as explained on:
http://www.sitepoint.com/article/319/5

It's nice because you can replace the html code with includes. But
beware that as is, this code requires register_globals to be set to ON.

It handles sessions well but it can be adapted to use cookies if you
wish. Oh ya, you'll have to change it to use mySQL but no big deal.