this related previous question asked: hide / show multiple divs i have code in place previous question , seems work ok apart when change value in dropdown "after" ticket selection made. i have number of javascrpts in place wondering if there clash somewhere? first bit of code in head of document. <head> <script type="text/javascript"> $(function() { $('.cat_dropdown').change(function() { $('#paymethod').toggle($(this).val() >= 2); }); }); </script> <script type="text/javascript"> $(document).ready(function () { $(".paymentmethod").click(function () { $(".paymentinfo").hide(); switch ($(this).val()) { case "credit card authorisation": $("#pay0").show("slow"); break; ...
i've got error on mysql while trying add unique key. here's i'm trying do. i've got column called 'unique_id' varchar(100). there no indexes defined on table. i'm getting error: #1062 - duplicate entry '' key 'unique_id' when try add unique key. here screenshot of how i'm setting in phpmyadmin: here mysql query that's generate phpmyadmin: alter table `wind_archive` add `unique_id` varchar( 100 ) not null first , add unique ( `unique_id` ) i've had problem in past , never resolved rebuilt table scratch. unfortunately in case cannot there many entries in table already. help! the error says all: duplicate entry '' so run following query: select unique_id,count(unique_id) yourtblname group unique_id having count(unique_id) >1 this query show problem select * yourtblname unique_id='' this show there values have duplicates. trying create unique index on field duplicates. need r...
Comments
Post a Comment