| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> just doesn't make sense
<1> what's the is_active function do
<1> can you pastebin that?
<1> or just pastebin the whole userpage cl***
<0> Okay well its definately getting data because I did print_r($data); and its all there
<0> http://intam***age.com/mod.php?mod=userpage&menu=130802&page_id=68
<2> how about trying to print_r the $current_data
<0> Aye tried that, when I print_r $current_data nothing comes up for page_id=68 however it prints for the rest of the pages
<0> youho: one second lemme paste the is_active for u
<0> youho: here's the whole userpage cl*** http://pastebin.com/717883
<3> hello, what is the easiest way to convert database from postgreSQL to mySQL? Is it possible?
<4> nanotube: some people have reported success with using the Migration Toolkit
<4> nanotube: otherwise, using pg_dump with some options and importing it into mysql can work (keeping an eye out for errors - sometimes you have to fix things such as some quotes)
<2> if the quotes is " for the identifier, you can set mysql to recognise " instead of `
<3> MacPlusG3, thanks
<3> will do some research on it...
<5> hey is there a way to simply insert a row into a DB that matches another row?
<2> where is the row you want to match
<5> in the same db
<2> another table
<5> same table;
<5> sorry
<2> !m squigly insert select
<6> squigly: (INSERT ... SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
<2> same table?
<5> yes
<7> hi, is there any changes in sight in the certification?
<7> because I would buy a book from 2004 and I want to know if it's still revelent
<0> the newer the better
<0> a lot can happen in 2 years
<5> lokus, thanks !
<2> stpere: there are exams for version 4.1 and 5.0
<2> stpere: even 4.1 something may be new that is not in the 2004 book
<2> stpere: best to buy the official certification guide
<2> stpere: there are 2 different books for the different version
<8> stpere: I've heard the test is tougher than most people expect. like half fail.
<8> so study hard
<9> can i do a select to count the number of rows in a table?
<9> and can i do it with join?
<2> oh, at the uc, about 60% fail from teh result posted on the board, but i guess some are not fully prepared especially those who got the exam fro free
<8> ya
<8> sobering
<8> the only certification I would have to respect would be the cisco ones, and maybe the cissp one.
<8> those are useful.
<8> A+, MSCE, etc. - those aren't
<2> depends to which cisco, the higher ones are but not the lowest one
<8> they're all tough
<8> and all really helpful
<10> ccna isn't useful
<8> sure it is
<10> ccnp is ok, ccie is the one that's actually worth it
<10> naw
<10> a monkey can p*** ccna
<8> some of those take like 5 years to prepare for now
<2> but need to go on the next level
<10> ccnp is a bit tougher but still not bad
<10> the one people spend years preparing for is ccie
<8> I'd like to know more about the ccnp. do you know how long it takes/ how much work it is to prepare for?
<10> 4 tests
<10> routing/switching/wan/troubleshooting
<10> if you know cisco reasonably well and you learn quickly you can study for each for maybe a few weeks and p*** it
<10> that's what i did at least
<8> cool
<8> do you feel more like a stud now?
<10> not at all
<8> do you work at an isp or something?
<10> i barely use cisco stuff these days
<10> nope
<10> i got it for the fun of it
<8> gleam- did you practise on real hw?
<10> nope
<10> this is the reason i say ccnp isn't a good indicator of skills
<8> well, that's lame
<8> they've tightened things up to avoid that now
<10> they've supposedly made it harder since i took it
<8> so I heard
<10> this was back in 2001 or so
<2> so your cert expired already? there is a expiry date or something on cisco cert
<10> yeah, they expire after 2-3 years or so
<10> and i just didn't see the value in it
<10> people care so much more about experience than certs
<10> and really about how you interview
<2> maybe except ccie
<10> well yes
<8> ya, especially since most experienced cisco people are pre-certification.
<8> :)
<10> but i think it's really ahrd to get ccie without having the skills to back it up
<0> man this makes absolutely NO sense at all.. if you go to http://intam***age.com/mod.php?mod=userpage&menu=130802&page_id=68 it works fine, however if all I do is change on character inside row 68 it gives me an error.. even if I end up changing it back
<10> have you looked to see if your query is generating an error?
<0> Its not
<0> gleam-: I'm only updating it via phpmyadmin.. select row and click edit, change one letter or don't even change anything.. hit submit and its broken
<10> so?
<10> maybe there's a bug in your code
<0> gleam-: well its not my code, its a mess created by someone else, but it works fine for everything, its only when I try to edit a row when it dies (still works for the rest of non edited rows)
<0> makes me think its a way mysql is saving the updated row
<10> try changing it via the cli, maybe phpmyadmin ****s
<10> do you have hte code for index.php up somewhere?
<0> Could it be because phpmyadmin is print the /r and /n and ****? like when I click edit (its longtext) it displays it properly formatted) however when I created it, I inserted it as one huge line/unformated
<0> Like after I edit it, I can delete the row and re INSERT and the code works fine again
<10> i have no idea. i've barely used phpmyadmin
<0> Like instead of editing it, I deleted the row, and then edited the SQL dump I was given by the old admin and INSERT it again with the new code, and the changes work now
<0> okay, so I should look into installing cli?
<10> the cli is probably around somewhere anyway
<10> ssh into the server and run mysql
<0> okay
<0> I'm in.. now what?
<10> run "mysql -uusername -p -hdbserver databasename
<0> aye I'm in
<0> mysql>
<10> run your queries
<0> meh, its hard
<0> because the database they set up is ****ing ridiculous
<0> you want to know why?
<0> its because t hey have a listing of 400 members and instead of just having a database with DATA then inserted like 400 members including all the HTML formatting into ONE row for each country
<10> well that's pretty damned stupid.
<0> so that means if I want to make a SIMPLE change I need to retype everything
<0> yeah no ****
<0> I'm in the process of completely rebuilding the site
<0> however I've been requsted to make some simple database changes to the members in the meantime
<10> looks like you'll need to delete and reinsert the rows or come up with an easier way to edit the field than the cli and one that works better than phpmyadmin
<0> ungh
<0> is there anything you would recommend over phpmyadmin?
<10> the cli :)
<0> heh
<0> hard to type in 400 members including all the formatting for each one everytime I want to make a simple change :P
<10> copy and paste?
<10> use the string functions?
<10> !m mugger string functions
<6> mugger: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<0> I guess I could do that via PHP
<9> can anyone help me with a select and unixtime question?
<9> okey, im writing a blogg
<9> and i need help listing the months available in a table-column
<9> anyone wanna point me somewhere?
<10> !m sidey date and time functions
<6> sidey: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<8> sidey: just use Wordpress.
<8> the world doesn't need another blog
<9> im doing one for myself
<9> aint coding nothing for the public
<9> :D
<11> OMG! ##mIRC !
<9> what am i looking for perl?
<8> sidey: curious why you want to write another blog? you gonna write your own templating syste too?
<12> huh wonder why my slave won't get into sync
<13> Hi. I want to wipe out all of my mysql data. What can I safely delete in /var/lib/mysql? I want to start totally fresh.
<10> everything and run mysql_install-db
<10> _db
Return to
#mysql
or
Go to some related
logs:
the eldritch supaplex
is fixboot harmful
#debian
askmethod bind-config
kde notifications ogg123 mplayer
#php
#css
ubuntu xfs Input/output
mod_pony
#math
|
|