Jump to content

JustLikeIcarus

Members
  • Posts

    430
  • Joined

  • Last visited

Everything posted by JustLikeIcarus

  1. I believe 'INTERVAL +7' is incorrect. Try this assuming your storing the date of birth in the age field this below should work for you. SELECT * FROM kids WHERE WEEK(age) = WEEK(DATE_ADD(NOW(), INTERVAL 7 DAY))
  2. It will return the autoincrement value of the last insert. So once you insert your record into customer you can use it like insert into services NULL, last_insert_id(), whatever......... However if you are going to be inserting multiple records into the next table you need to set a var = last_insert_id. You can use php's mysql_insert_id() function to give you the id you just inserted into customer, set a variable to that value then use it in your other insert statements.
  3. Are you using the mysql last_insert_id() function when inserting the record into the joining table?
  4. You may be able to specify distance in the options for drop. Currently the code shows drops distance as var distance = o.options.distance || (ref == 'top' ? el.outerHeight({margin:true}) / 2 : el.outerWidth({margin:true}) / 2); so .hide('drop', {distance: <your distance logic>}) may work.
  5. Checkout this plugin for mousehold http://remysharp.com/2006/12/15/jquery-mousehold-event/ you will need to alter your function to fire on mousehold.
  6. If your going to do it that was the "as cnt" needs to come after the query in parenthesis like SELECT *, (SELECT COUNT(items.item_cat_id) FROM items WHERE item_cat_id = categories.id) as cnt FROM categories WHERE parent = 4" Im not sure if doing it that way will bring back the result you want. it may.
  7. While your testing queries you may find it easier to use phpmyadmins SQL form or a local mysql GUI app that will show you results
  8. Ok it must not like count(items.*) you can change the * to a specific col in the items table like count(items.id) if you have a column named id.
  9. haha yes @JAY6390 you are exactly right.
  10. Woops. try this select category.name, count(items.*) from items, category where category.id = items.item_cat_id and category.name IN ('Javascript', 'Ajax') group by category.name
  11. Heres one way to do it. select location_s.start as start, location_e.name as end from journeys, location as location_s, location as location_e where journeys.start_id = location_s.location_id and journeys.end_id = location_e.location_id and journeys.journey_id = ?
  12. Try this select category.name, count(*) from items, category where category.id = items.item_cat_id and category.name IN ('Javascript', 'Ajax') group by category.name
  13. I would use jQuery personally. Give the checkbox an id like "fruit" and then the js would be: if ($('#fruit').is(':checked')){ // code here }
  14. Using a label for the input will line it up automagically HTML: <div class="searchbox"> <form method="get" action="search.php" style="float:left;"> <input type="hidden" name="type" value="images" /> <label for"keyword">Search:</label> <input type="text" name="keyword" size="32" value="Search" id="sbi" onclick="clickclear(this, 'Search')" onblur="clickrecall(this,'Search')" /> <input type="submit" value="Search" name="B2" class="sub-button" /></form> </div> CSS: #sbi { font:normal 12px verdana; height: 18px; width:240px; color:#000000; letter-spacing: 1; border: 2px inset #F5F5F5; background-color: #ffffff; } .sub-button{ font:normal 12px verdana; width:88px; color:#FFFFFF; letter-spacing: 1; border: 1px inset #F5F5F5; background-color: #990000 } .searchbox label { font-size:30px; color:#666; }
  15. Your image file needs to be before any of the text you want to have wrap around it. When an item is floated its positioned within the normal flow, then taken out and repositioned. Anything coming before the floated item will have an effect especially when floating to the left. Your CSS looks fine. Just move your image to the begining of the text and all should be good.
  16. Yeah there are some lines in your php.ini file you need to uncomment.
  17. Try changing your path to C:\\xampp\\htdocs\\access\\test.mdb
  18. The :hover pseudo class is only going to apply that specific css when the mouse cursor is actually hovering over the link. Once you move the mouse away they will be removed. This type of thing is best done with Javascript.
  19. Here is what i did to get what you wanted. You had a bug which was causing page refreshes if a cookie value was set. I assumed thats not what you were wanting. With the below changes if a cookie isnt set it default to displaying the content else it uses the cookie value. Change the last line for getCookie() from return false; To: return 'block'; Then changed your links to read. <a href onclick="toggleList('div1'); return false;">Taggle Div 1</a>
  20. The way that article shows how to do this is in my opinion not the best. Try it this way, youll get better results in the end. http://www.oscaralexander.com/tutorials/how-to-make-sexy-buttons-with-css.html
  21. Check your spam folder. If the domain in the emails from doesnt match the domain in the header it will flag it as spam. Usually all my test emails from my dev go to my gmails spam.
  22. One of the main issues causing this is the flash. You need to specify wmode="transparent" as one of the flash attributes. Its a known issue with flash and html elements. Also set the position and z-index of the flash element along with adding the position and z-index of the jqueryslider ul. I messed with it through firebug and finally got it to display right.
  23. Foo::bar();
  24. Your going to need to provide your code. It sounds like there is something in the php logic thats causing your issues. $_GET itself wouldnt cause this issue.
  25. Your iframe css needs to have position:relative; added to it because z-index will not work without a position set. Also the flashcontent div inside the iframe needed position:relative; z-index:1; added. After that i was able to see the menu above the flash.
×
×
  • 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.