[SOLVED] Strange Behaviour with "Select Count(*) "

[surajkandukuri]

Hi all,

 

      I am facing a strange issue here and I cannot thinkof any valid reason why it is doing like this

 

basic query :-

$sql3="SELECT Count(*) as count FROM `objectives` WHERE `ObjectiveJobPosition`=$jobid and `ObjectiveinCat`=$cat_num";

$result_sql3=mysql_query($sql3);

$row3=mysql_fetch_array($result_sql3);

$obj_num=$row3['count'];

echo($obj_num);

 

where

 

echo($jobid); -> 1

echo($cat_num); ->1

 

OUTPUT:- 8 which should be 10

 

I get the output  10 when I execute the query with 1 and 1 (instead of $jobid and $cat_num)

 

and When i run the query in phpmyadmin it returns 10.

 

    Please i cannot find out the error I made here.

 

[surajkandukuri]

Sorry Problem solved I WAS USING other varialbes inthe query