query without loop

Question

I want to query from the db records for a single post (title, body, date)

For example I have my query..

$query = 'SELECT * FROM posts WHERE id=$post_id';

From that query how can I echo the title for instance without a while or foreach loop?

Answer 1

You can just call mysql_fetch_assoc() (or any similar function) one. Like this:

$sql = "SELECT * FROM table";
$row = mysql_fetch_assoc( mysql_query($sql) );
echo $row['title'];

This is the easiest and most readable way to do this with the MySQL functions.

Answer 2

You can use mysql_result:

$sql = 'SELECT * FROM posts WHERE id=$post_id';
$query = mysql_query($sql);
echo mysql_result($query, 0, 'title');

This will echo the field titlefor the first(0) row.