| hypersonic | I don't know if I have access to the mysql server settings ,it's a remote server. :\ Will backslashes still escape special characters, but just not be removed with that mode set, or will they not escape at all? |
| erflynn | hi is there a way to drop a list of tables that start with a prefix? |
| insta | if "EXPLAIN SELECT ..." returns select_type of "SIMPLE", a type of "ALL", and possible keys is blank ... does that mean the query won't use an index? |
| SnakeO | hey, how is this done: http://digg.com/search?section=news&s=mysql the result highlighting? |
| insta | it's nothing with MySQL |
| SnakeO | so that's postprocessing the results with php or something |
| insta | basically $content = str_replace($_GET['s'], "<strong>" . $_GET['s'] . "</strong>", $content); |
| blobaugh | SnakeO: yup. just pulled s out |
| SnakeO | sweet thanks |
| Kenman | i see the wiki lists MySQL by Paul DuBois as a good book, would it be good for someone with minimal mysql/sql knowledge? |
| Slynderdale | Alright, a mysql question for your smart folds. I simply want a second oppinion, from the look of this structure: http://75.83.72.61:8080/mysql.txt Is it possible to call the users.usersname, usermoney.balance and money.name by making a query where username = a persons name in the users.username field and money = the name of the money in money.name. My oppinion would have to be yes, how about yours? |
| Kenman | *opinion |
| Slynderdale | Thanks Kenman So would this be possible to call the data from all three tables with the username from users and money name from money? |
| Theodred | Hey guys 03:02 < root__> I'm having a problem with mysq/phpMyAdmin 03:02 < root__> I'm trying to login as a user I created, phpbb, and a password I setup. 03:03 < root__> I know that I have not mis-typed the password, I know that (I've re-set it several times, in fact) but when I enter the info into the phpMyAdmin weblogin, it says "Failed Authentication" 03:03 < root__> Any thoughts? |
| action | the_little_mouse pokes his little head in... sniffs.. umm whats in here...... wags tail....wiskers twitching ....... |
| the_little_mouse | pokes his little head in... sniffs.. umm whats in here...... wags tail....wiskers twitching ....... |
| Theodred | Whoops... Sorry for that one. |
| action | the_little_mouse ..............scurries across.........................room..........................>>............. #php ............................................ |
| the_little_mouse | ..............scurries across.........................room..........................>>............. #php ............................................ |
| PHPdesigner | how do we join a un group for example, with a simple click..with php. |
| Theodred | I'm having a problem with mysql (using phpMyAdmin) where I have created a user (phpbb) and a password I know, but cannot log in as that user. I know that I have the password and user right, but it won't let me in... I can log in fine as root to mod things, create users, etc, but I like to have non-prived users to do other tasks. Any ideas why this is happening? |
| blobaugh | Theodred: have you tried it from the command line to make sure it works? Theodred: did you give the user a db? PHPdesigner: huh? explain |
| Theodred | blobaugh: I'll just check if I can do it from the cl. One moe... |
| PHPdesigner | blobaugh something like join this group, with orkut |
| Slynderdale | Theodred: Did you set up the neccesary permissions with the account and then linked the password to the account? |
| blobaugh | a mysql group? |
| Theodred | blobaugh: Well. |