Can someone tell me what I'm doing wrong here?

[dastaten]

I'm using this link...

 

<a href="view.php?id=2">link</a>

 

to pass the "id = 2" to another page, view.php that contains this code...

 

include 'dbconn.php';

$id = $_GET['id'];

$query = "SELECT * FROM stories WHERE postid = '$id'";
$result = mysql_query($query);

$page = $result['title'];

echo $query . "<br /><br />";
echo $page;

 

the echo $query writes

SELECT * FROM stories WHERE postid = '2'

to the page, but the $page is coming up blank.  I'm still fairly new, so I have a feeling it's something easy that I'm just missing.  Any help would be greatly appreciated.

[wildteen88]

You need to use mysql_fetch_assoc

 

$result = mysql_query($query);

$row = mysql_fetch_assoc($result)

$page= $row['title'];

[dastaten]

Aaahhh, thanks so much!

[unkwntech]

Not to mention you should use mysql_real_escape_string() to prevent people from running their own queries on you database.

For more info see: http://www.php.net/manual/en/function.mysql-real-escape-string.php in preticular example #2