Hi,

I am having problem with getting data from database.........I need your expert suggestions.....

here's the code:

PHP Code:

<?
          $sql_sub="select * from tblsubcate order by subcategory asc";
          $result_sub=mysql_query($sql_sub);
          while($row_sub=mysql_fetch_array($result_sub))
          {
          ?>

When I run this..................an error occur
"mysql_fetch_array(): supplied argument is not a valid MySQL result resource in"

I am sure i mistook somewhere......please help....

your help would be highly appreciated.

Thanks.

Your query looks ok.
Try to display the error, if there was one:

PHP Code:

$sql_sub="select * from tblsubcate order by subcategory asc";
$result_sub=mysql_query($sql_sub);
if(!$result_sub){
  echo mysql_error();
  die();
} 


Thanks tripy...............I'll try and let you know....soon.