You must extract the results of the query row-by-row.
while( $row = mysql_fetch_array($result) )
{
print "ircname:".$row['ircname']."<BR>";
print "email:".$row['email']."<BR>";
print "realname:".$row['realname'].".<BR>";
print "asl:".$row['asl']."<BR>";
print "info:".$row['info']."<BR>";
}
-----Original Message-----
From: louie miranda [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 03, 2002 2:46 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] printing php variable into html > print $result; ?
Hi, is it possible to print the sql query? i mean
i want to print the output of the command "SELECT * FROM members;"
and output it into html, i tried
print $result; -- it gives me different output..
> Resource id #2
ty,
louie...
# PHP SCRIPT ###############################################
<html>
<body>
<?php
$db = mysql_connect("my_db_host", "my_db_user", "my_db_pass")
or die("Could not connect");
mysql_select_db("cavite",$db);
$result = mysql_query("SELECT * FROM members",$db) or
die("Error:".mysql_error()
);
printf("ircname: %s<br>", mysql_result($result,0,"ircname"));
printf("email: %s<br>", mysql_result($result,0,"email"));
printf("realname: %s<br>", mysql_result($result,0,"realname"));
printf("asl: %s<br>", mysql_result($result,0,"asl"));
printf("info: %s<br>", mysql_result($result,0,"info"));
print "<br><br>";
?>
</body>
</html>
# PHP SCRIPT ###############################################
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
