10,946 Topics
 | |
| | hi, i have created a web form that input data from user and insert it into the mysql database by calling stored procedures butt i am facing the following error " Exception during execution of 'p_AddUser': Invalid attempt to access a field before calling Read() ". plz help me how … |
| | hi, plz help me how can i get the return value of mysql stored function from ASP.net with c#. Currently i m using the following code for this purpose [code] string strConnect = "Data Source=" + host + ";Database=" + database + ";User ID=" + user + ";Password=" + password … |
| | The code below displays a signature on the screen previously signed on the form before. It has now displayed the image as a png. How do i go about saving the image into a mysql database field so i can recover the picture as and when i need to / … |
| | Hello, I'm new to Daniweb. I have a question. I tried too google it, without result, so I hope you guys are able to help me ;) Anyway, I created hiscores for my RuneScape Private Server. Everything works well, except the part to load a rank. [url]http://epicscape562.no-ip.org/highscore/attack.php?page=0[/url] That is the …  |
| | Hi, On my website I have a group of tables (about 40). I want visitors to be able to search all these (identical) tables at the same time. Right now I'm using MATCH and UNION to do a FULL INDEX search on all tables. The problem is that this method … |
| | I facing a problem where i cant update my mysql data with calculation and if statement i want to update my column answer column and make calculation between column one and two depending on column sign.whether to sum minus multiply or divide:S UPDATE calculation SET answer IF (sign = +) … |
| | I need to add two different fields in two separate tables, but the second sum is double what it should be. Here's what I'm using: Select A.dc,A.rc,B.acctno, ((Sum(If(B.ttc In ('X','Y','Z'), 0, B.ua))) - (Sum(If(B.ttc In ('X','Y','Z'), B.ua, 0)))) As Total_UA, (Sum(C.cub)) As Total_CUB From Table_B As B Left Join Table_C … |
| | I have a php script that echoes results from a search. Generally I have no problem getting the results in a table but for some reason I can't get these scripts to do that. I figure its a small error. I'm going to put in the code but if you … |
| | Hi to all, i created following table in SQL. =================================== create table employee(name varchar(20), dob date) =================================== But, when i ran the query, i got the massage that 'SQL can not find data type 'date''. How should i include 'date' in to table definition.  |
| | Hi :) I am writing an admin application for a website I've written. It's a basic database update/insert/delete app. I started by using the website's server, but the time it took to connect to the server (since the main JTable is populated from the db, you have to wait for … |
| | Hi Guys, Can anybody spot the error on this code? it gives me error: SQL Server Database Error: Incorrect syntax near the keyword 'inner'. 5 0 [CODE]Select e.event_number,e.start_date ,event_desc, venue_desc,s.location from events e inner join venues v on v.venue=e.venue inner join sessions s on s.event_number=e.event_number and session_type='0' (inner join contact_categories … |
| | iam doing computer engineering and currently in 3rd year and i am making a web based agricultural forecasting system using some web services for getting information about weather forecasting,location of the region etc. i have also collected the available data about my region which may be helpful for my application. … |
| | Hi to all, I created following table =================================================== create table man(id integer, name varchar(20), city varchar(20), age integer, dept integer) =================================================== I want name and maximum age of person residing in 'mumbai'. I wrote following query, but got the error like 'can not include name with max() fuction since it … |
| | hi, guys i have a problem here. i have a form which creates a new table for each new user and that user will have a monthly update of his salary now im confused how to go about this. do i need to create a new table or how to … |
| | Below is a piece of code i,ve configured with, It's giving me an Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/****/public_html/****/g.php on line 265. The information stored in the database can accessed be accessed by other pages, using the same code. but its not possible …  |
 | |
| | I currently have a linked table from two tables in one database. I would like to add information from a third table contained in another database. The code for the current table is: [CODE] <?php $con = mysql_connect("","",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("", $con); … |
| | Hello guys, i need a text box editor for users to post their own article, the article is stored to a database. I've been searching and i have not found what i need. I dont require a mega-advanced one, just so people can write an article. I hope someone can … |
| | Hi I've been all over these discussions and still cannot find the syntax that works! When I echo $co and $bus, they both print on screen as they should. But when I try to update the mysql records using the following php, the business_name field data gets erased instead of … |
| | Hi Everyone, I am having some trouble with the libmysql.dll file in Delphi 7. When I try to connect to a database with the dbexpress MySQL driver, i get the error "Unable to load libmysql.dll". I have tried the following to resolve my problem: [LIST] [*]installing different versions of MySQL …  |
| | I am trying to implement a CSS hierarchical unfolding menu on a site. The thing is, it needs to be dynamically populated from the results of a database query. I previously had the menu working but then it was ‘hard coded’ and not built on the fly. Menu description: 2 … |
| | hi, i have a client request which i am unsure how to achieve. i need to be able to search the mysql database for the closest post code to a person who enters in their post code. so for example a user types in post code nn1 1ne and the … |
| | I need to record insert statements, who did them, and when. I am adding triggers to tables and putting the freshly inserted data into a sql_log table. Everything is working well except one thing. I want dates, times, and timestamps to be surrounded by quotes. Just like they would be … |
| | Hi everyone, I have a project I'm working on where I am collecting data for a client on a form I host. They use "MailApe" (you know who I'm talking about), who aren't a very helpful group of monkeys. I need to collect the data to my db from my … |
| | PLEASE can someone help me, am trying to upload files into mysql database. fine uploadiing the file is working, but trying to download thesame file, it's working, but the download is giving me a 0byte empty data. pls if any one has a full code on how to download and … |
| | I've been creating a login system in Java. The functionality of all the programming in java has been a breeze. Though, I can't find any good comprehensive tutorials on creating a login database, which is something I have never done before. [B]Could someone please give me or link me to … |
 | Hey guys, I understand how to setup the cron job to run once a day. Now I am having trouble putting together a function to do the following: I need to delete all content (rows) automatically where the "expire_date" field is equal to or greater than todays date. Keep in … |
| | Having trouble storing dollar amounts in the thousands due to the "," that gets inserted once the number becomes 1, 000.00. Any advise? |
| | 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 … |
The End.