[Resolved] this should be easy but i don't get it

[NZ_Kiwi]

This is my code

<?php

 $table='news'; 
$query1="SELECT count(id) FROM $table WHERE cat = 34"; 
$sql1=mysql_query($query1);  

$count=mysql_result($sql1,0); 
$lines=10;  

// grab start position 
if(isset($_GET['next']) && is_numeric($_GET['next']))  

    {  

      $start=$_GET['next'];  

    }  

elseif(isset($_GET['pre']) && is_numeric($_GET['pre']))  

    {  

    $start=$_GET['pre'];  

}else{  

    $start=0;  

    } 
$hold=$start;     

if($start>$count-$lines) 
    { 
    $start=$count-$lines; 
    } 
if($start<0) 
    { 
    $start=0; 
    } 
// loop through array from next 
$query="SELECT * FROM ".$table." ORDER BY id LIMIT ".$start.",".$lines; 
$sql=mysql_query($query); 
while($row=mysql_fetch_assoc($sql)) 
    {  

    ?>

and i get this easy error

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/rugbyleaguenz.com/httpdocs/thailand/index.php on line 90

line 90 is this one

$count=mysql_result($sql1,0);

any ideas what is wrong?

[TheDefender]

Try this instead:

$query1="SELECT count(id) FROM ".$table." WHERE cat = 34";

Also, where in your code are you estalishing the connection to and selection of the database? (mysql_connect and mysql_select_db)

[sidney]

can you list your table fields please

[NZ_Kiwi]

Originally posted by sidney
can you list your table fields please

I'm a dork I have the wrong table in there haha, now though it gets all results not just those with the $cat id of 34... how would i fix this?

<?php

 $table='gallery'; 
$query1="SELECT count(id) FROM ".$table."  WHERE cat = '34'";

$sql1=mysql_query($query1);  

$count=mysql_result($sql1,0); 
$lines=10;  

// grab start position 
if(isset($_GET['next']) && is_numeric($_GET['next']))  

    {  

      $start=$_GET['next'];  

    }  

elseif(isset($_GET['pre']) && is_numeric($_GET['pre']))  

    {  

    $start=$_GET['pre'];  

}else{  

    $start=0;  

    } 
$hold=$start;     

if($start>$count-$lines) 
    { 
    $start=$count-$lines; 
    } 
if($start<0) 
    { 
    $start=0; 
    } 
// loop through array from next 
$query="SELECT * FROM ".$table." ORDER BY id LIMIT ".$start.",".$lines; 
$sql=mysql_query($query); 
while($row=mysql_fetch_assoc($sql)) 
    {  

    ?>

[sidney]

change the bottom query to this

 // loop through array from next 
$query="SELECT * FROM ".$table." WHERE cat = '34' ORDER BY id LIMIT ".$start.",".$lines; 

[NZ_Kiwi]

Originally posted by sidney
change the bottom query to this

 // loop through array from next 
$query="SELECT * FROM ".$table." WHERE cat = '34' ORDER BY id LIMIT ".$start.",".$lines; 

[/B]

i've done that and now i get this error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/rugbyleaguenz.com/httpdocs/thailand/index.php on line 116