Hi, I've been having some very wierd problems using arrays and the database functions for mysql_fetch_array and mssql_fetch_array. (Running on Windows 2000). Please see the comments in the code below. #connect to the ms sql db #(the problem also occurs when using a mysql db) $connsrc = mssql_connect("dellserver","vbweb", "password"); #select the db mssql_select_db("vbwcontent", $connsrc); #execute the query $query = mssql_query("SELECT TOP 10 * FROM dir_items"); #get the number of fields in the query $count=mssql_num_fields($query); while ($data=mssql_fetch_array($query)) { #in theory, count($data) should return the same number #as the $count variable, but it returns twice the amount #presumably because of the use of keys and indicies? #loop through the returned data for ($i=0;$i<$count;$i++) { #we can try to do this 2 ways, both cause access errors #use the array position. However, once we use this, #it appears we cannot use the named field... try it! $data[$i]=str_replace("'","''",$data[$i]); #alternatively, try getting the name of the field, and reference #it using it's named field... $pos=mssql_field_name($query,$i); $data[$pos]=str_replace("'","''",$data[$pos]); #and we still get 'PHP has encountered an Access Violation at 0146E027', or #Warning: Cannot use a scalar value as an array in D:\Virtual Hosts\vbweb.co.uk_new\bin\importdata.php on line 27 #it appears that PHP is getting it's memory in a mess, as #some very weird values are returned... } echo "INSERT INTO dir_items (authorid,url) VALUES ($data[memberid],'$data[url]')"; } Can any one tell me why this is happening, and any way to work around it? Regards, - James Editor, VB Web ================== Web - http://www.vbweb.co.uk Email - [EMAIL PROTECTED] ICQ# - 60612011 Fax - +44(0)8707052859 ================== -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]