Re: [PHP] Re: ordered alpabeticaly list
Hi list, I'm using this script to generate an alphabetical list of names, and a .gif as separator. Thank's Gerard onorato for the code. But I'd like a help to make something that I always have problem. At this moment my script outputs a html table with 1 column, how can I make it outputs a 3 column table??? this is the code. $ultletra = ''; $row = ''; while($resultado = $query->dados()) { $curletra = $resultado['letra']; if($curletra != $ultletra) { $row .= "\n\n\n\n\n"; } $row .= "".$resultado['Nome_Artistico']."\n"; $ultletra = $curletra; } Thank's in advance Rodrigo -- 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]
RE: [PHP] Re: ordered alpabeticaly list
Okay, haven't tested this but it should work. I would let mysql do some of the work here. In your select add something like Something like $result = mysql_query('select ucase(left(name,1)) as foo, name from userlist order by name'); $lastletter = ''; while ($data = mysql_fetch_array($result)) { $curletter = ($data['foo']); if ($curletter != $lastletter) { echo("" . $curletter . ""); } echo($data['name'] . ""); $lastletter = $curletter; } As I say, I haven't tested this but it should work. Unless I stink... which I often do. -Original Message- From: Rodrigo Peres [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 13, 2001 1:36 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: ordered alpabeticaly list Thnk's Mike, But what I really need is create a separation like this ex: A ab... ac.. ad.. B be... bee... .. for all the names in my table Thank's again Rodrigo on 12/13/01 4:30 PM, Mike Eheler at [EMAIL PROTECTED] wrote: > If I understand you correctly, you want to put a separator when the > letter changes. > > Try this: > > $result = mysql_query('select name from people order by name'); > $lastletter = ''; > while ($data = mysql_fetch_array($result)) { > $curletter = strtolower(substr($data['name'],0,1)); > if ($curletter != $lastletter) { > // Put code to insert a separator here > } > // put code to display the name here > $lastletter = $curletter; > } > > Mike > > Rodrigo Peres wrote: > >> Hi list, >> >> I have a mysql tables, with names on it. I'd like to select this names >> ordered by name and output it to a html in alphabetical order, but separates >> by letter, ex: a, names with a, b >> I've done the select, but I can't figure out how to output the respective >> letters separated. >> >> >> Thank's in advance >> >> Rodrigo Peres >> >> > -- -- 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]
Re: [PHP] Re: ordered alpabeticaly list
Thnk's Mike, But what I really need is create a separation like this ex: A ab... ac.. ad.. B be... bee... .. for all the names in my table Thank's again Rodrigo on 12/13/01 4:30 PM, Mike Eheler at [EMAIL PROTECTED] wrote: > If I understand you correctly, you want to put a separator when the > letter changes. > > Try this: > > $result = mysql_query('select name from people order by name'); > $lastletter = ''; > while ($data = mysql_fetch_array($result)) { > $curletter = strtolower(substr($data['name'],0,1)); > if ($curletter != $lastletter) { > // Put code to insert a separator here > } > // put code to display the name here > $lastletter = $curletter; > } > > Mike > > Rodrigo Peres wrote: > >> Hi list, >> >> I have a mysql tables, with names on it. I'd like to select this names >> ordered by name and output it to a html in alphabetical order, but separates >> by letter, ex: a, names with a, b >> I've done the select, but I can't figure out how to output the respective >> letters separated. >> >> >> Thank's in advance >> >> Rodrigo Peres >> >> > -- -- 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] Re: ordered alpabeticaly list
If I understand you correctly, you want to put a separator when the letter changes. Try this: $result = mysql_query('select name from people order by name'); $lastletter = ''; while ($data = mysql_fetch_array($result)) { $curletter = strtolower(substr($data['name'],0,1)); if ($curletter != $lastletter) { // Put code to insert a separator here } // put code to display the name here $lastletter = $curletter; } Mike Rodrigo Peres wrote: > Hi list, > > I have a mysql tables, with names on it. I'd like to select this names > ordered by name and output it to a html in alphabetical order, but separates > by letter, ex: a, names with a, b > I've done the select, but I can't figure out how to output the respective > letters separated. > > > Thank's in advance > > Rodrigo Peres > > -- 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]