TEMPORARY tables would require that he create and fill ALL the tables each
time. Too much work for what he needs.
mysqldump is your friend here
- Original Message -
From: Eugene Mah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 30, 2002 10:08 AM
Subject: [PHP-DB] Re:
majordomo and ezmlm would provide more power and cause more headaches than
he needs.
What he describes is very basic and can be done in less than 5 hours.
- 1 hour to create sign-up screen with db update, including test
- 30 minutes to create un-register screen with db update, including testing
Why don't you sort in your SELECT statement?
SELECT * FROM newsitems where ID='1' ORDER BY newsdate DESC
- Original Message -
From: Kirk Babb [EMAIL PROTECTED]
To:
Sent: Saturday, April 27, 2002 3:56 PM
Subject: [PHP-DB] select and sort question
I have a db table which holds news in
How is your option list created? Did you pull the names and values from a
database? Or is the list hard-coded?
- Original Message -
From: its me [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 26, 2002 3:39 AM
Subject: [PHP-DB] selected problem
i have the file:
$lastid = mysql_last_id();
returns auto_increment from inserted record
- Original Message -
From: CJ [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 24, 2002 4:19 PM
Subject: [PHP-DB] determine the primary key after adding a row to a table
(mysql)
is there any way to
mysql permissions?
you gave us no info...we can give you no answer
- Original Message -
From: Thomas omega Henning [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 22, 2002 11:25 AM
Subject: [PHP-DB] Problem
Ok i have a problem big one. I'm using php 4.0.6 and mysql 3.23
Why don't you let mysql sort and limit the records for you? That's easy
enough. Just keep track of where you are in the database and select only
the records that you need.
- Original Message -
From: James Kupernik [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002
I don't understand what you're saying
- Original Message -
From: James M Kupernik [EMAIL PROTECTED]
To: 'Richard Emery' [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 4:05 PM
Subject: RE: [PHP-DB] results on multiple pages
Because if I limit the record sort, then if the record I
Are you trying to create a table named How Are You? If so, can't do it.
It MUST be a one-word name.
You would have discovered this yourself had you typed your CREATE statement
into the mysql command line.
Second ALWAYS include an or die(Error: .mysql_error()) part after your
mysql_query().