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]

Reply via email to