| |
| |
| |
|
Page: 1 2 3
Comments:
<0> hi
<0> i have one table in my db with size=75mb, when I want count how many rows has it, it doesnt work
<0> mm, with others tables work rightly
<1> well, what are you doing to count them?
<0> thus
<0> $sql=mysql_query("select * from table",$link); echo 'cant: '.mysql_num_rows($sql);
<0> I guess that like its the biggest table I would need put field and not * when Im selecting
<1> $sql = mysql_query('SELECT COUNT(*) FROM table', $link); $res = mysql_fetch_array($sql, MYSQL_NUM); print('Count: ' . $res[0]);
<0> how you would do it?
<0> oh
<2> there ya go
<0> mm, do you say that the problem is because si so much big?
<2> probably
<0> ok, let me test it
<2> have mysql do the work
<2> instead of pulling huge amounts of data into php
<0> I dont understand what is the function of COUNT(*)
<0> and not * just
<1> well, instead of returning every row in your table, it returns the number of rows
<2> because you don't need to return the entire table just to get the count.
<2> it's what we in the business call "stupid"
<0> nothing
<0> it dont show me anything :s
<0> here is the file, let you see what it show http://www.pirata777.com/backup.php
<0> it doesnt solve it
<3> if I have a gif file
<3> can I change it to a .jpg
<3> and send it with a gif header
<3> will it still render?
<4> I thnk you owe it to yourself to try, just to find out
<5> trollboy yea.
<5> people serve .gif's as .jpg's sometimes for those scare things.
<3> rock on
<3> someone pissed me off
<3> and forgot I hosted her myspace bg
<3> I have a fatporn jpg up there now
<3> but a nice ani-gif would work better
<6> now there is an error i have not seen before: "Cannot remove module mod_auth_dbm.c: not found in module list" even though i only have "#AddModule mod_auth_dbm.c" in httpd.conf. the same for 6 other modules...
<6> in apache start log...
<3> locate mod_auth_dbm.c?
<6> it is in the compile-dirs
<6> but not installed it seems
<6> na... in the apache compile dirs
<3> where is the other modules
<3> where are rather
<6> apache_1.3.33/src/modules/standard/
<6> apache only remarks on 7 out of about 20
<6> well na, it seems it reports them all
<0> Revolt- done, it work :D
<6> and now apache wont start... any ideas here? apache log file: http://pastebin.com/650342
<7> im getting #1063 - Incorrect column specifier for column when im trying to convert an existing column to auto-increment
<7> anyway to get around it?
<8> did you make it a varchar or something?
<7> yeah
<7> ah yeah
<8> ...
<7> i see ur point
<7> ;D
<7> thanks :D
<8> mysql users pfft
<1> does anybody read the manual? =\
<7> i try.. i just need the obvious stated to me sometimes
<7> regularly*
<9> hello
<9> how can i read data from a mysql data base table ?
<8> McDaglas, you don't
<8> mysql is INPUT ONLY
<9> to read and echo
<8> you need to buy the output module
<8> I can sell you it
<8> for 50 AMERICAN CENTS
<9> god!
<9> everyone wants money to help
<1> well, you COULD go to php.net and search for mysql_query
<8> Revolt-, THAT IS ILLEGAL
<1> it's okay, I have connections there
<1> they won't rat me out
<8> DO YOU WANT THE GESTAPO TO COME AFTER YOU?
<1> yes
<1> been meanint to test out my new AR... was hoping the illegal immigrant riots would turn bad, but that might work just as well
<1> meaning*
<8> I bet wikipedia is having mysql troubles again
<10> ****ing hell, spim stopped working all of a sudden
<11> what the heck is going on in here
<6> do you reach this url? http://local.demomusic.nu
<6> does any of you reach this url? http://local.demomusic.nu
<10> meow
<7> nite
<11> tyler, did you get your nick from tyler durden ?
<12> no
<13> that's a stretch
<14> 'lo
<14> u lazy bastards... wake up :D
<10> **** you
<10> :(
<10> sup Jstr :)
<14> ****, just tired of being sick...
<10> fun.
<14> yea..
<14> and I am about to crash, cause i have to get up early cause i have to drive to toledo oh in the morning..
<11> Why is this Kevin Rose guy so popular
<15> he is good at ****ing ****
<15> slurp
<11> lol ok
<11> his series 'thebroken' is kinda "out there"
<11> didn't realise he was the founder of digg.com
<3> dear god
<3> I so want a macbook pro
<3> Mac's releasing software that will allow their new intelMac's to dual boot winXP
<3> that's just craziness
<3> at that point, wtf is the point of buying a "pc" at all
<15> nice
<15> yeah
<15> well the lower cost
<15> and wow, they finally made a commercial clockless processor
<3> it comes with a ****ing remote
<3> and even does scrolling on the touchpad mouse
<3> dude
<3> wtf
<15> yeah
<15> hehe
<3> that's just crazy
<15> my thinkpad has the scrolling thing
<3> Can your thinkpad run osx?
<3> yeah
<3> I didn't think so
<15> hehe
<15> Mebbe. :)
<3> as a person that swings both ways (PC's and Mac's) I have to say, architexture issues aside, Mac's are just damn fine computers
<3> and now that we can finally put the architexture issues aside...
<3> Dizam Bizzle
<3> I've owned macs
<3> I've 3 in my home right now
<3> all really nice computers
<15> yeah
<15> I like them
<15> they're just much too pricey
<3> Expensive as they are, they ARE worth every penny
<3> I view them like Bentleys....
<3> They're worth it
<3> but few "reach that high"
<3> speaking of "high", I'm off to teh wall's mart. I needs an iron, hair gel, and nuts.
<3> Don't ask why
<3> possibly a shirt as well
<15> !addquote <3> I needs an iron, hair gel, and nuts.
Return to
#php
or
Go to some related
logs:
#india
#allnitecafe
#linux
hohny lever
#kl
#india
#photoshop
caht with bangalore girls
#allnitecafe
fonction gmp call to undefined easyphp
|
|