Jump to content

dietkinnie

Members
  • Posts

    34
  • Joined

  • Last visited

    Never

About dietkinnie

  • Birthday 10/29/1985

Profile Information

  • Gender
    Male
  • Location
    Malta

dietkinnie's Achievements

Member

Member (2/5)

0

Reputation

  1. Great this is exactly what i needed. Thanks !
  2. 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
  3. 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.
  4. 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
  5. Hi Everyone, Can you please tell me what this type of menu is called ?? Football > Europe > Italy > Milan. Thanks .
  6. 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..
  7. 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
  8. 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 !!
  9. 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!!
  10. 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 ?? ???
  11. 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 !!
  12. 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
  13. 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
  14. Hi vicodin, Thanks for the reply. Any good news slidshow with caption or description you can recomend ? Regars, DK
  15. 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';
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.