Preluare date SQL

[danP]

Salut, am urmatorul cod:

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 ?

[Cristi G]

Inlocuieste :

;
$result=mysql_query($uid);

$query = "INSERT INTO questions (user, title, content, userid, date)
VALUES('$username', '$qtitle', '$content', '$result', '$data')"; 

cu:

;
$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')"; 

[danP]

A mers, nu stiam comanda, merci.