php

[tiburblium]

Hi all, I am trying to pull some information from a mysql database using php and display the information in html. I belive this should work but what i get as output is simply the word Object.

$query = "SELECT content FROM $table2 WHERE newsid = '$newsid'";
$result = mysql_query($query);
$r = mysql_fetch_object($result);
print "news = $r";

Also tried

$query = "SELECT content FROM $table2 WHERE newsid = '$newsid'";
$result = mysql_query($query);
$r = mysql_fetch_row($result)

print "news = $r [ 0 ]";

that printed the word array, any help appricated im confused!

[karateka75]

Hey,
for the first version, try:
$query = "SELECT content FROM $table2 WHERE newsid = '$newsid'";
$result = mysql_query($query);
$r = mysql_fetch_object($result);
print "news = $r->content";
Ciao
Sascha

[mikeq]

$r = mysql_fetch_object($result);
print "news = $r";

should be $r->content

$r = mysql_fetch_row($result)

print "news = $r [ 0 ]";

try taking all of the spaces out
$r[0]