10,939 Topics
| |
Hi, I just encountered a problem with mysql connection. I don't know the main reason why it happened. But what I was just trying to do is copy the database from my laptop and transfer it to a desktop computer, when I tried running the webpage that I was developing … | |
i need help with a project im working on. im writing a task manager for school, and lets say i have a section for the due-date. How would i write a calendar that pops up like in Google tasks or phpmyadmin when you go to insert a date. thank you. | |
I currently have two queries that separately show goals scored and appearances made by players in a football team but need to bring them together in one query so I can aggregate results against each other, as well as output records from both in one html table. The two queries … | |
Hi to all, Problem Statement: [INDENT]I have 4 nodes which are executing in parallel, each node is processing some information and storing records in MySQL DB, the possible records being saved in an db daily is above thousand, but i want only 100 samples to be stored in db daily, … | |
Earlier today I created simple database (user and login fields), login, and registration PHPs. Now I need help going about the following enhancement: In a nutshell: I am trying to create a registration form like facebook's with php code (and link it a mysql database)... 1.) My updated registration.php has … | |
hi ppl, i am having issue updating the table with details from edited form, and it turns out to be foreign key constraint issue. the error i am getting is, ================================ Cannot add or update a child row: a foreign key constraint fails (`****`.`purchase_order_detail`, CONSTRAINT `purchase_order_detail_component_item_id_component_item_id` FOREIGN KEY (`component_item_id`) REFERENCES … | |
Hello all. First time post. A little background before I ask my very first NEWBIE question. Have committed myself to the design of a business software solution for an existing client. For approx 10 years, they have been using a custom MS Access database to keep track of their magazine … | |
Hi everyone. In my application i would like to have some kind of custom fields, which can be defined by administrator. For example, we have two types of goods: food and toys. Those two types has common fields, e.g. name, price, amount. I'm planning that administrator can create custom fields … | |
I'm very stressed out right now and cant seem to fix the problem with this php/mysqli script. I will pay $10 through paypal to anyone who duplicates my code, (and its fixed) as a reply to this thread. My deadline is very close, and I need it within a day. … | |
Hi, i facing a problem with update data in database... i had create 3 files [CODE] //list_records.php <?php $host="localhost"; // Host name $username=""; // Mysql username $password=""; // Mysql password $db_name="test"; // Database name $tbl_name="test_mysql"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); … | |
Hello, I'm creating a project in C# that requires me to use access a remote MYSQL server.. I have an online hosting account, that is hosting the database HOWEVER, i don't know how to access it.. In the 'Remote MYSQL' part of the site it just has this: 192.168.1.% So … | |
Hi, I have a table with 2 laksh records. If i use rand() in mysql query it takes approximately 1.5 seconds to run So i use mt_rand(1, 200000) It returns most of the times results in 1,000,00s The query is like this. $query = "SELECT * FROM tbl WHERE Length(word) … | |
Hi I have not installed mysql on my own, its the default one that is coming with fedora14 at /usr/local/mysql I am giving you some screenshots, please check if you can find out something. ********************************************************************************************************************************************************* The first issue is while I login using command mysql -u root -p it asks … | |
Hey, I have a problem.. I'm working on my final project and wanting to do some database intigration, now I have chosen MYSQL to do it in, however, when I try and create a database (locally) it won't let me connect.. This is annoying! So, is there any way that … | |
how do i find the foreign key and primary key constraints of a particular table through a sql query? | |
Hello, I am trying to connect to a database "database1" using C#, however, everytime that I try to connect I get this error: [I]Unable to connect to any of the specified MySQL hosts.[/I] This is the code that I am using to connect to database1 [code] string connString = "Data … | |
Hey Guys, I know there has to be a way to automatically delete a row in a MySQL table on a specified date. I am just brain dead today :icon_confused: Let's just say I have CMS that I input posts and want one of the fields in the table to … | |
Hi, today for the first time I get this error Lock wait timeout exceeded; try restarting transaction when using sentence [CODE] UPDATE info_psl SET eil_nr = eil_nr + 1 WHERE eil_nr >= 4 [/CODE] The table is such [CODE] CREATE TABLE IF NOT EXISTS `info_psl` ( `psl_id` int(11) NOT NULL … | |
Hi Everyone, As i wannna to be my Primary Key Em_Id auto increment in MySql but it should be a varchar datatype....as i want my id like em001,em002....something like this.... So can any body help.... Thanks, Ashish | |
| Hi, I would like to know if there is a way to sort data in a table, not when selecting it, but the actual data in the table. I would like to sort it by 2 columns though. For example the "topic" should go from A-Z and then inside all … |
i am currently working on a survey project and the answer should be something like that Poor,Average,Good,Very Good,Excellent and their value will be 1 2 3 4 5. but i can't bind them into my database, the questions show using datalist, and i got no idea how to fix this.. … | |
Hi Guyz, i just wanna know how to fix my problem, or rather fix my code and simply my code base on my MODULE. heres the error " You have an error in your SQL syntax; check the manual that corresponds to your mysql server version for the right syntax … | |
Ok, I'm really really stuck with this. I've tried everything to my knowledge to fix it, but I just can't. So please, can anyone here help me with this error: [CODE]Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'host-ip' (4) in /home/ashley/public_html/pw/inc/config.php on line 7[/CODE] This is my PHP: … | |
hi, i have a site which i want to generate a weekly report of activity from. the monthly report should be fine as i could set the query to format the date into month and where "date" is NOW() however how can i generate a weekly report in mysql? any … | |
Hi, I am using a prototype PayPal payment system which does not ever need to properly work, but I am having trouble writing to the database as well as redirecting to the PayPal payment page at the same time. Here is the form: [code=php] echo '<form name="purchase" target="_blank" action="https://www.paypal.com/cgi-bin/webscr" method="post">'; … | |
I am trying to write or find scripts that will: 1- create a script that will allow someone to Unsubscribe to a mailing list based on email address. 2- export data to a predefined excel file which will be used to print mail labels. I have looked and looked and … | |
Hello I asked a similar question a few posts before but not the same, so I started this thread. I am trying to add a user to MySql which I installed via XAMPP. I found this command: [CODE]CREATE USER 'root'@'localhost' IDENTIFIED BY 'mysqlpass';[/CODE] But I don't know where to put … | |
Hi!The code I use for getting the values from dynamic javascript form fields is not working dont know why? The problem might actually be because of form tags and submit buttons, I guess.So now I have three sets of pages using same code, #1.Working in excellent condition #2.Partially working if … | |
I needed to fetch the points for a Building at a certain level. For this, I created a Stored procedure in MySQL Workbench 5.2 CE as following: [CODE=MYSQL] CREATE DEFINER=`tribalwars`@`%` PROCEDURE `GetPoints`(IN BuildingID INT, IN BuildingLevel INT, OUT Pts INT) BEGIN Select Points INTO Pts From Points Where BID = … | |
how to get from table only one column and its downstair data? from this: [URL="http://lashatt.comoj.com/table1.JPG"]http://lashatt.comoj.com/table1.JPG[/URL] show only this: [URL="http://lashatt.comoj.com/table2.JPG"]http://lashatt.comoj.com/table2.JPG[/URL] what will be mysql code of this? |
The End.