Database Question

[SN3]

What is the code to get the field "location" from a database and then print it out in a php file?

[SVB]

What do you mean field location?
"ID
Surname
Forename"
You mean like, Forename is location 3?

[SN3]

No, the field entitled "location" is in a database. How do I get the content in the field "location" to print out.

[kwvarga]

<?php
$link = mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());
$query = "SELECT location FROM table";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
$location = $row[0];
echo "Location: " . $location;
mysql_close($link);
?>

[hatchet]

A little more efficient to do

$row = mysql_fetch_assoc($result);
echo "Location: " . $row['location'];

mysql_fetch_array pulls the indices and the names.. assoc only pulls the field names.

You should also have some error checking (this goes before mysql_fetch_assoc()
if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}

and if you're expecting multiple rows of information (after the last code segment)
while ($row = mysql_fetch_assoc($result)) {
echo $row["location"];
echo '<br>';
}

and you don't have to close the connection - php will do it automatically.

[SN3]

Thanks!

[kwvarga]

oh yeah thats right, i forgot you dont have to close it, ive been dealing with multi-mysql server scripts so i have had weird errors if i didnt close it. hmm