Search DaniWeb - mysq

MySQ-help... 18 Years Ago by crestaldin [COLOR="Navy"]Hi everyone, I just finished my summer internship last week and part of what my boss told me at the end of the program was to work on DBMS skills. I am thinking of working on MySQL and from experience I know the best way to master any programming skill(or the likes) is via practice so I am seeking help with possible … Re: MySQ-help... 18 Years Ago by trafficman I like the keyword: 'mysql tutorial' have you tried in google? mysq update table 14 Years Ago by dev.vini help me to autodecrement a field in a table when delete any entry from table example: !-------------------------- !id name userno !-------------------------- ! 1 harry 101 !-------------------------- ! 2 abc 102 !-------------------------- ! 3 xyz 103 !-------------------------- ! 4 xyz 104 … Re: mysq update table 14 Years Ago by hielo First make a DELETE query. It it succeeds, then make an UPDATE query - ex: [CODE] $id=3; mysql_connect("localhost","username","password") or die(mysql_error()); mysql_select_db("dbname") or die(mysql_error()); mysql_query("DELETE FROM tableName WHERE `id`=$id") or die(mysql_error()); mysql_query(&… Re: mysq update table 14 Years Ago by pritaeas Already answered: [url]http://www.daniweb.com/forums/thread310054.html[/url] Re: mysq update table 14 Years Ago by dev.vini this one is diffrent pls chek it manualy nd reply i am waiting pls hurry Re: mysq update table 14 Years Ago by pritaeas There is no columnno field, do you mean id ? If so, what type of field is it ? If it is not a PK then the other thread applies. If it is a PK then I wouldn't recommend decrementing it. If it is an autoinc field then it is not possible. Re: mysq update table 14 Years Ago by dev.vini !---+---------------+--------+ !id ! name | userno | !---+---------------+--------+ ! 1 | harry | 101 | !---+---------------+--------+ ! 2 | abc | 102 | !---+---------------+-------- ! 3 | xyz | 103 !-------------------+------- ! 4 | xyz | 104 !-------------------+------ sorry its not… Re: mysq update table 14 Years Ago by pritaeas See the other thread... Re: mysq update table 14 Years Ago by peter_budo Threads merged, double removed! Brute force algorithm for square roots with tatics 14 Years Ago by cwarn23 … $this->value = $i; return $this->value; } } function mysq($in) { $tmp = (int) $in; $tmpp = ($tmp/2); …$i=($j+$k); } } } return $i; } $s = microtime(true); mysq(128); $e = microtime(true); $a=($e-$s); unset($e,$s… Re: Brute force algorithm for square roots with tatics 14 Years Ago by cwarn23 …+=$m; $i=($j+$k); } } } } return $i; } $s = microtime(true); mysq(128); $e = microtime(true); $a=($e-$s); unset($e,$s…a, 64, '.', ''),'0').'<br>'; echo 'mysq result='.mysq(128).'<br>'; echo 'sqrt time ='.rtrim(number_format(($e… How to hyperlink mysql search results? 19 Years Ago by bennieblanco … part# in to a form field How can I make mysq results in to a hyperlink and transfer them to the… Getting users added to MySQL table. Please Help! 17 Years Ago by alanos206 I am trying to add users to my MySQ table "users" and for some reason I can … Re: Getting users added to MySQL table. Please Help! 17 Years Ago by hooray …=alanos206;513785]I am trying to add users to my MySQ table "users" and for some reason I can… Someone PLIZ Assist 15 Years Ago by masocha Ok l am coding a simple PHP & Mysq session based athentication. l have done numerous of these before with success. Sadly this one cant run,. Someone pliz send me the correct code. install mysql on linux(centos) successfully 15 Years Ago by talk2sachi …: enforcing it should be like this getsebool -a | grep -i mysq allow_user_mysql_connect --> off mysqld_disable_trans --> off if this is the… MYSQL Query inside Javascript 14 Years Ago by jonnypixel … that does it for me using just php and the mysq; query. Except i cant seem to work out how to… Help PHP RadioButton 12 Years Ago by spluskhan …;strong> <?php // Connects to your Database mysql_connect("mysq.com", "bd", "pass") or die… UPDATE. to plate1 on table 11 Years Ago by thearts.beach <?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","… Re: UPDATE. to plate1 on table 11 Years Ago by thearts.beach … , however this <?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","key1","… Re: UPDATE. to plate1 on table 11 Years Ago by thearts.beach … looks like <?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","key2","… Change PHP Script for mysqli / PHP 7.2 to work 6 Years Ago by daisyr … not work. The problem is of course the database connection .... mysq under PHP 7.2, which I get not fixed **My… convert .edb file to MySQ 20 Years Ago by berimor Hi guys, can anybody help, plase. Is there an instrument to convert .edb file (as far as i know Oracle's Enterprise DB but under free licence) to MySQL? date selection for in jsp and date variable to be caught in servlet to insert in mysq 17 Years Ago by mrityunjay22 i want a date selection form in jsp and that date variable should be caught in servlet so that i can insert date in mysql. its very urgent plz help me Re: date selection for in jsp and date variable to be caught in servlet to insert in mysq 17 Years Ago by masijade And? Your question is? No one is going to do it for you. Re: date selection for in jsp and date variable to be caught in servlet to insert in mysq 17 Years Ago by peter_budo There are some nice tutorials for [URL="http://64.18.163.122/rgagnon/howto.html"]Date and Time[/URL] of Java section, it is up to you to implement it. Next time JSP related questions posr in >Web Development>>JSP mysql_num_rows(): supplied argument is not a valid MySQ 15 Years Ago by Liles13 [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/l/i/l/liles13/html/main/libraries/joomla/database/database/mysql.php on line 344[/CODE] Im trying to get a new portfolio site up and running, and I'm very new to PHP. I've read various topics about queries and dropping tables, but I still can… Re: mysql_num_rows(): supplied argument is not a valid MySQ 15 Years Ago by Wraithmanilian Looks like you're pretty new to DaniWeb as well. [URL="http://www.daniweb.com/forums/thread191031.html"]http://www.daniweb.com/forums/thread191031.html[/URL] Re: mysql_num_rows(): supplied argument is not a valid MySQ 15 Years Ago by Liles13 I know, i know. Newbie here...my apologies and thanks for pointing me in the right direction