Hi, newbie here, go easy on me I'm learning this as I go ;)
Got a bit of teaser here.
//<?php
mysql_connect (localhost, foouser, foologin);
mysql_select_db (footest1);
$csvfile = file("http://foo.com/foolist.csv";);
foreach($csvfile as $line_no => $datastring) {
$data = explode (",", $datastring);
$foo1 = $data[0];
$foo2 = $data[1];
$foo3 = $data[2];
$foo4 = $data[3];
$foo5 = $data[4];
$foo6 = $data[5];
$foo7 = $data[6];
mysql_query ("INSERT INTO 'footable' (foo1, foo2, foo3, foo4, foo5, foo6, foo7)
VALUES '$foo1', '$foo2', '$foo3', '$foo4', '$foo5', '$foo6', '$foo7')");
}
//?>
The result of the above is I get nothing INSERT-ed in 'footable'. No lines of data at all. I looked in the table using phpMyAdmin and zilch.
I have however dumped the contents of each variable in the 'foreach' loop to the screen in a table and it all maps out correctly as i was in the CSV file, so the CSV file is being parsed correctly. The fault seems to be in the MySQL query I think.
Privilages have no influence - I've tried both the database's 'regular' users and also the 'root' user and it makes no odds.
I've also tried dumping the list of single variables and using '($data[0], $data[1] etc...) and that has no effect.
It's probably something glaringly obvious to an expert but as I say I'm learning as I go so any help would be great :)
Thx.
--
Mark Benson
http://homepage.mac.com/markbenson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
