DaniWeb Forum Index > Web Development > PHP

Help me .....

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jun 2008

Posts: 145

Reputation: ishlux is an unknown quantity at this point

Solved Threads: 0

ishlux

Offline

Junior Poster

Help me .....

Jul 22nd, 2008

Hi.....here i am able to display only the last row contents.....pls help me......i want to display the rows based on user selection.....here what ever u select it will disply the last row.....

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 
<?php
session_start();
 
	include('database.php');
$result = mysql_query("SELECT * FROM  autoalto_mail" );
 
while($row = mysql_fetch_array($result))
		{
		?>
 
 
			<tr><td width="10%"></td>
				<td ><img src="images/buldot.gif" alt="" height="6" width="6">
				     <?echo $row['from']?></td>
				<td >
				     <a href="contractor_mail_action_contents.php?mail_id=<? $mailid=$row['mail_id'];
					 session_register("mailid"); 
?>">
 
<? 
session_start();
	include('database.php');
$mailid1 = $_SESSION['mailid'];
 echo $mailid1;
 $query1="SELECT * FROM  autoalto_mail where mail_id='".$mailid1."'"  ;
 
//echo $query1;
$result = mysql_query( $query1 );
//echo mysql_num_rows($result) ;
while($row = mysql_fetch_array($result))
		{ 
		 echo $row['contents'];
		}
mysql_close();
 
 ?>
<?php
session_start();

	include('database.php');
$result = mysql_query("SELECT * FROM  autoalto_mail" );
	
while($row = mysql_fetch_array($result))
		{
		?>
		
			
			<tr><td width="10%"></td>
				<td ><img src="images/buldot.gif" alt="" height="6" width="6">
				     <?echo $row['from']?></td>
				<td >
				     <a href="contractor_mail_action_contents.php?mail_id=<? $mailid=$row['mail_id'];
					 session_register("mailid"); 
?>">
		
<? 
session_start();
	include('database.php');
$mailid1 = $_SESSION['mailid'];
 echo $mailid1;
 $query1="SELECT * FROM  autoalto_mail where mail_id='".$mailid1."'"  ;

//echo $query1;
$result = mysql_query( $query1 );
//echo mysql_num_rows($result) ;
while($row = mysql_fetch_array($result))
		{ 
		 echo $row['contents'];
		}
mysql_close();

 ?>

•

Join Date: Nov 2007

Posts: 183

Reputation: lydia21 is an unknown quantity at this point

Solved Threads: 5

lydia21

Offline

Junior Poster

Re: Help me .....

Jul 22nd, 2008

hope this works.plz reply

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
while($row = mysql_fetch_array($result))
{
?> 
<tr><td width="10%"></td><td ><img src="images/buldot.gif" alt="" height="6" width="6"><?echo $row['from']?></td>
<td >
<a href="contractor_mail_action_contents.php?mail_id=<? echo $row['mail_id']; ?>"> 
<? session_start();	include('database.php');
$mailid1 = $_GET['mail_id']; 
 $query1="SELECT * FROM  autoalto_mail where mail_id=$mailid1"  ;
 $result = mysql_query( $query1 );
while($row = mysql_fetch_array($result))
		{ 
 
		 echo $row['contents'];
		}mysql_close();  ?>
while($row = mysql_fetch_array($result))
{
?> 
<tr><td width="10%"></td><td ><img src="images/buldot.gif" alt="" height="6" width="6"><?echo $row['from']?></td>
<td >
<a href="contractor_mail_action_contents.php?mail_id=<? echo $row['mail_id']; ?>"> 
<? session_start();	include('database.php');
$mailid1 = $_GET['mail_id']; 
 $query1="SELECT * FROM  autoalto_mail where mail_id=$mailid1"  ;
 $result = mysql_query( $query1 );
while($row = mysql_fetch_array($result))
		{ 

		 echo $row['contents'];
		}mysql_close();  ?>