Hello, The result $Location_info is an array.So you've got the answer 'Array'. Consider that you requested MySQL to fetch several columns through SQL "Select * from...". So the result was an array. You can get the content of the result like $Location_info[0],$Location_ info[2],....and so on.
Hiroshi Ayukawa http://hoover.ktplan.ne.jp/kaihatsu/php_en/index.php >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 General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
