| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> Kartagis: insert into table (date) values (NOW());
<1> Any suggestions on the logrotate /
<1> ?
<0> Kartagis: US date format is stupid: http://www.w3.org/QA/Tips/iso-date
<2> so, mysql_query("INSERT INTO defter VALUES('".$_POST[ad]."', '".$_POST[eposta]."', '".$_POST[yorum]."', '".NOW()."')"); ?
<0> no Kartagis
<0> Kartagis: first, separate the query from mysql_query(); so you have $sql="INSERT....."; and then mysql_query($sql);
<3> and then mysql_query($sql) or die( $sql . mysql_error() );
<0> $sql = "INSERT INTO defter VALUES('{$_POST['ad']}', '{$_POST['eposta']}', '{$_POST['yorum']}', NOW())";
<3> ewwwwwwwwwwwwwwwwwww
<3> Don't do that.
<0> will[werk]: why die??
<3> Kxzz, Check for syntax errors.
<3> Don't put POST variables directly into your code!
<0> will[werk]: the guy did it :)
<0> I don't really do it :P
<4> dormando: I hate that they don't setup caching of gifs in their https site :)
<0> I ahve more of a OOP way of doing things :0
<3> $ad = mysql_real_escape_string( $_POST['ad'] ); $sql = "INSERT INTO defter ( columns ) VALUES ( '$ad' )";
<2> that's because my webadmin said it's safer
<4> dormando: every time it has to load 60 small files ;-)
<4> this is how systems shouldn't be built
<3> OK!
<0> will[werk]: are you sure that the guy doesn't have magic quotes on? :)
<5> domas; I'm totally on the fence about offering to rewrite SM's website
<5> pageload are slow as hell too
<3> Kxzz, Bad bad bad idea
<0> Kartagis: your webadmin said... what is safer?
<0> will[werk]: d/w i'm no noob ;)
<3> d/w?
<0> don't worry
<3> Don't advocate it either! :)
<2> putting POST variables directly into the code
<0> Kartagis: O_O
<0> the guy is a freaking piece of noob
<3> Who?
<0> will[werk]: Kartagis `s web admin
<3> Kxzz, Btw, "freaking piece of a noob" isn't very nice.
<1> Thanks anyway. I'll try again another time.
<3> Even if said person is not here.
<0> will[werk]: but if a guy says that it's more secure :O
<2> what should I do then?
<3> Kartagis, My way.
<0> Kartagis: be aware of SQL injection and security; Google is always your friend :)
<0> will[werk] `s way is good too I think :)
<6> What do I need to do in order to rename a DB with InnoDB and not screw anything up?
<0> will[werk]: ok, i won't use any badder words :/
<6> I tried this the usual way (stopping mysql before renaming on disk) and this prevented me from dropping any tables with "Can't find record in 'table'" errors.
<3> heh
<3> hackel, mysqldump :)
<0> :]
<0> renaming files is not a good idea
<6> will[werk]: Ahh, I suppose that works I just figured there was a faster way, but thanks.
<2> Fatal error: Call to undefined function NOW()
<0> Kartagis: i suppose that you put it in PHP :|
<0> Kartagis: as i showed: insert into table (key) values (NOW());
<2> Kxzz: that's right
<0> this is a mysql functoin. you don't put it in any quotes and it is in the mysql query
<3> Fatal error means PHP error!
<0> will[werk]: yes look below that
<4> mysql doesn't have fatal errors!
<4> just crashes! :)
<3> I'm a newbie. SORRY
<3> hah
<0> domas :)
<0> will[werk]: you didn't sound like a newbie before :]
<3> I am.
<4> you are
<3> I mean, especially in the presence of domas.
<4> will and newbie sound quite same
<0> hehe :0
<3> SELECT * FROM #mysql WHERE SOUNDEX('will') = SOUNDEX('newbie');
<0> of course
<7> :)
<0> dammit :)
<8> lies
<3> Are you calling me fat?
<9> LOL
<3> ALL OF YOU GO AWAY
<4> will: LEVENSTEIN()
<4> will: feel the power of UDFs
<3> oooooooh
<9> if you have a 6pack and it's not beer are you still a nerd ?
<3> I
<3> Feel
<3> The
<3> Power
<0> I3ooI3oo_work: i don't see anything wrong with that :)
<3> I3ooI3oo_work, Yes
<7> I3ooI3oo_work: beer? I'll stick with wine and koolaid thanks :)
<9> if you have a 6pack and it's not beer are you still a nerd ?
<9> read the NOT beer
<2> mysql_query("INSERT INTO defter VALUES('".$_POST[ad]."', '".$_POST[eposta]."', '".$_POST[yorum]."', date("dd-mm-yyyy"))"; <--- what's wrong with this? apart from what will[werk] said
<3> I3ooI3oo_work, If it's not beer, we call you a liar!
<3> !tell us about whats wrong
<10> will[werk] asked me to tell you this: Don't ask us "What's wrong with this query...". We are not SQL parsers. We do not care to look character by character looking for errors when MySQL will tell all of us WHERE the error is. Paste the FULL error issued by MySQL.
<4> wooo, looks beautiful on 20" monitor
<3> domas, Widescreen?
<0> Kartagis: youi're not using NOW()
<4> will[werk]: um, yeah, it's more wide than tall
<3> domas, The Dell 20" LCD?
<4> will[werk]: imac
<3> iWho?
<3> www.ibuzz.co.uk
<2> Kxzz: because NOW() gives me american format
<4> iMac!
<2> unexpected T_STRING
<3> Kartagis, No. NOW() gives YYYY-MM-DD HH:MM:SS
<0> Kartagis: what?:) It's your MySQL server's problem. The best way to do is to put in the Timestamp of the date :)
<11> lousy american imperialists with their oppressive date formatting!
<0> american formatting is so crap :0
<4> haha, ibuzz rox
<3> Kartagis, Listen to what Kxzz has told you. And what I have told you. if you don't, go away.
<9> will[werk] is there an easy way to get utc from Now()
<0> pisses me off when there's something like 02/03/04 :)
<2> will[werk]: I want dd-mm-yyyy
<7> lsmith: samsung displays ROCK ***! That's the only brand LCD I buy anymore. I have three and they all came with zero dead pixels, and have never once had a problem and are BEUTIFUL displays
<3> Kartagis, date_format
<3> !m Kartagis date and time functioons
<10> Kartagis: Nothing found
<12> Sembiance: yeah
<3> !m Kartagis date and time functions
<10> Kartagis: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<13> hi. I am missing the file mysqld.sock in /var/run/mysqld/, so my mysql server won't start. what do I have to do to fix that?
<12> i took a look at a 20" wide screen benq
<12> not very impressed with the image quality
<12> and a 24" is bigger ;)
<7> lsmith: I'm still using 19" LCD's at 1280 resolution... I'd like to make the jump to 1600 resolution but don't want to shell out the dough :)
<12> 1,1k euros for the 24" samsung
<0> lsmith: what?!
<0> you coh wait...
<3> Was that English?
<0> you can get LCD for 900euros with 1324x768 or something resolution
<12> the only problem .. i need to try it out on my port replicator beforehand
<12> and its going to be hard to find one in a store
<12> Kxzz: that 1920x1200 res
Return to
#mysql
or
Go to some related
logs:
KOBEX debian
dpkg was interrupted vmware debian
linux a4tech wop35 wheels
ipw220 Fedora.core.5
#linux
etc-update meld
#perl
colt zaptel
#gentoo
trwbw go with god
|
|