and thanks for your quick reply.
Ill try to explain in more detail what im trying to do:
I need to create a product catalogue wich displays records from DB table into Flash using PHP.
In Flash I have a combobox that displays all available categories for these products (products.swf).
New products will be added to corresponding categories through another Flash file (save_products.swf).
Maybe new categories will be added too.
Whenever I add a new entry, send and load back in Flash, the data for that corresponding row is truncated.
I rechecked as you suggested by calling php script and found the source of this problem:
The ID which is set to Auto Increment was delivering the results in a non-sequential way, something like this (id1, id2, id3, id6, id7, etc.)
(products.swf loads these arrays in sequence).
So that's why I was getting these: ",, " empty fields in my combobox, because I had previously deleted rows 4 and 5.
Now, the only solution I found was to do a query in phpMyAdim like this:
ALTER TABLE `products_table` AUTO_INCREMENT =4
Things are now back to normal but I'm a little worried about what could happen later on when i have tons of products and some rows need to be deleted.
Also I find it upsetting that phpMyAdmin doesn't do this automatically.
So my question now is if there is a way to avoid resetting ID manually every time a product is deleted, maybe there is a PHP script for this or maybe I have to change the way my combobox receives the data.
It seems like I solved one problem only to find another.
I would really appreciate any suggestions you might have as to what can be done.
Thanks in advance!!