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 *.