Resource id # 3 Error

sash11 · February 21, 2010

<?php

if (isset($_REQUEST['submit'])) {

echo "<p> hello</p>";

$dbhost = 'localhost';

$dbuser = 'root';

$dbpass = 'shshsh11';

mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'Studentt';

mysql_select_db($dbname);

$result = mysql_query("SELECT * FROM `allele`");

print $result;

} else {

?>

<html>

<body>

<P><strong>Available Queries</strong><br>

<INPUT TYPE="radio" NAME="Microsatellite Primers">Microsatellite Primers<br>

<INPUT TYPE="radio" NAME="Maps">Maps for specified loci, possibly on a specified chromosome<br>

<INPUT TYPE="radio" NAME="Common loci">Loci in common between two maps<br>

</form>

</body>

</html>

<?php

}

?>

it gives following result

hello

Resource id #3

what is Resource id #3

how do we solve it?

please help

jl5501 · February 21, 2010

you are trying to print the result from the query, which is a mysql result resource.

You next need to fetch the data as mysql_fetch_assoc($result) OR mysql_fetch_object($result) depending on how you want the data.

Then you can print 1 item from that

Recommended Posts