10,938 Topics
 | |
| | I am relatively new to mysql. I am updating a site for a customer, and I'm using mysql 5 w/ phpMyAdmin. I was supplied an .sql (echeck.sql) script to build the database for this site. I create a database named "echeck" in phpMyAdmin, and once created go to the import … |
| | Can not get the following code to delete Jack.... What is wrong with the code? <?php ===QueryString=== delete.php?q=169|170|171| $arr = explode('|', $q); for ($i = 0; $i < count($arr); $i++) { $query .= "DELETE FROM aCar WHERE aID = '".$arr[i]."'"; $result =mysql_query($query); } ?> Thanks in Advance!  |
| | I had my site working which require mysql database... so now im trying to host that site here at home... my site comes up but now on the top of the main site 3 errors come up... Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'milatcom_clipsha'@'localhost' (using password: YES) in /www/www.mysitesname.com/include/adodb/drivers/adodb-mysql.inc.php … |
| | Hello Everyone i need help connecting my site to a database.. Either MySQL or PHP Which Is better. |
| | I used both Myisam and InnoDB. We have something like 500k update, 500k and 500k insert/delete/replace per hour. Many full scan because of updation.Both give me some problem either dead lock occurs or too many connection rise. Also insert/delete/replace operation takes long time. If i used innodb then dead lock … |
 | I'm looking for some PHP scripts that be able to search into the Database and retrieve all the records that matches the user input string in the search form. Please advise. |
 | I want to apologize for this morning's downtime. We were having some mysql problems this morning, and I didn't realize it until I woke up, a few hours too late. Sorry everyone! Cheers, Dani |
 | I am emailing a field from a MySQL DB table. The field type is text. Basically, it is an accept email. How can I make it so the email sent is capable of emailing HTML to make the message more attractive? I have already tried to insert < html > … |
| | I want to build a web application with MySQL database. When more users will visit my site, more database queries will be initiated and the response time will increase. - Is there a limitation for the number of users who can query MySQL? - What are the ways to handle … |
| | hi i want to know how to fetch data by giving more than two condition...please tell me wat should i use eg i have a query [ICODE]SELECT * from post_resume WHERE ind_type='IT'and career='Engineering' order by tdate DESC[/ICODE] i want to check based on another condition also... [ICODE]select association from employer … |
| | hi, i need ur help. can u help me how to remotely connect some database like ms access,sql server,etc to mysql?every minute i hav to send new information from database ex ms access to mysql. I use VB6.  |
| | guys i m really havin hard time to establish connection bet jsp n mysql...give me some tips..i ve done all the procedures required for that n i couldn execute the followin code [code=html]<%@ page import="java.sql.*" %> <% String username="mahesh"; String password="mahesh"; String connectionURL = "jdbc:mysql://localhost:3306/mahesh"; Connection connection = null; //Statement …  |
| | I use redhat enterprise 5 and I want to install mysql++, which used to connect to mysql from c++. I get the following error message when install checking for MySQL include directory... configure: error: Didn't find the MySQL include dir in '/usr/local/mysql/include /usr/local/mysql/include/include /usr/local/mysql/include/include/mysql' |
| | [code=mysql] $query = "INSERT INTO users (first_name, last_name, email, password, registration_date) VALUES ('$fn', '$ln', '$e', SHA('$p'), NOW() )"; [/code] What is the NOW() used for. Is it compulsory? |
| | Hi everyone, I was trying to setup MySql with Cygwin so that i can create and work on databases using my Windows OS. After gruesome hours of googling, I am still confused as to how to do that. I first downloaded the installer for MySql on windows. I also downloaded … |
| | Say you have 3 tables A (Key, a) B (Key, b) C (Key, c) How would you select say 10 from A ordered by a, from 50 from B ordered by b, from 100 from C ordered by c? All the keys represents the same thing. Thanks! |
| | Hi, I have a long list of options( 60 option) where user can selecte none or all of them. the code is like that [CODE] <selecte name="list"> <option value="1">option</option> ... </selecte> [/CODE] and I have to display it again as a list ( <li></li> ), my question is what the …  |
| | I have a need for a program better than Query Analyzer, I use Enterprise Manager on a daily basis for work purposes and have given the Query Analyzer program to our head person in charge of the front-end of the software, but they are now having a growing need to … |
| | I am trying to insert a row into a table into a MySQL DB 5.0 table. One of the VALUES that I am inserting just so happens to be HTML code. When I execute the INSERT in MySQL Query Browser it tells me "You have an error in your SQL … |
| | Well n not a mysql expert so i need help with this sql file here r d contents of it. Quote:[code] CREATE TABLE `admin` ( `id` int(11) NOT NULL auto_increment, `username` varchar(255), `password` varchar(255), `webmaster_email` varchar(255), `lastlogin` int(11), PRIMARY KEY (`id`) )"; "insert into admin set username='$admin_login',password='$admin_pass',web master_email='$admin_email'"; CREATE TABLE … |
| | Hi, I am using Cerberus ticketing system Recently I have started getting lots of junk email with the subject line containing non0latin characters. The Subject & Content looks like this: [CODE] <br> antivirus Äú=ºÃ£º<br /> <br /> ÖйúÉÌÒµÊý¾Ý¿ª·¢×é֯ΪÄúÌṩ±ãÀû¶øÇ¿¾¢µÄ£¬<br /> ¡ï£µ£°£°£°£°£°£°ÖÁ¡ï£µ£°£°£°£°£°£°£°ÉÌÎñµç×ÓÐÅ<br /> º¯±¬·¢Í¶·Å·þÎñ£¬È·±£ÄúµÄ²úÆ·(ºÍ·þÎñ)µÃµ½¼«´óÊý<br /> Á¿Ïû·ÑÕߵĹØ×¢ÓëÇàíù£¬²»³îÄúµÄÉúÒâûÓÐת»ú£¬´ø<br /> À´È«ÐÂÈ«·½Î»´ó¸²¸ÇÂʵÄÉÌ»ú£¬Ç§Íò¼¶µÄÊг¡ÄúÒ²ÄÜ<br /> Ó®µÃ£¬Ê÷Æ·ÅÆ´òÊг¡µÚһѡÔñ£¡<br /> <br … |
| | [B]Hi! I make nws CMS for self. I added search function too. But I have problem. I save data with html at DB Sample: [ICODE]<font color=red>Some text</font>[/ICODE] When I search for string "some" I get this row. But when I search for string "font" , I also get this row …  |
| | [code=sql] CREATE TABLE users ( user_id int(10) unsigned NOT NULL auto_increment, username varchar(20) NOT NULL default '', password varchar(20) NOT NULL default '', PRIMARY KEY (user_id) ) TYPE=MyISAM; [/code] [COLOR="Red"][U]Questions:[/U][/COLOR] 1. What is the purpose of MyISAM? 2. What happen if I created the above table without MyISAM. |
| | Hi everybody! I have a trouble with my work. I have a file data CVS, and i want to cover to a table in mysql. But in my file CVS have some special character : /t, ", Please help me! Thank a lot! mysql>load data local infile 'price.csv' into table … |
 | Im quite new to php and mysql but ive figured out how to upload and display content from my database, but im still facing quite a lot of problems. - First how do you display an image uploaded in the database? - Second how do you make the content only … |
 | Hi friends, I am using Netbeans 6.0.1 and I've installed MySql on Fedora 8...I 've been able to configure the jdbc-MySql connector that's bundled with Netbeans and I can create tables and query MySql using the Netbeans GUI.So I guess my connection was correct...My connection properties are as follows: Database …  |
| | hi dear all give me some details for which one of best suitable server for PHP+ mysql ? Thanks |
| | I am new to PHP or just not good at it lol, I have been trying to insert checkbox elements into a mysql database. I have a table called Team with two collumns. Id int not null auto increment PK team varchar 30 not null <? <body><form action="insert.php" method="post"> select … |
| | Hello Friends, I am having trouble figuring out how to get me Radio Buttons to search my database. Everything is up on the page and when I select enter it just shows all the items as if nothing was entered. There was already a set search button in the script … |
| | I Started Installing it and i am getting this error Step 2) Connect to the database Attempting to attach to database Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/www/tropical4.freefronthost.com/Vb/Vb/includes/db_mysql.php on line 140 The database has failed to connect because you do not have permission to connect …  |
The End.