haha
It's really not hard .. u can code it in any language
I coded it in a functional language in about 4-5 lines in my first subject at uni
Search found 240 matches
- Tue Oct 12, 2004 7:51 am
- Forum: PHP - Theory and Design
- Topic: Euclidean question :)
- Replies: 2
- Views: 2051
- Sat Oct 02, 2004 8:00 am
- Forum: PHP - Theory and Design
- Topic: validate a opensource CMS
- Replies: 4
- Views: 2846
- Tue Sep 28, 2004 10:32 am
- Forum: PHP - Theory and Design
- Topic: PHP Optimization
- Replies: 51
- Views: 21526
- Thu Sep 09, 2004 7:37 pm
- Forum: PHP - Theory and Design
- Topic: limit to the size of an array?
- Replies: 8
- Views: 4301
- Thu Sep 09, 2004 7:32 pm
- Forum: PHP - Theory and Design
- Topic: Advanced Permission Management
- Replies: 21
- Views: 13930
Wow, nice link. Seems a little complex on first pass, but on reading it over, it's a pretty elegant solutiontimvw wrote:meaby http://www.tonymarston.net/php-mysql/ro ... ntrol.html makes it a little clearer?
- Tue Aug 24, 2004 7:26 am
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
- Sat Aug 21, 2004 11:37 am
- Forum: PHP - Theory and Design
- Topic: OOP and database for business site
- Replies: 23
- Views: 11448
- Sat Aug 21, 2004 10:18 am
- Forum: PHP - Theory and Design
- Topic: OOP and database for business site
- Replies: 23
- Views: 11448
- Fri Aug 20, 2004 7:49 pm
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
- Fri Aug 20, 2004 10:19 am
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
There is an odd problem. I have 4 rows in my invoice table. With this query, I get 3 invoice rows only- one for each of the 3 customers that have invoice/s. SELECT *, invoice.* , IF(ISNULL(SUM(payment.cost)), 0.00, SUM(payment.cost)) as paid_off FROM invoice LEFT JOIN payment ON invoice.invoice_id =...
- Thu Aug 19, 2004 2:59 am
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
- Wed Aug 18, 2004 9:09 am
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
- Sun Aug 15, 2004 6:42 pm
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
- Sun Aug 15, 2004 7:15 am
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
- Sun Aug 15, 2004 1:12 am
- Forum: Databases
- Topic: Help with a query
- Replies: 13
- Views: 2472
Help with a query
Hi, I've got a proabably fairly simple mysql query, but I'm ite sure how to do it. I have these 2 tables (these are the relavent fields): Invoice -------- id cost Payment ---------- invoice amount Each Invoice has a number of Payments (could be none). What I need is to be able to select all invoices...