Hi,
I have a question on how to make a simple search...
I have two columns in a MySQLdb-table: item, price
I want to list all items with their prices. However, items with the same
price should be concatenated.
I've looked through the manual - but can't figure out how to concat
rows
Hi all,
I have a table including two colums: names and apartment numbers:
apt #| name
--
1 | Smith Joe
1 | Smith Anne
2 | Doe Richard
3 | Svensen Mike
3 | Brant Liza
I need to get a list in alphabetical order, but with people in the same
apt keept together:
Brant,
I want to select all entries in my table that in a column with given
dates findes all dates inbetween $from_date - $to_date. (These are
vars that the user supplies from the HTML-page). I don't know how to set
up the SELECT query. I tried the following way but it didn't work:
SELECT * FROM