Hi Leif,
Anytime you get an MySQL error code number use perror program to see what it

[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.

-----Original Message-----
From: Leif K-Brooks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 1:46 PM
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

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

Reply via email to