mysql_fetch_array() expects parameter 1 to be resource

Question

Possible Duplicate:
“Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given” error while trying to create a php shopping cart

<?php
//connect to MYSQL
$con=mysql_connect("localhost","root","");
if (!$con)
{
          die ('cannot connect:'.mysql_error());
}

//to show the original message
mysql_select_db("tracking", $con);

$result = "SELECT lat, lng, DATE_FORMAT(datetime,'%W %M %D, %Y %T') AS datetime FROM markers1 WHERE 1";
if (!$result) { // add this check.
    die('Invalid query: ' . mysql_error());
}


echo "<table border='1'>
<tr>

<th>id No</th>
<th>lat Time</th>
<th>lng</th>
<th>datetime</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['lat'] . "</td>";
  echo "<td>" . $row['lng'] . "</td>";
  echo "<td>" . $row['datetime'] . "</td>";

  echo "</tr>";
  }
echo "</table>";

mysql_close($con);

It show me mysql_fetch_array() expects parameter 1 to be resource.

Can anyone help me .thx.

you did not do `mysql_query($result)` before fetching – KJYe.Name Mar 07 '11 at 02:39 — KJYe.Name, Mar 07 '11 at 02:39

score 3 · Accepted Answer · answered Mar 07 '11 at 02:40

3

You're not running the query, it's only being stored in a string called $result. Here is the function you need: http://php.net/mysql_query

answered Mar 07 '11 at 02:40

Josh

2,820
23
15

score 2 · Answer 2 · edited Oct 17 '17 at 06:19

2

You aren't actually making a query...

Make the line...

$result = mysql_query("SELECT lat, lng, DATE_FORMAT(datetime,'%W %M %D, %Y %T') AS datetime FROM markers1 WHERE 1");

edited Oct 17 '17 at 06:19

Pang

9,564
146
81
122

answered Mar 07 '11 at 02:39

Jacob

8,278
1
23
29

Thx Jacob. May god bless u.hv a nice day. – user647527 Mar 07 '11 at 02:50

score 1 · Answer 3 · answered Mar 07 '11 at 02:39

1

You need to call mysql_query to execute the query string. You also have a number of other problems with your code (the least of which is parameter binding.)

answered Mar 07 '11 at 02:39

Edward Z. Yang

26,325
16
80
110

score 0 · Answer 4 · answered Mar 07 '11 at 02:41

0

try this $result = mysql_query( "SELECT lat, lng FROM markers1 WHERE 1" );

You need to call the mysql_query() function first before you can call any fetch function such as mysql_fetch_array()

answered Mar 07 '11 at 02:41

Angelo

533
5
18

mysql_fetch_array() expects parameter 1 to be resource

4 Answers4