Parameter Problem

#1

Dear Sir,

I have following codes

<?php mysql_connect("localhost", "root", "") or die("Connection failed! " . mysql_error()); mysql_select_db("asia"); echo "Connection successful!"; $find_query = "select *FROM ghee where sno=3"; $strSQL = mysql_query($find_query); // Execute the query (the recordset $rs contains the result) $rs = mysql_query($strSQL); // Loop the recordset $rs // Each row will be made into an array ($row) using mysql_fetch_array while($row = mysql_fetch_array($rs)) { // Write the value of the column FirstName (which is now in the array $row) echo $row['pack'] . "<br />"; } mysql_close(); ?>

It show error message show in attachment

( ! ) Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\find.php on line 8
Call Stack

Time Memory Function Location

1 0.0780 141360 {main}( ) …\find.php:0
2 0.4836 149584 mysql_query ( )
…\find.php:8

( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\wamp\www\find.php on line 11
Call Stack

Time Memory Function Location

My table structure can be seen in attachment

Please help me to get rid of both error messages


Untitled.jpg

#2

Both error messages are because you’re doing the mysql_query line twice.