SIR
SORRY FOR LATE . I AM NAAZIR FROM SRI LANKA..I AM DOING WEBDEVALOBMENT
USING PHP AND MY SQL, I WAS BORN IN A MIDDLE CLASS FAMILLY. MY FATHER
IS A BUSSINES MAN MOTHER IS HOUSE WIFE. I HAVE 5 SIISTER. MY FATHER
BUSSINUS BADLY AFFECTED MY TSUNNMI . WE LOST OUR FATHER BUSSINES .
AND FATHER SAY RO ME I CAN'T PAY MONEY TO STUDY ME I DON'T HAVE MIONEY
NOW .AND HAVE TO SPEND SISITERS STUDIES NAD WEDDING . SIR I ASK FROM
YOU IF CAN PLEASE HELP TO STUDY OR ATLEAST SEND SOME GOOD NOTES OR
PAERNT BOOK OF PHP $ MyAQL TO MY MAIL
THNAK SIR
naazir
On Mon, 07 Mar 2005 13:16:31 -0600, Martin Norland
[EMAIL PROTECTED] wrote:
Wendell Frohwein wrote:
Hi martin, thanks for the email. I'm sorting it out slowly but surely. I
was just a little over worked the night I wrote that novel of an email.
I don't know if you saw my latest email titled Mysql Result. That's
the last step I am at. I used a select statement across multiple tables
to get all the values that I wanted. I forgot because I was so tired
that, once I had those values in there that I could sort by anything I
wanted to.
If you have a solution for my Mysql Result problem, that would help me
out alot. Most people are saying that I have to do a sub query, so I am
not really sure. Thanks though.
-Wendell Frohwein
[snipped from another email]
I wanted to know if it would be possible for it to output it like so:
+--+---+-+--+
| makename | modelname | versionname |years |
+--+---+-+--+
| Acura| Integra | RS | 92,93|
| Acura| Integra | GSR | 94,95,96,97,98,99,01 |
+--+---+-+--+
[snip]
As penance for suggesting the quick way out in another posting, I've
answered your question!
(I would've answered anyway - I'm a softie. I got distracted this
morning with the whole 'work' thing - sorry for the delay.)
I remembered doing this before - and sure enough:
GROUP_CONCAT: http://dev.mysql.com/doc/mysql/en/group-by-functions.html
The relevant bits:
GROUP_CONCAT([DISTINCT] expr [,expr ...]
[ORDER BY {unsigned_integer | col_name | expr}
[ASC | DESC] [,col_name ...]]
[SEPARATOR str_val])
mysql SELECT student_name,
- GROUP_CONCAT(test_score)
- FROM student
- GROUP BY student_name;
Or:
mysql SELECT student_name,
- GROUP_CONCAT(DISTINCT test_score
- ORDER BY test_score DESC SEPARATOR ' ')
- FROM student
- GROUP BY student_name;
The default separator is the comma. Just toss in a 'GROUP_CONCAT(year)
AS year' and appropriate 'GROUP BY' clause and have at it.
Cheers,
--
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php