MySQL sysntax error

[nkosinathi]

Hi Guys
im trying to write an import class where i can import information from .CSV file into my database. I am getting the following error
Errors: 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 '' at line 1 PHP Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource in C:\hshome\sysco n05\sysconsolut ions.co.za\impo rt\Quick_CSV_im port.php on line 138 PHP Warning: mysql_fetch_ass oc(): supplied argument is not a valid MySQL result resource in C:\hshome\sysco n05\sysconsolut ions.co.za\impo rt\Quick_CSV_im port.php on line 143
Below is the block of code making the error

function get_encodings()
{
$rez = array();
$sql = "SHOW CHARACTER SET";
$res = @mysql_query($s ql);
// Below is where line 143 is situated
if(mysql_num_ro ws($res) > 0)
{
while ($row = mysql_fetch_ass oc ($res))
{
$rez[$row["Charset"]] = ("" != $row["Descriptio n"] ? $row["Descriptio n"] : $row["Charset"]); //some MySQL databases return empty Description field
}
}
return $rez;
}

//defines the encoding of the server to parse to file

[myth0s]

Hi Guys
im trying to write an import class where i can import information from .CSV file into my database. I am getting the following error
Errors: 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 '' at line 1 PHP Warning: mysql_num_rows( ): supplied argument is not a valid MySQL result resource in C:\hshome\sysco n05\sysconsolut ions.co.za\impo rt\Quick_CSV_im port.php on line 138 PHP Warning: mysql_fetch_ass oc(): supplied argument is not a valid MySQL result resource in C:\hshome\sysco n05\sysconsolut ions.co.za\impo rt\Quick_CSV_im port.php on line 143
Below is the block of code making the error

function get_encodings()
{
$rez = array();
$sql = "SHOW CHARACTER SET";
$res = @mysql_query($s ql);
// Below is where line 143 is situated
if(mysql_num_ro ws($res) > 0)
{
while ($row = mysql_fetch_ass oc ($res))
{
$rez[$row["Charset"]] = ("" != $row["Descriptio n"] ? $row["Descriptio n"] : $row["Charset"]); //some MySQL databases return empty Description field
}
}
return $rez;
}

//defines the encoding of the server to parse to file

Why do you have a "@" before "mysql_query($s ql)". I never seen this before.

As for the warnings on lines 138 and 143, it's normal. If the query fails (as yours did), then $res does not contain a result set. Any subsequent functions that require $res to be a result set, as mysql_num_rows( $res), will fail because the SQL command failed ;)