retrieving data from database

[Raju B]

Hi friends..
i had written php code for fetching data from mysql database(windows).
but it showing some error like:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in D:\wamp\www\getapplication.php on line 13.

Actually i have to print all the coloumns in that table.
please go through my code.

<?php
$db=mysql_connect("localhost","root","root");
 
if (!$db)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("apppack",$db);
$query  = "SELECT * FROM application ORDER BY id DESC LIMIT 10 ";
$result = mysql_query($query);
 
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
 
echo ($row['appid'].$row['appname'].$row['appdescription'].$row['categoryid'].$row['version']. $row['jadfilename'])."</br>";
 
 
 
}
mysql_close($db);
 
?>
 

[zorgi]

Check if the name of your database is correct at:

mysql_select_db("apppack",$db);
 

[Raju B]

thanks for your reply.
there is no wrong in database name.

[zorgi]

Ok I see. I think you used identifier id and in your echo statement you have:

echo ($row['appid']
 

try ordering by appid instead of id