-
Posts
34 -
Joined
-
Last visited
Never
About dietkinnie
- Birthday 10/29/1985
Profile Information
-
Gender
Male
-
Location
Malta
dietkinnie's Achievements
Member (2/5)
0
Reputation
-
Great this is exactly what i needed. Thanks !
-
Hi All, Here is a better explanation: Menu Table structure id description parent_id 1 Soccer 0 2 England 1 3 Arsenal 2 4 United 2 5 Germany 1 6 Bayern 5 7 Italy 1 8 Milan 7 9 Palermo 7 10 Inter 7 11 Liverpool 2 I need a way to list the menu hierarchy when i only have the child available. For example if i have the description 'Milan' with parent_id 7, how can i go through all the parent ids to find the main parent which is soccer and display accordingly ? Soccer (parent_id = 0) >> Italy (parent_id = 1) >> Milan (parent_id = 7 ) Hope this explains what i need help with a bit clearer as i am completely lost. Thanks in advance. //DK
-
Hi, This is what i would do. Hope this makes sens to you ? talents ( talent_id , talent_firstname, talent_lastname) -- 1 row movies (movie_id, movie_description, movie_year) -- 1 row castings (casting_id , talent_id , movie_id) -- multiple rows Regards, Rob.
-
Hi, sorry for the vague reply. First off, I already have a horizontal left menu that is up and functioning correctly. However when i click on Milan i would like to include the "menu path" in the page i am redirected to. Football >> Europe >> Italy > Milan Something like this http://www.oddsportal.com/soccer/germany/bundesliga/. Soccer» Germany»Bundesliga
-
Hi Everyone, Can you please tell me what this type of menu is called ?? Football > Europe > Italy > Milan. Thanks .
-
Hi Guys & Gals!! Hope you are all ok.... I need some help with the following I need to trim the following word as follows: $word = 'James Bond'; output would be 'James B' There is a space between all of the words I need to trim... Any suggestion?? Thanks in advance..
-
Hi Everyone, I am stuck , and would like some inspiration I am trying this sql but not getting the correct result. case when max(price) and product_order = 1 then shelf_id end What i need is the shelf_id of the book with the highest price and has a product order of 1. p.S this is just a small part of the query.... I have really run out of ideas, so any tips would be greatly appreciated. Thanks in advance. //DK
-
[SOLVED] Splitting table results by date
dietkinnie replied to dietkinnie's topic in PHP Coding Help
Hi joel24 and waynewex thanks for your replies , it was so simple, i was tearing my hair out over this. Problem solved now. Great stuff , thanks again guys !! -
i everyone, I have run into a problem and need your help. I am running a query and displaying the results into a table through php. This is a sample output. Date Cars 6/13/2009 6:30:00 PM Ferrari 6/13/2009 6:30:00 PM Subaru 6/13/2009 8:00:00 PM Toyota 6/13/2009 8:00:00 PM Opel 6/14/2009 5:00:00 PM Ford 6/14/2009 6:00:00 PM Hyundai 6/14/2009 6:00:00 PM Fiat 6/15/2009 9:00:00 PM BMW However i would now like to split and group the results up by date to something like this Date Cars Sum(cars) 6/13/2009 6:30:00 PM Ferrari 76 6/13/2009 6:30:00 PM Subaru 67 6/13/2009 8:00:00 PM Toyota 6 6/13/2009 8:00:00 PM Opel 98 --New Table 6/14/2009 5:00:00 PM Ford 65 6/14/2009 6:00:00 PM Hyundai 65 6/14/2009 6:00:00 PM Fiat 65 --New Table 6/15/2009 9:00:00 PM BMW 4 Any input would be greatly appreciated as i have run out of ideas ??? Thanks in advance!!
-
Can you help me to solve this problem?
dietkinnie replied to merck_delmoro's topic in Microsoft SQL - MSSQL
Im not sure but it looks like the character "B" in ( 003602490B 012420755B 012454145B 012507387B ) Cannot be converted to Float as B is not a number ?? ??? -
OK i have finally got the code working <?php include '/var/www/html/oddssurf/config.php'; $result = mysql_query("SELECT * FROM SLIDESHOW") or die(mysql_error()); $count = mysql_num_rows($result); //print_r($count); //check count of rows in table while ($row = mysql_fetch_array($result)) { echo "<div class=\"bigimg\" title=\"$row[title]\"id=\"$row[id]\"><img src=\"$row[imgsrc]\" class=\"change\"></div>\n"; } ?> Can anyone tell me if its possible to link the ID to a specific url? The output of the above code is: The output of the above code is <div class="bigimg" title="http://farm2.static.flickr.com/1429/1252247669_5f014e7dc1_b.jpg"id="Hihihihihihihihihihihihih"><img src="http://farm2.static.flickr.com/1429/1252247669_5f014e7dc1_b.jpg" class="change"></div> Now i would like to link "id = "Hihihihihihihihihihihihih" to www.example.com. Is this possible ? Thanks in advance !!
-
building a menu and its submenus (recursion!)
dietkinnie replied to hassank1's topic in PHP Coding Help
Hi There, Try reading this post. http://www.phpfreaks.com/forums/index.php/topic,240251.msg1120398.html#msg1120398 In this example i used the spry menu which comes with dream weaver Hoe this helps. //DK -
Hi Everyone, My current slide show uses static data to display images. <div id="feature_gallery"> <div class="bigimg" title="http://farm2.static.flickr.com/1429/1252247669_5f014e7dc1_b.jpg" id="piknown printer took a galley of 1"> <img src="http://farm2.static.flickr.com/1429/1252247669_5f014e7dc1_b.jpg" class="change" ></div> <div class="bigimg" title="http://farm1.static.flickr.com/153/332584527_bd5efc0197_o.jpg" id="picLorem Ipstext of tnpsum hadu typa type spec"> <img src="http://farm1.static.flickr.com/153/332584527_bd5efc0197_o.jpg" class="change" ></div> <div id="output"></div> <a href="http://design-notes.info/tutorial/jquery-tutorial/how-to-creat-a-feature-article-slide-show-with-thumbnails-and-indicator/">Article</a> </div> I now need to insert that data into my db , loop the data an output it in the same syntax ax above , but am not sure how to to do so. Can anyone help me here , or point me in the correct direction ? Thanks in advance !! //DK
-
Hi vicodin, Thanks for the reply. Any good news slidshow with caption or description you can recomend ? Regars, DK
-
Hi , In config.inc.php Try using the mysql root login details to see if you can log in. $cfg['Servers'][$i]['controluser'] = 'root'; $cfg['Servers'][$i]['controlpass'] = 'rootpassword';