>
> Thanks Richard that makes it clear.
>
> Thomas
>
> Hello Thomas,
>
> Thursday, June 2, 2005, 10:20:11 AM, you wrote:
>
> T> I have a bit of strange question: when wanting to insert multiple
> T> records into the db, instead of looping through the set
> and executing
> T> mysql_query (wh
Thanks Richard that makes it clear.
Thomas
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 12:43 PM
To: php-general@lists.php.net
Subject: Re: [PHP] Multiple inserts as a single string?
Hello Thomas,
Thursday, June 2, 2005, 10:20:11 AM, you wrote
Message-
From: Shaw, Chris - Accenture [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 12:20 PM
To: Thomas; php-general@lists.php.net
Subject: RE: [PHP] Multiple inserts as a single string?
Thomas,
If you're inserting alot of rows, (eg millions) then concating them and
calling the db
Richard Davey wrote:
>
> Sure.. mysql_query doesn't support more than one query in the sql
> statement.
>
At the risk of being thick, does the OP not mean something like this:
INSERT INTO blah VALUES (value1, value2), (value3, value4)
versus
INSERT INTO blah
VALUES (value1, value2)
ne
-Original Message-
From: Thomas [mailto:[EMAIL PROTECTED]
Sent: 02 June 2005 12:20
To: Shaw, Chris - Accenture
Cc: php-general@lists.php.net
Subject: RE: [PHP] Multiple inserts as a single string?
*
This e-mail has been received by the Revenue Internet
Hello Thomas,
Thursday, June 2, 2005, 10:20:11 AM, you wrote:
T> I have a bit of strange question: when wanting to insert multiple
T> records into the db, instead of looping through the set and
T> executing mysql_query (which will then call the db n times), is it
T> not better to concat a string
Thomas,
If you're inserting alot of rows, (eg millions) then concating them and
calling the db once probably would give a small speed advantage, because of
the database handshaking.
But I would look at the load the database is under, if there is alot of users
hitting the database with small inser
On Wed, May 18, 2005 9:47 pm, mayo said:
> $ses_basket_items is the total number of items
> $orderID = the orderID which these items are a part of
> $ses_basket_id = is the itemID number
Which item ID number?
Cuz, like, you've got FOUR different itemID numbers.
Something isn't making sense here
The trick here is to do some debugging :)
Firstly make sure that your error reporting level is set to E_ALL in
php.ini - then you've got some chance of seeing error and warning messages.
Secondly, while there are probably loads of ways of doing what you are
trying to do, all the correct ones wil
In a message dated 09/03/2001 12:38:08 GMT Standard Time,
[EMAIL PROTECTED] writes:
<< Whoa, you're mixing apples with oranges. Try:
$db = mysql_select_db($dbase, $connection);
$SQLStatement = "INSERT INTO Members (Email) VALUES ('" . $GetEmails[$a] .
"')"; //removed the 'or die' portion
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote:
> $SQLStatement = "INSERT INTO Members (Email) VALUES ('".$GetEmails[$a] ."')"
> or die ("Problem");
> $db = mysql_select_db($dbase, $connection);
> $SQLResult = mysql_query($SQLStatement);
Whoa, you're mixing apples with oranges. Try:
11 matches
Mail list logo
