#mysql
23 October 2007
Total 29 pages. You are browsing page 5/29.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
02:45 <****> hello
02:46 <****> does anybody have a little to help me write a database interface for a little widget?
02:46 <****> heh
02:46 <****> homework?
02:47 <****> no
02:47 <****> not a homework
02:47 <****> it's a widget I have written for a friend for his website, now he want to change the functionalities via an interface which I must implement in the admin section of the cms they use
02:48 <****> I just need good orientations on how to setup the tables because I started and got lost
02:48 <****> http://209.85.40.50/
02:48 <****> on this page you will see on your left a sort of image slider
02:49 <****> I have hard coded everything in the javascript code
02:49 <****> he wants control over the speed, where the images come from, and the order
02:49 <****> whats the link on how to delete duplicate rows?
02:50 <****> DISTINCT?
02:50 <****> vice-versa: first thing you need to do is optimize your site
02:50 <****> its stupid slow
02:50 <****> oops that was fro you nvictor
02:50 <****> blobaugh: I got it
02:50 <****> blobaugh: it's not mine, and I don't agree on the design
02:51 <****> it uses table for layout
02:51 <****> I don't like the cms
02:51 <****> I don't like the way things are organised
02:51 <****> :)
02:51 <****> blobaugh: do you see the widget?
02:51 <****> it's all I'm concerned about
02:51 <****> on the left
02:52 <****> which one? there is a bunch of stuff on the left
02:52 <****> you dont know how to make tables?
02:52 <****> I know the basic stuffs
02:52 <****> so what do you need specifically?
02:52 <****> but I need professional look on it
02:53 <****> well, you see I would really put all those config stuff in a ini-like file but this cms enforces database
02:54 <****> whats wrong with keeping it in the db?
02:55 <****> blobaugh: well this is why I'm here, how do I keep this sort of thing? There are basically 3 things, a speed or the image rotator, the different features [blogs, interviews, news...] which are displayed, and finally their order
02:55 <****> this is how I started
02:56 <****> http://rafb.net/p/OUu5BB33.html
02:57 <****> hi. I'm trying to select some rows wich have id's 5, 4 and 3 in that order. I can't just SELECT * in `foo` WHERE `foo_id` IN (5, 4, 3), because they become ordered arbitrarily
02:57 <****> you could have a column called order in a single table with all the config stuff
02:57 <****> i want the result to have the order 5, 4, 3
02:57 <****> me?
02:57 <****> vampirefrog: you need ORDER BY
02:57 <****> order by what?
02:57 <****> 5, 4 and 3 are arbitrary examples btw
02:57 <****> ever used order by before?
02:57 <****> I might want 5, 3, 4
02:58 <****> yes
02:58 <****> but by id and date
02:58 <****> what can I use here?
02:58 <****> order by foo_id desc
02:58 <****> to get 5 3 4 you'll have to ask chadmaynard
02:58 <****> chadmaynard: ping
02:58 <****> :)
02:58 <****> hehe
02:58 <****> order by field(column, 5,3,4);
02:59 <****> told ya ;)
02:59 <****> hm
02:59 <****> let me try
02:59 <****> i replace "field" and "column" ?
02:59 <****> or is field a function
02:59 <****> field is a function
02:59 <****> right
02:59 <****> replace column
02:59 <****> i should have capitalized
03:00 <****> ah
03:00 <****> yes
03:00 <****> thanks
03:00 * blobaugh smacks chadmaynard on the back of head
03:00 <****> it worked just fine
03:00 <****> :)
03:00 <****> there's no important performance loss,right?
03:00 <****> just like normal ordering
03:00 <****> let's say I have 20 id's in the list
03:00 <****> ok
03:01 <****> thanks
03:02 <****> blobaugh: http://rafb.net/p/DAIYl086.html
03:02 <****> how do I ensure that features are unique?
03:03 <****> use the UNIQUE keyword when creating the column
03:03 <****> are there lots of items going into rotator_features?
03:04 <****> yes
03:04 <****> no
03:04 <****> ?
03:04 <****> 4 of 5 max
03:05 <****> im not sure i can parse that
03:05 <****> are these definitions correct?
03:05 <****> there are 5 features max
03:05 <****> i want to know if there will be multiple rows in the rotator_features table, or only one
03:05 <****> multiple
03:05 <****> ok
03:06 <****> I need id right?
03:06 <****> i would. it makes it easier to update the table
03:07 <****> ok
03:07 <****> the config table only holding one column and one row is a bit excessive though
03:07 <****> you could easily have that in a file somewheres
03:07 <****> yes
03:08 <****> same for the others also
03:08 <****> but in order to integrate this in the admin section of the cms
03:08 <****> I have to do that :(
03:08 <****> does it need an id also?
03:09 <****> Any one knows where to find a good reference to build a WEB2.0 db?
03:09 <****> not really. just say update and it will take care of the whole table
Total 29 pages. You are browsing page 5/29.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last