still trying to access database

zuessh

I am trying to pull back some information from a database. Below is my phptest.php file

<html>

<body>

<?php

$db = mysql_connect ("localhost", "root");

mysql_select_db("delivery",$db);

$result = mysql_query("SELECT * FROM employees",$db);

printf("Company: %s<br>\n", mysql_result($result,0,"company

printf("Address: %s<br>\n", mysql_result($result,0,"address

printf("Phone: %s<br>\n", mysql_result($result,0,"phone"));

</body>

</html>

however, in my browser this is what i am recieving:

\n", mysql_result($result,0,"company")); printf("Address: %s
\n", mysql_result($result,0,"address")); printf("Phone: %s
\n", mysql_result($result,0,"phone")); ?>

Any suggestions? Thanks

matt_4013

Hi there,

You're going about it the wrong way. Rather than using mysql_result, loop through your result set, while at the same time putting it into an easy to manipulate array, using mysql_fetch_assoc(). This is achieved like so:

// Connect to your database (you shouldn't be using root, VERY insecure)
$db = mysql_connect("localhost", "username", "password") or die("Could not connect to database!");
// Select the datbase to use
mysql_select_db("delivery", $db);

// Run the query
$query = "SELECT * FROM employees";
$result = mysql_query($query, $db) or die("Could not execute query!");

// echo the page header to the screen
echo "<html>";
echo "<body>";

// Loop through each query result, and echo it to the screen
while($row = mysql_fetch_assoc($result)) {

echo "Company: ".$row['company']."<br />\n";
echo "Address: ".$row['address']."<br />\n";
echo "Phone: ".$row['phone']."<br />\n<br />\n";
}

// Add your page footer
echo "</body>
echo "</html>";

There's a pretty good tutorial on webmonkey that covers this. Doing a Google Search would be good 🙂