error with my mysql statement
Posted: Mon Dec 25, 2006 12:48 am
can anyone tell me what the heck is wrong with my MYsql statement?
Code: Select all
$mysql_tickname_insert="INSERT INTO curldata VALUES ($ticker,$companyname,'','','','','','');";
my error is
[quote]Error number: 1064 Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1838 Bond Debenture Trading Fd,'','','','','','')' at line 1[/quote]
i'm inserting it into my table curldata that has 8 fields. I don't havevalues to insert for the last six values. all fields are VARCHAR.
okay here is my php code from my php class:
[syntax=php]function get_ticker($text_ticker){
$file = "NYE.txt";
$fc=file($file);
foreach ($fc as $line_num => $pline){
$spline=explode(" ",$pline);
foreach ($spline as $key => $value){
if ($key == 0){
$companyname = $value;
}
else if ($key == 1){
$ticker = $value;
}
$mysql_tickname_insert="INSERT INTO curldata VALUES ($ticker,$companyname,'','','','','','');";
if ( $sqldb = mysql_connect( "localhost", "localuser", "localpass" ) ) {
print "Connection to mysqldb username: localuser complete<br>";
}
else {
die ("Unable to connect to mysqldb username: localuser . Error: <b>".
mysql_error()."</b>");
}
if ( mysql_select_db( intelligent , $sqldb ) ) {
print "Select of intelligent complete<br>";
}
else {
die ("Select failed database name intelligent Error number: <b>".mysql_errno().
" Message: ".mysql_error()."</b>");
}
if ( mysql_query( $mysql_tickname_insert, $sqldb ) ) {
print $mysql_tickname_insert." complete<br>";
}
else {
print $mysql_tickname_insert." failed. Error number: <b>".mysql_errno().
" Message: ".mysql_error()."</b>";
}
mysql_close($sqldb);
}
}
//end of get ticker
}[/syntax][syntax=php][/syntax][syntax="sql"][/syntax][quote][/quote]