10,940 Topics
 | |
| | Get records between date for example in mysql 2009-08-11 to current date 2009-08-11 is to retrieve all date , this is just an example I have tried WHERE time between date(time) and DATE(time) = CURDATE(); |
| | Dear experts I am running one mysql query which contains selection from multiple tables.The problem is sometimes the query runs very slow, but sometimes it is ok.Acctually when i run it first time it is very very slow, and from the next time it becomes fast.I wonder if it is … |
 | Hi! I am currently working on my thesis and I don't have any idea on how can I view the records stored in 3 mysql tables. Can someone please give me some code regarding on this. The records should be displayed in a table form then when you click a … |
 | how to bind mysql array to SOAP server.Im using nusoap  |
| | Good day! I am currently working on this code. My problem is that the delete option don't function. It gets the error "There has been a fatal error." as stated in the code, so please help me to fix this code. Thank you <html> <head> <title>Buyer's Profile</title> </head> <body> <?php …  |
| | Good day! I have 3 tables name property, personal and spouse, they have all the same id. I want to join the 3 of them, I had already join property and personal table but I can't join the spouse table. $userquery = mysql_query("SELECT * FROM property, personal WHERE property.id=personal.id") or … |
| | I need to change the timezone of mysql to 'Asia/Calcutta'. I am on shared goaddy hosting. Please tell me how to do the same |
 | hello i wanted to insert data into database like html format i mean i text wich contain html tag like H1 H2 OR P, and any basic other i must use BLOB OR LONGTEXT, if i uses BLOB i must enter that directly in database or upluad that file ?? … |
 | I designed a swing interface with MySQL table. I put two comboboxes in a manner when the 1st combobox value is selected (Brand Name), the second combobox values (available items under thise selected brand) will be loaded via a mysql query. My code is... try{ String url = "jdbc:mysql://localhost:3306/databasename"; String …  |
 | i'am trying to create a setup file for my system where it has a database...can you help me???...i've tried to search it but it's only for mssql... |
| | [CODE=php] <?php //get the variables $var = $_POST['query'] ; $trimmed = trim($var); $table = $_POST['table']; //make connection $conn = mysql_connect('localhost','root','123') or die("Error:".mysql_error()); mysql_select_db('sutilities',$conn) or die("Error:".mysql_error()); //delete temp search table $del_table = "drop table search"; #mysql_query($del_table) or die ("Error:".mysql_error()); // Create a MySQL table in the selected database #mysql_query("CREATE TABLE search( … |
| | Hi, I have three folders in my project named as apache, php and mysql. I want to update my php,apache and mysql to latest version but I do not want to reinstall all the system again. My system works in this way that we copy all the folders and install … |
| | I have two tables that I would like to work together (stories and events). Stories is a table that is used to produce articles on a website and events is a series of events put into a table. I would like to be able to add events to story based … |
 | I have a requirement to make a sales report from 1-aug-2014 to 24-aug-2014 like this: Product Name First Week Second Week Third Week a 12 6 2 b 0 0 4 c 0 3 0 My table like this. products( prod_name varchar(200), quantity int, qty_ordereddate datetime ) my sql query … |
 | Dear Friends iam facing a problem in the pagination. It was working fine in my offline wamp server when i moves it to the online it was showing Warning: mysql_real_escape_string() expects parameter 2 to be resource, integer given in /home/pps/public_html/news_and_events.php on line 10 Please help me I have gone through …  |
| | Hi all i need to update some iframe values in my videos table, embed column. Can I achieve this with this kind code below ? I tried already but i got syntax errors. Please help me. here is the code type of column embed is text. UPDATE videos SET embed … |
| | Good afternoon, I'm drawing a complete blank on this, and decided someone in here could answer the question for me without an issue. I have a mysql DB with thousands of records in it, and over time have used an inadequate system for maintaining terminated records. I've been simply prepending … |
| | Hello guys. I already install the mysql conector and my for studio 1.2 nu t in th visual studio 2012 i cant conetor to database. I try three time reinstall but is the same thing. Someona knows or somenoa already have this problem.«?  |
| | Hello, I have my database xampp mysql and i put values from visual studio 2012. I have the code for INSERT INTO mytable, but always i insert the value, this value appears like 0. I dont know the reason beacause if i'm conected to the database and i send the … |
| | I manage to display data using below query that will show value for each month. How to calculate average value starting july onwards(based on user selection). Let say the value for element 'A' are Jul=66, Aug= 65, Sep=87. If user select Aug then the average is 65.5 and if user …  |
| | Can you help me with this program?. I am trying to insert data into two mysql tables at once. I have two tables: property and personal. <?php define('DB_NAME', 'purchase'); define('DB_USER', 'root'); define('DB_PASSWORD', 'root'); define('DB_HOST', 'localhost'); $connection = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$connection) { die('Could not connect: ' . mysql_error()); } … |
 | Hello Anyone, I am new with PHP, I have nearly no experience. I need to update PHP though. I have no idea how to. I have PHP version 5.2.0 and need to update to a newer version. The web server it's used for is also using MySQL and IIS. If …  |
 | Hello everyone. I have 4 tables whose Structures are provided with my question as snapshots Table 1--> Students Table 2--> Courses Table 3--> Student_Courses Table 4--> Users I want 3 columns in the output which are. 1- Course 2- Classes Attempt 3- Classes Missed Now : --Only those courses should … |
 | Hello iwant a script in php i describe my problem below > i checked all the checkbox and updated after updating i am getting values from enable field but when i checked randomly i am not getting updating i am getting different values to be checked Here's the code /* … |
 | Hey guys. I'm writing myself an online toolbox (for my code snippets). I have a "Snippets" table. My question is this. Would you save the snippet source in a Text column or would you have the snippet saved to a text file and the Snippet entry would reference the file … |
| | Hi.. I'm getting error in my query.. while using it in oracle it is working.. But when using it in mysql it is not working.. i'm getting error as insert into ProjectHealthReportAudit(clientid, projectid, month, year, phasesId,ACTIVITIESSUBTYPEID, ACTIVITIESARTIFACTSID,processConformance,comments, pcinumber, pciscore, colour, createddate,createdby) values ( (select clientid from client where clientName = … |
| | i want to print the bill to printer from php mysql database? is it possible? help me please!!!!! |
 | `Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\administrator\admin\schedule.php on line 187` admin/schedule.php //LOAD CLASS LIST $sqlstr = "SELECT * FROM class_list INNER JOIN `group` ON class_list.group_id = `group`.group_id INNER JOIN teacher ON class_list.teach_id = teacher.teach_id INNER JOIN class ON class_list.class_id = class.class_id WHERE datetime > '".date('Y-m-d …  |
| | Hello buddies! I'm new at Java SE Porgramming with PHP background. I've made a simple app which uses JSON to save some data and I would like to use MySQL database but there was some question for me. 1. If I used MySQL or any database, how much would my …  |
| |  In the above model I have an Images table which holds all the filenames relevant to the image. I have two relationship tables (Image_Has_People and Image_Has_Event). Both of these tables have an FK ImageID linked to the Image table's PK idImage. I'm wondering, if I set both relationship … |
The End.