more useful options | |
PerlMonks |
Re: Looping Databaseby dug (Chaplain) |
on Oct 16, 2002 at 18:55 UTC ( [id://205798]=note: print w/replies, xml ) | Need Help?? |
Assuming that the field "category" in the table "items" corresponds to the field "id" in the table "category" and you want to solve this using SQL instead of Perl and you are using Mysql (may work on other databases as well, but untested) ... which is a lot of assumtions :^) You could use
If you are going to be doing a bit of database driven programming, it's certainly worth your time to spend a bit of time studying SQL. I'm just beginning to realize its power for certain tasks. -- dug
In Section
Seekers of Perl Wisdom
|
|