Hi Leif, Anytime you get an MySQL error code number use perror program to see what it is..
[root@atsiz /root]# perror 28 Error code 28: No space left on device It seems like you don't have enough space to write to your table. Gurhan -----Original Message----- From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] What is mysql error 28? I have a website which has, among other things, virtual items. The items are stored in table items, the different types of items in item_types. I use the following query to get a user's items: SELECT DISTINCT t1.id,t1.itemtype,t2.name FROM items as t1,item_types as t2 WHERE (t1.itemtype = t2.id AND t1.owner = '$theirrealinfo[username]' AND t1.placein='inventory') A few minutes ago, items mysteriosly started getting then followowing error from mysql_error(): "Got error 28 in table handler". Thanks to anyone who can help! P.S. They just started working again. I'm still sending this because I want to know what was wrong. Thanks again! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php