Hello fellow techsters,

Short and sweet,

The Problem,

I'm looking for a way to load multiple SQL queries and display them to the screen WITHOUT using an autoincrementing feild, like id.

The reason for this, i'd like to allow users to enter data and have it alphabetically formated when displayed, and allow then to delete their data at will.

Now I'm using mysql_fetch_array with the ID field within a while loop, and I'm dropping and re-inserting the id feild everytime a post is deleted.

Desired Solution,

I'd be incredibly gratefull if someone knew a function to load all of the rows in a field and access them without using an id key.


Well, thanks a lot for the replies in advance!

Wouldn't you just selct without a limit, or with a high limit, like:

? I'm probably just not getting what you mean though.

Hi Peter,

thanks for the response,

I'm writing PHP code if that helps, but here's generaly what I use now (in psuedocode):

$id = 0

While $name != "" {
select $table where id = $id;
assign associative array to data;
print link to screen;
$id = $id + 1;
}

That's what I've been using cuz I cant use store all data in a table to an associative array, or a nested associative array, ie: $array[row1[name]], it won't work!

I'm not sure if what I want is possible,

but I do appreciate the response, thanks.

Wow, I'm glad everyone jumped right in to help...

I solved the problem,

SOLUTION: for seamless loading, use an auto-increment feild, but drop and
re-insert it for every row deletion.

Ok, I solved it a very long time ago, but I've dropped that project and decided to use includes... it works much better.

here's the page I'm working on for those who care: http://www.gallatinwebdesign.com

Bah!