Yes agreed - but you cannot store them in a variable because they will
be lost each time the page reloads. Why not store them in a cookie?
Hello Davey,
thank you for help! I now don't use a cookie but added a column for this
purpose in my usertable in the db.
Torsten
--
PHP Database Mailing
Hello Pavel,
Tuesday, March 2, 2004, 7:20:03 AM, you wrote:
PL 2. ALTER TABLE `board` ORDER BY `threadid` DESC;
I never knew you could do this - it's quite fascinating this list
sometimes :)
I do have a question though - if I use this order by table
alteration, does MySQL remember it, or will
Hello Pavel,
Tuesday, March 2, 2004, 7:20:03 AM, you wrote:
PL 2. ALTER TABLE `board` ORDER BY `threadid` DESC;
I never knew you could do this - it's quite fascinating this list
sometimes :)
I do have a question though - if I use this order by table
alteration, does MySQL remember
Hello Pavel,
Tuesday, March 2, 2004, 12:33:17 PM, you wrote:
PL
http://www.mysql.com/documentation/mysql/bychapter/manual_SQL_Syntax.html#ALTER_TABLE
PL ORDER BY allows you to create the new table with the rows in a specific
PL order. Note that the table will not remain in this order after
Note! IMHO
Creating test table:
---
CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`site_user_id` varchar(32) NOT NULL default '',
`boardid` tinyint(3) unsigned NOT NULL default '0',
`subject` varchar(200) NOT NULL default '',
Hello Pavel,
Tuesday, March 2, 2004, 2:05:44 PM, you wrote:
PL Note! IMHO
[snip]
Wow. I'm speechless - thank you, that was probably the single most
useful post I've ever read on this list. You sir are a genius.
PL Change `site_user_id` FROM VARCHAR(32) TO CHAR(32)
It was a char(32) - it
Hi all,
Please CC me on any reply - I get the digest :)
I am working on a project where I need to implement something that most
resembles a checkbook register, where I am tracking pre-paid hours
bought vs. hours used on-site.
I am getting a bit stuck on the best structure for the mysql table,