I think it's very simple to do it.
<?php
//...
$result = mysql_query('SELECT * FROM my_table ORDER BY Type, "Place Name"');
for($i = 0, $prev_type = FALSE; $i < mysql_numrows($result); $i++)
{
$row = mysql_fetch_array($result);
if ($prev_type !== $row['Type'])
{
// close the previous type list if any
if ($prev_type !== FALSE) echo '</ul>';
// new Type list
echo '<ul>' . $row['Type'];
}
// print out the rest of the row like :
// Place Name and Place Abbr and ther link
echo '<li>'.$row['place name'];
echo ' <a>jump '.$row['place abbr'].'</a>';
//...
}
//...
?>
or maybe I missed something?
----- Original Message -----
From: Kath <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 30, 2001 3:17 PM
Subject: [PHP] Databases, arrays and woes
> I have a MySQL table which stores information like this:
>
> | Type | Place Name | Place Abbrv |
>
> and lets say I have data in the table like:
>
> Example #1:
> | Office | Bill's Office | bo |
> | Store | Millcreek Supply | mcs |
> | Office | Harry's Office | ho |
> | Store | Sam's Discount Taxidermy | sdt |
> | Shipping | East Coast Distribution Facility | ecdf |
>
> What I'd like to do is be able to have PHP grab the information out of the
> database and sort like this on a webpage:
>
> Type Name #1:
> - Place Name (with hyperlink using the abbrv)
> - Place Name (with hyperlink using the abbrv)
>
> Type Name #2:
> - Place Name (with hyperlink using the abbrv)
> - Place Name (with hyperlink using the abbrv)
>
> For a better illustration, using the information from Example #1:
>
> Example #2:
>
> Office
> - Bill's Office (link using bo)
> - Harry's Office (link using ho)
>
> Store
> - Millcreek Supply (link using mcs)
> - Sam's Discount Taxidermy (link using sdt)
>
> Shipping
> - East Coast Distribution Facility (link using ecdf)
>
> So basically it has to group the common "Type" fields together and list
them
> together and make a hyperlink.
>
> What is the best way to do this? I've tried arrays, different MySQL
calls,
> voodoo, ouija boards and drinking, but nothing has gotten me what I need.
>
> btw, the information in "Type" is not a set number. There could be 2 or
200
> different "Type". (Otherwise this would be much easier and I might not
have
> a hangover from aforementioned drinking ;p )
>
> - k
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
