HOME       >>       Programming

[MYSQL] Drink List create a sorted list of recipes


iGuest

product showcase question....

Category, Subcategory?

 

Ok, what I am trying to do is piece together a database of bar drinks. So far I compiled about 60 or so shots. So now what I am trying to do is go from index/drinks.Php, to take all the listings from the sql query on that page and turn them into a link, so when I click it, it will dynamically generate index/drinks/purplemf.Php and generate the recipie in that window...

 

 

 

All I have is the query for the shots listings, and the data entered in mysql, but I don't know how to turn the name into a link and dynamically generate the page itself from a template that I want to make...

 

 

 

I hope I explained this right lol.

 

 

 

Kinda like on a shopping site, you click on yhour product category, then the list of products come up, then you click on a specific product name, and it generates the template with all the information about that specific product.

 

 

 

-question by Antonio


salamangkero

Ok, what I am trying to do is piece together a database of bar drinks. So far I compiled about 60 or so shots. So now what I am trying to do is go from index/drinks.Php, to take all the listings from the sql query on that page and turn them into a link, so when I click it, it will dynamically generate index/drinks/purplemf.Php and generate the recipe in that window...

Hmmn... ok, assuming that you have a php page for each drink, let's suppose that you have the following table:

+-------+-----------------+------+-----+-----------+----------------+| Field | Type | Null | Key | Default | Extra |+-------+-----------------+------+-----+-----------+----------------+| id | int(4) unsigned | | PRI | NULL | auto_increment || name | varchar(64) | | UNI | | || page | varchar(64) | | UNI | index.php | |+-------+-----------------+------+-----+-----------+----------------+

Now suppose you have these data:

| 6 | Blood Type AB | ab.php |
| 7 | Blood Type O | bo.php |
| 8 | Screaming Orgasm | so.php |
| 9 | Coke and Rum | cr.php |
| 10 | Ginger Ale | ga.php |
| 11 | Polyjuice Potion | pj.php |
| 12 | Pumpkin Juice | pk.php |
| 13 | Butterbeer | bb.php |
+----+--------------------+--------+ linenums:0'>+----+--------------------+--------+| id | name | page |+----+--------------------+--------+| 1 | Martini | mt.php || 2 | Vodka | vd.php || 3 | Bloody Mary | bm.php || 4 | Margarita | mg.php || 5 | Wizard's Mind Bomb | mb.php || 6 | Blood Type AB | ab.php || 7 | Blood Type O | bo.php || 8 | Screaming Orgasm | so.php || 9 | Coke and Rum | cr.php || 10 | Ginger Ale | ga.php || 11 | Polyjuice Potion | pj.php || 12 | Pumpkin Juice | pk.php || 13 | Butterbeer | bb.php |+----+--------------------+--------+
Your index.php will look something like this:

$name = $row['name'];
echo "<p><a href='$page'>$name</a></p>";
}

... OTHER STUFF HERE ... linenums:0'>... INITIALIZATION GOES HERE ...mysql_connect(DB_HOST, DB_USER, DB_PASS) or die(mysql_error());mysql_select_db(DB_NAME) or die(mysql_error());$result = mysql_query("SELECT name, page FROM drinks ORDER BY name");while ($row = mysql_fetch_assoc($result)) { $page = $row['page']; $name = $row['name']; echo "<p><a href='$page'>$name</a></p>";}... OTHER STUFF HERE ...
This will give you a list of links to your drinks' recipes ordered alphabetically by drink name.

Hope this was of help to you

jlhaslip

Split Topic



VIEW DESKTOP VERSION REGISTERGET FREE HOSTING

Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.