7,368 Topics
| |
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 … | |
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 - … | |
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 … | |
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) … | |
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 … | |
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. … | |
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); … | |
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 ... | |
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 … | |
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 … | |
Can anyone please help I'm having an index error with my php code. When I run the code I get the errors Notice: Undefined index: name in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 9 Notice: Undefined index: surname in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 10 Notice: Undefined index: contact_number in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on … | |
I have a silly issue, I am creating a CMS at the moment. it has pages and menus . I created a page to add new pages. on that page i have a drop down list that is populated with data from the menu. I also have an edit page, … | |
Hi, I'm sorry if I had post duplicate post. I had join this 2 table (dt_dict_tbl - store dictionary, sdn5_5 - store accumulate value for reporting). Here the table structure **dt_dict_tbl** CREATE TABLE `dt_dict_tbl` ( `dtDictCode` VARCHAR (30), `dtDictDesc` VARCHAR (600), `rptCode` VARCHAR (30), `rptSubCode` VARCHAR (30), `dtCreatedDate` TIMESTAMP , … | |
Hi, Need Help regarding a query. I want to search all empName from emp table whose name 3rd letter is "s" | |
Hello, I am working on a query for a dog agility venue where it's calculating award requirements. There are two columns that are identifiers, one is the RegNum which is the dogs identification number, and the other is Class_Subset, which identifies which class the points were earned under. And then … | |
The End.