Add variables to database!
Posted: Tue Jun 02, 2009 4:06 pm
Code: Select all
if(isset($_POST['doaddach'])) {
$username = 'snarkiest';
$user_id = mysql_query("SELECT id FROM ach_users WHERE username='$username' ",$connect);
$achievement_id = mysql_escape_string($_POST['addach']);
$result = mysql_query("
INSERT ach_achievements (`user_id`, `achievement_id`)
VALUES ('$user_id','$achievement_id')
",$connect);
echo $topview_ach;
echo "<table width='949' class='toutborder' cellspacing='2' cellpadding='2'><tr width='100%'><td class='tinborder' align='center' width='10%'>Message: Achievement added.</td></tr></table>";
echo $bottom;
}If I click doaddach, it inserts in database record where achievement_id = mysql_escape_string($_POST['addach']); until now everything is correct, but when it has to insert value $user_id it don't insert the correct value, it just inserts 0. But it should insert number 1 because "snarkiest" id is number 1.
Why so? When in database sql window I run this:
SELECT id FROM ach_users WHERE username='snarkiest'
It gives out the correct number. (In this case number 1)