10,940 Topics
 | |
| | Hi, I have developed a database web application, in that, a database has 2 tables with same structure. I am using MySQL querybrowser to add, update and delete the records. So, now my question is how can I move the tables records from one table to another, without writing a … |
 | I Use visual Basic 8.0 and Mysql 5.0 I have one Table1: [COLOR="Red"]Table1[/COLOR]: RecordID , Integer = primary key auto_increment NOT NULL Articlenr , Integer Articlename, Char(20) Table1: has two records: RecordID, Articlenr ,Articlename 1 , 1000, Hamer 2 , 2000, saw I want to use Datagridview to update Mysql … |
| | I'm making a photo album with my own CMS, part of it is adding photoalbums to it, but i'm having some trouble linking the "click on album name" to the loading of the correct photo album. my 2 tables are gallery_categories, primary key: id and gallery_assests, primary key: cat_id What … |
 | Hi All, Can anybody see why this code wouldnt update the database? Cheers Paul [code] $me = $_SESSION['user_id']; $user_title = $_POST['user_title']; $user_fname = $_POST['user_fname']; $user_lname = $_POST['user_lname']; $user_add1 = $_POST['user_add1']; $user_add2 = $_POST['user_add2']; $user_city_state = $_POST['user_city_state']; $user_post_zip = $_POST['user_post_zip']; $user_email = $_POST['user_email']; $user_password = $_POST['user_password']; // Connect to server and … |
| | Hi all... Im having some trouble inserting values to my mySQL database. I have the following installed on my local system. [B]MySQL[/B] Server: localhost via TCP/IP Server version: 5.1.43-community Protocol version: 10 User: root@localhost MySQL charset: UTF-8 Unicode (utf8) [B]Web server[/B] Apache/2.2.14 (Win32) PHP/5.2.12 MySQL client version: 5.0.51a PHP extension: … |
| | Hi all, I have a 4 column table. Say the count of records in each column is 5, 50, 100, 200. the column with 5 entries, has those entries not appearing at the top of its data area. eg cars houses flights a b c d a e b a … |
| | Hello and thank you for taking the time to read my question. I am currently moving a static html site into a faux CMS and have a question about which direction is best recommended. I have series of 'News Articles' that I would like to make available through a db. … |
| | hello every body i want help for the ERD , if any missing in that pleas tell me and advise me how can i modify this ERD . this ERD for Online Library management system . the diagram attached |
| | Hi, I have the following: [CODE] $_host = $DHOY_CONFIG['db'][$connection_name]['host']; $_name = $DHOY_CONFIG['db'][$connection_name]['name']; $_port = $DHOY_CONFIG['db'][$connection_name]['port']; $_user = $DHOY_CONFIG['db'][$connection_name]['user']; $_pass = $DHOY_CONFIG['db'][$connection_name]['pass']; $dsn = "mysql://$_user:$_pass@$_host:$_port/$_name?new_link=true"; print "dsn is $dsn"; if ($dsn != 'mysql://:@:/?new_link=true') { $db_connection[$connection_name] = DB::connect($dsn); if (!DB::isError($db_connection[$connection_name])) { return $db_connection[$connection_name]; } else { trigger_error("General system error ID: 00002 - … |
| | Hi, How do I change maximum connection to mysql database and maximim user connection to mysql? Thanks |
 | Hi all I'm having trouble displaying special characters. I have a database that has a number of characters from different languages and I've managed to display almost all of them. But I still have some characters showing up as a question mark inside a diamond. The code I'm using in … |
| | i want to insert non empt values (as $im1, $im2.....) in mysql database, code is as follow, im_id is auto_increment key [CODE] $im1 =image1['image']; $im2 =image2['image']; $im3 =image3['image']; $im4 =image4['image']; $sql = "INSERT INTO `class-ads`.`images` (im_id, image) VALUES (NULL, '$im1'), (NULL, '$im2'), (NULL, '$im3'), (NULL, '$im4') mysql_query($sql) or die('Error, Posting … |
| | Hi This isn't specifically a php issue, but i would be using php for the project... i am creating a site where people can upload articles, photos, docs etc - thing is, I want to keep everything as its own entity and use tables to link articles to images etc... … |
| | Hi all, I'm still a newbie in programming world.. And I just realized that PHP has a function "mysql_insert_id()" to get the most recent id that generated by AUTO INCREMENT. But, before I use it, I want to know Is it safe to use it when many users insert data … |
| | Hi, i'm sql newbies, hope someone can help. I'm trying to do a tariff lookup table for my voip service. When a user makes a call, i capture the destination phone number which has the country code prefix (the prefix may have or not have the plus sign). I'm trying … |
| | Hey, so I have a form and i want to break down the form into 2 sections when inserting into my database. I have made 2 tables to hold my values. this is my SQL statements. [CODE] $sql_insert1 = "INSERT INTO `agent_users` (`user_name`, `password`, `primary_email`, `secondary_email`, `join_date`, `last_accessed`, `activation_code`, `first_name`, … |
| | Hi there, I have successfully setup a page using a tutorial (shown [url]http://www.phpeasystep.com/mysql/10.html[/url]) It's all working fine as it stands. I have now added another column to the database that can either be 1 or 0 and I would like to be able to change it on the update page … |
| | I have 3 tables, all linked. Table 1, Table 2 and Table 3. 1 to many. Table 1 will always have records in Table 2. However, Table 2 does not have to have any records in Table 3. I want to get the id's and names of the records in …  |
| | hi. i am senthilmurugan. i am learning to php language. one error occur. i try to connect to database. [B]Can't connect to MySQL server on 'localhost' (10061)[/B]. how to correct the error . please reply the answer... |
| | I am currently working on a client management system for my Computing Coursework and I've come to the "Client Details" section, which allows staff and admin to view personal information about each client. I've successfully coded the query and everything else around it, I'm just a but stuck on how … |
| | Hai, In one of my project I need to add some data into my data base and redirect the page to a different page. In this case I need to check whether the data has uploaded successfully and then redirect. For a rough sample mysql_query("INSERT INTO") [ICODE] if(data added ){ … |
| | Hey folks, I am loading the database from the text file using load infile command, what i wish to do is to delete last inserted data not just the last row i.e all the data i have loaded from text tile.I am working on MySQL. Thanks in advance Prankyrules |
| | Hi guys, I am having difficulties to purchase a HONEST and DECENT Linux hosting for my PHP + MySQL website. I am asking you to suggest me one or two based on your experiences because most of hosting companies offer very exciting stuff but most of them are hustlers (I … |
 | Knows the code importing file in mysql using php? that would save all the data saved in excel to mysql database..tnx GOdbless |
| | i am writing a java problem connecting to mysql database. i don't know why data type decimal or numeric woudn't store any decimal numbers. my java program would output: [code] Type was: DECIMAL [/code] when trying to insert number like 23.50. what data type should i be using? probably not … |
| | userfood table auto_id | userId | date | foodname | perserving | satfat | monofat | polyfat | protein | carb 1 ------ 1234567S --2010/02/01 -- chicken rice- --- 382g ----- 8.7 ----- 9.1 ---- 3.7 ------ 25 ----- 75 2 ------ 1234567S --2010/02/02 -- mee siam----- --- 683g ----- … |
| | I am not familiar with Linux/ Unix and I encountered a corruption. How do I repair this? Warning: mysql_num_rows():supplied argument is not a valid MySQL result resource in usr/local/apache2/htdocs/vicidial/AST_timeonVDADall.php |
| | Hi guys, I'm pretty much self taught, and I'm working on a site that stores mysql data using php. In the site I previously did, I used separate pages with a query relating to what I wanted to show, eg. a page called Manchester.php that displayed all records with an …  |
| | |
| | Hey Brother, I have need to create new table into new database from exist table of old database. So how I can copy that much table into other database. I have tried below code. but it give error at "IN". [CODE] SELECT * INTO dbo.pqrnew IN "NewDatabase" FROM dbo.pqr [/CODE] … |
The End.