Page 1 of 1

Need Help with a script

Posted: Mon Aug 25, 2008 7:34 am
by schmi458
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

Re: Need Help with a script

Posted: Mon Aug 25, 2008 7:46 am
by jaoudestudios
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

Posted: Thu Aug 28, 2008 9:41 am
by schmi458
I am new to this so please bare with me.

Re: Need Help with a script

Posted: Thu Aug 28, 2008 10:15 am
by jayshields
Change your mysql_query() call to something like

Code: Select all

mysql_query($query) or die('Error: <strong>' . mysql_error() . '</strong><br />Caused by <strong>' . $query . '</strong>');
That will probably help you debug it. Simple tips like this are in the forum stickies.