Re: newbie array question

Hello, This is a reply to an e-mail that you wrote on Thu, 10 Jul 2003 at 15:30, lines prefixed by '>' were originally written by you. > If i have a valid sql query that returns three the records > 'john','jack' and 'mary' and i want to put that into an array > where > array[0]->john,array[1]->jack etc how do i do this? Im trying to use > sybase_fetch_array as follows: > $query = "select name from names (where age <'23'')"; > $numero= sybase_connect("database" , "user" , "password" ) > or die ("Unable to connect to database server"); > $result=sybase_query($query,$numero ); > $names=sybase_fetch_array($result); sybase_fetch_array will fetch one row of the result, if you want all three rows in one array you will need something like this... $allnames = array(); while($thisname = sybase_fetch_row($result)){ $allnames[] = $thisname[0]; } I have never used the sybase db functions though so I may be incorrect. All the best, David. -- phpmachine :: The quick and easy to use service providing you with professionally developed PHP scripts :: http://www.phpmachine.com/ Professional Web Development by David Nicholson http://www.djnicholson.com/ QuizSender.com - How well do your friends actually know you? http://www.quizsender.com/ (developed entirely in PHP)