Glitch with receiving a table ID

I have a fairly standard one to many set up in with a couple of tables (features and revision).

With a page listing the feature details and a link to add revision items. The page where the revision is added should show the FeatureID and Project_Name form the features table for reference.

However, it doesn't seem to work if its the first bit of revision (although it seems to add it correctly with the correct FeatureID. But it does all work correctly if I then go and add a second bit of revision.

More details below...

looks like the problem is in the Redirect URL for the insert on the add_revision/index.php page. It was set to use the rsFeature recordset, I changed it to use FeatureID form variable instead

Thanks Jason - that looks like its fixed the redirect when adding the first item of revision.

But its still not displaying the FeatureID and Project_Name fields on the Add Revision page.

For example, if you look at the WA test 2 you added, you can see test 1 listed correctly. If you click on Add Revision to add a second item, it correctly shows 704 - wa test 2 on that page.

But if you look at WA test 3 that I've added and click on Add Revision the first time, its drawing a blank there.

That is because you're recordset was set to use inner join. I set it to use left join instead to fix the problem.

with inner join, it will return a result if there is a match on both sides, where no revision record existed yet, it would not return a result.

see this page for more details o the join types:
http://www.sitepoint.com/understanding-sql-joins-mysql-database/

Thanks Jason.

you're welcome.