[PHP-DB] Is this query even possible?

2003-06-10 Thread Susan Ator
This is what I am trying to do: if ($FUNC==(USERPOST) || $FUNC==(MODU)) { $sql = UPDATE newdacs SET emailfwd='$emailfwd', mformat='$mformat', filter_code='$filter_code' if

RE: [PHP-DB] Is this query even possible?

2003-06-10 Thread Susan Ator
[mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 11:33 AM To: 'Susan Ator'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Is this query even possible? I would say something like the following would work better: if($FUNC==USERPOST || $FUNC==MODU) { $sql .= UPDATE newdacs; $sql

[PHP-DB] mySQL field structure question

2003-10-01 Thread Susan Ator
If I have a field in mySQL consisting of a number with 8 digits a decimal point and 4 more digits what is the field type it needs to be to sort it numerically? I've tried decimal(8,4) but it converts everything to .. I've also tried float but it doesn't sort numerically. All of the