IIRC, someone added automatic rollback to MySQL from PHP 4.3.0 just
like PostgreSQL.
BTW, PostgreSQL module rollbacks uncommitted transaction automatically
from PHP3.
--
Yasuo Ohgaki
John W. Holmes wrote:
I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use
InnoDB tables for tr
Although my query returns the date of the day that had the highest number of
records inserted.
It outputs the total number of records in the table..
Can someone with more experience in SQL help me only count the number of
records inserted on the day with the highest number of records?
BTW the co
Well, for one thing, EXTRACT() is for MySQL timestamps, not unix
timestamps.
---John Holmes...
> -Original Message-
> From: Noodle Snacks [mailto:webmaster@;tececo.com]
> Sent: Saturday, October 19, 2002 7:36 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] It counts everything not a speci
Hiya,
Just wondering what is the best way to get some data out of a database in cutom
order.
They all have grades like A*, A, B, C and some are grade Secret.
If I sort them by grade secret is at the bottom, I would like this at the top. I
realise I could get all the Secret's, then
Steve Vernon <[EMAIL PROTECTED]> wrote:
>Just wondering what is the best way to get some data out of a
>database in cutom order.
>
>They all have grades like A*, A, B, C and some are grade Secret.
>
>If I sort them by grade secret is at the bottom, I would like this
>at the
OK,
Looks like there are two options
I can either convert the unix timestamp colomn to a mysql time one *OR*
someone can tell me how to use unix timestamps in this query...
--
JJ Harrison
[EMAIL PROTECTED]
"John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:001101c2777a$dcb96c10$7c0
You can use an auxiliary lookup table:
FK_mygraderank
-
Secret1
A+ 2
...
Now join this table to your SELECT query on FK_mygrade, add 'rank' to the
SELECT items,
and ORDER BY rank
HTH
Ignatius
__
Hi,
in some cases, you might prefer to use a multiple element; this can
give you a much more compact user interface (though you probably won't use
it if you have 40 options ...)
It goes like this:
--all--
conjuration
abjuration
Hi,
Saturday, October 19, 2002, 5:15:41 PM, you wrote:
JN> You know, I didn't even think about serializing the array. I have a
JN> table set up for spells, one for schools, and a linking table using the
JN> spell id and the school id(s). I could have done without the linking
JN> table. Some
At 11:48 PM 10/18/02 -0500, Shiloh Madsen wrote:
For instance, a series of checkboxes with items such as abjuration,
conjuration, divination, and others, which will all have a numeric value
which gets plugged into the enum field. for instance, if a user selected
abjuration, and divination, i
There should really be another table for all of this information. Say
you're tracking school information for a specific person. That person
would have an ID number and you'd store the school information in a
separate table that stores the user's ID and the school ID. You could
even expand this to t
While reading the MySQL manual for INSERT SELECT, I was
not able to determine how to include all 5 fields of one table into another
table (containing 100 fields) into SPECIFIC data fields. Do I need to
explicitly list all the fields within the table of 5 fields? If so, would
the statement
That's how you do it. Hopefully you've figured it out already.
---John Holmes.
-Original Message-
From: dwalker [mailto:dwalker@;healthyproductsplus.com]
Sent: Saturday, October 19, 2002 7:51 PM
To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Ins
For some reason the Insert Select statement returned an ERROR and I had to
resort to
INSERT INTO Products
(ProductName,Size,SuggestedRetailPrice,ProductCategory,ManufacturerName)
SELECT *
FROM kalproduct ;
Is there a noticeable reason why:
INSERT INTO Products
(ProductName,Size,SuggestedRetail
what was the error?
"dwalker"
,
15 matches
Mail list logo