Can't retrieve all records from database [SOLVED]

[eluser]andrewtheandroid[/eluser]
Here's my script i whacked in to test.. i did what u did whacked in 5 items and 5 descriptions.. deleted 3 & 4 and it gave me 1,2 and 5 :S

Code:

CREATE TABLE categories (categoryid INT NOT NULL, categoryname VARCHAR NOT NULL, categorydescription VARCHAR NOT NULL, PRIMARY KEY (categoryid));

CREATE TABLE items (itemid INT NOT NULL AUTO_INCREMENT, itemname VARCHAR(11) NOT NULL, itemdescription VARCHAR NOT NULL, PRIMARY KEY (itemid));

select * from items i, categories c where i.itemid = c.categoryid

when you manually view your data from both tables you sure the item 5 id corresponds?