This is back to my last issue but then I figured out that I can't compare the value from a primary key to a value in another table.
In table 1, there is a value of 3 in one field
I want to be able to lookup row 3 in table 2 and fetch all that information.
I originally thought that WHERE index = 3 would work but it doesn't. For that to work, I would have to create another field but that field won't be able to auto increment.
I figure that if I could fetch the row number, that would be the same. I'm reading up on mysql_fetch_row right now.