10,946 Topics
 | |
| | 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. … |
| | Hi guys.! Good day! I have a one windows xp computer which ive installed wamp(windows apache mysql) package. I want to connect to this computer using one computer on a network. The code works fine when i run the program on this server computer because i will just specify the … |
| | I would like to create a table in mysql, with one of the fields being images. Can any one tell me what type i should call the field, and also if i have to put in any special commands. thank you |
| | i had a table categories category_id parent_id industrial null automotive null petrol industrial bikes automotive diesel industrial tankers automotive ....so on ihad another table CATEGORY_PRODUCT with fields(category_id) in this table i want to insert the category_id from category table as if parent_id=null then insert category_id as parent_id if parent_id !=null … |
| | I have three tables in the mysql database. Let's say: Table: Human -> Fields: human_id (primary key), name Table: Attribute -> Fields: attribute_id (primary key), name Table: Human_Attribute -> Fields: human_id (foreign key to human table), attribute_id (foreign key to attribute table) Cardinality: Human Table to Human_Attribute Table (1 to … |
| | Hello, I'm pretty new to PHP and MySQL. I was wondering what the most efficient way to access a large database would be. All the tutorials I've seen show something along the lines of: [icode]$database = mysql_query("SELECT * FROM table");[/icode] But it seems to me that if 'table' was a …  |
| | I have a registration page that needs one final thing and I'm a little stumped... In one table I have email, pass, gender, dob and the other I have company... In the registration page, I want to check that the company exists before I submit the form... Since I'm using … |
| | Hi i had a big database and need to delete and add to it daily. About 500 rows are there in that table. I add add a check box in every row ( in the output page ) .. Something like this [ICODE]<table> <?php $select=select * from table ; while($row=mysql_fetch_array($select)){; … |
| | Hi I have the code below and I just simply want to return the results from another table ant the same time. I thought I could just add FROM member, members2 or add a join but nothing seams to work, I just get a blank page. [code] $sql = mysql_query("SELECT … |
| | Hello, I am just starting to get into mysql and have a quick question: I have a table that has a datetime field, and i simply want to store that datetime into a variable and be able to print it, and also compare it to the current date to see … |
| | Okay, I don't understand this at all. Maybe someone more polished could help me. I am trying to enter a group of numbers into the database using PHP and it works on my personal server, but then when I try it online it only takes the first number of the … |
| | Hi I had a database . I need to take one of the cell content into an array. I had code but not working [ICODE]$select=mysql_query("SELECT * from db where name='rajeesh'") or die(mysql_error()); $new=mysql_fetch_array($select); $forfriends=$new['first']; $forf=array ($forfriends); while (list ($key, $val) = each ($forfriends)) { echo "$key -> $val <br>"; }[/ICODE] …  |
| | Hi, I am currently developing a website which uses MySQL with PHP, and right now i wish to upload all files and DB to my server, but am stuck with the connection path... Server: Windows Database: MySQL Webhost C Panel: Helm Web Host Database name: hotel Can anyone provide me … |
| | I'm trying to use mysqli with Apache 2.0.63, Mysql 5.1.32, and Php 5.2.9-1 for Windows. Looking at phpinfo() I can see mysqli installed. I can also run a mysql query. However when I attempt to run a prepared statment I it fails at the if statement if($stmt->prepare($sql)) with the following … |
| | Hey Everyone, First post to the forum so go easy on me... So here's the deal... I am writing the php/mysql for a page that updates my database with the values of a member who's membership details have been edited. I am having problems getting the values to update into … |
| | hello all, Please get me a way to export all contents of a table in mysql database to a PDF file and it can be downloadable and can be printed from the website.. please provide some sample code. it is very much urgent for me. plz help  |
| | i had a table productcs with stucture as pid,name,description,applications,created_at as datetime,updated_at datetime. i will load the data from a csv file.now i want to insert the current timestamp while loading the data i.e the present time at which i am loading the data .is it possible to insert the current … |
| | Hello, The problem is I have made a second user account for my databases, every time I open the MySql monitor it doesn't prompt me for a username, it just assumes I want to log into the Root and asks for my Root password. It doesnt ask for a username … |
| | Hi everyone, I am inserting value in a table in a database through query but it is giving some error as like this :- Error: 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 … |
| | Hi, I'm not sure if this shpould be in PHP or here so apologies if I'm in the wrong place. I'm trying to encrypt a password and insert it into my database along with other data. Everything works when I remove the md5 password encryption. It doesn't work when I … |
| | Though the directories and files still appear to be there, I don't see any of my MySQL databases when using the tools I normally use. This happened after I restored yesterday's backup. Need help. |
| | I give two parameter like year & period. For example year = 2009 & period=3 Result : 22 working days in this month Plz help me. |
| | i want to insert data into third table for two tables that is first table:table struct: pid -->int,name-->string ..etc second table :cid -->int,parentid-->int....etc third table struct is:pid-->int,cid-->int now iwant to insert data into third table from the other two tables pid from first table is a prime key and pid … |
The End.