| |
| |
| |
|
Page: 1 2 3
Comments:
<0> hello, does anyone have a phpmyadmin-2.8 conf file ?
<1> no
<2> thesefirah: google
<0> nothing good. 2.6 works 2.8 doesnt
<3> hello
<3> can someone plase help me with a query
<3> i have a table with a width and heght field
<2> and?
<3> i want to get a list of all width x height without haven same sizes repeated
<3> how can i do that?
<3> i know i have to use group by, but don't know how
<3> select id, width, height from table order by width, height ..... ????
<1> select width*height as size from table group by size;
<3> grazzy, no width x height is a string output: "10.2 x 23.3"
<1> well taht ****s for you
<1> heh
<1> why?
<1> and ueh, then i dont understand your question either
<1> what data do you want?
<3> grazzy, can i add other fields: select width*height as size, width, height from table group by size;
<1> ypu
<1> why dont you just try it instead?
<3> i need them as separated fields
<1> sure, go ahead and experiment
<3> ok
<1> it's not like a select-statment will kill you or your data.
<3> thanks
<3> i already tried... thats why i came here .. :)
<3> bu i'll try again starting from your sample
<3> grazzy: wait... but doing w*h, i don0t get them in order
<1> order by <whatever you want>
<1> heh
<1> now you're just being plain stupid
<1> please, read the doucmentation for group by
<3> :| ... think that was a stupid question
<3> heh
<1> and atleast try to understand what it does
<1> it's nothing magic about it
<1> give it 5 minutes and you'll wrap your head around it
<3> just got the same error as before
<3> as soon as i put the group by
<3> oh, got it...
<3> it was because i was putting and order by before group by
<3> thanks
<4> I need a dump of a very specific SQL Query in CSV Format
<4> how can I do that?
<5> i would use phpMyAdmin if you can, if not i think mysqldump can do that
<4> zeldar how can I escape
<4> table.column-name
<4> in an sql query
<2> mysqldump -u user --p***word=wordp*** database | gzip > backup.sql.gz
<4> Yeah I can't seem to get my query to work
<2> what error do you get?
<6> Lubs
<6> http://www.affinitygo.net/
<6> all from MySQL
<6> grazzy no im not spamming nothing on the site
<1> lub
<6> love
<6> i put eveything in MySQL images/css/js/html
<6> its all handled by one script called system.php
<6> heheheh
<2> ;)
<1> thats almost .. perverted
<1> using mysql as a filesystem
<1> actually, i do almost hte same
<1> ;)
<1> i store phpcode in a database for one project
<1> that i select and evaluate depending on the situation
<1> to create a dynamic site (you can edit the php-code from the adminsystem)
<6> yeah what im writing is a multi site SEO engine
<1> heh
<6> so you point a domain at it and then you get content thats selected by hostname
<6> one code base
<6> many many sitez
<6> sorry
<6> sites
<1> spam ;)
<6> (dark room, black keyboard)
<6> no not spam we sell CMS solutions
<1> hehe
<6> just when we find a bug we have to p*** it across all the CMS`s
<6> and its a PITA this way when we lanch v2 i can have one code base to patch
<1> i do that for plenty of sites
<1> i use symlinks and gettext()
<1> one codebase that's symlinked into many hostname_tld-directories
<1> and then i change the content with po/mo-files
<1> and if i dont want a specific feature on one particular site i just remove the symlink and place a static file there
<1> i do that for hotels for instance.. hotel booking sites.. have like domains 50 in swedish
<6> cool
<1> i rewrote the entire system to be in english and under one domain at the form /hotel/city/hotel instead of domain.com/hotel/
<1> in an afternoon ;)
<1> yeah it's quite efficient, gettext rules :)
<6> awsome
<6> the reload of image over the text BTW is on purpose the text is rendered on the fly with the font of choice for that site
<6> its pt in a <h1>your text here</h1> cause SEO likes that
<6> then i replace with JS an image by extracting the text from the H1
<6> and GD render an image
<1> ;)
<6> matching the inline style
<6> gives a nice screenshot but sticks with SEO
<6> (were seo specialists too hehehe)
<1> which kid on the corner isnt these days..
<6> yeah we dont do blackhat tho
<6> ;
<6> ;)
<6> http://search.msn.co.uk/results.aspx?q=staffs+CRM&FORM=MSNH&srch_type=0&cp=65001
<1> msn is bs though ;)
<1> spam enough links and you'll rank for anything on a new site
<1> you slowly drop in the serps
<6> http://search.msn.co.uk/results.aspx?q=chameleon+CMS&FORM=QBRE
<6> we havnt spammed any
<6> i said no blackhat
<6> we only do whitehat SEO
<6> http://search.msn.co.uk/results.aspx?q=midlands+locksmith&FORM=QBRE
<6> 2nd result
<6> http://search.msn.co.uk/results.aspx?q=car+hire&FORM=QBRE
<6> first result
<6> all ours
<1> "whoa"
<1> are those new domains?
<1> or old (+1 years)
<6> carrentals is +1
<1> mhh ok, might stick then
<6> locksmiths is about 18 month old too
<1> but still
<1> msn is bs for seo
<6> oceanworks domain is 2 years
<1> and you dont get as much traffic as of google
<1> i rank #1/#1 on similar terms on google / msn and i dont even get 10% from msn of what i get from goog
<1> im even second on goog and #1 on msn
<6> http://www.google.com/search?hl=en&lr=&safe=off&rls=RNWM%2CRNWM%3A2005-50%2CRNWM%3Aen&q=car+hire
<6> we get a lot of traffic from msn
<1> aha?
<1> thats curious
<1> domain im talking about is a co.uk
<1> for int traffic
<6> most of ours are
<6> are traffic is more local cause we do more local work
<1> - Google25622562
<1> - MSN9
<1> - Google 2562
<1> heh
<1> #1 on msn, #2 on goog :) same term..
<6> cool
<6> http://www.google.co.uk/search?hl=en&safe=off&rls=RNWM%2CRNWM%3A2005-50%2CRNWM%3Aen&q=chameleon+CMS&btnG=Search&meta=
<6> see we only get 4th for that on google
<6> but we get a lot of traffic from MSN
<1> ahh..
Return to
#mysql
or
Go to some related
logs:
#AllNiteCafe
fuck lolt
#MissKitten
#chatzone
#gentoo
#linuxhelp
#chatzone
#chatzone
#london cheech
#linux
|
|