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.borag...@gmail.com  /
   // 15 40 58 60 02 ///////////////////////////
+                                                                          _


-----Mensaje original-----
De: Chris [mailto:dmag...@gmail.com] 
Enviado el: Viernes, 28 de Agosto de 2009 03:42 a.m.
Para: Emiliano Boragina
CC: 'Arie Nugraha'; php-db@lists.php.net
Asunto: Re: [PHP-DB] 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

Reply via email to