(no subject)

[rubah]

My one and only big brother Cory Tyler is getting married tomorrow! My mom is excited xD

Also hey, if you guys didn't do this johari thing (picking attributes that fit me) the last time I did it like, two years ago now maybe? Do it now!

http://kevan.org/johari?name=jume

I dolled myself as miss scarlett xD From Clue!



It was kinda funny, I opened ws ftp like I always do to upload a doll, then I stopped and thought 'heyyyyyyyyy wait, I have the dollanator thing all finished now, let's TEST IT OUT!'

So I used my form for the first time the way it was intended :)

Of course I added a field to the myql table and didn't reflect that in the form (I love phpmyadmin) so I'll have to add that later, but man!

(I have been having to make up all kinds of sql snippits to work with this database thing, and I don't have a book or anything and the documentation on the web is pretty. . well, unintuitive if you don't know what you're doing (if they'd make that better they'd have more people being web programmers and stuff! php is similarly a FIEND to get a hold on early on! well I guess it might not be if you had patience to do dumb tutorials instead of coming up with what to do yourself and trying to reverse engineer a way to do it, but hey I'm getting some of this stuff down.) ANYWAYS, I've been saving up the snippits in a text file so I won't have to relearn them every single time I want to order the rows in the table xD)


To duplicate a field/replace info in certain fields
UPDATE [the table] SET [the updating field]="" WHERE [the trigger field]=""

To display rows
SELECT * FROM `[table]` ORDER BY `[field]` ASC/DESC LIMIT [start(0)] , [end]

To shift a whole bunch of rows' values in one field
UPDATE [table] SET [field] = ([field]+/-[amount]) WHERE [field] BETWEEN "min" AND "max"

This last one I'm really proud of. For my dolls database, I set the primary id to auto increment and tried really hard to add them all in chronological order (it's hard because I don't have any proof of chronologicity anymore because of resaving files, editing and saving, etc etc etc, but I have it more or less in time order) but for some reasons I missed some or accidentally did some wrong and the counter got upset in some spots. And then when I was trying to reorder them, it was hell getting an empty spot to put some, and I really could have used this earlier on xD But I managed to get this to work today (after several tries!) and I am so really happy about it!

I've been listening to radio-fr again, and I really enjoy it.

Comments

[krabmeat.livejournal.com]

I'm listed on that thing twice now!

and my answers are different!