10,938 Topics
 | |
| | how to implement a java class making dynamic queries in java that access mySql tables query,insert & delete taking changing conditions & parameters every time like : SELECT field_names FROM tablename WHERE condition every time it takes different field_names , tablename and conditions  |
| | Hello, I am trying to store a single MYSQL result into a 2 dimensional array, for example I would like to end up with something like this: array[0][0] = result[0] , array[0][1] = result[1] , array[0][2] = result[2] ..... Here is my code: [code] $tempCat = array(); for ($i=0;$i<$numcat;$i++) { … |
| | i want to insert into table some dummy data so as to large my database is there any script or procedure in mysql to execute a insert statement about some thousands times |
| | |
| | Hi, I want to send a XML file to my website where the XML is read and information passed to MySQL database. I know this is done but i don't know how to do it. Something related to header etc? Any idea? Thanks |
| | Hi, I have been building a shopping cart for a website that I am building. What I am trying to do is created a purchase history so when an item is purchased it is stored in the customers purchase history (in the customers MySQL table). I have three tables Cart … |
| | attached is a screenshot of what my table already has for the URL micorosft.com. The column headings are the same as column names. Now, if I do the following statement: [CODE=MYSQL]select * from assign2 where UPPER(keyword1) LIKE '%MICROSOFT%';[/CODE] OR [CODE=MYSQL] select * from assign2 where keyword1 LIKE '%microsoft%'; [/CODE] I … |
| | Hi, I am attempting to write a query to return whether or not a particular items value entered is the lowest value and also unique. For example, if an item as 6 values against it e.g. user_id item_id value 1 101 3 2 101 3 2 101 4 3 101 … |
| | i want to insert dummy data for testing my database.so i want to execute a single insert statement 1000 times. is there any function to do so or is there any script todo. if so plz help me |
| | hi all could someone plz help me out in validating csv file(excel sheet) before i can insert it into the database?:?: i hv the code for uploading but not validating reply ASAP. cheers coder |
 | I can handle errors just fine on MySQL, but what about warnings? If I use the following code I still get to see the warning, while that is not what I want: [code=php] if(mysql_connect($host, $user, $pass)) { $conn_server = true; } else { $msg = "Fout bij verbinden naar de … |
| | Hi, I am new to PHP and Mysql development . I had installed RHEL5 Server, Apache, PHP5 and MYSQL5.1. I got below script which actually give status of the Apache, PHP and MYSQL. [code] <?php session_start(); ?> <!-- INSTRUCTIONS: 1. Please copy this file anywhere in the DocumentRoot of your …  |
| | I am using Wamp server, I reinstalled Wamp after uninstalling it to try Xaamp.I have completely removed all of the Xaamp files.Recently,I opened my phpmyadmin directory and discovered an error message which hinted to me that there were two MY SQL servers installed on my computer(please refer to [url]http://i89.servimg.com/u/f89/13/69/31/58/sql_mi10.jpg[/url] ). … |
| | Hi everyone, I am creating a student timetable. I have the table done in html and I now need to input the values in the database. I was trying to use something along the lines of [code]if(day = 'Monday' && time = '9') { echo(subject); }[/code] i keep getting an … |
| | Hi Everyone, I am facing one problem in inserting query when i am inserting value of textarea in database. Let me explain whole of this. i am working as a empoyee form in which form when we insert value of all information regarding leave of that employee . In this … |
| | HI there [QUOTE]Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`database/t1`, CONSTRAINT `t1_ibfk_1` FOREIGN KEY (`ID`) REFERENCES `t1` (`ID`))[/QUOTE] The field ID is an auto-increment field and I altered the field to a lower number and now I can't insert any …  |
| | how can we check whether the primary and foreign key are working in the database in mysql |
| | Hi, I need to retrieve the max and min values of the price field in my db. I have a item table and a category table. I am using $_GET['category'] to get the category name and then I need to retrieve the min and maxvalues only for the items in … |
| | I have a small database, at the present time, built for basic tracking and it has 5 rows ... trackid datetime uid emailaddress orgcodetrack It's populate with 10 records test data from 3 users (uid)... I need to return the total visits from each uid... Here's what I have so … |
| | hey, I am having some trouble with this one. I am doing a student web organiser.The user registers details which goes into userinfo and sem1week1. My three tables are: 1.userinfo: firstname, lastname, e-mail, username, password, coursecode, courseyear. 2.courseinfo: subject, time, day, semester, coursecode, courseyear. 3.sem1week1: username, coursecode, courseyear, day, time, …  |
| | hai i want a shell script to load data from a csv file into mysql table plz reply me soon urgent |
| | Hi Ive reached my own limit with this one... hopefully its not that tricky. I have a products table, each with a unique id. I then have a complimentary_items table which links two products as 'matches'. The complimentary items table has three columns: id, prod_id1, prod_id2. Can I write 1 … |
| | i had a table categories(cid int primekey,name varchar,description text,parent_id,created date,updated date) i want a script for insertion like this insert into categories(...) values(cid value,name value,..desc, parent_Id..); can i write the statement as insert into categories(....) values (1,'aaa','some text',[U]select parent_id from categories where parent_id=id[/U],date,date); just i wana know how can i … |
| | hi all, am still new in developing J2ME applications.I have a mobile application that needs to connect to mysql database using JSP as the middleware..can anyone please sort me out am stuck on the how to go about it.  |
| | I use MySQL-Front tool create and call Stored Procedure successfully, but in my PHP code and phpMyAdmin it fails. How can i figure out this problem when i run on phpMyAdmin the error show #1305 - PROCEDURE joomla1.5.9.save_orders does not exist this is my code of procedure [code=sql]DROP PROCEDURE `save_orders`// …  |
| | I have a query [code=language] SELECT radcheck.id, radcheck.UserName, radcheck.epost, radcheck.fylke, MAX( radacct.AcctStopTime ) AS AcctStopTime FROM radcheck LEFT JOIN radacct ON radcheck.UserName LIKE radacct.UserName WHERE AcctStopTime LIKE '%2009-03-19%' GROUP BY radcheck.id[/code] I'm looking for a way to use wilcards, > <, NOT LIKE etc on only the highest date value … |
| | i have a database and it has a column thats id its auto incrementing and one called download_link i want to have that autofill with a url thats concatinated with my id so localhost/upload/downloadtest.php?id= adds the id and becomes localhost/upload/downloadtest.php?id=1 localhost/upload/downloadtest.php?id=2 localhost/upload/downloadtest.php?id=3 etc how could i do that be done |
| | [CODE]$realUser = mysql_query("SELECT Username FROM my_db WHERE Username = $user ");[/CODE] This is not storing the $user value to $realUser. I am correctly using $_REQUEST['user'] to retrieve the value for $user from a form, and I am connected to my database. I understand there is an issue with PHP variables … |
| | i have a table holding files and each has a unique id eg. 1, 2, 3 etc. i have a column in the table i want to contan the link that should be <a href=\"localhost/upload/dltest.php?id=(number) eg. <a href=\"localhost/upload/dltest.php?id=2 i want that link to be auto created from the other information … |
| | I have two tables, question_table and answer_table. i want to be able to select a certain number of questions in a random order and have the answers that relate to the selected questions also display. IE: question_Table: ID: Question_Text 1 Who are you? Answer_Table: ID: Question_ID: Question_Answer 1 1 Me. … |
The End.