Re: [PHP-DB] Help with a query

2003-03-06 Thread Corne' Cornelius
Why not use: SELECT a.item_id, a.subtotal, a.quantity FROM shopping_cart a, orders b WHERE b.session_id = session_id() AND b.customer_id = $customer_id AND a.order_id = b.border_id ? !Exclude Disclaimer! Jonathan Villa wrote: I can't figure this query out. I want to pull data from 2

Re: [PHP-DB] Storing images in MySQL table

2003-02-19 Thread Corne' Cornelius
Milan, The only disadvantage i've had of storing images in DB instead of Filesystem, is that when you use a PHP script to output the image to a client browser, MSIE doesn't always accept a suggested filename so it might try and save it as your-script.php?img=2. Other then that, keeping images

Re: [PHP-DB] More help with mysql

2003-02-18 Thread Corne' Cornelius
Yo Evan, Have you got an '@' in front of the mysql_query() to supress errors ? Evan Morris wrote: Hi all I have successfully managed to connect to the mysql database, using the following code: mysql_connect('localhost','php','***') || die (Unable to connect to MySQL server.); $db =

Re: [PHP-DB] Multiple select box using mysql

2003-02-18 Thread Corne' Cornelius
You have to give the Mutli select box a name as an array. eg: SELECT NAME=experts[] MULTIPLE SIZE=5 OPTION VALUE=key1val1/OPTION /SELECT then in PHP, you can access $experts as an array. while (list ($key, $val) = each($experts)) { print $key = $valBR\n; } Jason End wrote: I writing a