I have a PHP page that takes data from a form and inserts it into a
table:
Show columns:
+------------+--------------------+------+-----+---------+--------------
--+
| Field | Type | Null | Key | Default | Extra
|
+------------+--------------------+------+-----+---------+--------------
--+
| ID | mediumint(10) | | PRI | NULL |
auto_increment |
| userid | varchar(20) binary | | | |
|
| name | varchar(20) binary | | | |
|
| tier | int(2) | | | 0 |
|
| price | double | | | 0 |
|
| tierNumber | int(2) | | | 0 |
|
| Min | double | | | 0 |
|
+------------+--------------------+------+-----+---------+--------------
--+
I have a while loop that insterts the records in the correct order (by
tierNumber).
INSERT INTO TarifBuilder SET
name='{$_POST'name']}',tier='$tier',price='$price',tierNumber='$count',M
in='{$_POST'min']}'";
However when I go to the database and do a "select * from tablename;"
the records are in the table in the reverse order!!
Even the auto increment is in reverse order...
| 65 | | 2-gaf | 0 | 0.0004688 | 0 | 0.3
|
| 66 | | 2-gaf | 1536 | 0.0002917 | 1 | 0.3
|
| 67 | | 2-gaf | 6144 | 0.0002344 | 2 | 0.3
|
| 68 | | 2-gaf | 15360 | 0.0001172 | 3 | 0.3
|
| 69 | | 3-gaf | 0 | 0.0001172 | 0 | 0
|
| 70 | | 3-gaf | 0 | 0.0001172 | 1 | 0
|
| 122 | | test-decreasing | 200 | 1.001e-05 | 2 | 0.51
|
| 121 | | test-decreasing | 100 | 2.002e-05 | 1 | 0.51
|
| 120 | | test-decreasing | 0 | 3.003e-05 | 0 | 0.51
|
+-----+--------+-----------------+-------+-----------+------------+-----
-+
Why is this?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
