Hi Nitin, > i am make a directory of kosher kitchen but i have no idea > to make this how i manage all these thing plz help me.
> Kosher Kitchen > a. Recipe Finder > b. List of Kosher Symbols and Products Manufactured > Under Symbol > c. Recipe should allow brands to be inputted and > linked to manufacturer or retailer site (ie if brand > mentioned in recipe has website, auto link) How much DO you know about creating a database driven site in PHP? To start with the basics: 1. set up a database, containing at least the following tables: - manufacturers contains an ID, name of manufacturer, URL of manufacturers website (fields: say mf_pk, mf_name, mf_url). - ingredients an ID, name of ingredient, link to manufacturer: mf_pk, ingredient details (like tips on handling, storage, where to buy) (fields: say in_pk, in_mf_pk, in_name, in_handling, in_storage, ...) - recipe categories an ID, name of recipe category (like 'starter', 'main', 'desert', 'snack', 'cake', whatever), fields would be ca_pk, ca_name - recipies an ID, name of recipe, link to category, filename of picture of recipe, (fields: say re_pk, re_ca_pk, re_name, re_foto) - quantities an ID, link to recipe, link to ingredient, amount (fields: say qu_pk, qu_re_pk, qu_in_pk, qu_amount) what you mean with b. is not clear to me. then some SQL to get the data to construct the pages, and some CSS to format those pages. Data for the pages you would obtain with SQL like this: Recipies (list): "SELECT * FROM recipies LEFT JOIN categories ON ca_pk=re_ca_pk ORDER BY ca_name, re_name"; Recipy: "SELECT * FROM recipies LEFT JOIN quantities ON re_pk=qu_re_pk LEFT JOIN ingredients ON qu_in_pk=in_pk LEFT JOIN manufacturers ON in_mf_pk=mf_pk WHERE re_pk=[value generated from link or form]" Links to pages are to be generated automatically where you use the values of the promary keys to create a link like <a href="index.php?Page=rec&ID=12"> Of course there will have to be a way to manage the site (add, edit and remove recipies, ingredients, manufactuirers, etc) which most likely means an extra table with data for the forms and their inputs. Shouldn't be too difficult, that is: if the problem was with seeing where to start. If the problem is a total lack of knowledge of PHP and any database things may get a bit more complicated ;-) Marc ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/HKFolB/TM --------------------------------------------------------------------~-> Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
