10,946 Topics
 | |
| | good day! im working on a migration tool for mysql to mssql. is there any references or codes that you guys can share to me to create databases and transfer data from mysql to mssql? ive just got this idea of using dump mysql files since they also have sql …  |
 | I need help on building a mysql query. I have 2 tables : list and type. List : id_list, name Type : id_type, id_list, name The id_list column in table Type is a reference for id_list in the table List. My HTML [main.php] : <head> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> <script type="text/javascript"> function … |
| | Hi there, I have 3 tables to extract data from. My query thus far is: SELECT `ministry`.`pm_name` AS 'Name', DATE_FORMAT(`ministry`.`min_begin`, '%Y') AS 'Election Year', `ministry`.`party` AS 'Party Led', `deputy_name` AS 'Deputy PM', COUNT(DISTINCT `ministry`.`min_begin`) AS 'Times Elected PM', `GG_name` as 'GG Name', `gg_title` as 'GG Title' FROM `ministry` JOIN `deputy_pm` … |
| | Hi, I am a complete newbie when it comes to php. I have been searching google for a way to upload multiple pictures to a directory at one time, and at the SAME time store each pictures path into a table in the database. I have found several examples of … |
| | Step 1. Install mysql-essential-5.0 Following Command To install that . start mysql-essential-5.5.12-win32.msi /quiet /norestart Step 2. Set configuration Run Following Command line For That . cd\ cd Program Files cd MySQL cd MySQL Server 5.5 cd bin MySQLInstanceConfig.exe -i -q "-lC:\mysql_install_log.txt" "-nMySQL Server 5.5" "-pC:\Program Files\MySQL\MySQL Server 5.5" -v5.5.12 "-tC:\Program …  |
 | Hi all, the following PHP MysSQLi query works in XAMPP but not in WAMP: <?php include('../../inc/config.php'); $mysqli = mysqli_connect($config['host'], $config['user'], $config['pass'], $config['db']); $responseQuery = "SELECT tr.id as trid,tr.topicid,tr.usersid,DATE_FORMAT(tr.date_added,'%b %d, %Y %H:%i') AS format_date_added,tr.date_added,tr.response,tr.status, t.id, t.usersid as creatorid, u.id, u.authuser, u.memtype, u.fn,u.ln,u.avatar FROM topic_response tr LEFT OUTER JOIN topic t ON …  |
| | Please I dont have any code for that. Can any body help this? |
 | Is the error i get trying to connect to my db. Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2005): Unknown MySQL server host 'http://www.fleethabari.com/' (1) in /home/www/fleethabari.com/inc/config.php on line 2 Unable to select database: Unknown MySQL server host 'http://www.fleethabari.com/' (1) Warning: mysqli_close() expects parameter 1 to be mysqli, boolean given in /home/www/fleethabari.com/inc/config.php on line …  |
 | i'm trying to alter a table's column name but i keep getting an error. alter table GelderlandDist change inauguration 'inauguration date'; but i keep getting an error: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the …  |
 | Hie everyone I have the below code on my console to import data from an excel sheet to a mySql database but unfortunately I am having an error which reads: NO CONNECTION TRYING TO RECONNECT.... ERROR 2005 (HY000): UNKNOWN MYSQL SERVER HOST '(ID,NAME):' (11001) ERROR: Can't connect to the server … |
 | hello Dear friend i can't explain cause i dont' know why, i'm using the code below to insert data into a myql table but i work fine ust today i get a error colum subtotal can't be null... i' have try too much thing but still same i delete the … |
 | I have a database and I have 3 different values that I want to count, to say that You have x amount of tickets open. I am created an array $array = array( 'Pending', 'Waiting on parts', 'Waiting for customer response' ); and a query string $result = mysql_query("SELECT COUNT(*) … |
| | hello friend i just wanna learn if a way exist to generate AUTO_INCREMENT i have my datble and the colum ID is an AUTO_INCREMENT and the id is from 1, 2, 3 .... i would like to diferent id for exemple : CC13445356 i want 2 letter at begin or … |
 | Hello, I would like to solve form validation and filename problem. Here is my code: /************************** Step 1: Select Cell************************************/ if(isset($_POST['SmartPhone'])) $checked1=$_POST['SmartPhone']; $form->add_checkbox('SmartPhone','SmartPhone',$checked1); if(isset($_POST['Apple'])) $checked2=$_POST['Apple']; $form->add_checkbox('Apple','Apple',$checked2); /************************** Step 2: Select Model************************************/ if($_POST['SmartPhone']==false and $_POST['Apple']==false) { $this->add(new error('<span style="color:red">Select your cell..!!</span>')); $this->step1(); return; } if(isset($_POST['S4'])) $tech2=$_POST['S4']; $form->add_checkbox('S4','S4',$tech2); if(isset($_POST['iPhone 5'])) $tech3=$_POST['iPhone 5']; …  |
 | Hello, I'm working to cellphones spec script. Now I want to create a sidebar with several checkboxes that filter result using ajax. Someone can help me to create this? |
| | So I 1. downloaded the odbc drive from the oracle site, "Connector ODBC 5.2" 2. created a user datasource that tested successfully in ODBC Datasources Administrator 3. created a new db in access 4. External Data->More->odbc database->Link ..., selected the datasource i created and got "ODBC - call failed" Data … |
| | Good Afternoon, I have 2 senarios to which I need some clarification. I have an Access 2010 frontend with linked tables to mySQL using ODBC. Senario 1: I need to add a few fields to the main table and the software is used 24/7 if I add new fields will … |
| | whenever i open phpmyadmin it showing that access denied and #1045 - Access denied for user 'root'@'localhost' (using password: YES) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they … |
| | I have an assignment where I'm supposed to normalize up to three normalizations for a table but the teacher didn't explain it well. Empno Pro# Hours Pro_name Pro_loc Ename Job Job# Pay_rate 56789 1100 32.5 x Apex Smith, John Database Deisgner 100 90 45555 1100 52.5 x Apex May, Joyce … |
 | |
| | I have 2 tables for a simple massage board, one for questions and one for answers. The table forum_questions has a field called 'reply' with holds an int value for the number of answers the question has. My problem is this: I have a form to delete answers, you pick … |
 | getting recepient based on login support id 5 login i need recepitent as 3 and name vimal. |
 | private void cmdsecadd_Click(object sender, EventArgs e) { try { string myConnection = "server=localhost; port=3306; username=root; password=palo; database= student"; MySqlConnection myConn = new MySqlConnection(myConnection); myConn.Open(); MySqlCommand cmd = new MySqlCommand("insert into student.tblstudlog (studentnumber, fullname, year, section) values ('" + this.txtstudno.Text + "', '" + this.txtfullname.Text + "','" + this.txtyear.Text + "','" … |
| | private void cmdlogsec_Click(object sender, EventArgs e) { try { string myConnection = "datasource=localhost; database=secretary; port=3306; username=root; password=palo"; MySqlConnection myConn = new MySqlConnection(myConnection); myConn.Open(); string userText = txtusersec.Text; string passText = txtpasssec.Text; MySqlCommand selectcomand = new MySqlCommand("select username,password from secretary.tblseclog where username=' " + this.txtusersec.Text + "' and password ='" + …  |
| | Am building a vehicle fleet management system, srevice cost is added each time a vehicle is serviced. Now, lets say vehicle A have been service 8 time, B 5 times, C 10 times ... I want to show the SUM(cost) for servicing each vehicle at the same time. I wrote … |
| | Hi, Please advise which database should choose for developer and dba profile |
| | **test.html** <!DOCTYPE html> <html> <head> <title>Database test</title> <link rel="stylesheet" type="text/css" href="test.css"> <script> function validateForm(n,mes) { valid=true; var x=n.value; var errn="error_"+n.id; var email = document.getElementById('EMAIL').value; var filter = /^([a-zA-Z0-9_\.\-])+\@(([a-zA-Z0-9\-])+\.)+([a-zA-Z0-9]{2,4})+$/; //alert(errn); if (x==null || x=="" || x.trim()=="") { document.getElementById(errn).innerHTML=mes; valid=false; } else { document.getElementById(errn).innerHTML=""; if(n.id == 'EMAIL') { if (!filter.test(email)) { document.getElementById(errn).innerHTML="Please … |
| | I didn't expect to find this so difficult, but I'm trying to set a user variable in MySQL to contain an array of values. I have no clue how to do this so tried doing some research and was quite suprised to find no answer. |
 | How do I make a uploader for .cct files to be uploaded into the catalogue of my database for my shockwave game or is there a uploader already created? please help |
| | Hello guys, im trying to self study about connecting java to mySQL database. it's been a while since i used java, so i forgot some of the codes a little, and im also not so good at it. So im trying to connect, been copying and pasting codes trygint to …  |
| | I have this search method that doesn't seem to work, and I am not sure why. I need an extra pair of eyes to see why my search query brings back false results. Thanks in advance. public function search($data) { $person = $data['person']; $bind = [ ":person" => "%$person%" ]; … |
 | Hi, I use a query which is identical throughtout my application, only thing that differs is the select part of the query, so for example: mysql_select_db("mydatabase", $con); $result4 = mysql_query("SELECT * FROM nap where Exchange LIKE '$majorvalue%'"); while($row = mysql_fetch_array($result4)) { $psba = $row['Site']; $status = $row['Status']; $spectrum = $row['InSpectrum']; … |
| | Hello. I've created 2 pages that i'm currently working on. One is called; Test.php -- which just includes a basic form in HTML. <Form name ="form1" Method ="POST" Action ="result.php"> Building Name: <INPUT TYPE = "TEXT" Name ="buildingName"> Room Number: <INPUT TYPE = "TEXT" Name ="roomId"> <INPUT TYPE = "Submit" … |
| | Say I have 2 tables: Table 1 Name - Toys - broken - recurrence Jack 6 4 0 John 8 3 1 Mark 8 2 2 Jack 4 2 1 John 3 3 1 Mark 6 0 2 Table 2: Name - Toys - recurrence COlumn Name: name Column Toys: … |
 | **Hashing Method** // If the two SHA1 hashes are the same, returns true. // Otherwise returns false. private static bool MatchSHA1(byte[] p1, byte[] p2) { bool result = true; if (p1 != null && p2 != null) if (p1.Length == p2.Length) for (int i = 0; i < p1.Length; i++) … |
| | Hi I need an help on showing related post in an website. i want to display my related posts with help of keywords column. Below is my database structure id int(12) title varchar(250) content varchar(250) image_path varchar(250) type varchar(250) keywords varchar(250) can any one please help me. Thanks |
| | Hi, I am currently creating 'Routines' to speed up the analysis of the quiz data my database stores. One of the queries I have been using which I would like to turn into a Routine looks like this. SELECT Candidate, QuizName, PercentageScore, PassFail FROM Results WHERE Candidate ='Joe Bloggs' This …  |
 | When I insert data into the database, for instance, a new client, and after that query the clients in the database, the new client is not immediately shown in the list. For it to be listed, I have to clear the cookies and log in, again, into the site. Why …  |
| | Hello, I have Error Like this when i open the table in phpmyadmin.. why this is happening with table ? please any solution for that... #145 - Table is marked as crashed and should be repaired Thanks |
| | If I have a table like this: Table1 ID - sequence - value 1 1 6 1 2 4 2 1 3 2 2 2 3 2 6 4 1 5 5... Table2: ID - Firstname 1 Jack 2 John 3 Mark 4 Mary Querry Result I hope for: ID … |
| | I'm trying to build google+ sign in feature. I'm able to get all the user data from google+, how can i insert this data into database? I know js is client-side language and it is needed to be done on server side....... my code: <span id="signinButton"> <span class="g-signin" data-callback="signinCallback" data-clientid="My-client-id" …  |
| | i have two tables (they are fixed, not going to update any more) in my databae "phoneadd" phone_nos----name(primary id),home,office,college,friend. Examble: john 87954 45698 78965 12365 martin 45698 78962 45789 45789 trull 47896 14587 85632 14563 addresses----name(primary id),address Examble home first street,new town office second street,old town college thrid street,maxi world … |
 | want to update my database via email, for exm i have 3 fields in db, 1-Id, 2-Name, 3-Marks i wants to update this records by sending a email, how can i update it, |
| | Say I have 2 tables: Table 1 Name - Toys - broken Jack 6 4 John 8 3 Mary 8 2 Nina 6 0 Table 2: Name - ID Mary 1 John 3 Jack 2 Nina 4 I need to merge Table 1 into table 2 and get the ID … |
| | the following function "ranks" the applicants and writes them to the rank_results table in the database: function rank() { $rank = 0; $sql1 = "SELECT * FROM applicant_details"; $results = $this->db->query($sql1)->result(); $sql3 = "SELECT * FROM job_advert"; $job_advert = $this->db->query($sql3)->result(); foreach ($results as $applicant) { $applicant_age = $applicant->age; $applicant_id_number = … |
| | I'm working on an ORM experiment, and I'm looking for ideas to help choose which path to take in it's development. I currently have an index showing how to use it, two interfaces, a database class, a table base class and two auto-generated classes (representing a database table). The first … |
 | I already have a php file that catches data from an uploaded CSV file to MySQL but the problem is, every time I upload the csv file, it duplicates the data into the MySQL What i really want is, if I uploaded the first csv file, and edit some data …  |
| | PFA...!! **Please look at the table data carefully.** I need to delete the rows. I need urgent help..!! Table: CREATE TABLE IF NOT EXISTS `version` ( `nidt` varchar(11) NOT NULL, `noeud` tinyint(3) NOT NULL, `VERSION` float NOT NULL, `ETAT_FONCT` varchar(20) default NULL, `idnap` varchar(25) NOT NULL, `nidtint` bigint(20) NOT NULL … |
| | I Need some help.i just have some tables in data base, that is school ---Name(primary key),phonenumber,street,town,state,country college---Name(primary key),phonenumber,street,town,state,country Railwaystation---Name(primary key),phonenumber,street,town,state,country Hotel---Name(primary key),phonenumber,street,town,state,country In the front end, i will put two combobox and a submit button. All i need is first combo box will have to select the table.Second combobox shows … |
| | Please help, I want to connect two tables in mysql |
The End.