10,940 Topics
 | |
| | Wordpress - I want to use a title condition for displaying info on a page, from a MySQL table "country". The condition must compare the title with the names in the column "name" and when it match a value than display on the page the text from column "description" from …  |
| | Dear, I make a php page to upload the images, pdf, swf etc etc for specific orginisation entered in same form. In the form i made the input type files to upload a maximum of three files but i know how to upload one of them only. here i upload … |
| | Hi, I am using timestamp datatype for storing date..and value of column is like 2013-12-31 T 23:59:59.000Z For query SELECT * FROM a WHERE created_on BETWEEN '20131201' AND '20131231' SELECT * FROM a WHERE created_on >= '20131201' AND created_on <= '20131231' Which will give right result?? |
 | Hello. I am having a hard time in figuring out how to view the pdf file after uploading it in your system. My plan is retrieved PDF files that is stored in mysql database and display them in the browser when the user click the view button. please help me. … |
| | I am having a problem on notifying the user when he/she submit a empty form. When I submit an empty form, the system doesn't notify or alert the user that the form is empty. And when I put a title and I leave the content textbox empty its still add … |
 | Ok, so I'm working on a web-project, I connected a custom hanlder to the root Logger in `contextInitialized()` of a ServletContextListener: @Override public void contextInitialized(ServletContextEvent sce) { Logger def = Logger.getLogger(""); Handler hand = new DatabaseLoggingHandler(); hand.setLevel(Level.WARNING); def.addHandler(hand); } which looks like: import java.io.PrintWriter; import java.io.StringWriter; import java.util.logging.LogRecord; import java.util.logging.Logger; … |
| | Hi, I am trying to merge below two queries in a single query such that company_id,company_name,noOfOpenTickets,noOf PendingTickets Need suggestions?? No Of open Tickets: select c.company_id, (select company_name from company where id=company_id) as companyName,count(s.complaint_id) as noOfOpenTickets from complaint3 c ,complaint3_status s where s.id =(select max(d.id) from complaint3_status d where d.complaint_id =c.id … |
| | Hello Everyone, I have to create a temporary table for basket. I have to include certain fields from different table. Now I know the code to create a temporary table "CREATE TEMPORARY TABLE", is that right? But I dont know how to choose different fields from different table. Let me … |
| | Read first row from csv file and create table automatically according to it(csv file fields) in mysql. Looking for PHP script? I have tried this. <?php $arr = array(array(),array()); $num = 0; $row = 0; $handle = fopen("./contacts.csv", "r"); while($data = fgetcsv($handle,1000,",")){ $num = count($data); for ($c=0; $c < $num; …  |
| | Hi, I want to do like: 1> [COLOR="Red"]browse file and upload .xls file only[/COLOR] (Not csv or other format) 2> save into mysql database. Any sample demo example?? Or link please? |
| | Hello guys, i have been working on a new script that will import data from a TXT file to mysql. Using this code works ok: $sql = 'LOAD DATA LOCAL INFILE 'logons-16-12-2013.txt' INTO TABLE pcvsuser COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\\r\\n''; But if i … |
| | Hi I'm working on a function and it was working good until I had an error that tells me I should swich from mysql to mysqli so I did swich but I'm having a lot of errors ! (the function is working fine but I have a lot of errors!). … |
| | Hi I'm facing this error : Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /var/www/core/inc/config.php on line 7 I've tried to replace mysql with mysqli but I faced some errors.So I decided to return to mysql but my … |
| | I have three tables 1.course(c_id(pk),c_name,sem_no); 2.student(s_id(pk),s_name,user_name,password); 3.student_info(s_id(fk),c_id(fk)); i have logged in the student.. den i run this query select distinct sem_no from course,student_info where course.c_id=student_info.c_id and s_id='0001' order by sem_no; it shows all the semster he passed inclueding the running semster.. now i want to show the last value of …  |
 | Hello, What's the mysql syntax to rename column in a table? I try this: ALTER TABLE static_content RENAME COLUMN title TO shorttext MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | hi im making a database for my project is it possible to have multiple foreign keys shown at the picture? i tried to alter the tables and add foreign keys but i always get a #105 error, so i deleted all of my tables and will make a new set … |
 | I created a table in phpmyadmin and i was curious to know if it is possible to assign multiple values to one variable/field in the same table. For example here is what i have: ID | Shoe | Sizes ____________________ 1 | CK | 7 ____________________ 2 | LV | …  |
| | Hello, guys.. I am actually working on a project. I can't figure out how to limit the displayed content on a table of a particular data. I have a table (tblservices) that have fields (service_id, service_name, service_content, date_created).. *the service_name* is the title of the service, *service_content* is the whole …  |
 | HELLO! I've been debugging my code for an hour now. seriously. So I have this string: SQLString = "UPDATE `etmsystem`.`main` SET `timeIn` = '22:00' WHERE `main`.`serialNo` = '70002B4A8F9E'" actually the TIME and the SERIAL NO. here is to be represented by a variable. But I changed the code into that …  |
| | I made a new MySQL table in Phpmyadmin in Wordpress in the same database from Wordpress but a new table. I want to make a new page and add a script in the body that allows: 1. when i insert the page title to the new page, the script should … |
| | Below are 2 functions that will handle the Query and rending of the menu from MySQL Database. This function Loops through the array. Takes in 2 arguments. function loop_section($array, $parent_id = 0){ echo '<ul>'; foreach($array as $section){ echo '<li>'; echo $section->section_name; echo '</li>'; } echo '</ul>'; } This function handles … |
 | Hello. I am beginning to re-develop a small database using PHP/MyQL; I have already sucessfully done this a year ago but no longer have access to the machine, code or credentials. It worked great! But now, I'm rebuilding it. The test site (PHP) seems to be fine. I see no … |
| | Please provide detailed description of how to update ft_min_word_len value in global_variables table of information_schema database.  |
| | hi i am currently working with php which requires registration once the user registers with his/or her details then an email is sent to the user for activation once the link is clicked the account is activated this works perfectly but the question is how do i expire the link … |
 | Somebody can help me. I'm new in php and highcharts. I tried to populate my chart using mysql and php, but when I tried to run it, the chart didn't appear, only a blank web page. And there's no error appeared. Her's my codes (sorry for messy code): <!DOCTYPE HTML> … |
| | The following snippet shows how you can use binding in your queries when using MySQLi. For starters, here's the table structure I've used: CREATE TABLE `mytable` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `dob` date DEFAULT NULL, `level` int(11) DEFAULT NULL, PRIMARY … |
| | Hi, I am using VB6 and phpMyAdmin connected by WAMPServer for my system. I am new in this language. Here's the code in my that seems to be wrong: Private Sub cmdsubmit_Click() Dim rs As ADODB.Recordset Dim strsql As String strsql = "insert into table1 ( surname, firstname, middlename, house, … |
| | I have a table EmpList. I want to use loop to bring result as I expected. Example, EmpNo ReportingTo ------------------- 27 14 68 14 104 27 105 27 138 27 139 68 150 8 151 8 8 5 Suppose query input is 14, I need result like this EmpNo ------ …  |
| | So I am reading a book from Pratt and it is called A Guide to MySQL. Apparently the book stinks and I am trying to answer some of the questions from the book. #fc1 show tables in the current selected database # for your current database it should be two … |
| | hi all.. i am having an problem during mysql installation..hopefully you all can give me advice and solution on how to solve it...below is the image of screenshot that i take.please help :)   |
The End.