Friday, 15 June 2012

" Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\wamp\www\svgmember\admin\emp-profile.php on line 27" -



" Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\wamp\www\svgmember\admin\emp-profile.php on line 27" -

this question has reply here:

error: warning: mysql_num_rows() expects parameter 1 resource, boolean given in c:\xampp\htdocs\…\…php on line 19 4 answers

i'm new php. got below message."warning: mysql_num_rows() expects parameter 1 resource, boolean given in d:\wamp\www\svgmember\admin\emp-profile.php on line 27"

this script

<?php require_once('includes/start.php'); include('includes/header.html'); ?> <?php`$page_title = 'edit employee'; if( (isset($_get['id'])) && (is_numeric($_get['id'])) ){ $id = $_get['id']; }elseif( (isset($_post['id'])) && (is_numeric($_post['id'])) ){ $id = $_post['id']; }else{ echo '<p>page error</p> <p class="error">page has been accessed in error!</p><p><br /><br /> </p>'; exit();} require_once('../dbcon.php'); $query = "select * employee fname, bday, gender, nid, status, gsd, mpost, email, contact, address, activities, mid=$id"; $result = @mysql_query($query); if(mysql_num_rows($result) ==1){ $row = mysql_fetch_array($result, mysql_num); echo'<br>'; echo '<h3><center>employee profile</center></h3> <table align="center" width="350"> <tr> <td><b>full name:</b></td> <td>'.$row[0].'</td></tr> <tr> <td><b>birth date:</b></td> <td>'.$row[1].'</td></tr> <tr> <td><b>gender:</b></td> <td>'.$row[2].'</td></tr> <tr> <td><b>national id/passport no:</b></td> <td>'.$row[3].'</td></tr> <tr> <td><b>status:</b></td> <td>'.$row[4].'</td></tr> <tr> <td><b>gs divition:</b></td> <td>'.$row[5].'</td></tr> <tr> <td><b>member post:</b></td> <td>'.$row[6].'</td></tr> <tr> <td><b>email address:</b></td> <td>'.$row[7].'</td></tr> <tr> <td><b>contact number:</b></td> <td>'.$row[8].'</td></tr> <tr> <td><b>address:</b></td> <td>'.$row[9].'</td></tr> <tr> <td><b>activities:</b></td> <td>'.$row[10].'</td></tr>'; echo'</table> '; }else{ echo '<p>page error</p> <p class="error">page has been accessed in error!</p><p><br /><br /></p>';} mysql_close(); ?> <br> <a href="../resume/<?php echo $fetch['resume']?>"><center>view resume</center></a> <br> <?php require_once('../includes/footer.html'); ?>

please help.....

try this

$query = "select fname, bday, gender, nid, status, gsd, mpost, email, contact, address, activities employee mid='$id'";

or

$query = "select * employee mid='$id'";

php

No comments:

Post a Comment