php include and mysql

[haditedi]

Hi All,

 

pls help me with this

I have include a 'connect.php' but it resulted error

 

"mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\carpark\viewcars.php on line 21"

 

but if I dont use php include then everything works fine,,, below the code :

 

<?php

 

 

include "connect.php";

 

echo "<table border='1' id='position'>

<tr>

<th>Ticket</th>

<th>Car Name</th>

<th>Car Out</th>

</tr>";

 

$result=mysql_query("select * from car");

 

while ($row=mysql_fetch_array($result))

{

 

echo "<tr>";

echo "<td>".$row['ticket']."</td>";

echo "<td>".$row['carname']."</td>";

echo "</tr>";

}

echo "</table>";

 

 

 

mysql_close();

?>

 

connect.php

<?

$host="localhost";

$user="root";

$password="";

 

mysql_connect($host,$user,$password);

 

mysql_select_db("car");

?>

 

If I use below ,,everything works fine ... what went wrong ???

 

<?

$host="localhost";

$user="root";

$password="";

 

mysql_connect($host,$user,$password);

 

mysql_select_db("car");

echo "<table border='1' id='position'>

<tr>

<th>Ticket</th>

<th>Car Name</th>

<th>Car Out</th>

</tr>";

 

$result=mysql_query("select * from car");

 

while ($row=mysql_fetch_array($result))

{

 

echo "<tr>";

echo "<td>".$row['ticket']."</td>";

echo "<td>".$row['carname']."</td>";

echo "</tr>";

}

echo "</table>";

mysql_close();

?>

 

 

[trq]

You should always check your query succeeds and returns a result before attempting to use it.

 

if ($result=mysql_query("select * from car")) {
  if (mysql_num_rows($result)) {
    while ($row=mysql_fetch_array($result))
    {
      echo "<tr>";
      echo "<td>".$row['ticket']."</td>";
      echo "<td>".$row['carname']."</td>";
      echo "</tr>";
    }
  } else {
      // no results found.
  }
} else {
  // query failed, handle error
}

 

[haditedi]

Thx for the reply Thorpe but still wont work,,,

before my error was

 

"mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\carpark\viewcars.php on line 21"

now

it changed to mysql_num_rows() expects parameter 1 to be resource, boolean,,,,,

[Pikachu2000]

When posting code, please enclose it within the forum's

 . . . 

BBCode tags.

 

Now that that's out of the way, are you sure you're connecting to and selecting the database and successfully?

[haditedi]

After all day ,,,wondering and pondering ,,, finally the good God shows the way ,,,

 

I tried the code from

 

<?  to <?php

 

and it works nowww!!!  but still dont know the reason behind this though,,,,,

 

 

[Pikachu2000]

Short open tags aren't enabled by default, so you should make it a habit to always use the full <?php tag syntax.