10,940 Topics
 | |
 | 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 |
The End.