[SOLVED] Resource ID 4?

[pugboy]

I am creating a shopping cart script for my site, and I am trying to test the store name function...

 

<?php
mysql_connect("localhost", "*****", "******") or die(mysql_error());
mysql_select_db("ffforum_shop") or die(mysql_error());
$sid = $_GET["id"];
$q = "SELECT title FROM user WHERE id = '" . $sid . "'";
$title = mysql_query($q);
?>

 

$title becmes "Resource ID #4"... Why is that? Shouldn't it output my shop title?

 

(Sorry, I am a MySQL n00b XD)

[lemmin]

mysql_query returns a result set.

<?php
mysql_connect("localhost", "*****", "******") or die(mysql_error());
mysql_select_db("ffforum_shop") or die(mysql_error());
$sid = $_GET["id"];
$q = "SELECT title FROM user WHERE id = '" . $sid . "'";
$title = mysql_query($q);
while ($row = mysql_fetch_assoc($title))
   echo $row['title'];
?>

[DarkWater]

@lemmin: Well, he's only going to have one row because he's using an ID to pull the right row.  Try:

 

<?php

mysql_connect("localhost", "*****", "******") or die(mysql_error());

mysql_select_db("ffforum_shop") or die(mysql_error());

$sid = $_GET["id"];

$q = "SELECT title FROM user WHERE id = '" . $sid . "'";

$result = mysql_query($q);

list($title) = mysql_fetch_assoc($result);

?>

 

 

[pugboy]

What should I echo?

 

$title = nothing

$title[0] = nothing

list($title) = error

[pugboy]

I guess it should have been mysql_fetch_array... Now it works

 

Thanks