Mysql sorting

[moinuddin102]

<?php
$con = mysql_connect("localhost", "username", "password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("sjpayme_search", $con);

$result = mysql_query("SELECT * FROM search WHERE type='web' DESC");

while($row = mysql_fetch_array($result))
  {
  echo $row[query];
  }

mysql_close($con);
?>

it show me this:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/main/xyz.php on line 18

what is the problem?

[NogDog]

The error message means your query was not able to be processed by MySQL, so it returned boolean false instead of a resource ID. I suspect the error is the "DESC" without an "ORDER BY field_name" before it. You can make it easier to debug by using this coding pattern:

$sql = "SELECT * FROM search WHERE type='web' DESC";
$result = mysql_query($sql) or die("Query failed: $sql - " . mysql_error());