Re: printing php variable into html > print $result; ?
| From: | charlesk | Date: | Thu, 03 Jan 2002 21:09:04 +0000 |
| Subject: | Re: printing php variable into html > print $result; ? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-79366@lists.php.net to get a copy of this message | ||
something like
<?
$result = mssql_query($sql);
for ($i=0;$i<mssql_num_rows($result);$i++) {
mssql_data_seek($result,$i);
$row = mssql_fetch_object($result);
echo $row->someColumnInTable;
echo $row->someOtherColumnInTable;
}
?>
---------- Original Message ----------------------------------
From: "louie miranda" <louie@chikka.com>
Date: Fri, 4 Jan 2002 04:45:57 +0800
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 General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
For additional commands, e-mail: php-general-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net
--
Charles Killmer
Netgain Technology
251-4700
--