[RESOLVED] Unexpected T-String Error

[austenr]

I am getting an unexpected T-String error on line 7. Can anyone tel me what is wrong with this code? Thanks

<?php

mysql_connect("localhost");

mysql_select_db("mysql");

LOAD DATA LOCAL INFILE /webcdm.csv
INTO TABLE cpt_info
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(description);

?>

[NogDog]

Yeah, all that text starting with "LOAD DATA..." is just a bare string in your code -- it's not part of any PHP command. I'm assuming you want to submit it as a query, something like:

<?php

mysql_connect("localhost");

mysql_select_db("mysql");

mysql_query("LOAD DATA LOCAL INFILE /webcdm.csv
INTO TABLE cpt_info
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(description)") or die ("Query failed: " . mysql_error());

?>

[austenr]

Thanks for the reply. I will try it in the morning.

[austenr]

That code throws an error, "can't find the database". I used the wizard to install WAMP and used the defualts for the root. Where does the DB reside if anyone knows?

[austenr]

Here are the errors it throws:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\testtable.php on line 3

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\testtable.php on line 5

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\wamp\www\testtable.php on line 5

Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\testtable.php on line 11

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\testtable.php on line 11
Query failed: Access denied for user 'ODBC'@'localhost' (using password: NO)

[austenr]

This is my only error at present.

Query failed: File '\Webcdm.csv' not found (Errcode: 2)

The file Webcdm.csv is in the root directory(www) which is the default when you install WAMP.

<?php

//mysql_connect("localhost");

//mysql_select_db("cpdata" user="root" password=" ");
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
    die('Not connected : ' . mysql_error());
}

// make cpdata the current db
$db_selected = mysql_select_db('cpdata', $link);
if (!$db_selected) {
    die ('Can\'t use cpdata : ' . mysql_error());
}
mysql_query("LOAD DATA LOCAL INFILE '/Webcdm.csv'
INTO TABLE cpdinfo
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(description)") or die ("Query failed: " . mysql_error());

?>