dpwhite

it seemed to work until I looked at the data in the $row to make it simple: $array = array(1,,3,4pas1,5); does not work it does not like an empty field nor does it like the alpha numeric field 4pas1 so I put data in the empty field and quotes around the alphanumeric $array = array(1,a,3,"4pas1",5); does work any suggestions thanks

That cleaned up somethings but here is dump Array ( [1] => Array ( [ukey] => 143 [cid] => [vid] => 4pas1 => 4 [tnum] => 1234 [driver] => dpw [direction] => N [speed] => 45 [date] => 2008-09-07 [time] => 05:01:00 [timestamp] => 20080907050100 [street] => 460 Race St [description] => Garage [city] => Holyoke [state] => MA [lat] => 42.196175 [lon] => -72.612205 ) it is naming the variables when I just want to put relational data in array (i.e 143,,4pas1,1234,dpw,N,45,2008-09-17,05:01:00, 20080907051000, 460 rase st, garage, holyoke, ma, 42.196175,-72612205 Your advice is appreciated dave

$reeadings is a associative array function getdata1() { $stmt1= "select * from latlonreadings"; $results = mysql_query($stmt1); $line=1; while (($row = mysql_fetch_object($results))) { $readings[$line]=array($row); #### this line is wrong it fills array but includes more than values(i.e. lat=>12.123456) $line=$line+1; }

I just want to take an entire row from the DB and put it in a 2D array. Thanks

Just wanted to know 2 things. Has anyone used PHP on Microsoft Web Server 2008 and does it work. Has anyone opened ports other than 80, and does it work. Thanks

I have a page(form) where the user enters a state in box1 On the next line (box2) is a select that uses an sql query to retrieve data equal to the value in box1 based on a session variable, but this is not updated until the form is processed how do I get the sql query to see the value in box1 without refreshing the page manually thanks

I have a table in php which I want to write out to a mysql table. then I want to read it back into the array. I want to either loop thruough the array and write it, or write the entire array. How do I do it. Thanks