wierd connect error

When i run a script i get this error message, havnt a clue what it means:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock

could someone please explain. thanks ;)

that message usually means that mysql server is not running.

My server is all up and running......still this error

Is it setup for php?

yes everything even mysql......

the mysql works perfect on other pages but on this page with a pagination its just not doing it........

i presume you have the mysql_connect command in your page?

ok why aint this working:


$cato = $_GET['catid'];
if(empty($cato)){
$cato = 1;
}

$query2 = "SELECT FROM table WHERE catid='$cat' LIMIT $start, $limit";
$result = mysql_query($query2);


error is:

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 'FROM table WHERE catid=6' at line 1

mysql version: 4.0.25

$query2 = "SELECT field1,field2,field3,field4 FROM table WHERE catid='$cat' LIMIT $start, $limit";

ok why aint this working:


$cato = $_GET['catid'];
if(empty($cato)){
$cato = 1;
}

$query2 = "SELECT FROM table WHERE catid='$cat' LIMIT $start, $limit";
$result = mysql_query($query2);


error is:

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 'FROM table WHERE catid=6' at line 1

mysql version: 4.0.25

Simple reason you forgot to put what you are selecting, if you want to select everything then you would do
SELECT * FROM table
or to select certain fields
SELECT field1, field2, field3 FROM table