Hi,
mysql_fetch_row($result) function output is an array - so it's not strange that
your script produces such output. Read the manual for detailed explanation of
this function and how to handle the result set.
You should also know name of the field you want to retrieve from db - in SQL
query you're selecting all record fields - maybe it's not necessary...
You can also try (I prefer :-)) this way:
$result= mysql_query($query);
$answer = mysql_fetch_array($result);
$Location_Info = $answer['required field name'];
echo $Location_Info;
HTH
Piotr
Jason Tobias wrote:
> 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";
>
> ?>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
