January 23rd, 2013, 08:19 AM
|
 |
Contributing User
|
|
Join Date: Apr 2007
Location: Galway
Posts: 1,360
Time spent in forums: 4 Weeks 1 Day 23 h 38 m 14 sec
Reputation Power: 8
|
|
connect to your database:
Code:
$conn = mysql_connect('database_name', 'username', 'password');
if (!$conn) {
die('Could not connect: ' . mysql_error());
}
create a sql query based on the fields and database name
Code:
$query = "select name,address from contact_table;";
run the query:
Code:
$run = mysql_query($query);
possibly check for failed query
Code:
if (!$row) {
echo "failed query";
}
then display the data:
Code:
while $row = mysql_fetch_array($run)) {
echo $row['name'] . " - " . $row['address'] . "\r\n";
}
__________________
When I die, I want to go peacefully like my Grandfather did, in his sleep -- not screaming, like the passengers in his car.
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
