10,940 Topics
 | |
| | This is a rookie question and don't really know how to word it so that google finds me an answer, but can someone give me an example of a query using multiple WHERE restrictions so I can see how to format my query? |
 | Hi, I have never used table locking before. Would something like this be sufficient? Basically I want to only allow exclusive write access to the bid table: [CODE] <?php $query = "LOCK TABLES bid WRITE"; $placebid = mysql_query("INSERT INTO bid (auction_id, seller_id, bidder_id, b_timestamp, b_currentprice) VALUES ('$id', '$uid', '$ruid', NOW(), … |
| | Hello, I have a database with about 25 tables and almost every table having a foreign key on some other table. They system needs to deal with a large number of reads and writes. I'm concerned if having too many foreign keys and relationships between tables will lock the tables … |
| | Hi, well what i need to do is, through a certain interface there are assignment upload calls given by the admin, this is that interface [CODE]<html> <head> <script type="text/javascript"> function remlink(num){ var rownum=num; var rowid = "subname_"+rownum; var sn=document.getElementById(rowid).innerHTML; var cnfrm = confirm ("Are you sure you want to remove … |
| | I hope you can help. I have a program using 2 pages (main.php and resize_image.php) fragments shown below. Each script works fine independenly of each other. My problem comes when I want to pass a value held on my database held in $story[picture] to resize_image.php..... It simply will not transfer … |
 | Hello ... I have a very annoying problem just now, MySQL server in my office is not stable. This morning it has stopped for more than 10 times. :'( FYI, the version of MySQL is 3.23.54 running on redhad 9. When I tried to restart it, it showed like this: … |
 | Hi, I have a script which is meant to use all of my servers cpu but mysql will only use one core. I have 8 cores but only 1 core is being used. Does anybody know how to allow mysql to use multiple cores? -------- Second question How do I …  |
| | I am using AJAX scripts in jsp to access mysql database which has been made using InnoDB and MyISAM. while the database is in InnoDB format, the ajax script works fine but for MyISAM format, it doesn go well. Pls. let me know how this structure architecture plays role in … |
 | Hi I am using C# to connect to mysql database that install in my local machine.After I complete the project I want to publish it in another server.So I change the mysql connection string.Here I mention the connection string that I used in local machine String MyConString = "SERVER=localhost;"+"DATABASE=IPG;"+"UID=root;"+"PASSWORD=Test;"; Before … |
 | I use: Visual studio 8.0 MySql database One table: table :Groups, two fields : groupnb,groupdef One Datagridview with is link to [COLOR="Red"]Mydataset1[/COLOR] [COLOR="Red"]Some times [/COLOR]a get this MySQL error: [COLOR="red"]"Connection must be valid and open"[/COLOR] I use first this command : [COLOR="Green"]MyDataset1.Tables("groups").Rows.InsertAt(row, 0)[/COLOR] Then I change the content of some … |
| | Ok, I have been searching everywhere for solutions for charset problems I have. I have php website and backend Mysql database. In some fields I need to put in letters from the Greek alphabet. If I use a form to send info to the database and type in Greek letters, … |
| | Just wondering, why is it that PHP seems to be the preferred option over JSP when dealing with MySQL databases? I've long gone off PHP and have moved onto JSP in more recent times and find that it handles the over-all performance much better. I'd like to hear from all … |
| | Hi everyone, I am using Ubuntu 7.10, and I have Java and MySQL installed with the command line as follow: 1. sudo apt-get install sun-java6-jdk 2. sudo apt-get install mysql-server and my JAVA and MySQL are working well, but now I want create connection between JAVA application and MySQL using …  |
| | Hi my first insert statment works ok, My problem is that I wish to insert all the selected options passed from the form. into my user_req_opt table. Some items only have 1 option others may have 10 options. [CODE] $sql = "insert into user_requests(rq_id, user_id, code_ref, code_id, cat_id, opt_yn, rq_qty, … |
| | Can someone help me?? How to retrive image from MySQL(not MS_SQL) and show into my <asp:Image> control using c# Lets said my table on have a field as following: "SELECT pic FROM image" Thanks in advance !!  |
| | Hey, so i'm trying to make a double login page, 2 users put there user and password there and login at the same time, the problem is that it always says that the passwords are wrong... I think my problem is connecting with the MySQL database, because i can't create … |
| | i tried to solve a problem using php, mysql and javascript. i should cliuck a button and ythen the script alters some values in the mysqldatabase. it doesn't work. someone said i had to use ajax but i have never used ajax, please give me some help the internet dazzles … |
| | I want to calculate somebody date using his/her Date of Birth which is located on the database column name(DOB)..which sql function do i use and how do i use it on the Sqlquery..please help |
| | This is the error I keep getting, This script works fine with the local SQL server running on my windows test box but when I try it with the SQL server running on my shared web hosting account with go daddy it gives this error, I think obviously their databases … |
 | Which is better? I know that autoincrement fields allows you to get the last inserted id which is helpful when dealing with multiple tables, but other than that I'm not sure which I should use to make the database more secure/robust. |
| | Hi guys, I am creating a university database, where student can take sections and courses have prerequisites. I have to make sure that when user takes a section, he has met all the prerequisites for that course he is signing up for. And, when a course is deleted from the … |
| | Hello everyone I want to run a .jar file, but the only way to run in my computer is with the "java -jar file.jar ", but the problem is that the application conects to a mysqldatabase, when I want to add something in the program appear a message that say … |
| | I am trying to access a Mysql Server through Lan using VB6 using ADODB connection db.Open "DRIVER={MySQL ODBC 5.1 Driver};DATABASE=xxxx;SERVER=192.168.1.6;USER=root;PASSWORD=xxxx;OPTION=3;" it is giving error [Mysql][ODBC 5.1 Driver]host couldn't connect to the Mysql Server My Server IP is :192.168.1.6 user is: root Firewalls are turned off.... Might be i need to …  |
 | hello... i am doing login verification. there is tabs in index page thats why i am choosen this. actually after entering the values of email and password how to check that values are in database or not using javascript. and i will show message in alert box. this is my … |
| | Hey there. I am attempting to create an administrator option, which would be the following: When the administrator checks the checkbox, it would automatically save it to the db. Usually update it. [CODE] while($row = mysql_fetch_array( $retrieve )) { echo "<td><input type=\"checkbox\" name=\"noutate\" onClick=\"this.form.submit();"; if (isset($_POST['checkbox'])) { $update ="UPDATE content … |
| | Hi guys, mysql noob here. :) So here's my problem. I have 2 tables, Order(order_id,product_id) and Product(product_id,product_name). For one order, I can have many products. So my question is how can I auto increment order_id? When I insert multiple products in the order table, it generates an order_id for each … |
| | I'm looking for a solution. I am developing a "user profile" php file which will render to the current user their profile information. The info rendered and seperated into different divs (styled with css) will be in the form of html/php. However, if no information exists in a specific field … |
| | hi to people who like starting with <?php and finishing with ?> I can always help your php and mysql works.when you need a help just add me to your msn and request a help [email snipped] friendship is first and the second must be helping each other. my name … |
| | I have a database containing records which I want to edit. I populate a list box which gets populated with the records in the database and I select and click on one of the records for editing. I find that I am able to select the record from the listbox, … |
 | Hi all, i want to know that 'Is mysql support chinese language?' If yes then any changes require in configuration? My site is in english. Let if any user have inserted their information in Chinese and if anyone search using Chinese keyword, then it should match with mysql and if … |
The End.