Warning: Mysql_fetch_row(): Supplied Argument Is Not A Valid MySQL Result Resource In

thanks, that worked for me.

thanks webune, i really appreciated.

im new at this, but it really helps to have guys like this, that's why i have two of my websites hosting at webune.com

thanks for your help.

ok, i found your problem, you need to enclose the value

replace this:
$sql = "select count(*) as total from ".$db_prefix."table where id = $id";

with this:
$sql = "select count(*) as total from ".$db_prefix."table where id = '$id'";

all i basically added was single quotes on you $id to make it look like this: '$id'

try it and let me know if it helps

sure, this is what i see now:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/www/index.php on line 158

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

replace
$row = mysql_fetch_row($result);

with this
if(! $row = mysql_fetch_row($result)){echo mysql_error();}

this will show you what the error you are getting from the mysql server

post the error here ok

sure, it looks like this:

$sql = "select count(*) as total from ".$db_prefix."table where id = $id";
$result = mysql_query($sql ,$db);
$row = mysql_fetch_row($result);

can you provide your sql query please?