show a field in php file
| From: | George B | Date: | Mon, 18 Jul 2005 18:42:28 +0000 |
| Subject: | show a field in php file | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-218894@lists.php.net to get a copy of this message | ||
Hey guys how would i show a filed from a MySQL database in a php file?
Isnt it this?
SELECT * FROM
user
But that dosent work because it comes out blank :-\
And I already am connected to the database
Code:
mysql_connect ('localhost','myaccount','mypass')
or die ("could not connect to server");
mysql_select_db ('database')
or die ("could not connect to database");
$query = "SELECT *
FROM user
LIMIT 0 , 30";
mysql_query($query);