Returning one row from database

Anon

Can anyone please help? I am writing a login script that checks a username and password against a database (mySQL). Therefore I have:

$result=myqsl_query("SELECT * FROM $db_table WHERE username = $username AND password = $password");

But where do I go from here? I actually want to create a cookie based on the ID of the row that is returned. Nothing I have tried seems to work, so assuming I have everything else correct and the username and password exist in the database, what should my next lines of code be?

I know how to create the cookie, but I don't know how to get the data I want. Surely I don't have to return the $result as an array? (Besides I have tried this and it didn't like it!).

Please someone enlighten me!!!

nashirak

Why try and make your own cookies and keep up with em from page to page when PHP already does that for ya.

http://www.php.net/manual/en/ref.session.php

This creates cookies and keeps up with the user for you. You could do it with your own cookies and session type stuff, but why code something twice.

What I would do from here is say:

if (MYSQL_NUM_ROWS($result) == 0) {
// the we couldnt find a password or username
else {

    //start a session

   session_start();
   session_register("USER");

    // Now we can use USER like a array

   $USER["name"] = $username;
    $USER["ID"] = mysql_result($result,0,"ID");
   or whatever else you want.....

then on everypage (before!!!!!!!!!!!) ANY html or ANY output to the browser do a session_start(); followed by a session_register("USER"); . I only stress ANY cause there have been a lot of problems posted to the board about getting warnings on there pages cause they outputed before they registered there sessions.

Hope that Helps! (And is what you want 🙂 )

Anon

Thanks for the advice.

The reason I want to create my own cookies is that the ID in the user database is essential to the way the rest of the site works, therefore the simplest way is to put the ID into a cookie. When a user joins up to my site they are assigned a unique ID number (the database ID). This ID number is then referrenced in other tables in the database, which means that only data relevant to that user is ever displayed.

Where I am getting stuck is the returning of one record from the database and assigning the ID as a variable to make into a cookie. For some reason I can't get the script to work as I want no matter what I try ;~(

No matter. Once again, thank you very much for your help.