Hi!
I hope, I understood you right: You want to delete a user completely from
your database?
If yes, you can just do it step by step (I hope the last step - putting all
the queries together works):
$uid = 1;
$qry = 'SELECT `Allocation_ID` FROM `WMS_Allocations` WHERE
`User_ID`='.$uid;
$ent = mys
Message -
From: "Corne' Cornelius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 07, 2003 9:00 AM
Subject: Re: [PHP-DB] Help with a query
> Why not use:
>
> SELECT a.item_id, a.subtotal, a.quantity
>FROM shopping_cart a, orders b
&g
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
ch is what I wanted to avoid, but I guess
there's no other way
Thanks for the quick reply.
---> Jonathan
-Original Message-
From: Paul Burney [mailto:[EMAIL PROTECTED]
Sent: Monday, March 03, 2003 10:06 AM
To: [EMAIL PROTECTED]; PHP Database List
Subject: Re: [PHP-DB] Help
on 3/31/03 10:41 AM, Jonathan Villa at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I want to pull data from 2 tables but using a primary key from one.
>
> Here is what I think it should look like.
>
> SELECT item_id, subtotal, quantity from shopping_cart WHERE order_id =
> (SELEC
