SELECT * FROM `prd_flds` WHERE cat= ORDER BY `position`

Error 1064 : 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 'ORDER BY `position`' at line 1

array (
  0 => 
  array (
    'file' => '/home/digiirco/public_html/kernel/includes/classes/data.inc',
    'line' => 201,
    'function' => 'show_error',
    'class' => 'MySQL',
    'type' => '->',
    'object' => 
    ExData::__set_state(array(
       'dbconn' => NULL,
    )),
    'args' => 
    array (
    ),
  ),
  1 => 
  array (
    'file' => '/home/digiirco/public_html/pages/products.php',
    'line' => 728,
    'function' => 'table',
    'class' => 'Data',
    'type' => '->',
    'object' => 
    ExData::__set_state(array(
       'dbconn' => NULL,
    )),
    'args' => 
    array (
      0 => 'prd_flds',
      1 => 'cat=',
      2 => '`position`',
    ),
  ),
  2 => 
  array (
    'file' => '/home/digiirco/public_html/pages/products.php',
    'line' => 953,
    'function' => 'show_cat',
    'args' => 
    array (
    ),
  ),
  3 => 
  array (
    'file' => '/home/digiirco/public_html/index.php',
    'line' => 143,
    'args' => 
    array (
      0 => '/home/digiirco/public_html/pages/products.php',
    ),
    'function' => 'include',
  ),
)

Error 1064 : 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 'ORDER BY `position`' at line 1