Topic awaiting preservation: select only one register from different fields (Page 1 of 1) |
|
---|---|
Maniac (V) Mad Scientist From: Azylum's Secret Lab |
posted 08-30-2002 12:15
Hello, I've been thinking about this but i don't find a way to do it |
Paranoid (IV) Inmate From: Lebanon |
posted 08-30-2002 12:44
very nice question! |
Maniac (V) Mad Scientist From: Azylum's Secret Lab |
posted 08-30-2002 12:52
Nop, I dunno!!!! |
Maniac (V) Mad Scientist From: Belgrade, Serbia |
posted 08-30-2002 12:56
Use "GROUP BY" SQL statement in your SELECT query... |
Paranoid (IV) Inmate From: Lebanon |
posted 08-30-2002 16:25
Okay, Wakkos, mr.Max gave us a hint: quote:
code: select
|
Maniac (V) Mad Scientist From: Azylum's Secret Lab |
posted 09-01-2002 22:50
code: $query_select = "select wakk_gallery.imagen, wakk_gallery_cat.categoria FROM wakk_gallery,wakk_gallery_cat WHERE wakk_gallery.categoria = wakk_gallery_cat.categoria LIMIT 5"; |
Maniac (V) Mad Scientist From: Belgrade, Serbia |
posted 09-02-2002 09:03 |
Maniac (V) Mad Scientist From: Azylum's Secret Lab |
posted 09-02-2002 10:06
Done!! code: $query_select = "select wakk_gallery.imagen, wakk_gallery_cat.categoria FROM wakk_gallery,wakk_gallery_cat WHERE wakk_gallery.categoria = wakk_gallery_cat.categoria group by wakk_gallery_cat.categoria";
|