A retail... I have two tables in my db. One for product description, in this one I have the column CATEGORY as INT. The other table is CATEGORY with ID and NAME of category. So, I do a select from this two tables... but I need switch the number of the CATEGORY in the first table to the NAME in the second table. Thanks a lot + _ // Emiliano Boragina _ // Diseño & Comunicación ////////////////// + _ // emiliano.boragina@xxxxxxxxx / // 15 40 58 60 02 /////////////////////////// + _ -----Mensaje original----- De: Chris [mailto:dmagick@xxxxxxxxx] Enviado el: Viernes, 28 de Agosto de 2009 03:42 a.m. Para: Emiliano Boragina CC: 'Arie Nugraha'; php-db@xxxxxxxxxxxxx Asunto: Re: switch and while Emiliano Boragina wrote: > Thanks Arie... > But I need to do "category1" be the ID of my table. > Using this way I have CASE number_ID_table echo string_CATEGORY_FIELD_table, > and will be automatic... Many CASES as ID I having in the database If the $selectCategory is part of the database query, then you need to do it like that. switch ($selectCategory) { case 'category1': $query = .....; break; case 'category2': $query = .....; break; } You haven't really explained what you're trying to achieve so it's a bit hard to suggest anything. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
