Warning: mysql_fetch_array() expects parameter 1...

**channark** · 07 May 2011, 06:26 AM

i try to create a dinamique table but its not working this is the error :
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in .... ligne 7
here is the code :

Code:

<?php
$connection=mysql_connect("localhost","root","");
$val=$_GET['id'];
mysql_select_db("test_base2");
$requete = "SELECT * FROM `nature` WHERE id=$val";
$select=mysql_query($requete);
$row = mysql_fetch_array($select);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Tableau</title>
</head>

<body>
<p>Afichage de l'image :<?php echo $row['name'];?></p>

<table border="1" cellspacing="0" cellpadding="5">
  <tr>
    <td>Nom</td>
    <td><?php echo $row['name']; ?></td>
  </tr>
  <tr>
    <td>Place</td>
    <td><?php echo $row['place']; ?></td>
  </tr>
  <tr>
    <td>Photo</td>
    <td><img src="<?php echo $row['photo'];?>"/></td>
  </tr>
</table>

</body>
</html>

thanks

**MarPlo** · 07 May 2011, 12:36 PM

Perhaps there isn't "id=a_number" in URL adress.
Try this:

PHP Code:


<?php

if(isset($_GET['id'])) {

$connection=mysql_connect("localhost","root","");

$val=$_GET['id'];

mysql_select_db("test_base2");

$requete = "SELECT * FROM `nature` WHERE id=$val";

$select=mysql_query($requete, $connection);

$row = mysql_fetch_array($select);

}

else { $row = array('name'=>'', 'place'=>'', 'photo'=>'') }

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Tableau</title>

</head>



<body>

<p>Afichage de l'image :<?php echo $row['name'];?></p>



<table border="1" cellspacing="0" cellpadding="5">

  <tr>

    <td>Nom</td>

    <td><?php echo $row['name']; ?></td>

  </tr>

  <tr>

    <td>Place</td>

    <td><?php echo $row['place']; ?></td>

  </tr>

  <tr>

    <td>Photo</td>

    <td><img src="<?php echo $row['photo'];?>"/></td>

  </tr>

</table>



</body>

</html>

Thread: Warning: mysql_fetch_array() expects parameter 1...

Thread Tools

Warning: mysql_fetch_array() expects parameter 1...

Similar Threads

fwrite() expects.... help???

fwrite() expects.... help???

'Wmode transparent' parameter being buggy in IE. Help?

Posting Permissions