one more thing

[g7pwx]

here is the code

$lnk=mysql_connect("localhost", "", "") or die("cant connect to database");

$select = mysql_select_db ("contact"); // or die("cant select database");

$mysql="select * from names";

$mysql_result=mysql_query($mysql, $lnk);
$num_rows=mysql_num_rows($mysql_result);

this is the error. I keep getting this with database connections,

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/home/httpd/vhtdocs/inc/personal.php on line 20
sorry there is no information

any help will be greatfully received, thank you

[g7pwx]

line 20 is this

$num_rows=mysql_num_rows($mysql_result);

[bastien]

giving you a problem as mysql_result (without the $ ) is a reserved word, maybe the parser is getting confused...

http://www.php.net/manual/en/function.mysql-result.php

try changing it to just $result....

[cahva]

Oh.. Im too tired to see the error. Try putting mysql_error() in the end. That outputs the error more detailed.

[g7pwx]

Cheers

its not selecting the database for some strange reason

thanks loads.