10,946 Topics
 | |
| | am trying to export data from mysql db to excel format, but the excel file i get is damaged. i get two varibles by $_GET, and run a search, and then creates the excel file based on the results... `$p_na = $_GET['p_na']; $svreg = $_GET['svreg']; include_once("classes/PHPExcel.php"); $result = mysql_query("SELECT * …  |
 | When I run: ---`mysql> SET PASSWORD FOR 'garrett'@'localhost' = PASSWORD('abc123');` I get: ---`ERROR 1133 (42000): Can't find any matching row in the user table` Also, when I run: ---`mysql> UPDATE mysql.user SET Password=PASSWORD('abc123') WHERE User='garrett' AND Host='localhost';` I get: ---`Query OK, 0 rows affected (0.00 sec)` ---`Rows matched: 0 Changed: … |
 | |
 | 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NOT NULL, CreatedOn DATETIME NOT NULL, ModifiedOn DATETIME NOT NULL, `StartD' at line 1 CREATE TABLE `billing`.`ebUsers` ( `UserID` INT NOT NULL AUTO_INCREMENT … |
| | I'm trying to do the following: 1. get username typed into the userField 2. make a SEARCH mysql_query with the username as a variable I'm having a hard time getting past phase 2 since mysql_query takes a const char* as the query string, and I can only get username as …  |
| | drop trigger if exists update_asset; drop trigger if exists insert_asset; drop trigger if exists process_asset; delimiter | create procedure process_asset_calc ( in name varchar(50), in cost decimal(20,2), in life int(11), in whenacquired date, inout Months_Depreciated int(11), inout Accumulated_Value double(2,0), in residual_value double(2,0), inout Monthly_Depreciation double(2,0), ) BEGIN set Months_Depreciated = …  |
| | I'm working on making a user maintenance system for my class, I have created the add/delete user portion but as for the edit portion I am completely stumped. So far I have created the form but what I want to do is be able to hit find user and then … |
| | help i with inno script i am finished with the prerequisite problem of framework my only problem is that after setup my sql files will be automatically imported |
| | $query="SELECT * FROM history WHERE p_na LIKE '$p_na%' AND svreg LIKE '$svreg%' IN (SELECT * FROM history WHERE cdate BETWEEN '2013-09-12' AND '2013-12-12')"; $sql=mysql_query("$query"); am searching for data LIKE a and LIKE b that falls between to dates. I thought a sub query will be the best method, but its … |
| | I am learning JSP, and have developed a books application, which displays the book-id,title,author and price. There are seperate text box for each of the field, whenever the user fills the form and hits submit button the value must be inserted into my database. If I try to submit it … |
| | I am building a cms I want to iplement the ability to hide pages. I have a row in mysql named hidden which stores the values 1 and 0. 1 will allow the page to be shown and 0 will hide it. The defalut value is set as 1. When … |
 | Helloo, Good day Everyone, Can I anyone help me? Here is my problem. I am newbies in C# development, I am Interesting to learn, searching to google and go to youtube, download lynda tutorials it's help a lot of me. But I'm on the problem that I can't not resolve. … |
 | hi, in the mysql we can fetch data and store them into variables, like the code below: if (mysql_num_rows($userquery) != 1) { die ("that member could not be found!"); while($row = mysql_fetch_array ($userquery, MYSQL_ASSOC)){ $first_name = $row['first_name']; $last_name = $row['last_name']; $email = $row['email']; $password = $row['password']; $sex = $row['sex']; $dbusername … |
| | Hello! I am editing my website to make it more updated and have created a new couple of pages which use my Database. I created the script and the databases (and tables) and everything was working OK... until somehow the tables have got partially deleted. I say partially because if …  |
| | i want to write a function which calculates the Monthly depreciation and accumulation of an asset but i am having difficulties writing it to calculate and insert it into my datebase.I will appreciate the help private double getAccumulation(){ double Accumulation = 0; double Monthly_Depreciation; int Estimated_Useful_Life = Integer.parseInt(eul.getText()); double Cost_Of_Acquisition … |
 | Hi, I begin study shell programming. I need a basic tutorial or ebook about shell script control MySQL databases (not shell command) please hellp me!  |
 | hello all I am a beginner... I want to move a wordpress site from a local computer to live server... live server: plesk parallels I followed some tutorials and it says: you must create a new mySql database on server... ok I went to parallels plesk panel and I created … |
 | Hello Professionals out there, i am making a point-of-sales systems in java. And i have a jTable named "tbitempurchase" wherein I add the ordered items using an add button.I also have a table in mysql database named "itemSold". Now my problem goes like this, I want to insert the data …  |
| | here if user logged information is correct it should show the main page. in that mainpage right top corner i need to show the username, employee id, employee name. here i can get username correctly. but, i did not get employee id and employee name. for example : Name - …  |
| | hii, i am new to php and i wanna create a library management system with the help of php and procedure function in mysql so that i also got the security on my localmachine. bt i want to login the user with the help of access card and fetch all … |
| | I have a login scrip (downloaded from the internet) that I have adapted to my database. I However have a problem with linking from the login to a page in my system with details of the user that has logged in. The users table on which the login system is … |
| | I am writing an asset monthly depreciation system and i have written a code which works but i want to set the values such that the user enters the value manually into the system. Currently the values have been declared with a variable. this is my code // declare an … |
| | Hi, I am having an issue, any suggestions will be great. I am trying to fetch records from 3 tables on conditions to retrieve the correct data. So far it brings up 2 of the same results as there are two image file names with the same product id's in …  |
| | Hi all, I have this ajax script that accepts only one value at a time. I want to send more than one value to mysql for processing... but am not so good with javascript, pls point me in the right way....thanks // auto select vehicle # and fleet # <script> … |
| | Create Procedure `SelectProduct` (IN prod VARCHAR(70)) BEGIN SET @sql = null; SELECT GROUP_CONCAT(DISTINCT CONCAT( 'max(case when Attribute = ''',Attribute,'" Then p.Attributevalue end) as `',Attribute,'`' ) INTO @sql FROM tblAttribute; SET @sql = CONCAT('Select pr.product, ',@sql,' from tblproduct tblproduct pr LEFT JOIN tblproductattribute p using(productid) left join tblattribute a using (attributeid) … |
| | So I'm making a wishlist but am stuck at joining 2 MySQL tables together. At the moment I'm doing this by using following code: if ($stmt = $mysqli->prepare("SELECT ItemID FROM wishlist WHERE WishlistID = ?")) { $stmt->bind_param("s", $this->ID); $stmt->execute(); $stmt->bind_result($id); while ($product = $stmt->fetch()) { if ($stmt2 = $mysqli2->prepare("SELECT products.name … |
 | How I can create .mdf file from MySQL; if yes then HOW and if not then which tool do I use create .mdf from MySQL ? |
| | Please, I am trying to build a chat program in python i have built a chat client program and a server program, I want to ask someone told me that I don't need to build a server all i need to do is connect a db server directly and the … |
| | hi i am building a cms system for my website, i am able to put data into a mysql database with the following code(look below). i also have a login system for accessing the cms, everything worked so far. I am facing a problem now. Ok so user signup info …  |
| | I have a query that collects multple ID numbers and stores them into a php Array. I then want to make a mysql query for every result in the php Array. I believe I am on the right track but am getting an error saying the `join()` method has invalid … |
 | Dear all, I cant get any result set back, when issuing a simple Select statement through VB.Net and MYSql Data provider, to a Mysql table searching for some Greek string. MYSQL Ver:5.5.32 VB.Net: 2010 Do I need any special encoding for the passed string? Thanx |
| | Hi, I would like to load the data from a SOAP response XML file to a MySQL table. Sample SOAP XML would be http://data.gov.in/sites/default/files/Ashgourd_2012.xml. I have to write a program to populate the data. I'm not very familiar with Java Web Services. I've worked with Struts2 and basics of Spring. … |
| | how to bind a datagridview to a list of custom classes?? pls i need your help guys, tnx.  |
| | hello there. in order to gain experience I started a small python project. it is an more or less simple, collaborative address book (Snow Leo and Python 2.6.1). the final step is to create a standalone programm. to create the address book I used PyQt4 and MySQLdb. since py2app chokes …  |
 | I have a table (employees) like this ID Name Group Email 1 Bob Buckland Marketing b@example.com 2 George Alaz Engineering g@example.com 3 Tom Grady Marketing t@example.com 4 Mary Jane Engineering m@example.com Im going to use this in a email form. First a combobox should load all the groups possible. This … |
 | so, im editing my site and i made a blog, it worked earlier but idk why its not working now. it may be something small that im just over looking but my table of entries come up empty when i know my mysql server has 1 entry in that table. … |
| | This a question please schools grades ------- -------- havard 90% with this table, i want to select the information in each column concatenate them and ouput the results in a textfeild. sample output = havard/90% so can you declare a column in mysql as a variable in java? if yes … |
| | How to fetch the data of 6 different tables and display them in single datagrid view ? Including the image have to displayed from table and displayed into the table? |
| | Hello, First of all apologies if this has been posted before, having trouble findin the answer, Let me start by inserting the code I have having the problem with, apologies if this isn't the correct way of doing things but I am still a newbie at php <?php include('config.inc'); mysql_select_db($dbname); … |
 | Is there a way to use PHP function similar_text with MySQL databases? How should I connect the database with similar_text resulting 5 similar words or less? |
| | <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>SYNTHESIS REACTIONS</title> </head> <body> <p> Chemistry synthesis reaction equations </p> <p> </p> <form name="form1" method="post" action="index.php"> <p> <label for="A"></label> <input type="text" name="A" id="A"> + <input type="text" name="B" id="B"> <label for="B"></label> </p> <p>NB: Case Sensitive - Use Real Names!</p> <p> <input type="submit" name="solve" id="solve" … |
| | i am always finding this error. if you have an idea.please assist as soon as possible mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\validate_login.php on line 20 This is line with the problem as per text -editor(* $row = mysql_fetch_array($result);*) <?php // Grab User submitted information $email … |
| | Am using ajax to populate a drop down list, and it works fine, but i just can't find a way to make choosen.proto to work. It works on other drop-down, but not the one populated with ajax. In short, the form must allow the user to select multiple items Here … |
 | hi my problem is how i will save all the grades of student from grade 1 to grade 7 per subject or easiest approach?? can u help me ... |
| | hi frnds can u pls help me in mysql how to write commands for cgpa calculator\ |
| | Not exactly sure if my Article Title fits my question, I'm new to using SQL. so sorry if this is a nooby question I'm working on filling out a DB. I have a table called Gamer, that has a primary key named Username, in my other table Character, Username is … |
| | hi frnds i need mysql commands for cgpa calculator and need database connectivity |
 | I'm working on a School's fee management module. The client's requirement is: 1. There are 6 types of fee to be paid: * Annual Fee * Tuition Fee * Exam Fee * Games Fee * Development Fee * Other Charges 2. Only tuition fee will be paid monthly and rest …  |
| | in my project i'm using user input form. that form contains serial no, reference no, name, email, phone, address, etc.., in that user input form serial number textfield is readonly option. user can't able edit the serial number. in that textfield i want to show the next auto_increment id from … |
| | hello guys, i have created a jform which contains these field; ComboBox_decCode(description code) ComboBox_itemCode(item code) combo_Area(Branch_Area) ComboBox_dept(Branch_Code) txt_sn(Serial Number) i want to generate a serial key based on these information in my database. Description Description_Code --------------- ---------------- Lands & Building LB(001) Branch_Area Branch_Code ------------ ------------- Labone LB(001) now the idea … |
The End.