Re: [PHP-DB] problems getting results displaying correctly

2003-08-01 Thread Matthew McNicol
Any idea's on where to throw a echo br; put the echo br; inside the first if statement. thus each new manufacturer type is preceded by a blank line. ... while ($manufResult = db_fetch($manufQuery)) { if ($thread_manufacturer != $manufResult['manufacturer']) { echo

Re: [PHP-DB] subtracting dates...

2003-08-03 Thread Matthew McNicol
In mySQL, I store dates as -MM-DD, a standard DATE type. It stores users date of births. I need to calculate in a PHP script, the users age from this DOB. I get a PHP date in the same format as the mySQL and subtract, which returns the year rounded off. ie, it doesnt matter if your

Re: [PHP-DB] PHP MSSQL

2003-08-14 Thread Matthew McNicol
Shaun, the MySQL manual suggests that you have hit your limit using the VARCHAR field type (255 characters). To store 6,000 characters have you not considered using the TEXT field type? 6.2.3.1 The CHAR and VARCHAR Types The CHAR and VARCHAR types are similar, but differ in the way they are

Re: [PHP-DB] Host check?

2003-08-20 Thread Matthew McNicol
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 20, 2003 1:24 PM Subject: [PHP-DB] Host check? http://www.beamhost.co.uk/hosting.html I'm moving hosts with our site at work... I found these guys and am very impressed. Has anyone had any

Re: [PHP-DB] Printing selected characters (strcnt?)

2004-07-15 Thread Matthew McNicol
datetime in format of 715041200 /snip Thanks any help appreciated Vincent Jordan Technical Support Smart Parts, Inc. Loyalhanna Business Complex 100 Station Street Loyalhanna, PA 15661 800-992-2147 X 5617 -- _ Matthew McNicol yellowmarker.co.uk PHP / MySQL web development -- PHP Database

Re: [PHP-DB] DB table creation question

2004-07-18 Thread Matthew McNicol
-- _ Matthew McNicol yellowmarker.co.uk PHP / MySQL web development -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] RE: [SPAM] Re: [PHP-DB] DB table creation question

2004-07-19 Thread Matthew McNicol
, last_modified_date datetime NULL, ); -Original Message- From: Matthew McNicol [mailto:[EMAIL PROTECTED] Sent: Sunday, July 18, 2004 5:46 PM To: Vincent Jordan Cc: [EMAIL PROTECTED] Subject: [SPAM] Re: [PHP-DB] DB table creation question use the mysql 'auto increment' on a 'int

Re: [PHP-DB] search form w/ multiple fields

2004-07-22 Thread Matthew McNicol
: input type=text name=email / input type=submit value=search /form all of this is on the same page, the page is called search.php -- _ Matthew McNicol yellowmarker.co.uk PHP / MySQL web development -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit