Here i pasted Three scripts first one is displaying the details which
i have stored in database this is working but in second script is in
link with first one if i click main.php it displays all the details in
the database if i click one particular detail i want to see the
details about that( so i gave link in main.php scriptl).Here i
mentioned some sql line i got some problem from there
$edit="select subject from addevent where event ='$_POST[event]'";
if i use var_dump() it gives output as NULL.
If i give like this i got output as a blank page.
$edit="select subject from addevent where event ='deepavali'";
If i mentioned particular event then it displays the details adout
that partcular event I cant found the error from that code.Tell me in
this how to retrive the values .I got the same thing in to some other
scripts also.
----------------------------Main.php---------------
Expand|Select|Wrap|Line Numbers
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://
- www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <title>Untitled Document</title>
- <meta http-equiv="Content-Type" content="text/html;
- charset=iso-8859-1">
- </head>
- <body>
- <?php
- include('connect.php');
- $sql="SELECT * FROM addevent";
- // OREDER BY id DESC is order result by descending
- $result=mysql_query($sql);
- ?>
- <table width="90%" border="0" align="center" cellpadding="3"
- cellspacing="1" bgcolor="#CCCCCC">
- <tr><div align="center"><h1>List Of Events</h1></div></tr>
- <tr>
- <td width="6%" align="center" bgcolor="#E6E6E6"><strong>Event</
- strong></td>
- <td width="6%" align="center" bgcolor="#E6E6E6"><strong>Country</
- strong></td>
- <td width="53%" align="center" bgcolor="#E6E6E6"><strong>Date</
- strong></td>
- <td width="15%" align="center" bgcolor="#E6E6E6"><strong>Month</
- strong></td>
- <td width="13%" align="center" bgcolor="#E6E6E6"><strong>Year</
- strong></td>
- </tr>
- <?php
- while($rows=mysql_fetch_array($result))
- {
- // Start looping table row
- ?>
- <td bgcolor="#FFFFFF">
- <a href="event_view.php"<?php echo $rows['event']; ?>>
- <?php echo $rows['event']; ?></a>
- <BR>
- </td>
- <td align="left" bgcolor="#FFFFFF"><?php echo $rows['countryname']; ?
- ></td>
- <td align="center" bgcolor="#FFFFFF"><?php echo $rows['date']; ?></td>
- <td align="center" bgcolor="#FFFFFF"><?php echo $rows['month']; ?></
- td>
- <td align="center" bgcolor="#FFFFFF"><?php echo $rows['year']; ?></td>
- </tr>
- <?php
- // Exit looping and close connection
- }
- mysql_close();
- ?>
- </table>
- </body>
- </html>
view.php
Expand|Select|Wrap|Line Numbers
- <html>
- <style type="text/css">
- <!--
- .style3 {color: #FFFFFF; font-weight: bold; }
- -->
- </style>
- <form name="form1" method="post" action="">
- <?Php
- include('connect.php');
- $edit="select subject from addevent where event ='$_POST[event]'";
- $sql=mysql_query($edit);
- //$editf1=mysql_fetch_assoc($sql);
- $edits=mysql_query($edit);
- echo $number = mysql_num_rows($edits);
- 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>