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,
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 hol
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 '',
`mo
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 in
> 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 MyS
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 wil
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 List
