Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean

phpwand

hi i ve been getting the above error
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean

i looked up a few sites that said this error occurs when the resource passed to it has been changed after the first time it is used. but i checked my code and cant seem to find where ive gone wrong. pls help.
this is my code

<?php
$i=0;
$link=mysql_connect('localhost','root');
mysql_select_db("hms");

$query="select * from leave where h_code";
$result=mysql_query($query);

echo "<table align=left position=fixed bgcolor=#66CCFF cellspacing=20 cellpadding=5 rules=rows>
		<tr>
		<th><font color=blue size=2>L_ID</th>
		<th><font color=blue size=2>RECEIVED ON</th>
		<th><font color=blue size=2>H_CODE</th>
		<th><font color=blue size=2>TOTAL_DAYS</th>	
		<th><font color=blue size=2>DEPARTURE_DATE</th>
		<th><font color=blue size=2>RETURN_DATE</th>
		<th><font color=blue size=2>DESTINATION</th>
		<th><font color=blue size=2>PURPOSE</th>
		<th><font color=blue size=2>STATUS</th>
		</tr>";

while($row = mysql_fetch_array($result,MYSQL_BOTH))
{			
			$i=$i+1;
			echo "<tr>";
			echo "<td><center>".($id=$row['leave_id'])."</td>";
			echo "<td><center>".($row['date_applied'])."</td>";
			echo "<td><center>".($row['h_code'])."</td>";
			echo "<td><center>".($row['total_days'])."</td>";
			echo "<td><center>".($row['dept_date'])."</td>";
			echo "<td><center>".($row['return_date'])."</td>";
			echo "<td><center>".($row['destination'])."</td>";
			echo "<td><center>".($row['purpose'])."</td>";
			echo "<td><center>".($row['status'])."</td>";

}
mysql_free_result($result);
echo"<font size=3 color=green>$i Leave Requests Pending..</font>";

  ?>

vivek151189

just echo the query and

echo $query="select * from leave where h_code";  exit;

and take the output of query and fire it in your phpmyadmin's
sql panel
does it give result ?
check

vivek151189

I think your query is retutning

MySQL returned an empty result set (i.e. zero rows)

write your query that works perfectely in sql panel of phpmyadmin
and then chck does it returning the value

vivek151189

No I mean to say the samthing that your query is not returning anything
but by mistake I forgot to type not returning
Sorry.....
For that
But I really want to say that only

phpwand

am sorry the query below is not wat i wanted..
$query="select * from leave where h_code";

its supposed to be..
$query="select * from leave";

another doubt..suppose i ve set a field on auto increment in myphpadmin,how do i manage that field while inserting a row into tat table..?? how can i enter all other fields without mentioning the field set as auto-increment(the auto incremented field is the primary key in my case).

also how abt a field whose default value has been set in myphpadmin..how can i insert values to all other fields except tat field but stil have d default value inserted along with the rest of the values i want to insert.

pls help..

vivek151189

First of all there is no need to insert the column which is autoincreemented column
it will automatically increemented

And Secondly the column whose default value is set in phpmyadmin if not inserted than it will automatically take the default value but it should be not set to null Assign some default value