[PHP-DB] Listing select * from table; on PHP

2002-01-09 Thread louie miranda

?php

mysql_connect ('dbhost','user','pass');
mysql_select_db ('db');

$ircname2 = htmlspecialchars($ircname);

mysql_query (select ircname from members);

print ($ircname2);
?


--

Hi, i have tried this php script to view my table db,
but when i browse it over the net i couldn't see anything
just plain blank page.

Hm, Can u help me make this show tables over on php
and post it over.



thanks,
louie...


-- 
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]




RE: [PHP-DB] Listing select * from table; on PHP

2002-01-09 Thread Rick Emery

?php

mysql_connect ('dbhost','user','pass');
mysql_select_db ('db');

$ircname2 = htmlspecialchars($ircname);

$result = mysql_query (select ircname from members);
while( $row = mysql_fetch_array($result) )
{
print $row['ircname'].BR;
}

?

Don't forget all other HTML tags you need to pack around this
-Original Message-
From: louie miranda [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Listing select * from table; on PHP


?php

mysql_connect ('dbhost','user','pass');
mysql_select_db ('db');

$ircname2 = htmlspecialchars($ircname);

mysql_query (select ircname from members);

print ($ircname2);
?


--

Hi, i have tried this php script to view my table db,
but when i browse it over the net i couldn't see anything
just plain blank page.

Hm, Can u help me make this show tables over on php
and post it over.



thanks,
louie...


-- 
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]