10,940 Topics
 | |
 | 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 …  |
The End.