Hiya Folks new to all this , but got a joke site autogenerator thingy , downloaded all the files but it comes with no instructions So i managed to create the DB and use a file called conn.php to connect to it , so its connecting fine , and the site opens up but with no jokes now OBVIOUSLY it wants the jokes , they should be in a table called err djokes and i have a file called djokes.sql Now heres my question ....... anytime i have worked with these type of things theirs normally afile called setup or something that creates and propagates the fields ...there doesnt seem to be anything like this with this one So do i have to manaully LOAD IN the jokes via cpanel at hostgator ?never manually created a DB table and loaded info in ... is it hard ? PAUL
You don't use Cpanel to populate databases. You use PhpMyAdmin. At the bottom of your cpanel > mysql section, there's a link to open phpmyadmin. Here select the database you want to populate. Click the "import" tab, and upload the file. If it's not too big, it will hopefully make tables and populate it. If it's big, then use "Big Dump" or something similar to run the sql file. regards
ah .. managed to get the tables populated ..mmm geting there Ithink i have jut learned if theres no setup file and you see a text file ending in .SQL it means you nee to manually import it ! Ok thats down , front pages seem fine ..however when you actually click on a joke it shows an error ..i think its omehtin to do with it creating th pge ON THE FLY from the database as the url of each joke is a static one ... phew ... any ideas ? PAUL
im looking for a script that will help autogenerate webpages from a sql database like this. any thoughts
theres piles of them going around but i got the joke script FREE from this thread if its any help http://forums.digitalpoint.com/showthread.php?t=487428 My issues sorted now this thread can die