[PHP-DB] Returning a formated dat

I have a date stored in a MySQL field in a format like this: For example, 02/02/2001 (Today) would be stored as: 02022001 What I need to do is to format that so that it looks like: 02/02/2001 -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail

[PHP-DB] MySQL Database Design

If was to create a table in a database with 19 Fields, and define them all as a BLOB, even though some of them may only hold a max of 10 characters. What would be the implications of this? -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail

RE: [PHP-DB] number formatting

Say, you get the result into a variable called $foo You could use: floor($foo); this would round it DOWN to a whole number: EG 2.1 returns 2 2.9 returns 2 -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http

RE: [PHP-DB] PHP security

e my Password in the source right? Does this answer your question? As the MySQL server is on localhost, then the password never leaves the machine, so is not travelling over the internet. Therefore, no-one can packet grab from the machine to get the password. -- Ben Cairns - Head Of Technical Operat

RE: [PHP-DB] Drop down box

Hope this helps -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK.." -- PHP Database Mailing List (http://www.ph

[PHP-DB] Auto_Increment

What is the best field type to use for an Auto_Increment field? i am using int at the moment, is there a better one? -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense o

RE: [PHP-DB] overrun??

Closing a MySQL connection is a good habit to get into, However, what you describe, doesn't sound like a PHP error, it may just be one of the many errors with msie rearing its head. -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [

RE: [PHP-DB] Separating paragraphs in mySQL?

have a look at the wordwrap() functions in the PHP manual -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK.." -- PHP Databa

[PHP-DB] PHP On Linux

know, what files go where etc... Thanks. -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK.." -- PHP Database Mailing List (htt

[PHP-DB] Update Multiple records

the numbers at the end of the statement. But I cant see what... Pls help. Thanks in advance. -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WOR

RE: [PHP-DB] Stupid question

The value of a CHECKED Checkbox is 'CHECKED' So, you would do: hth -- Ben Cairns - Head Of Technical Operations intasept.COM Tel: 01332 365333 Fax: 01332 346010 E-Mail: [EMAIL PROTECTED] Web: http://www.intasept.com "MAKING sense of the INFORMATION TECHNOLOGY age @ WORK..