Menu
Community /Pin to ProfileBookmark
@NogDogNov 25.2014 — #It would help if you told us which line in the script was throwing the error (which should be part of the actual PHP error output, right after the file name).
I'm going to guess (and it's just a guess right now) that MySQL has a reserved word "number", and that you need to quote your column name with "back-tick" quotes -- or maybe you meant to use table name numbers but left the "s" off in one of the update queries? (Note that it never hurts to quote any column/table name with back-ticks, so you might want to do it anyway just in case.) @NogDogNov 25.2014 — #That's the output from mysql_error(), but the die() command itself should have spewed something out that says something about a fatal error, and that lists the *.php file where it failed, with the line number right after the file name. That way we can narrow it down to which query failed. Also, a useful pattern is to output the query with the mysql_error() output, something like:
(Hopefully doing something "nicer" than that in the live version so you don't spew DB info onto the live site. ? )
PS: the PHP MySQL extension (all those mysql_*() functions) is deprecated, and you really should be using the MySQL[b]i[/b] extension or the PDO extension, instead; but that's a whole other issue you probably don't want to deal with right now. ?
mysql ERROR No idea what it is (Newbie)
//connect to database
$con = mysql_connect (“localhost”,”u258029154_teddy”,”*******”);
if (!$con)
{
die (‘could not connect: ‘ . mysql_error());
}
$db_selected = mysql_select_db(“u258029154_smste”, $con);
if (!$db_selected) {
die (‘Can’t use foo : ‘ . mysql_error());
}
$i = 0;
while ($i != 8000) {
This is part of the code where I’m getting the error on my script anything stand out?
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogNov 25.2014 — #I'm going to guess (and it's just a guess right now) that MySQL has a reserved word "number", and that you need to quote your column name with "back-tick" quotes -- or maybe you meant to use table name numbers but left the "s" off in one of the update queries? (Note that it never hurts to quote any column/table name with back-ticks, so you might want to do it anyway just in case.)
0
@NogDogNov 25.2014 — #That's the output from mysql_error(), but the die() command itself should have spewed something out that says something about a fatal error, and that lists the *.php file where it failed, with the line number right after the file name. That way we can narrow it down to which query failed. Also, a useful pattern is to output the query with the mysql_error() output, something like:[code=php]
$sql = "SELECT * FROM some_table WHERE foo=1";
$result = mysql_query($sql);
if($result == false) {
die(mysql_error.PHP_EOL.$sql);
}
[/code](Hopefully doing something "nicer" than that in the live version so you don't spew DB info onto the live site. ? )
PS: the PHP MySQL extension (all those mysql_*() functions) is deprecated, and you really should be using the MySQL[b]i[/b] extension or the PDO extension, instead; but that's a whole other issue you probably don't want to deal with right now. ?