[Bitsys]

Yesterday at 09:32 PM slashboy said this in Post #1297



mysql> show columns from items_cats;
+----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | | PRI | NULL | auto_increment |
| name | char(50) | | | | |
| description | char(250) | | | 0 | |
| catorder | int(2) | | | 0 | |
| type | tinyint(4) | | | 0 | |
| ownerid | int(11) | | | 0 | |
| sold | int(11) | | | 0 | |
| profit | int(11) | | | 0 | |
| battletype | int(10) | | | 0 | |
| itemonofforder | int(3) | | | 0 | |
+----------------+------------------+------+-----+---------+----------------+
10 rows in set (0.00 sec)

yes i have a few personal item shops.... i think thats the problem, coz after i removed the personal itemshops.. everything seems fine..

Those are the column definitions. I need the value of the id column of all the rows. The query would be something like "SELECT id FROM items_cats". Do you have phpmyadmin?