ecrement the items in stock by 3.
>
> Just an idea...
>
> Do you know about database normalization? How is the database designed?
>
>
>
> -Original Message-
> From: elias [mailto:[EMAIL PROTECTED]]
> Sent: August 2, 2001 6:32 PM
> To: [EMAIL PROTECTED]
&g
Come on, you're pushing SQL in directions it's not supposed to go! It is
set oriented after all.
So it's experimentation time. I've never tried, but as LIMIT works on a
SELECT, try it on an update. And let us know what happened.
Miles
At 10:30 AM 8/2/01 +0200, elias wrote:
>How can I update on
Miles,
The LIMIT works great with UPDATE too.
"Miles Thompson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Come on, you're pushing SQL in directions it's not supposed to go! It is
> set oriented after all.
> So it's experimentation time. I've never tried
the database designed?
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySql help #1
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3 items status to "Reserved".
When he buy he just tell how many and not which ones.
"Lawrence Sheed" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]
Sounds like a strange request, what are you trying to do?
I don't think you can do this directly in mysql, but you could build an
array of results in php.
eg something like (crappy code below)
//Grab results
$db = mysql_connect($db_domain, $db_user,$db_password);
mysql_select_db($db_databasenam
6 matches
Mail list logo