10,939 Topics

Member Avatar for
Member Avatar for JerieLsky

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 …

Member Avatar for smantscheff
0
117
Member Avatar for tcollins412

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.

Member Avatar for diafol
0
104
Member Avatar for MargateSteve

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 …

Member Avatar for smantscheff
1
302
Member Avatar for Agent-of-Chaos

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, …

Member Avatar for smantscheff
0
146
Member Avatar for jacob.irwin

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 …

Member Avatar for jkon
0
297
Member Avatar for puvi

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 …

Member Avatar for puvi
0
158
Member Avatar for peterbata

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 …

Member Avatar for peterbata
0
380
Member Avatar for Adoshev

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 …

Member Avatar for diafol
0
357
Member Avatar for waveydaveywaves

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. …

Member Avatar for waveydaveywaves
0
443
Member Avatar for LWS

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"); …

Member Avatar for LWS
0
174
Member Avatar for Phil++

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 …

Member Avatar for pritaeas
0
84
Member Avatar for agriz

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) …

Member Avatar for smantscheff
0
104
Member Avatar for cmaheshwari16

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 …

Member Avatar for rch1231
0
273
Member Avatar for Phil++

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 …

Member Avatar for Momerath
0
72
Member Avatar for indr

how do i find the foreign key and primary key constraints of a particular table through a sql query?

Member Avatar for indr
0
92
Member Avatar for Phil++

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 …

Member Avatar for Momerath
0
83
Member Avatar for drewpark88

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 …

Member Avatar for drewpark88
0
168
Member Avatar for McLaren

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 …

Member Avatar for McLaren
0
483
Member Avatar for aksahoo17

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

Member Avatar for Gfaith31
0
376
Member Avatar for feoperro

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 …

Member Avatar for feoperro
0
192
Member Avatar for shakeit13aby

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.. …

Member Avatar for kvprajapati
0
111
Member Avatar for bestex

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 …

Member Avatar for bestex
0
142
Member Avatar for xapher19

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: …

Member Avatar for xapher19
0
573
Member Avatar for mrhankey

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 …

Member Avatar for mrhankey
0
5K
Member Avatar for AdriftUniform

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">'; …

Member Avatar for AdriftUniform
0
226
Member Avatar for Vai

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 …

Member Avatar for sumitgupta225
0
436
Member Avatar for newbiecoder

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 …

Member Avatar for pixelsoul
-1
199
Member Avatar for anita_86

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 …

Member Avatar for anita_86
0
100
Member Avatar for sid78669

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 = …

Member Avatar for smantscheff
0
191
Member Avatar for lashatt2

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?

Member Avatar for smantscheff
0
113

The End.