[RESOLVED] Need help with cookies

[Double_M]

Hi im trying to set a cookie to a database value.

heres some code:

// "SELECT RefNumber FROM Warrants";
$query_ref = "SELECT RefNumber FROM Warrants";
//$ref = mysql_query($query_ref, $localhost) or die(mysql_error());
//$row_ref = mysql_fetch_assoc($ref);
//$value = $row_Warrants[RefNumber]; //'here';
setcookie("user", $query_ref());

tried lots of things, but i think i need to get the value from the database and then set it to a variable and then cookie.

Any replys apreciated.

[bogu]

Dont u have more records in your DB table "Warrants", if u do u need a where condition of witch value do u want ...

$query_ref = "SELECT RefNumber FROM Warrants WHERE ....";

Your question is how to extract values from DB?
Here is a little example based from your code:

$query_ref = "SELECT RefNumber FROM Warrants"; 
$ref = mysql_query($query_ref) or die(mysql_error()); 
if (mysql_num_rows($ref)) {
    while ($row_ref = mysql_fetch_assoc($ref)) {
        $records[] = $row_ref;
    }
    echo "<pre>",print_r($records,1),"</pre>";
} else {
    echo "The SELECT extract zero records!";
}

If u have problem setting up cookies, then u should check here.

[Double_M]

Well first i insert a record into the database, and then i want to bring back the auto incremented value in the newly created table row. Then set the auto increment value to the cookie. And then of course retrieve the cookie afterwards at any time.

Hope that explains it alright.

Thanks.

[bogu]

Why don't u say that from the beginning?
mysql_insert_id

[Double_M]

Thats done the trick 🙂 thanks alot for your help.