phpretard Posted July 27, 2008 Share Posted July 27, 2008 How can I turn this into an array? $result = mysql_query("SELECT City FROM ZipCodes ORDER by City"); while($row = mysql_fetch_array($result)) { $a[]=$row['City']; } echo $a; // Just echos "Array" and I have lots of cities in the DB Link to comment https://forums.phpfreaks.com/topic/116791-solved-array-from-db/ Share on other sites More sharing options...
DarkWater Posted July 27, 2008 Share Posted July 27, 2008 You can't echo an array. Link to comment https://forums.phpfreaks.com/topic/116791-solved-array-from-db/#findComment-600606 Share on other sites More sharing options...
phpretard Posted July 27, 2008 Author Share Posted July 27, 2008 This worked $result = mysql_query("SELECT City FROM ZipCodes ORDER by City"); while($row = mysql_fetch_array($result)) { $a[]=$row['City']; } $q=$_GET["q"]; //lookup all hints from array if length of q>0 if (strlen($q) > 0) { $hint=""; for($i=0; $i<count($a); $i++) { if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q)))) { if ($hint=="") { $hint=$a[$i]; } else { $hint=$hint." , ".$a[$i]; } } } } // Set output to "no suggestion" if no hint were found // or to the correct values if ($hint == "") { $response="no suggestion"; } else { $response=$hint; } //output the response echo $response; Thanks Link to comment https://forums.phpfreaks.com/topic/116791-solved-array-from-db/#findComment-600615 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.