PHP/MySQL: Need debugging help on 2 pages. Adding books to tables in a database and editing book data of tables in a database. Will be using INSERT and UPDATE into 3 tables. I have four other pages similar but I believe if I can get two to work, I can use that information in the other four.
Specifics: Using a php form and code to add information to a MySQL database and to edit information in a MySQL database.
Yes, I can provide code and database dump. Should I attach it here?
There is already someone else helping me - Eljon. Is he still helping? I just sent him the code a few minutes ago.
Did you get it that time?
okay, thank you
you can also find the Web site this code is being used on at
new file with includes folder is at http://ge.tt/8TSTKde/v/0?c
Did you get my last reply? I don't see it here. Anyway, what I said was I had two other joining tables like you created but I couldn't get my query to work so I thought it might be easier with only the three, so I reworked them the bookID to them.
And you were, right, totally messed up my viewBooks.php file and I have uploaded at http://ge.tt/8TSTKde?c
I did try the editBooks.php code and it didn't work. It may have to do with the pagination and sort code that is on the viewBooks.php
Thanks, XXXXX XXXXX great.
I see what you're talking about. I had attempted to add a book earlier, and it looks like it added the book information but did not add the author or publisher information to the other two tables. I'll delete that book manually from the database.
You too. I actually have music and movies to do the same way, and now I need to go back and re-add the tables I deleted for those. Luckily I have an old copy of those somewhere.
I will. Thank you again. I've been working on these for weeks, while also working on other files on the page.