PDA

Click to See Complete Forum and Search --> : Issue with Mysql

Andylonger
09-10-2008, 03:14 AM
hey guys here is the code and this to get rows from mysql but im getting error Resources id #38 can any one check and tell where i'm doing wrong

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form name="view" action="" method="post" >
<p>&nbsp; </p>
<table bgcolor="#313131" width="620"cellpadding="30" cellspacing="0" border="0" height="" align="center">
<tr>
<td align="left" colspan="2">
<font color="#FFFFFF" size="6"> Enter Date:</font>
<input type="text" name="date" size="10"/><font color="#FFFFFF" size="3">*Date Format YYYY/MM/DD*</font>
</td></tr>
<tr>
<td align="right"><input name="submit" style="font-size:12pt "type="submit" value="submit"/>
</td></tr>

<?php
include("connect.php");
include("userinfo.php");

if($_REQUEST['submit']=="submit")
{
$eventdate = mysql_real_escape_string($_POST['eventdate']);
$event = mysql_real_escape_string($_POST['event']);

$query = mysql_query("SELECT * FROM event_list where eventdate= '$eventdate'");
$result = mysql_query($query) or die ("Couldn't query data" . mysql_error());

echo "<table border='0'>";
while ($row = mysql_fetch_assoc($result))
{
// rand(1,$result[0]);
echo "<tr>";
echo "<td>" . $row['Room_No'] . "</td>";
echo "<td>" . $row['eventdate'] . "</td>";
echo "<td>" . $row['event'] . "</td>";
echo "</tr>";
}
}
echo "</table>";
?>
</table>
</form>
</body>
</html>
JeremyA
09-11-2008, 09:18 AM
Try this:
echo "<table border='0'>";
while ($row = mysql_fetch_array($result)) //this should work
{
// rand(1,$result[0]);
echo "<tr>";
echo "<td>" . $row['Room_No'] . "</td>";
echo "<td>" . $row['eventdate'] . "</td>";

Goodluck,
Jeremy A.
chazzy
09-11-2008, 09:34 AM
the second line on here should be removed. you don't run mysql_query on the results of a mysql_query call.


$query = mysql_query("SELECT * FROM event_list where eventdate= '$eventdate'");
$result = mysql_query($query) or die ("Couldn't query data" . mysql_error());
rlhawk
09-15-2008, 10:04 AM
Yes. Chazzy's reply is correct. Perhaps you meant to do something like this:

$query = "SELECT * FROM event_list where eventdate= '$eventdate'";
$result = mysql_query($query) or die ("Couldn't query data" . mysql_error());