JustLikeIcarus
Members-
Posts
430 -
Joined
-
Last visited
Everything posted by JustLikeIcarus
-
Problem with select and dates / week of year
JustLikeIcarus replied to bschultz's topic in MySQL Help
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)) -
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.
-
Are you using the mysql last_insert_id() function when inserting the record into the joining table?
-
Jquery Hide - how do I contain effects within div?
JustLikeIcarus replied to Anti-Moronic's topic in Javascript Help
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. -
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.
-
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.
-
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
-
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.
-
Simple I bet but I still need a bit of guidance...
JustLikeIcarus replied to ToonMariner's topic in MySQL Help
haha yes @JAY6390 you are exactly right. -
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
-
Simple I bet but I still need a bit of guidance...
JustLikeIcarus replied to ToonMariner's topic in MySQL Help
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 = ? -
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
-
On click of checkbox insert the value or delete value
JustLikeIcarus replied to deepson2's topic in Javascript Help
I would use jQuery personally. Give the checkbox an id like "fruit" and then the js would be: if ($('#fruit').is(':checked')){ // code here } -
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; }
-
floating an image so text wraps around it.
JustLikeIcarus replied to deansaddigh's topic in CSS Help
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. -
[SOLVED] PDO, Connect to Microsoft Access Database
JustLikeIcarus replied to Vebut's topic in PHP Coding Help
Yeah there are some lines in your php.ini file you need to uncomment. -
[SOLVED] PDO, Connect to Microsoft Access Database
JustLikeIcarus replied to Vebut's topic in PHP Coding Help
Try changing your path to C:\\xampp\\htdocs\\access\\test.mdb -
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>
-
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
-
[SOLVED] [b]How To Send Email From Local Wamp To Internet [/b]
JustLikeIcarus replied to Gomesh's topic in PHP Coding Help
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. -
Navigation dissapearing under iframe?
JustLikeIcarus replied to liamloveslearning's topic in CSS Help
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. -
Foo::bar();
-
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.
-
Navigation dissapearing under iframe?
JustLikeIcarus replied to liamloveslearning's topic in CSS Help
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.