Resource Id#

[Beeeeney]

Hi all. I'm a complete nub at PHP so I was wondering if anyone could help me out?

 

This code:

 

<?php

mysql_connect("localhost", "XXX", "XXX") || die('Error:' . mysql_error());
mysql_select_db("newsite");

$query = "SELECT * FROM `newsite` . `content`";
$post = mysql_query($query);

echo $post;

?>

 

Returns "resource id #4" to the browser.

 

Any ideas on how to get it to return the actual DB data?

 

Thanks in advance.

Edited October 9, 2012 by Beeeeney

[TOA]

mysql_query returns a resource ID you use with any of the fetch_ functions.

 

So use fetch_result or fetch_row or something similar.

 

For example

$post = $mysql_query($sql);
while ($row = mysql_fetch_row($post)) {
 echo $row['somvalue'];
}

[Beeeeney]

It worked, thanks.