Query for returning info from 2 columns

[cruxy]

Hi everybody,

 

I have a small problem and I think you can help me.

 

I have this information in my table:

 

Team home    Team away  Info home    Info away

Barcelona      Valencia              W              V

Sevilla          Barcelona              G                G

Barcelona      Madrid                  V                W

 

 

I need a query to return the info home & away of the club Barcelona.

 

Something like that:

 

Barcelona: W, G, V

 

I could get only the info home of Barcelona and also only the info away.

 

But the problem is how can I get both info home & away of the club Barcelona in one table or line.

 

I appreciate any help.

 

Many thanks in advance,

Cruxy

 

 

[corbin]

http://php.net/mysql_result

http://php.net/mysql_fetch_row

http://php.net/mysql_fetch_assoc

 

 

 

That should answer your question.

 

 

But incase it really is a MySQL question, you would just do:

 

 

SELECT col1, col2 FROM table;