mysql - PHP MyAdmin Inserting data twice -


i adding afew tables current database drive online menu.

so far have created 'menu categories' table. below table structure.

create table if not exists `menu_categories` (   `id` int(2) not null auto_increment,   `cat_id` varchar(6) not null,   `cat_name` text not null,   primary key (`id`),   unique key `cat_id` (`cat_id`) )

i have yet write pho scripting wanted insert few dummy categories testing, when insert category , browse table data has been entered twice, 2 of each category.

i have looked around , cannot life of me figure out why, php myadmin?

below print screen of inserting data , end result:

inputting dummy data

inputting dummy data

the sql query inserting dummy data

the sql query inserting dummy data

preview of table duplicate entries

preview of table duplicate entries

any idea going on here?

thanks

*edit: forgot add tried setting 'cat_id' unique. when ran insert command, received error inserting duplicate data

okay, having same issue, , realized inserting data in table.

i figured out this: when press insert , fill out field , press go, going taken page has command line query notice on top showing message: "one row has been inserted, inserted row id 3" in light green bar.

the mistake making was: clicking "go" button @ bottom of query line command, , inserting query in table again. so, instead of clicking "go" click "browse" button on top navigation bar that's next "structure" button.


Comments

Post a Comment

Popular posts from this blog

cakephp - simple blog with croogo -

i not problem, made simple blog in croogo, problem is not adding or modifying or delete, because arabic language ?? function add in controller `public function admin_add() { $this->set('title_for_layout', __('add part')); if (!empty($this->request->data)) { $this->part->create(); if ($this->part->save($this->request->data)) { $this->session->setflash(__('the part has been saved'), 'default', array('class' => 'success')); $this->redirect(array('action' => 'index'));//, $this->part->id)); } else { $this->session->setflash(__('the part not saved. please, try again.'), 'default', array('class' => 'error')); } } }` => model `class part extends appmodel { public $name = 'part'; var $belongst...
Read more

How to group boxplot outliers in gnuplot -

i have large set of data points. try plot them boxplot, of outliers exact same value , represented on line beside each other. found how set horizontal distance between outliers in gnuplot boxplot , doesn't much, apparently not possible. is possible group outliers together, print 1 point , print number in brackets beside indicate how many points there are? think make more readable in graph. for information, have 3 boxplots 1 x value , times 6 in 1 graph. using gnuplot 5 , played around pointsize, doesn't reduce distance anymore. hope can help! edit: set terminal pdf set output 'dat.pdf' file0 = 'dat1.dat' file1 = 'dat2.dat' file2 = 'dat3.dat' set pointsize 0.2 set notitle set xlabel 'x' set ylabel 'y' header = system('head -1 '.file0); n = words(header) set xtics ('' 1) set [i=1:n] xtics add (word(header, i) i) set style data boxplot plot file0 using (1-0.25):1:(0.2) boxplot lw 2 lc rgb '#8b0000...
Read more

bash - Performing variable substitution in a string -

i have string contains use of variable, , i'd substitute variable's value string. right best have is #!/bin/bash foo='$name; echo bar' name="the name" expanded="$(eval echo "$foo")" echo "$expanded" which has obvious defects: prints the name bar while i'd print the name; echo bar instead of eval can bash's regex matching bash's string replacement: foo='$name; echo bar' name="the name" [[ "$foo" =~ \$([[:alnum:]]+) ]] && s="${!bash_rematch[1]}" && expanded="${foo/\$${bash_rematch[1]}/$s}" echo "$expanded" name; echo bar
Read more