RE: Updating auto_increment ID Column/Selecting Duplicate Rows
This would give you a list of all users that have entered things more than once; However, it would not give you all the rows that are duplicated. SELECT Count(User) from mail_form2 GROUP BY User HAVING Count(User) 1 Hope this helps! Daniel Von Fange -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 2) in a table i have a column called User. some people have entered things into this table multiple times. how do i create a SELECT statement to select only those rows that have multiple Users? i need something like this (but this is wrong, of course): SELECT * FROM mail_form2 WHERE 'count(User) 1' SELECT * from mail_form2 GROUP BY User HAVING Count(User) 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: sorting this egroup
I just use the [EMAIL PROTECTED] in the To field of the email. Works like a charm. --Daniel Von Fange -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 8:56 PM To: George Pitcher; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: sorting this egroup Maybe I overlooking the obvious here, but hey it won't be the first time. How does everyone sort this group in their email client? I have yet to find a way to manage these emails because of the lack of a consistent item in each email. i.e MySql in the subject line etc Suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql/php
?How can I output "no records found" when there is no record found? This is ?the query I am using. ?SELECT * FROM $table where description LIKE '%$keyword%' ?Is there a sql statment that will return a string if no record exists? ?Thanks in advance. An easy way, is to use PHP for this. For example. $Result=MySQL_Query("SELECT * FROM $table where description LIKE '%$keyword%"); if(MySQL_Num_Rows($Result)==0){ echo("No Records Found!"); }else{ //Your formating of results here. } Hope this helps! Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Password problems
It looks like MySQL is working fine, phpMyAdmin just needs to know your new password so that it can connect to the database. Just edit the "config.inc.php" file in the phpMyAdmin directory. Find the lines: $cfgServers[1]['user'] = 'root';// MySQL user (only needed with basic auth) $cfgServers[1]['password'] = 'george';// MySQL password (only needed with basic auth) Also, for security, make sure that no one but you can access phpMyAdmin from the web. Maybe use .htaccess Hope this helps, --Daniel -Original Message- From: Eddie Rhodes [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 8:38 PM To: [EMAIL PROTECTED] Subject: Password problems Hi all, The resolution to my problem is probably simple for many of you. However, I'm new to MySQL and php and am having difficulties. However, I'm ignorant, not stupid, and can follow directions. My setup is as follow: I had My SQL, php4 (with Zend) and phpMyAdmin installed on my Red Hat Linux dedicated server last year by the NOC tech support dept. I'm now about to use them. Yesterday, phpMyAdmin and MySQL were working. I created a couple of databases at a friend's house (he knows a bit of programming and also has phpMyAdmin. I returned home and began reading the docs. In so doing, I discovered that I had no root password set, and followed the instructions to create one. I did it via telnet and used the command shell mysqladmin -u root password George Naturally, George is not the real password. It's just less confusing to use something other than the word password to represent the password. Addendum - okay, I found out that I set my password literally to password, so I need to change it to "George". Afterwards, I was unable to access phpMyAdmin. I now get the message: Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in lib.inc.php on line 255 Error What a way to spend my birthday! Would anyone be kind enough to help me out? It would be much appreciated. Step by step literal instructions on setting up a user name and password would be appreciated also. I've been reading the docs and I don't think they do it as such. Eddie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: A report generator MySQL
What output media do you want? Paper or web? Some text formating tools I have found are: http://www.geocities.com/SiliconValley/Ridge/4280/GenericReportWriter/grwhom e.html http://mytextreport.sourceforge.net/en/manual.html Or, if you want to output to HTML, you could use the PHP programing language. It works very nicely with MySql, and would be not hard to make reports - if you knew PHP of course. :) --Daniel "Brains" Von Fange - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php