New to PHP Need Help
| From: | Jason Tobias | Date: | Thu, 04 Apr 2002 15:29:22 +0000 |
| Subject: | New to PHP Need Help | ||
| Groups: | php.db php.general php.windows | ||
| Request: | Send a blank email to php-db+get-18207@lists.php.net to get a copy of this message | ||
I am trying to define variables through an anchor tag to retrive data from
MySQL, When the script runs it displays Array. I am running WIN2K and IIS
5
echo "<a href=location.php?location=2>Camp Street Cafe</a>";
Here is the script that is called.
<?php
$db = mysql_connect("localhost", "", "")
or die ("Could not connect to Localhost");
mysql_select_db ("ETM", $db)
or die ("Could not connect to the Database");
$table = "locations";
$location = ($_REQUEST["location"]);
$query = "Select * from $table where Location_ID = $location";
$result= mysql_query($query);
$Location_Info = mysql_fetch_row($result);
echo "<p>$Location_Info";
?>