[PHP-DB] joining 2 tables - help please..

2002-09-18 Thread rainydays_sunshine
I have 2 tables as follows: product table | product_id | name | category_id | 1| coffee| 2 | 3| orange|1 | 5| mango|1 | 2| tea |2 and category table |category_id | category_name | |2| drinks

[PHP-DB] RE: regarding session

2002-09-18 Thread Smita Manohar
Graeme , Terry : thnx for reply :) now some picture is clear in my head regarding session handling. i did the stuff as u suggested. but getting error msg as , Warning: Cannot send session cache limiter - headers already sent (output started at c:\phpdev\www\mediawatch\mast_maint.php:9) in

RE: [PHP-DB] RE: regarding session

2002-09-18 Thread John Holmes
You must call session_start() _before_ any output is sent to the browser. This means before html or any other output at all. ---John Holmes... -Original Message- From: Smita Manohar [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 6:09 AM To: [EMAIL PROTECTED]

Re: [PHP-DB] joining 2 tables - help please..

2002-09-18 Thread Ignatius Reilly
Try: SELECT C.category_name, SUM( IF( ISNULL( P.product_ID ),0, 1) ) AS total FROM category AS C LEFT JOIN product AS P ON C.category_ID = P.category_ID GROUP BY C.category_ID Ignatius - Original Message - From: [EMAIL PROTECTED] To: [EMAIL

[PHP-DB] file timout

2002-09-18 Thread Ryan Jameson (USA)
Does anyone know a good way to have the file function timeout quickly if it cannot find the file requested? I've tried set_time_limit (5) but for some reason it still sits for about 30 seconds before failing. Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] set_magic_quotes_runtime???

2002-09-18 Thread Jason Vincent
So what does set_magic_quotes_runtime(0) do then??? Will it shut off the automatic backslashing of single quotes at run time or not? (it certainly doesn't seem to) Anyone? J

Re: [PHP-DB] set_magic_quotes_runtime???

2002-09-18 Thread Paul Burney
on 9/18/02 8:55 PM, Jason Vincent at [EMAIL PROTECTED] appended the following bits to my mbox: So what does set_magic_quotes_runtime(0) do then??? Will it shut off the automatic backslashing of single quotes at run time or not? (it certainly doesn't seem to) If I recall correctly, that