[RESOLVED] not inserting the values from the array

[jrough]

I know something is wrong with the array. How can I fix it so it inserts the rows?

$cols=(col1,col2,col3,col4,col5,col6,col7,col8,col9);
$cnx = odbc_connect("Driver={Microsoft ODBC for Oracle}; SERVER="myserver", "fsread","fsread");
$rs    = odbc_exec($cnx,$sql1);
$Fields=odbc_num_fields($rs);
   $cnt=0;   

   while( odbc_fetch_row( $rs )){
   $cnt++; 
       for($i=1; $i<=$Fields;$i++){ 
            $str=odbc_result($rs,$i);
            $arr=  array();
            array_push($arr,$str);
         }           

         $sData = "'".implode("','", $arr)."'" ;
    $sql3= "INSERT INTO `mydb`.mytable($cols)" ;
    $sql3.="VALUES($sData) ";

$result=mysql_query($sql3);

$strdata='';
$sData='';
}//end while


odbc_close( $cnx);
}

[dalecosp]

If this is a direct paste, you've got several problems, not the least of which is the unclosed quote which would probably cause script execution to stop.

[toma42]

The problem is you didn't convert it from VB correctly. A search for "convert vb to php" comes up with copious threads which may have a solution.

jrough;10972264 wrote:

I know something is wrong with the array. How can I fix it so it inserts the rows?
[/code]

[jrough]

I don't see any missing quotes. I ran the script and it runs. The only thing is it does not put all the 9 fields in the array so I can insert them into MySQL. In fact it is not inserting them at all. tnx,