10,945 Topics
 | |
 | 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%" ]; … |
The End.