my db is simple, numeric data only, but i went here, MYSQL Charsets (http://dev.mysql.com/doc/refman/5.1/en/charset-syntax.html) to find out how to display other character sets, it was complicated,...

CREATE TABLE Employee
(
Emp_Id int PRIMARY KEY IDENTITY,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
postalcode vachar(6),
/* other...

insert into #temptable ( IDENTITY(int, 1,1) AS number, select * FROM table ORDER BY score desc) SELECT * FROM #temptable ORDER BY number DROP TABLE #temptablethought process only, cant guarantee the...

good catch, stared at it and didnt see

I was thinking that spambots search for email addresses that always contain a '@' SO something that doesnt include a @ will get past
<input type='text' id='mailaccount'>@<input type='text'...

that address is sent in clear text through however many relays, proxies, exist in the traceroute between your host and the user,
any one of them could be compromised
with an appropriate packet...

This is Joomla's spam protection
Joomla has a plugin that obfuscates email addresses, to make it harder for scrapers and bots.
The visible address and effective address are not changed, just what...

select NAME from tablename order by name;

most do not want to be told rtfmits easier for me its just another line of code, that I have in memory, references I have to waste my time looking up

select name where state like '%s', $post['state']
mysql_query(sprintf("select name where state like '%s', $post['state'] "));
probably better if you take the commas out of your state tables
wa fl...

do not punctuate numbers in input data
mysql suypports multiple data schema, language-specific and region specific
in many supported schema the comma is a decimal separator, the number is truncated...

if( $r['whattotal'] == '0' ){ echo "Less";} ? maybe

AND b.date BETWEEN CURdate( ) AND DATE_ADD(CURDATE(), INTERVAL +9 DAY)