Obviously I will also be needing to implement MySQL in there as well. Well? Which would you suggest for a beginner?I’ve never seen, nor really know anything about ruby, so my vote is PHP
How long would it take someone to learn PHP? How long before I could edit stuff, etc…?
Im trying to select a list of categories, and display them, as well as list number of videos in each category.
I have 2 tables, categories (cat_id, cat_name), and videos (vid_id, vid_catid, etc). cat_id = vid_catid.
I need 1 query that will select the category names + number of rows in the video table that has [...]
This is the content of my table called "Category"
Is this possible through a query alone or do I need to read ALL the data into memory and then recursively sort it all?
This is in PHP+MySQL btw.
mysql> select id, name, parentid from category;
+—-+———–+———-+
| id | name | parentid |
+—-+———–+———-+
| 1 [...]
I’m working with a regional company that has 20 retail locations and is using a cryptic, difficult point-of-sale system. I feel like the current POS system is dated by at least ten years. Writing reports is tedious and syncing with the web requires a lot of ‘hacking.’ Does anyone have experience with [...]
I am really, really impressed with Amazon EC2/S3/Queue/SimpleDB. There have been a few issues of downtime lately, but basically I’ve written a web application using Perl/Catalyst/MySQL/Ubuntu (and sometimes Solaris) that needs to sale to 100K hits an hour or so, but will remain idle most of the time. In other words it needs [...]
