| |
| |
| |
|
Page: 1 2 3
Comments:
<0> hi, because im new to mysql
<0> im creating a website and i am creating database to mysql server
<1> lucky you
<1> now read the manual
<0> i know how to create the database
<0> im using php to create the website
<1> must be something you don't know, since you're here in the first place.
<0> no my question is some kind of general stuff
<0> how do we retrieve data from the database
<0> from the server
<0> i know using queries but how we link to database to retrieve it
<1> that is a PHP question then, not a mysql question
<2> mysql_connect()]
<1> I prefer pconnect generally
<1> persistant connection reduce the latency
<2> i dont its dangerous people leave it open
<1> nah, usually ok
<2> and maxis out the connections to easily
<1> that depends on the max limit now, doesn't it?
<0> do we need a to put the p***word of mysql server?
<1> Threads: 102
<1> Jakob: rtfm
<0> where is that
<1> dev.mysql.com
<2> mysql_connect(host,username,p***word)
<3> lol
<1> bah, same dude
<1> php.net/mysql_connect
<1> okay, next shot
<0> thanks...
<4> hi ...
<4> i'd like to know if it is possible to GRANT priviledges with a table name mask
<4> like:
<4> GRANT CREATE, DROP, SELECT, INSERT, DELETE, UPDATE ON `db`.`table\_name\_mask%` TO 'user'@'host';
<5> Does anyone know of a way to limit the amount of memory and number of processes mysql forks() at startup?
<1> I don't bother dealing with you today
<1> so please, just leave
<5> whats wrong dude?
<1> gf and I broke it off today..
<5> sorry to hear it.
<1> I'm not
<1> anyways, you were in here the day before as well
<5> yes I know.
<1> and you still haven't read the manual, have you?
<5> but honestly I don't like calling it "GNU/Linux" all the time.
<5> I know its GNU but its just semantics
<1> not really, I like to mess around with linux
<5> the kernel you mean? Or the whole system?
<1> mostly because when I first started using it I had to
<1> linux => kernel
<1> GNU/Linux => os
<5> I know.
<1> s/os/OS
<1> so when I say Linux, I mean Linux
<1> not GNU/Linux
<1> no matter how drunk I am
<5> so do you protest all the "Linux Bible" books that aren't dealing with the kernel only?
<1> they are made by n00bs for n00bs
<5> Are you a kernel developer? When did you first start playing with linux?
<1> not an official developer, no
<1> and I didn't really start before 95-96
<1> too yong
<1> young*
<1> was 12 then
<1> uhm, 11 in 96
<5> I see
<1> had to hack some kernel modules to get the printer to work for one thing
<1> which was part of what got me started on the whole thing
<5> I started in 94 with a slackware that was packaged in a book titled "Learning Linux"
<5> got burned by kernel panics
<1> well, depends on how you define "started"
<5> then took a break and started again in 96 with redhat
<1> I tried phat linux for one thing beofre it
<1> before*
<1> when I say get started I mean I actually used it
<5> same here.
<5> what distro are you into now?
<5> or have you moved to one of the BSD varients
<5> >
<5> ?
<1> a little bit of everything
<1> my client systems are mostly mandriva
<5> I haven't touched BSD yet. I probably should
<1> for servers I prefer gentoo
<1> some servers are pretty much LFS
<5> wow. I'm like the other way around. I like gentoo for desktops but debian for servers.
<1> that doesn't make much sense
<5> sure it does.
<1> the server you like to tweak
<1> custom compiler flags, get the beef
<1> the client system just has to work
<1> Linux alpha.kfwebs.net 2.6.15-gentoo-r1 #5 SMP Sun Jan 29 14:37:56 CET 2006 x86_64 Intel(R) Xeon(TM) CPU 3.00GHz GenuineIntel GNU/Linux
<5> I try to keep the most stable build for servers. They can't afford to be down too much
<5> Gentoo takes a lot of config time and takes even longer to rebuild software.
<5> My servers typically run headless with out X11 so speed is no problem for my servers.
<5> I admit I run gentoo servers from time to time because I'm a hobbiest I also admit Its not a good idea for a production server. :)
<1> of course you don't have a GUI on a server, that would be stupid
<5> besides it feels odd compiling a server with high optimization flags only to see it running scripts through cgi. ;)
<1> **** CGI
<5> I know.
<1> well, I actually have some CGIs
<5> but I wanted to learn it.
<1> tend to prefer PHP though
<1> but CGIs written in C++ can be optimize quite a lot
<5> does php not work through cgi?
<1> it can
<5> modules?
<1> I run it as an Apache module
<5> they have a module for everything I guess. :)
<5> I was looking to do some CGI via C. Right now I'm useing python.
<5> speaking of which. I thought it was odd that apache counts mysql as a dependency for some reason.
<5> postgress too, which is odd since I don't even have postgres installed.
<5> any ways is there a doc that better explains how to set up /etc/mysql/mysql.cnf? Still looking for the manuel
<1> dev.mysql.com
<1> chapter 7
<5> thanks. :)
<6> someone alive?
<6> i have a problem .. i need to make a distinct selection
<6> and i'm not good at :D
<6> so.. anyoane?
<7> $r = mysql_query("SELECT * mutu_poze");
<7> while($row=mysql_fetch_array($r))
<7> {
<7> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
<7> can somebody tell what is wrong ?
<1> that is a PHP matter
<1> and learn proper debugging
<1> id est mysql_error()
<7> You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mutu_poze' at line 1
<7> cool it work now :)
<1> http://www.kfwebs.net/debut
<1> http://www.kfwebs.net/debug
<8> You have an error in your program please consult the squishy problem between the chair and the keyboard
<1> hehe, NeoFuture
<8> hehe
<1> damn, I
<8> im tired and drunk
<1> ditto
<1> well, for the last part anyways
<9> mmm
<8> hehe nn all
<9> I'm going to be drunk
<1> heya JC^Omega
<1> I beat you too it
<9> here bout 2 hours...
<8> 02:43:10 here
<1> emptied my vodka already
<9> I'm going to be the only cowboy at the party
Return to
#mysql
or
Go to some related
logs:
#skype
connection limit to 10 in win2000 pro
#skype
gay coatza
#linux
inxorablewan
#java
#AllNiteCafe
#AllNiteCafe
printf C2022
|
|