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,...

depending on the language used as the front end to the mysql back end,
php $date=strtotime('string');
asp $date=DateTime.Parse('string');
in sql getdate($date)

don't use those codes look em...

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...

Nothing
searchme is a calculated column, it is created and defined during the query and only exists until the query is complete, it takes the format of the colums from which it is created

do not store separate date and time
store a single unix timestamp or sql datetime (both of which can output date, time, or date and time

then just
select max(dategps.datetime)

trySELECT a.airport_code AS airportcode, a.airport_name as airport, u.usr_id as userid, u.usr_fname as firstname, u.usr_lname as lastname, u.usr_email as email,u.usr_airline as airline,...

select * ( Concat(string1,' ',string2) as searchme ) from table where searchme like "$search"text string single space between the columns else you get

BrownCow which wont match brown cow

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...

Glad it all helped, examples stick in my mind better too

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;

page 4 of the joomla online referst to the database,
and table creation within the database.
If you have begun manually you need the appropriate part of the joomla manual install.

Joomla did...

once you create a dbase
then you have the ability to cxreate a number of tables inside the database, in my head the database is an empty filing cabinet, plenty of potential but not much use yet, my...

once the id topics are grouped the individual id_msgs may not be available for sort
perhaps what you want is
SELECT id_topic, subject FROM smf_messages WHERE id_board=$bolum ORDER BY id_topic,...

Verruckt
the final arbitration of all takes up so much of your time.
It must be difficult to be you.

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...

Y'welcome

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...

dynamically code the nested tables the same way the code generates the tables.
The code you have makes horizontal lines
one way is to output the sql query...

sql provides the output data (in rows)
formatting is done by your php script & the html css it generates
nest tables,
<tr>
<td>
<table><tr><TD></td></tr></table>
</td>
<td>...

output into a table, and the width will adjust to the widest name, or set the td widths
tables are still useful for tabular data

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

I've only learned one thing about DB design

store date and time as timestamps its a lot faster to compare numeric timestamps than text date/time stings

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

I have to admit ignorance,
Dunno,
on my development i didnt want to waste database on the webstats
the filesize is small enough that the flat file is faster than reading another table in sql cms,...

thought processes:::

md5 # data on table insert
compare md5 of login to table data

table in a folder chmodd invisible to the outside world

crypt

table location information only in php...

If its really only small & simple
why not a flat file version for those without sql
fixed length fields teminated by line feed
or
php arrays
is quite fast to read and write, especially since the...