I have a bible script and it allows you to search or read the King James Version by chapter. I would like to add the ability to select what version you would like to search or read. I plan on adding all the versions, but I needed help with the code. The database has two tables. The first table is bible and book, chapter, verse and text. Book, chapter and verse are all numeric and the second table is books which has number, book, chapters, grade. It does rewrite to html so I would like for it to rewrite with the version since it does it for chapters now. I'm thinking I could change the bible table to King James and then add the same structure table for all the versions, but not sure. It's two files (index.php and search.php) I guess I would send these to someone who could help, I'm not sure if I post them here. I don't mind paying for it and am not sure how big of a project this is, but any help is appreciated.
Thanks,
Jason
Need Help with a script
Moderator: General Moderators
Need Help with a script
Last edited by schmi458 on Tue Sep 02, 2008 8:27 pm, edited 1 time in total.
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: Need Help with a script
Post the code so we can take a quick look and see. Also post the database structure if possible.
Re: Need Help with a script
I am new to this so please bare with me.
Last edited by schmi458 on Tue Sep 02, 2008 8:28 pm, edited 1 time in total.
- jayshields
- DevNet Resident
- Posts: 1912
- Joined: Mon Aug 22, 2005 12:11 pm
- Location: Leeds/Manchester, England
Re: Need Help with a script
Change your mysql_query() call to something like
That will probably help you debug it. Simple tips like this are in the forum stickies.
Code: Select all
mysql_query($query) or die('Error: <strong>' . mysql_error() . '</strong><br />Caused by <strong>' . $query . '</strong>');