| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> its not set anywhere
<0> i cleaned up the code a bit for you, removed the die
<0> http://phpfi.com/123085
<0> but i dont see where $id comes from
<0> on line 36
<0> and you shouldnt be setting the $filename on line 36, that should be your WHERE part
<1> ok
<0> http://phpfi.com/123086
<0> like this
<0> you may want to check for filename and filetype being same as current entry... and not updating the filetype too
<1> I just put it because an example that I read, and well in phpmyadmin appear
<0> if you understand
<0> $query = "UPDATE upload SET size='".$filesize."', type='".$fileType."', content='".$content."' WHERE name='".$filename."'";
<0> this says.... find an entry in the table that has a filename of $filename, and set that entries filesize to $filesize, and its content to $content
<0> try that, see how it goes
<0> afk
<1> ok thanks
<0> i'm not sure your check to see if the select found any rows or not will work tho... ask that part in phphelp chan ;)
<1> Mmm I'm not try it yet, cause my script is not working jeje... just the one I send you
<1> jeje wait please
<1> ammm Kaell it's your name?
<0> ?
<1> or you put it for Superman
<0> no
<0> neither
<1> well in Mexico its the pronuntiation
<1> hahaha
<0> its a long story... it has nothing to do with superman and its not my real name either
<1> you know crypton
<1> ok
<0> here's teh short version.... it was a name generated by a name generator for NWN (a computer game)... the name was Kell... Kell died and I remade him but since dead Kell existed I had to make different name
<0> so i named him K'ell
<0> K'ell also died and i did same again, and had to change name
<0> so i made it Ka'ell
<0> ' dont work in irc nicks... thus... Kaell
<1> hahaha that's fun
<1> :)
<1> where are you from?
<0> earth
<0> (almost said krypton there...)
<1> really??? mee too!! hehe
<2> hey how can I make a selection and only get a unique result set, for instance, "select unique(section) from articles";
<0> secifiy a uinique ke
<0> key
<2> can't do that because there will be multiple articles per section in the table
<0> hmm?
<0> well, WHICH one do you want?
<0> if you have 2 entries named "Frank", which frank do you want to get?
<0> a random one?
<1> Kaell can I get your messenger?
<0> no
<1> sorry
<1> still not working, mmm I will try another idea
<0> why is it not working?
<0> is your php code bad?
<0> what is it doing?
<0> which line is run?
<0> is it the check to see if the entry already exists?
<1> well I trying to update and doesn't work
<1> and when the file exist, upload two times
<0> show code
<0> put in checks to see which its doing, the update or the insert
<0> i think your check to see if select returns a value isnt good
<1> wait
<1> http://phpfi.com/123092
<0> format it right, then repaste it
<0> i'm not looking through that mess again :P
<0> i fixed it for you once
<1> mmmm what?
<0> fix the indents
<1> is right or not?
<1> indents?
<0> you have 5 spaces on some lines, and 19 on some others
<0> make it lined up
<0> http://phpfi.com/123086 <--- good.... http://phpfi.com/123092 <--- bad
<0> if($row['Name'] == '')
<0> why is 'Name' not 'name'?
<1> http://phpfi.com/123093
<1> is not the same? 'Name' or 'name'
<0> no idea, but why switch?
<0> your formatting is still horrible
<0> line 27 needs an extra space
<0> line 25 shouldnt be indented
<0> line 30 shouldnt be indented
<0> etc, etc...
<1> ok ok I got it
<1> l
<1> ok
<1> kaell
<1> the firts part it's ok
<1> if I have somefile.doc in my db my script doesn't duplicate
<1> but eather update :s
<1> kaell?
<1> I can!!!
<1> Kaell? I can
<1> thanks for your help
<1> thanks to CR000 too
<3> lol
<3> thanks to you too
<3> thanks to everybody
<3> heal the world
<1> haha
<3> i am staying up with the help of coke+coffe per 10mins
<3> couldnt sleep
<1> no men, if you want sleep better read the most bored book that you have or drink a beer
<1> I don't that stuff to sleep, I'm easy slepy, but my friends sometimes need that
<3> i dont have any boring book left
<3> i read them all
<3> :)
<1> ok then take a shower and drink hot milk
<1> not too hot
<1> try it :
<1> :)
<3> lol
<3> k
<1> see ya
<1> I'm going to sleep
<1> :)
<1> see ya
<1> in a few hours
<1> because I have to watch the world cep
<1> cup
<4> Hi, I'm having something like select max(version),file,filename from myfile group by filename... how can I have the file of the max(version) in that case?
<5> hi
<3> what does that mean?
<6> what does what mean?
<3> Hi, I'm having something like select max(version),file,filename from myfile group by filename... how can I have the file of the max(version) in that case?
<6> oh
<3> hi2u2 btw
<6> he has to LEFT JOIN on the version = MAX(version)
<6> or do a subselect or something
<6> how would I make a check in MySQL to create a table only if it doesnt exists?
<6> i have a 1500 lines mssql script i have to port to MySQL cuz mssql ****s ;)
<3> from php?
<6> no, pure mysql
<3> well normaly create table would generate error if that table already exists
<6> yes but i still add these checks in case a f-tard actually tries to run the code 15 times in a row (believe me, it happens all the time)
<6> and then they just don't know if it ran correctly because it does show up errors on the 14 subsequent times
<3> well i think only mysql 5.0 can do mssql kinda scripting prorgamimng and error checking
<3> which i amnot familiar with
<3> i usualy do it with some interface
<3> and apis
<6> ahh
<6> i do these checks all the time in mssql :P
<3> mssql has handy stuff
<3> but with an interface they are easier
<3> for me at least
<3> i even kinda forgot how was mssql scripting need to refresh my memory
<6> i could send ya my script if u give me a hand translating it ;)
<3> @@ is for reserverd vars @ for local vars
Return to
#mysql
or
Go to some related
logs:
#linux
#gentoo
whats _bstr_t in vc++
snoid clever
rebekah+page 3+lingerie
dxb2game125
pr0gram0r
#AllNiteCafe
#apache
#windows
|
|