Problem in displaying records [Archive]

kavithadevan

07-16-2007, 11:25 PM

Hi ,

Actually i am not getting any errror but i am trying to display some records using select statement if i am using like this in that above code wat i send

$edit="select subject from addevent where event ='$_POST[event]'";

it shows blank page only this query not taking the value of $_POST[event].

If i give event name directly it displys some records which i have stored in data base
$edit="select subject from addevent where event ='deepavali'";

Tell me now y my first query is not working wat is the main problem tell me some solution regarding that.

Pls help me

here i pasted that script

<html>
<style type="text/css">

</style>
<form name="form1" method="post" action="">
<?Php
include('connect.php');
$edit="select subject from addevent where event ='$_POST[event]'";
$edits=mysql_query($edit);
while($editf1=mysql_fetch_assoc($edits))
{
?>
</p>
<p align="center"> </p>
<p align="center">  </p>
<table width="900" border="1" align="center">
<tr bgcolor="#666666">
<td width="246"><span class="style3">Subject</span></td>
</tr>
<tr bgcolor="#CCCCCC">
<td bgcolor="#FFFFFF"><?PHP echo $editf1['subject'];?></td>
</tr>
</table>
<p align="center"> </p>
<?PHP
}
?>
</form>
</html>
thanks