[Abdul]

Hi there can anyone me please to correct this error i dont know what exactly it means. This is my php script
<?
$sql = "select 1 from temp limit 1";
$check = mysql_query($sql);
$temp = mysql_result($check,0,0);

if ($temp == 0)
{
for ($i=0;$i<sizeof($Sport);$i++)
{
if (isset($Sport[$i]))
{
$query = "CREATE TEMPORARY TABLE IF NOT EXISTS temp
SELECT * FROM unisport WHERE SportID = '$Sport[$i]'";
$result = mysql_query($query);
}



t
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[dark one]

look at http://www.php.net/manual/en/function.mysql-connect.php if you have not already

if this won't help go to the shell and type
> mysql
if you would get "can't connect", than answer is simple - you do not have mysql server installed or you have it down. have a look at www.mysql.com for more details about installation.
try one of the following to get it up:
> service mysqld start
> mysqld start
> /etc/rc.d/init.d/mysqld start
should work
pretty strange yo do not have it started on boot - you've done something wrong during the installation probably.

if
> mysql
would say you "access denied" or connect you to the server, than check mysql hostname your script uses and the host php's mysql api linked to as localhost. unlikely but possible.

[Abdul]

I think you misinterpreted my question .............................
My Question was not if i m connected to the database
is that i do get connected to the database but i m creating a temproraly table
to store the result return by the query


$sql = "select 1 from temp limit 1"; here i m selecting from temp
$check = mysql_query($sql);
$temp = mysql_result($check,0,0);

if ($temp == 0)
{
for ($i=0;$i<sizeof($Sport);$i++)
{
if (isset($Sport[$i]))
{
$query = "CREATE TEMPORARY TABLE IF NOT EXISTS temp // is this ok to do this?????????????????
SELECT * FROM unisport WHERE SportID = '$Sport[$i]'";
$result = mysql_query($query);

[dark one]

well, if your questions is the script, it seems ok
if you get the following

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

than the problem is not with your script. the problem is with mysql server - it is not running on your machine, so the scripts fails before the line you so concerned about - on mysql_connect instruction. if it was something different, the error would be different. i gave you basic instructions on how to handle this. check mysql.com if you want more about mysql setup.