creeker

I'm not using it to auto increment. I'm calling in from a site to find the last added record. So "SELECT * FROM tablename ORDER BY id DESC LIMIT 1" seems a good method since the ID is auto_incremented. I guess another method would be using timestamps.

Ah ha. I thought it could be called later. I came to the code you suggested. In an older topic someone said it didn't comform to ACID. Do you know what that is and if it makes a difference? Thanks.

I'm trying to make a query to get the last record from a DB. When I use "LAST_INSERT_ID()" I always get 0 as the query. Is there something wrong with this function or do I have to use it combined with an INSERT or UPDATE? Does this make sense?

I figured it out and it works. Sorry to waste your time

This is a newbie question. I have two tables and perform this join: SELECT c.name, c.description, d.caption, d.image FROM archfolio_category AS c INNER JOIN archfolio_detail AS d on c.ID=d.project AND d.project =12; Everything works except that the c.description the cell entries show up as empty except for the heading. If I use the code below the column heading and entries show: SELECT * FROM archfolio_category;  I don't understand where things might be going wrong. Any help is appreciated.