-
Preluare date SQL
Salut, am urmatorul cod:
Cod PHP:
mysql_connect ( $dbhost, $dbuser, $dbpass) or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
$username=$_COOKIE["useru"];
$qtitle=$_POST["title"];
$content=$_POST["textu"];
$data=date("Y/m/d");
$uid="SELECT userid FROM users WHERE username='$username'";
$result=mysql_query($uid);
$query = "INSERT INTO questions (user, title, content, userid, date)
VALUES('$username', '$qtitle', '$content', '$result', '$data')";
mysql_query($query) or die(mysql_error());
mysql_close();
?>
Am tabelul users si tabelul questions. Vreau sa preia ID-ul userului logat din primul tabel si sa il bage in al doilea. Imi returneaza 0.
Poate vedea cineva unde e greseala ?
-
Inlocuieste :
Cod PHP:
;
$result=mysql_query($uid);
$query = "INSERT INTO questions (user, title, content, userid, date)
VALUES('$username', '$qtitle', '$content', '$result', '$data')";
cu:
Cod PHP:
;
$result=mysql_query($uid);
$row = mysql_fetch_assoc($result);
$userid = $row['userid'];
$query = "INSERT INTO questions (user, title, content, userid, date)
VALUES('$username', '$qtitle', '$content', '$userid', '$data')";
-
A mers, nu stiam comanda, merci.