[PHP-DB] LOAD DATA INFILE

[Karel]

hi, could you help me?

i have got this php code

Advertising

$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