page results

I want to split up data into a page.
I use a script that I foundd on the web

$cnx = @mysql_connect(localhost,$username,$password);

the error I get is:
You have an error in your SQL syntax near '' at line 1

not matter what i tried I couldn't solve it...every help appreciated.

To start with you need " " around localhost:

("localhost",$username,$password)

HTH

thanks but didn't help.

this is how i do it:

$connection=odbc_connect("$dsn","","");

problem might be that uid and pwd has to be between ""