0

Good day to *.
I having this kind of error when i tried to view all my data in the Database.

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\pm website\php\bulletin_board\bulletin_board.php on line 51
Error Sir

and here's my code.

<?php
  $con = mysql_connect("localhost","root","");
  if(!$con)
  {
	  die ('Could not connect to DB' . mysql_error());
  }
  mysql_select_db("profound_master", $con);
  $view = mysql_query("SELECT * FROM bulletin ORDER BY pro_no DESC");
  
  if (!mysql_query ($view, $con))
		{
			die ('Error Sir' . mysql_error());
		}
  while ($row = mysql_fetch_array($view));
  
echo "<table>";
echo "<tr id=\"boardLetter\">";
echo "<th width=\"46\">".$row['pro_no']."</th>";
echo "<th width=\"56\">".$row['date']."</th>";
echo "<th width=\"138\">".$row['project']."</th>";
echo "<th width=\"138\">".$row['task']."</th>";
echo "<th>".$row['originated']."</th>";
echo "<th>".$row['incharge']."</th>";
echo "<th>".$row['deadline']."</th>";
echo "<th width=\"139\">".$row['status']."</th>";
echo "<th width=\"151\">".$row['comment']."</th>";
echo "<th>".$row['din']."</th>";
echo "</tr>";
echo "</table>";
?>

Please help me to solve my problem.

God bless to *.

3
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by karthik_ppts
1

You are doing this wrong.

if (!mysql_query ($view, $con))
		{
			die ('Error Sir' . mysql_error());
		}

mysql_query() function's first argument should be a string(a SQL query).

Once you have queried the database using $view = mysql_query("SELECT * FROM bulletin ORDER BY pro_no DESC"); , you check the return value of mysql_query() to see if it executed successfully. It returns false on error. Hence
to check

if (!$view) {
    // error
}

Edited by vishesh: n/a

Votes + Comments
0

Yes vishesh is correct. Try with vishesh suggestion or Replace your line from 8 to 13

$view = mysql_query("SELECT * FROM bulletin ORDER BY pro_no DESC");
 
if (!mysql_query ($view, $con))
{
die ('Error Sir' . mysql_error());
}

with

$view = mysql_query("SELECT * FROM bulletin ORDER BY pro_no DESC") or die ('Error Sir' . mysql_error());

Edited by karthik_ppts: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.