Jump to content

JustLikeIcarus

Members
  • Posts

    430
  • Joined

  • Last visited

About JustLikeIcarus

  • Birthday 09/30/1978

Profile Information

  • Gender
    Male
  • Location
    Kentucky

JustLikeIcarus's Achievements

Newbie

Newbie (1/5)

1

Reputation

  1. You could use something like MySQL workbench which allows you to generate db diffs and manage migrations. http://dev.mysql.com/downloads/workbench/
  2. Here us a js fiddle with an up all night off the top of my head method http://jsfiddle.net/MtBSe/1/ Hope it helps Html: <body> <ul class="blogroll"> <li><a href="#">Title 1</a></li> <li><a href="#">Title 2</a></li> <li><a href="#">Title 3</a></li> <li><a href="#">Title 4</a></li> <li><a href="#">Title 5</a></li> <li><a href="#">Title 6</a></li> <li><a href="#">Title 7</a></li> <li><a href="#">Title 8</a></li> <li><a href="#">Title 9</a></li> <li><a href="#">Title 10</a></li> <li><a href="#">Title 11</a></li> <li><a href="#">Title 12</a></li> <li><a href="#">Title 13</a></li> <li><a href="#">Title 14</a></li> <li><a href="#">Title 15</a></li> <li><a href="#">Title 16</a></li> </ul> <a href="#" class="pager" data-page="1"> Next </a> </body> jQuery: $(function (){ var pageSize = 4; var count = 0; currentPage = $('.pager').data('page'); $(".blogroll li").each(function(i){ count = i % 4 == 0 ? count + 1 : count; $(this).addClass("listGroup" + count); }).not(".listGroup" + currentPage).hide(); $('.pager').on("click", function(e){ currentPage = currentPage < count ? currentPage + 1 : 1; $(this).data("page", currentPage); $(".blogroll").find("li").hide().end().find(".listGroup" + currentPage).show(); }); });
  3. When you build the link if you encode "&" as "&" this should no longer be an issue. A lot of people always encode the ampersand to prevent issues such as this. So the link would resemble <a href="http://somesite.com/page.php?var=1&ltid=1211" />...</a>
  4. start by changing #nav ul li:hover ul{ /*diplay when hovered*/ display: block; } to #nav ul li:hover > ul{ /*diplay when hovered*/ display: block; } test that it should put you in the right direction. Here is a fiddle with the change http://jsfiddle.net/6TGaf/13/
  5. Per the following from MSDN try changing your username to username@database. See if that gets you anywhere
  6. Chrome and Safari are both webkit browsers so they will both prove true for your media query and use the included style.
  7. Maybe something like this would help <script type="text/javascript"> jQuery(function($){ $('input[name=alm]').click(function(){ var parentTD = $(this).parents('td'); var id=$(this).attr('id'); var alm=$(this).val(); $.ajax({ type:'GET', url:'inc/villas_allotment_ajax_update.php', data:'id='+id+'&alm='+alm, success: function(html) { if(html=="1"){//change td bg to green if succeed parentTD.css("background-color", "#66cc00"); }else{ parentTD.css("background-color", "#ff8080"); } } }); }); }); </script>
  8. I dont belive those coordinates exist on the planet... Could be the issue you are seeing.
  9. If you give the clickable rows a class for example <tr class="clickable"><tr> then you could do something like $("#MyTable tr.clickable").click(function(){ $(this).nextUntil(".clickable").toggle(); } This would select all the sibling rows until it hit the next with the class of clickable.
  10. Try something like this. select `website`, sum(case when YEAR(FROM_UNIXTIME(`date_assigned`)) = YEAR(CURDATE()) then 1 else 0 end) AS c_year, count(*) as c_all from `assignments` group by `website` order by `website` asc
  11. Per the documentation it would be wrapAll instead of wrap. $('footer h5, footer ul').wrapAll('<div></div>');
  12. Well the following rule would split the url by '/' and set the vars vendor/category/product RewriteRule ^(.+)/(.+)/(.+)$ script.php?vendor=$1&category=$2&product=$3
  13. If you have 3 different scripts I would think you would want 3 different rules for example: RewriteRule ^vendor/(.+)$ vendor.php?name=$1 RewriteRule ^category/([0-9]+)$ cat.php?id=$1 RewriteRule ^product/([0-9]+)$ product.php?id=$1 Otherwise you may be better off passing the url to a php script to parse out using its regex engine. RewriteRule ^(.+)$ parse.php?url=$1
  14. Should be able to do something along the lines of SELECT id, CASE WHEN col1 = 'true' OR col2 = 'true' OR col3 = 'true' THEN 'true' ELSE 'false' END as newcol1, CASE WHEN col4 = 'true' OR col5 = 'true' OR col6 = 'true' THEN 'true' ELSE 'false' END as newcol2 FROM table;
  15. This should point you in the right direction if I understand you correctly. SELECT id, CASE WHEN col2 = 'true' OR col2 = 'true' OR col3 = 'true' THEN 'true' ELSE 'false' END FROM table;
×
×
  • 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.