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 Fa
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: so
?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 exam
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
For begining PHP and MySQL this 10-part series is great!
http://www.webmasterbase.com/article.php?aid=228&pid=0
To control your database remotely check out
http://www.phpwizard.net/projects/phpMyAdmin/
It's very easy to use.
Hope this helps!
-Daniel
-
t = htmlspecialchars($text);
// Strip out carriage returns
$text = ereg_replace("\r","",$text);
// Handle paragraphs
$text = ereg_replace("\n\n","",$text);
// Handle line breaks
$text = ereg_replace("\n"
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
lang