hi, could you help me? i have got this php code
$importfilename = $importdir_web . $importfile; echo $importfilename . '<br>'; $vysledekupdate = MySQL_DB_Query("$dbname","LOAD DATA LOCAL INFILE '$importfilename' INTO TABLE shop_rates FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n'"); if ($vysledekupdate == false) echo '<br>' . MySQL_Error() . '<br><br>'; else echo 'Import ok.<br><br>'; $cenaquery = MySQL_DB_Query("$dbname","SELECT * FROM shop_rates"); if ($cenaquery == false) echo MySQL_Error() . '<br>'; echo 'Updated:<br>'; echo '<table>'; while ($zaznamcena = MySQL_Fetch_Array($cenaquery)) : { echo '<tr><td>' . $zaznamcena[id_item] . '</td><td>' . $zaznamcena[c1] . '</td><td>' . $zaznamcena[c2] . '</td><td>' . $zaznamcena[c3] . '</td><td>' . $zaznamcena[c4] . '</td><td>' . $zaznamcena[dph] . '</td><td>' . $zaznamcena[jednotka] . '</td></tr>'; } endwhile; echo '</table>'; content of the file /home/abianet/e.abianet.cz/importc/1033573485.obabia.www.sql just two rows 19;20500;19400;0;0;22;ks 17;20000;19900;0;0;22;ks table shop_rates structure id_item, c1, c2, c3, c4, dph, jednotka this is the web/html output /home/abianet/e.abianet.cz/importc/1033573485.obabia.www.sql Import ok. Updated: 17 10440.00 0.00 0.00 0.00 22 ks 19 0.00 0.00 0.00 0.00 22 ks so that means tha import wasnot ok could you help me? thanks karel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php