can anybody tell me how to display the list as below

[thread_PHP]

Hi Can anybody tell me how to display the list as below

http://oursamplework.com/brainstorm/V2/directory.htm

The sort order is displayed in the above list using

Brett Brett

John John
Paul Paul
Maria Maria

like this and navigation using paging concept below i wrote the code like this i am not getting

<?php
$id=$_GET['id'];
require_once 'library/config.php';

?>
    		  		  <?php 

		 if($_GET['action']=='ALL')
		{
		 $qryall="select firstname,lastname,industry,position from ht_signup2 order by firstname ASC";  
		 $resall=mysql_query($qryall);
		 while($res1all=mysql_fetch_array($resall))
		 {
		 echo "<br><li><a class=profile1 href=view_profile.php?action=view>".$res1all['firstname']; echo "&nbsp";
		 echo $res1all['lastname']; echo "</a></li><br>";
		 echo "&nbsp;&nbsp;&nbsp;&nbsp;<span class=view>".$res1all['industry']; echo "/";
		 echo $res1all['position']; echo "</span><br>";
		 }}

		 ?>

The code is giving output
http://oursamplework.com/brainstorm/V2/directory.php?action=ALL&id=2

[ideffect]

Here's how I would do it...

<?php
$id=$_GET['id'];
require_once 'library/config.php';

?>
<?php

if($_GET['action']=='ALL')
{
	$qryall="select firstname,lastname,industry,position from ht_signup2 order by firstname ASC";
	$resall=mysql_query($qryall);
	while($res1all = mysql_fetch_object($resall))
	{
		$firstname = "$res1all->firstname";
		$lastname = "$res1all->lastname";
		$industry = "$res1all->industry";
		$position = "$res1all->position";

	echo "<br><li><a class=profile1 href=view_profile.php?action=view>$firstname&nbsp$lastname</a></li><br>
	&nbsp;&nbsp;&nbsp;&nbsp;<span class=view>$industry/$position</span><br>";
}
}
?> 

[thread_PHP]

hi ideffect
the values are displaying but the page is going to be enlarged with the length of the values displayed in the website. I want the values to be distributed to the second line right side and when it is finished it should display in the third line how can i do it?

[ideffect]

I'm not exactly sure what you mean so if you can, create the page with just html and post the part that should display the info. I'll take a look at it. All you want to do is insert the variables where they should be displayed. The variables in this case are $firstname, $lastname, $industry and $position.

[thread_PHP]

hi ideffect
if you want i can send you the html page to your email address i have tried to solve this by sending like those variable $firstname,$lastname,$industry,$position also but its not worked for me please go through this url

http://oursamplework.com/brainstorm/V2/directory.htm

please help me how to solve this problem

thanks in advance

[ideffect]

Well if you are just trying to get that look, try this. You will need to adjust the css to your liking.

PHP Code

<?php
$id=$_GET['id'];
require_once 'library/config.php';

?>
<?php

if($_GET['action']=='ALL')
{
    $qryall="select firstname,lastname,industry,position from ht_signup2 order by firstname ASC";
    $resall=mysql_query($qryall);
    while($res1all = mysql_fetch_object($resall))
    {
        $firstname = "$res1all->firstname";
        $lastname = "$res1all->lastname";
        $industry = "$res1all->industry";
        $position = "$res1all->position";

    echo "<div class='box1'>
	<a class='profile1' href='view_profile.php?action=view'>$firstname&nbsp$lastname</a>
	<div class='view'>$industry/$position</div>
	</div>";
}
}
?> 

CSS Used

<style type='text/css' media='screen'><!--
.box1 { width: 150px; height: 30px; padding: 2px; }
.profile1 { color: #002f64; font-size: 10px; font-family: verdana; font-weight: bold; background-image: url(test_dot.jpg); background-repeat: no-repeat; background-position: left center; text-decoration: none; text-align: right; text-indent: 7px; padding-left: 8px; }
.dots { margin: 0; padding: 0; list-style-type: disc; }
.view { color: #8c8c8c; font-size: 10px; font-family: verdana; padding-left: 15px; }
--></style>

I also used an image for the dot on the left side which I uploaded.
Remember this will take care of the look of each listing. You will need to insert it into your code to work with the 3 sections and the paging system.