First, I agree with Bruno concerning putting print all on one line, as you and I discussed previously Jason.
Second, keep using DATE data type in mySQL. Simply specify to the user how the date is to be entered on the form. DATE is maintained in mySQL as YYYY-MM-DD. User that -----Original Message----- From: Bruno Gimenes Pereti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 11:42 AM To: PHP-DB Subject: Re: [PHP-DB] PHP query on "date" field Hi Jason, What is the error message, in what line? I really can't find any error... Just one standarlization point: why do you use "( )" when printing <BR> and not in every other printing. For me, it's easyer to debug if every thing that do the same thing is writen the same way. Other thing out of the point. You could write all the line in one print command: print "<b>Total:</b> $row['total']<br>"; or print "<b>Total:</b> ". $row["total"] ."<br>"; or (my favorite) ?> <b>Total</b> <? print $row["total"]; ?><br>; <? Please send the error message, O got curios.. (sorry I don't remember how to write it, I think I can understand what I mean :-) Bruno Gimenes Pereti. ----- Original Message ----- From: "Jason" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 30, 2001 3:31 PM Subject: [PHP-DB] PHP query on "date" field > Here is my problem once again... =P I am wondering if I should change the > date table to something other than date... maybe something like date_1? > Would doing that resolve my issue, because of the fact that the date > variable in php is function? Thanks in advance... > Jason > [snip] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
