11,093 Topics
 | |
| | Hello, I have a problem, I'm interfacing C# with MySQL it seems to be that a lot of connections are left open even when the close() function and the dispose() functions are called. Also I've notice that the server only resists like 80 queryes at the time, then it halts …  |
| | I have a script that I am using to retrieve zip codes within a certain radius using a foreach php statement. However, with these zip codes that I am getting, I want to add a comma between each value (for example: 11111,22222,33333) to use in a SQL query using the …  |
| | I have a database that is filled with time series data points on different items. I would like to calculate the difference between values by item for the time series and then store it in a difference column. My table is as follows: id | Ticker | Date | SO … |
| | Hello, I'm trying to get mysql_num_rows from 4 tables where user id is being selected as session . My question is very simple : Is this sql is correct : ""SELECT * FROM users_tbl,events_tbl,players_tbl,sales_tbl,teachers_tbl WHERE events_tbl.user_id & players_tbl.user_id & sales_tbl.user_id & teachers_tbl.user_id = '$whois_id'"; ? user_id - The user id … |
| | I suspect there isn't a way to do this, but in case there is: Does anyone know how to pick up all the possible set values for a particular field from php? The reason I'm asking is that it means adding a new set value will not break all the … |
| | I have an online MySQL database, and I need to connect to it using Visual Basic. I have to read the values in the table and edit them. Any ideas?  |
| | hi, i am create one application and then automaticallly server machine is shut down and then it gives error like this how to solve this error Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [MySQL][ODBC 5.1 Driver]Host 'computer1' is not allowed to connect to this MySQL server how to solve … |
 | If I'm not mistaken using library that is GPLed will force your app to go GPL. Is there a way to get away with MySQL GPL licence and use it in closed source (Not necessarily commercial)? Two scenarios here: 1. libmysqlclient is linked dynamically 1. libmysqlclient is linked statically Thanks! |
| | Hi to all, I created following table --------------------------------------- crate table publisher(name varchar(20), city varchar(20)) --------------------------------------- I want to run following query. [U]'list all the positions of charcter 'a' from name.'[/U] for this, i ran following query, ---------------------------------------- select patindex('%a%', name) from publisher; --------------------------------------- But, it doesn't show proper output. When … |
| | Hi to all, i created following table ------------------------------------- create table employee(name varchar(20), dob datetime) ------------------------------------- I want to extract names of all months from 'dob'. for that i wrote following query ------------------------------------- select datepart(month, dob) -------------------------------------- it works and shows all months but in number format, i want to display … |
| | hi guys, i wanted a table to get created with the table name submitted from the form. how shall i go about this, i have tried it with my basic knowledge its here bellow but it dint work well, please help me anyone. [CODE] <?php if (isset($_POST['update'])) { mysql_connect('localhost', 'root', … |
| | hi all i have search engine like that: sql = "SELECT * FROM ads WHERE ad_country='7' and approve='1' and ad_name LIKE '%iphone%' or ad_country='7' and approve='1' and ad_content LIKE '%iphone%' ORDER BY ad_date DESC LIMIT 0,30"; and it's work great but it is too long. are there any sample way …  |
| | 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"); … |
The End.