kavithadevan
07-16-2007, 01:20 AM
Hi,
Here i pasted two 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 in red color i got some problem from there only.$edit="select subject from addevent where event ='$rows[event]'";
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 .Help me what error it contains and tell me some suggestions
----------------------------Main.php---------------
<!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 ORDER BY date DESC";
// 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
<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 ='$rows[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>
thanks
Here i pasted two 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 in red color i got some problem from there only.$edit="select subject from addevent where event ='$rows[event]'";
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 .Help me what error it contains and tell me some suggestions
----------------------------Main.php---------------
<!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 ORDER BY date DESC";
// 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
<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 ='$rows[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>
thanks