lucy24
msg:4323717 | 11:49 pm on Jun 8, 2011 (gmt 0) |
| I can't figure out how to do ficed width on the board |
|
Me neither. "code" and "pre" should both work, but neither of them does ("code" eats multiple spaces, and "pre" doesn't use a fixed-pitch font).
Anyway, you gotta give a little more detail. Are you working with a specific program and is this the specific block of information you want to tweak? Or are you looking for recommendations on the best data-cruncher for recurring problems similar to this one?
|
tangor
msg:4323726 | 12:02 am on Jun 9, 2011 (gmt 0) |
What is your data source and what are you using to pull the data, obviously you want to show it,,, :)
Welcome to webmasterworld, wel51x... We can help better if we can see some code you are attempting to use (Perl, PHP, MySql, etc...)
|
wel51x
msg:4323728 | 12:05 am on Jun 9, 2011 (gmt 0) |
I just want to have the language eliminated after the first row retrieved where there are multiple rows with the same language
ie
lang1 || country1
|| country2
|| country3
lang2 || country4
|| country5
lang3 || country6
lang4 || country7
|| country8
|
tangor
msg:4323755 | 12:51 am on Jun 9, 2011 (gmt 0) |
Show me some code and how you intend to display it. Can't help without that... don't know what you're using.
|
wel51x
msg:4323827 | 6:23 am on Jun 9, 2011 (gmt 0) |
thanks for the welcome.
here's the code (note the table "country" has three columns: Country, Language and Population):
SELECT `Language` , `Country`
FROM `country`
ORDER BY `Language` , `Country` ASC;
This produces the following output:
English || Canada
English || Isle of Man
English || United Kingdom
English || United States
French || France
French || Morocco
Portugese || Brazil
Russian || Ukraine
Spanish || Argentina
Spanish || Mexico
Spanish || Peru
Tagalog || Philippines
NOTE: " || " is used to denote th delimeter - it does NOT appear in the output.
what I want to see is this:
English || Canada
|| Isle of Man
|| United Kingdom
|| United States
French || France
|| Morocco
Portugese || Brazil
Russian || Ukraine
Spanish || Argentina
|| Mexico
|| Peru
Tagalog || Philippines
in other words the 'Language' column appears on;ly in the FIRST row.
|
coopster
msg:4324025 | 2:17 pm on Jun 9, 2011 (gmt 0) |
You need to monitor for a change in the language in your application logic and output the language only upon change.
|
LifeinAsia
msg:4324107 | 3:55 pm on Jun 9, 2011 (gmt 0) |
Not sure if you could accomplish something like this in a single query. You can probably do something easily by looping through the results of your query.
Much easier to do on the application server side (PHP, .NET, etc.).
|
wel51x
msg:4324465 | 7:50 am on Jun 10, 2011 (gmt 0) |
I suspected you couldn't do it with a simple query - will try it with php.
Thanks to all
|
|
