switch and while

SGVsbG8uDQoNCkkgd2FudCBkbyBhIFNXSVRDSCB1c2luZyBkYXRhIGJhc2Ug TXlTUUwuDQpUaGUg
Q0FTRSBtdXN0IGJlIGEgdmFyaWFibGUsIHNhbWUgdGhlIEVDSE8uDQpNeSB0 YWJsZSAoQ0FURUdP
UlkpIGNvbnRhaW4gSUQgYW5kIE5BTUUNCg0KSSBkbyB0aGlzICh3aXRoIGEg V0hJTEUpOg0KDQok
c3FsQ2F0ID0gIlNFTEVDVCAqIEZST00gY2F0ZWdvcmlhIjsNCiRyZXN1bHRD YXQgPSBteXNxbF9x
dWVyeSgkc3FsQ2F0KTsNCg0Kc3dpdGNoICgkc2VsZWN0Q2F0ZWdvcnkpDQp7 CQkJCQ0KCXdoaWxl
KCRhcnJheT1teXNxbF9mZXRjaF9hcnJheSgkcmVzdWx0Q2F0KSkNCgl7DQog ICAgICAgY2FzZSAk
cm93WzBdOg0KCQkkY2F0ZWdveSA9ICIkcm93WzFdIjsNCgkJYnJlYWs7DQoJ fQ0KfQ0KDQpCdXQg
ZG9lc250IHdvcmtzLCBwcmludCBhbiBlcnJvcjogUGFyc2UgZXJyb3I6IHN5 bnRheCBlcnJvciwg
dW5leHBlY3RlZA0KVF9XSElMRSwgZXhwZWN0aW5nIFRfQ0FTRSBvciBUX0RF RkFVTFQgb3IgJ30n
IGluDQpDOlxBcHBTZXJ2XHd3d1xhbmRhZGVtaXBhcnRlXGFkbWluXGxpc3Rh ZG8ucGhwIG9uIGxp
bmUgMTE4Li4uIHRoaXMgbGluZSBpcw0KdGhlIFdISUxFLg0KDQpIb3cgY2Fu IHJlc29sdmUgdGhp
cz8NCnRoYW5rcw0KDQoroKCgoKCgoKCgoKCgoKCgIKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBfDQqgoCAvLyBFbWls aWFubyBCb3JhZ2lu
YSBfDQqgoCAvLyBEaXNl8W8gJiBDb211bmljYWNp824gLy8vLy8vLy8vLy8v Ly8vLy8vDQoroKCg
oKCgoKCgoKCgoKCgIKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoCBfDQqgoCAvLyBlbWlsaWFuby5ib3JhZ2luYUBnbWFp bC5jb22gIC8NCqCg
IC8vIDE1IDQwIDU4IDYwIDAyIC8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8v Lw0KK6CgoKCgoKCg
oKCgoKCgoCCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCg
oKCgoKCgoKAgXw0KDQo=

RE: switch and while

VGhhbmtzIEFyaWWFDQpCdXQgSSBuZWVkIHRvIGRvICJjYXRlZ29yeTEiIGJl IHRoZSBJRCBvZiBt
eSB0YWJsZS4NClVzaW5nIHRoaXMgd2F5IEkgaGF2ZSBDQVNFIG51bWJlcl9J RF90YWJsZSBlY2hv
IHN0cmluZ19DQVRFR09SWV9GSUVMRF90YWJsZSwNCmFuZCB3aWxsIGJlIGF1 dG9tYXRpYy4uLiBN
YW55IENBU0VTIGFzIElEIEkgaGF2aW5nIGluIHRoZSBkYXRhYmFzZQ0KDQpU aGFua3MgYWdhaW4N
Cg0KK6CgoKCgoKCgoKCgoKCgoCCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKAgXw0KoKAgLy8gRW1pbGlhbm8gQm9yYWdp bmEgXw0KoKAgLy8g
RGlzZfFvICYgQ29tdW5pY2FjafNuIC8vLy8vLy8vLy8vLy8vLy8vLw0KK6Cg oKCgoKCgoKCgoKCg
oCCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCg
oKAgXw0KoKAgLy8gZW1pbGlhbm8uYm9yYWdpbmFAZ21haWwuY29toCAvDQqg oCAvLyAxNSA0MCA1
OCA2MCAwMiAvLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8vLy8NCiugoKCgoKCg oKCgoKCgoKAgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgIF8N
Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCkRl OiBBcmllIE51Z3Jh
aGEgW21haWx0bzpkaWNhcnZlQGdtYWlsLmNvbV0gDQpFbnZpYWRvIGVsOiBW aWVybmVzLCAyOCBk
ZSBBZ29zdG8gZGUgMjAwOSAwMzoxMyBhLm0uDQpQYXJhOiBFbWlsaWFubyBC b3JhZ2luYQ0KQXN1
bnRvOiBSZTogW1BIUC1EQl0gc3dpdGNoIGFuZCB3aGlsZQ0KDQpZb3UgaGF2 ZSB3cm9uZyBzeW50
YXggdGhlcmUgOg0KDQpUaGUgc3dpdGNoIGNvbnN0cnVjdCBpcyB3b3JraW5n IGxpa2UgdGhpcyA6
DQoNCjw/cGhwDQoNCnN3aXRjaCAoJHNlbGVjdENhdGVnb3J5KSANCnsNCqCg oCBjYXNlICdjYXRl
Z29yeTEnOg0KoKCgoKCgoCB3aGlsZSAoJGFycmF5PW15c3FsX2ZldGNoX2Fy cmF5KCRyZXN1bHRD
YXQpKSB7DQqgoKCgoKCgoKCgoCAvLyBkbyBzb21ldGhpbmcgaGVyZQ0KoKCg oKCgoCB9DQqgoKAg
YnJlYWs7DQqgoKAgY2FzZSAnY2F0ZWdvcnkyJzoNCqCgoCAvLyBkbyBhbm90 aGVyIHRoaW5nDQqg
oKAgYnJlYWs7DQp9DQoNCj8+DQoNCk9yIG1heWJlIHdoYXQgeW91IG1lYW4g aXMgbGlrZSB0aGlz
IDoNCg0Kd2hpbGUgKCRyb3c9bXlzcWxfZmV0Y2hfYXJyYXkoJHJlc3VsdENh dCkpIHsNCqCgoCBz
d2l0Y2ggKCRyb3dbMF0pIHsNCqCgoKCgoKAgY2FzZSAnY2F0ZWdvcnkxJyA6 DQqgoKCgoKCgoKCg
IC8vIGRvIHNvbWV0aGluZyBoZXJlDQqgoKCgoKCgIGJyZWFrOw0KoKCgoKCg oCBjYXNlICdjYXRl
Z29yeTInIDoNCqCgoKCgoKCgoKCgIC8vIGRvIHNvbWV0aGluZyBoZXJlDQqg oKCgoKCgIGJyZWFr
Ow0KoKCgIH0NCn0NCg0KT24gRnJpLCBBdWcgMjgsIDIwMDkgYXQgMTowMyBQ TSwgRW1pbGlhbm8g
Qm9yYWdpbmENCjxlbWlsaWFuby5ib3JhZ2luYUBnbWFpbC5jb20+IHdyb3Rl Og0KSGVsbG8uDQoN
Ckkgd2FudCBkbyBhIFNXSVRDSCB1c2luZyBkYXRhIGJhc2UgTXlTUUwuDQpU aGUgQ0FTRSBtdXN0
IGJlIGEgdmFyaWFibGUsIHNhbWUgdGhlIEVDSE8uDQpNeSB0YWJsZSAoQ0FU RUdPUlkpIGNvbnRh
aW4gSUQgYW5kIE5BTUUNCg0KSSBkbyB0aGlzICh3aXRoIGEgV0hJTEUpOg0K DQokc3FsQ2F0ID0g
IlNFTEVDVCAqIEZST00gY2F0ZWdvcmlhIjsNCiRyZXN1bHRDYXQgPSBteXNx bF9xdWVyeSgkc3Fs
Q2F0KTsNCg0Kc3dpdGNoICgkc2VsZWN0Q2F0ZWdvcnkpDQp7DQqgIKAgoCCg d2hpbGUoJGFycmF5
PW15c3FsX2ZldGNoX2FycmF5KCRyZXN1bHRDYXQpKQ0KoCCgIKAgoHsNCqAg oCCgIGNhc2UgJHJv
d1swXToNCqAgoCCgIKAgoCCgIKAgoCRjYXRlZ295ID0gIiRyb3dbMV0iOw0K oCCgIKAgoCCgIKAg
oCCgYnJlYWs7DQqgIKAgoCCgfQ0KfQ0KDQpCdXQgZG9lc250IHdvcmtzLCBw cmludCBhbiBlcnJv
cjogUGFyc2UgZXJyb3I6IHN5bnRheCBlcnJvciwgdW5leHBlY3RlZA0KVF9X SElMRSwgZXhwZWN0
aW5nIFRfQ0FTRSBvciBUX0RFRkFVTFQgb3IgJ30nIGluDQpDOlxBcHBTZXJ2 XHd3d1xhbmRhZGVt
aXBhcnRlXGFkbWluXGxpc3RhZG8ucGhwIG9uIGxpbmUgMTE4Li4uIHRoaXMg bGluZSBpcw0KdGhl
IFdISUxFLg0KDQpIb3cgY2FuIHJlc29sdmUgdGhpcz8NCnRoYW5rcw0KDQor oKCgoKCgoKCgoKCg
oKCgIKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCg oKCgoKCgoKCgoKCg
oKCgoCBfDQqgoCAvLyBFbWlsaWFubyBCb3JhZ2luYSBfDQqgoCAvLyBEaXNl 8W8gJiBDb211bmlj
YWNp824gLy8vLy8vLy8vLy8vLy8vLy8vDQoroKCgoKCgoKCgoKCgoKCgIKCg oKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoCBf DQqgoCAvLyBlbWls
aWFuby5ib3JhZ2luYUBnbWFpbC5jb22gIC8NCqCgIC8vIDE1IDQwIDU4IDYw IDAyIC8vLy8vLy8v
Ly8vLy8vLy8vLy8vLy8vLy8vLw0KK6CgoKCgoKCgoKCgoKCgoCCgoKCgoKCg oKCgoKCgoKCgoKCg
oKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKAgXw0KDQoN Cg0KLS0gDQpPcGVu
IFNvdXJjZSBpcyBhYm91dCByZXNwZWN0aW5nIG90aGVyIHBlb3BsZSBjcmVh dGlvbiBhbmQgc2hh
cmluZyBrbm93bGVkZ2UNCnRvIG90aGVycy4NClNlYmFpayBiYWlrbnlhIG1h bnVzaWEgYWRhbGFo
IHlhbmcgYmVybWFuZmFhdCBiYWdpIG9yYW5nIGxhaW4uDQpodHRwOi8vZGlj YXJ2ZS5ibG9nc3Bv
dC5jb20NCg==

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

RE: switch and while

Hi Chris,
Sorry... you're right!
With this I want to print the category in a html table after a search...
The search find the data, and print category and description. This =
category
is a number (ID), but I want to print the name of the category. My MYSQL
CATEGORY TABLE have ID and NAME, so using the SWITCH, I want to put in =
CASE
the ID and ECHO the NAME.
In other webs I do
switch($category) //where $category is an array fom the db
{
case 1:
echo "category1";
break;

case 2:
echo "category2";
break;

...
}
I want the 1, 2, 3... like the ID from my table, and "category1,
category2..." like the NAME from my table
Do not know if it was understood...
Thanks again

+ =
_
// Emiliano Boragina _
// Dise=F1o & Comunicaci=F3n //////////////////
+ =
_
// emiliano.boragina@gmail.com /
// 15 40 58 60 02 ///////////////////////////
+ =
_

-----Mensaje original-----
De: Chris [mailto:dmagick@gmail.com]=20
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=20
do it like that.

switch ($selectCategory)
{
case 'category1':
$query =3D .....;
break;

case 'category2':
$query =3D .....;
break;
}

You haven't really explained what you're trying to achieve so it's a bit =

hard to suggest anything.

--=20
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: switch and while

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=F1o & Comunicaci=F3n //////////////////
+ =
_
// emiliano.boragina@gmail.com /
// 15 40 58 60 02 ///////////////////////////
+ =
_


-----Mensaje original-----
De: Chris [mailto:dmagick@gmail.com]=20
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=20
do it like that.

switch ($selectCategory)
{
case 'category1':
$query =3D .....;
break;

case 'category2':
$query =3D .....;
break;
}

You haven't really explained what you're trying to achieve so it's a bit =

hard to suggest anything.

--=20
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: switch and while

Emiliano Boragina wrote:
> Hi Chris,
> Sorry... you're right!
> With this I want to print the category in a html table after a search...
> The search find the data, and print category and description. This category
> is a number (ID), but I want to print the name of the category. My MYSQL
> CATEGORY TABLE have ID and NAME, so using the SWITCH, I want to put in CASE
> the ID and ECHO the NAME.
> In other webs I do
> switch($category) //where $category is an array fom the db
> {
> case 1:
> echo "category1";
> break;
>
> case 2:
> echo "category2";
> break;
>
> ...
> }
> I want the 1, 2, 3... like the ID from my table, and "category1,
> category2..." like the NAME from my table
> Do not know if it was understood...

There are a couple of ways you can do it and no need for a switch.


1) get the category name as part of the query itself

This works nicely if an article only fits into one category. If it fits
into multiple categories, it gets a little messy (though it's still doable).


select * from articles where id='x';

becomes

select a.*, c.category_name from articles a inner join categories c on
(a.category_id=c.category_id) where id='x';


2) load all categories at once and then print the relevant one

This works if you have a small number of categories available. If you
have a lot (50+) then I'd look at the first method.

$category_list = array();
$category_query = "select * from categories order by category_name";
$category_result = mysql_query($category_query);
while ($row = mysql_fetch_assoc($category_result)) {
$cat_id = $row['category_id'];
$cat_name = $row['category_name'];
$category_list[$cat_id] = $cat_name;
}

then you can just print out the name, eg:

// article_category comes from your query to load the article.
$article_category = 'x';

// make sure it's a valid category name
if (isset($category_list[$article_category])) {
echo "Your article is in category " .
htmlspecialchars($category_list[$article_category]);
}

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php