Ad:

PHP Discussion Thread
Marked Solved
Views: 392

Jul 22nd, 2008

Help me .....

Expand Post »

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.....

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();

 ?>

ishlux

Reputation Points: 7

Solved Threads: 0

Junior Poster

Offline

145 posts
since Jun 2008

Permalink

Jul 22nd, 2008

Re: Help me .....

hope this works.plz reply

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();  ?>

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

Permalink

Jul 22nd, 2008

Re: Help me .....

Thanks a lot ..........its working,,,,,,,,i was struggling from yesterday.......

ishlux

Reputation Points: 7

Solved Threads: 0

Junior Poster

Offline

145 posts
since Jun 2008

Permalink

Jul 22nd, 2008

Re: Help me .....

welcome............mark it as solved

lydia21

Reputation Points: 19

Solved Threads: 5

Junior Poster

Offline

183 posts
since Nov 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Is the syntax is correct..

Next Thread in PHP Forum Timeline: code to find out holidiays in a month

DaniWeb Message

Cancel Changes

User Name
Password