#mysql
12 October 2007
Total 26 pages. You are browsing page 26/26.
First :: Prev :: [...] [22] [23] [24] [25] [26] :: Next :: Last
23:41 <****> update countries set
23:41 <****> Shankysv87: well there should be a program called "mysql.exe" somewhere that you can run and log in to a mysql console and issue SQL directly to the database
23:41 <****> .exe??
23:41 <****> ON GENTOO?
23:41 <****> Shankysv87: but easyphp may have some kind of administrator panel built in too... who knows
23:41 <****>cool, works :) update countries set Country_daDK = CountryDNK;
23:41 * ToeBee smacks chadmaynard
23:41 <****> TheGoldDIggah: good
23:42 * chadmaynard kicks ToeBee
23:42 <****> easyphp appears to be a windows only affair
23:42 <****> correct
23:42 <****> would #windows be a better channel for the problem?
23:43 <****> Haha. Doubt it Shankysv87
23:44 <****> Shankysv87: what is wrong exactly?
23:44 <****> looks like there isn't a #easyphp :(
23:44 <****> how can you make php easier? that's like claiming the name "php" is too long.
23:45 <****> it's longer than c
23:46 <****> vluther: maybe in spelling
23:46 <****> Anybody available to look at my fugly sql: http://pastebin.com/m49b99568 ??
23:46 <****> XD
23:46 <****> they take about the same amount of time to say
23:47 <****> but not type..
23:47 <****> three syllables vs 1
23:47 <****> see vs pee eich pee
23:48 <****> i guess if you call it phhhpf
23:48 <****> phupf
23:48 <****> heh
23:48 <****> prakriti: i saw that SQL your opinion isn't valid
23:48 <****> my opinoin?
23:48 <****> ion
23:48 <****> right
23:49 <****> which opinion is that?
23:49 <****> eich? like german?
23:49 <****> about php
23:49 <****> hehe
23:49 <****> and syllables
23:49 <****> me pronounces "h" like this: h
23:49 <****> ERROR 1349 (HY000): View's SELECT contains a subquery in the FROM clause
23:50 <****> pretty clear error
23:50 <****> right, I can't use the subselect in my from clause, I know that part. :)
23:50 <****> I just don't know how to do what I am trying to do. :(
23:50 <****> they key is two fields, mls_num and row_id
23:51 <****> row_id is badly named because it starts at 1 for each mls_num
23:51 <****> I just want the max row_id for each mls_num
23:51 <****> I don't know how to do that without the subselect that I used.
23:52 <****> Do I need to make another view to select from?
23:52 <****> have a view that hits a view?
23:53 <****> i will take the silence as a resounding YES. :)
23:54 <****> I have a table with userid and score. I want to select the score of user with id say 211, and want to know how many users with score higher than the score of user 211 there are.
23:55 <****> the thing is, there are a lot of users with the same score ..
23:55 <****> any ideas?
23:56 <****> phah, just asking that question alouod just gave me the answer ...
23:57 <****> drvdijk: i find that it often does ;)
23:59 <****> 211)
23:59 <****> *doh!*
23:59 <****> or
--- Log closed Sat Oct 13 00:00:13 2007
Total 26 pages. You are browsing page 26/26.
First :: Prev :: [...] [22] [23] [24] [25] [26] :: Next :: Last