11,093 Topics
 | |
| | I am attempting to update the value of one field within a table, by doing a select of the value of another field within the same table in a single UPDATE statement. Is it possible? And if so, could you tell me what is wrong with the syntax of my … |
| | [B][COLOR="Green"]Hello Guys I have learned c++ and some of java and I wish if anyone can help in starting the database design and how can connect it to a program , I mean by giving me some useful books and programs in which I will program in(MYSQL and ORACLE ) … |
| | Hi, I require some help in making the following possible with mySQL. My [simplified] database layout is as follows UserID Timestamp League Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Fields 1-6 values are either "yes" or "no" Basically a user submits a form selecting the … |
| | Hi Guys! I'm currently trying to refresh a DIV on my page that is linked to MYSQL (changes if database has 1 or more rows) without refreshing the entire page, I've tried using javascript although it didn't seem to work and so Im back to the drawing board, Im not … |
| | hi guys... i can connect now to the mysql database and is able to display the database names (because i have 3 databases) in a combo box.. i was stuck up in displaying tables from mysql in a listview.. please help me solve this.. here are my codes: [code] Public … |
 | Hi, I have started a new app in my current Django project and I want to make the new app use its own database. I have found this solution on the web: [URL="http://www.eflorenzano.com/blog/post/easy-multi-database-support-django/"]Django Multi-Database support[/URL] but it seems more like a hack than a supported solution. Do you think this … |
| | Hi, I have 2 tables i am querying. The first table has 2 columns, one for folder ID and the other for Category ID. I want to query that table to get a loop of all the folder ID's based on the category ID chosen. Then i query the second … |
| | Hello everyone! I need to be able to check if a "username" exists in one table in the database, and if not then create a row with that "username" and various other bits and bobs. I have it so I can input a username into a database but when I … |
| | Hi ALL, When i run this query it's take too much time to execute. SELECT ptnt.*,ptntF.familyName FROM -> (SELECT ptntPatientDetails.*,ptntPatientDetailsLang.occupation,ptntPatientDetailsLang.notes,pracStatusMasterLang.statusDesc, -> IFNULL((select countryName from genCountry where ice_global.genCountry.countryID = ptntPatientDetails.country),'') as countryName, -> IFNULL((select stateName from genState where ice_global.genState.stateID = ptntPatientDetails.state),'') as stateName -> FROM ptntPatientDetails,ptntPatientDetailsLang,pracStatusMasterLang -> WHERE ptntPatientDetails.patientID = ptntPatientDetailsLang.ptntPatientID … |
| | I'm having some problems with the UPDATE statement in VB.NET. Not the UPDATE statement directly, but when it comes to incrementing a field's value by 1. Below is the code that I'm using for writing to the database, as well as the two UPDATE SQL statements that I've tried. Any … |
| | hi, i need to do a query which joins multiple tables but i need to join the same 2 tables multiple times. is that possible? [CODE]SELECT timeline.TimelineID, timeline.SIPPorCASH, timeline.clients_ClientID, timeline.UserID, timeline.IFAID, timeline.RegionalSalesManager, timeline.AreaSalesManager, timeline.AgencyTradingAgreementSigned, timeline.DateOfClientMeeting, timeline.EstimatedPensionFundAmount, timeline.DateAuthorityMandateSentToIFA, timeline.DetailsOfPensionFunds, timeline.ProductID, timeline.PropertyRef, timeline.NPW, timeline.CaseComplete, clients.ClientID, clients.App1FirstName, clients.App1LastName, clients.App2FirstName, clients.App2LastName, users.UserID, users.FullName FROM … |
| | Dear all. I need help regarding on my error.. this is the sample code: [CODE] Private Sub GetDetails(ByVal id As String) Dim conString As String = (ConfigurationManager.ConnectionStrings.Item("ItemListing").ToString) Dim objConnection As New MySqlConnection(conString) objConnection.Open() Dim sdr As MySqlDataReader Dim sSQL As String = " SELECT i.SuppCode,s.SuppName,s.telno,s.Faxno,s.email,s.Salesman,s.Mobileno,s.add1," & _ " i.masterefno, i.invoicerefno,a.remarks, … |
| | Hi there I'm having trouble a with a forum query here are my 3 tables [B]categories[/B] [U]category_id[/U] category_name category_description [B]threads[/B] [U]thread_id[/U] [I]category_id[/I] thread_title thread_text [B]posts[/B] [U]post_id[/U] [I]thread_id[/I] post_text I want a query that selects all of the top level categories and displays them however in that query I am aware … |
| | Do you need to to install php, mysql, apache, and more on your computer? <URL SNIPPED> |
| | Good day! I'm a newbie in java and I'm using Netbeans 6.9.1 as my IDE. I want to connect the system that I'm developing to the MySQL 5.0 database in the WAMP installed in my computer. I already configured my MySQL by following several steps I found in netbeans.org tutorial. … |
| | hello, I need to display contents with their tags, and in same page all the tags of the page contents the problem is having a limit on contents doesn't work if join tags on them (the number of tags change the number of select contents) [B]THE TABLES ========== [/B] I … |
 | Hey everyone. I have a mysql project that requires only some basic queries except one. Nothing more challenging than some really basic select/insert statements. No problem there. But the one complex one isn't working out. I typically work a little with SQL server and wrote the following at work in … |
| | Can we call a single trigger for multiple tables.... say I have two identical tables a and b. now we have a trigger that is needed to be called by each table. It is possible in POSTGRESQL using Triggers function.... these functions allow to call a single trigger function from … |
| | Hello all. I created a C program that used MySQL in Linux and now I'm transferring the program to Windows. I would like to ask what software do I need to download/install in Windows to be able to compile and run the program there? Also, when the program is already … |
| | Hi guys, I'm doing a web app that will be available in various countries and I need it to be quick enough. That's why I'm wondering if keeping a separate database for each country would be faster than using a common database and filtering the results by country? |
| | I’m trying to pull athleteid, firstname, lastname, rushyards, teamname …while athletes.athleteid = ‘200’ My main goal besides getting this data out is that some athletes may move teams. So like atheleteid = ‘200’ may be on team 10 during weeks 1-4 but on team 15 for weeks 5-16. I’m trying … |
| | Hi, this is what i've got so far: [CODE]$sql = "SELECT * FROM ".$_SESSION[dbprefix]."users, user_skills WHERE user_skills.userid=users.id AND ((users.username LIKE '%" . $queryString . "%') OR (users.email LIKE '%" . $queryString . "%') OR (users.firstname LIKE '%" .$queryString . "%') OR (users.lastname LIKE '%" . $queryString . "%') OR (user_skills.skill … |
| | I'm wondering if it is possible to skip certain fields in the mysql table in a sql statement. Here is what I mean: I have a table that has the following columns: firstname lastname phone dob Suppose I write the following statement: $[CODE]mysql_query=("insert db_table (firstname, lastname, phone) VALUES ('$firstname' ,'$lastname', … |
| | Hi, I am trying to use AJAX to do a simple thing of displaying the results in the same page. Clicking on the <a href tag should display the results in the same page. This is working correctly in IE but the onclick() function is not working in firefox and …  |
| | is it possible to create an index using substr ? say for example i have a field called num which has char(8) as its datatype and length. an example of num's value would be something like 09092010 now what i want is to create an index using the last 4 … |
| | Hi! Could someone tell me please how to configure MySQL DB for storing both latin and cyrillic data sets in the same table? Thanks! |
| | Hi, I'm getting the error Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in C:\wamp\www\******\include\Database.php on line 294 when I try to run this [CODE]function calcNumActiveUsers() { $query = "SELECT * FROM ".TBL_ACTIVE_USERS; $result = $this->query($query); //just uses mysql_query var_dump($result); $this->num_active_users = mysql_numrows($result); }[/CODE] As far as I … |
| | [CODE] #include <Windows.h> #include <iostream> #include <mysql.h> using namespace std; int main() { MYSQL *conn; char names; names= mysql_query(conn,"select * from names"); return 0; } [/CODE] error: Error 1 error C2440: '=' : cannot convert from 'int' to 'char *' i want to set a varuable for the query so …  |
| | Hi! I have a Java application that works with MySQL DB. Until today I used latin alphabet, but now I would like to extend my application to working with cyrillic alphabet. As far as I know, it is possible to use UTF-8. But I don't know the way, in which … |
| | Hello: Here is an interesting question. I have a client payment recording form which retrieves data from a table that has clients balances and other. My task with this form is to take payments (which can be payments in full or partial payments). I need to be able to update … |
 | Ok, I am trying to access my table via php. I have a successful connection to the server and a successful selection of the right database on the server. But I keep getting this error message when I try to run my query line through the mysql_fetch_array() finction: Warning: mysql_fetch_array(): … |
| | Hi, I'm new to mySQL and I've got to run a bunch of queries on a database that I've been designing for a hypothetical record company. If anyone could check my queries, I would appreciate it greatly as they don't seem to be returning the correct results and I'm not … |
| | Good Evening: I am making a transition from ColdFusion to PHP, and I am curious about a code situation I encountered. I am playing around with adding two drop-downs with two different fields from the same query. Wish CFML, it is [CODE=coldfusion] <cfquery name="queryName"> SELECT * FROM food </cfquery> Please …  |
| | Users, I have a slight problem, because I have little experience and wisdom in the art of PHP I need someone to help me who does have knowledge of such. My problem is this: I am wanting to create another website, however, the website I want to create needs to … |
| | I am starting a new website.I want a best Login Logout Php mysql script with for get password fearutes.Where i can get it. Please help me |
| | Hi, I'm kinda new to using MySQL,I just downloaded sqlite3 for my Linux. Can anyone give me some links to tutorials/sample codes that use MySQL and C as a programming language? Thank you |
| | Hi, Can anyone tell me if two databases of the same schema were to be merged what potential problems would arise? Thanks Shephard |
| | Hi Guys, I'm having an issue with my sum() function on my queries. My DB has 3 tables 1. plans 2. handset 3. matrix [B][U]plans;[/U][/B] - planNum - planCode - planName - planLength - simRebate - commission [B][U]handset;[/U][/B] - handset - RRP [B][U]matrix;[/U][/B] - planNum - handset - subsidy The … |
| | This trigger is making me nuts! I've written about a dozen triggers before but nothing where I have ever pulled data from another table. What this is supposed to do is make sure that any inserted rows have a latitude/longitude (lat/lon) value. The users table has the lat/lon and these … |
| | I successfully configured MYSQL with VS2008, i executed the following code, and no errors were thrown. [CODE] #include <mysql.h> #include "stdafx.h" void main() { }[/CODE] Now i need to write a C++ code to retrieve some values from a Database, therefore i used the following code; [CODE] #include <mysql.h> #include … |
| | I'm having problems creating the following trigger as I keep getting the syntax error listed below the sql code and well, that error is about as clear as mud! LOL Two things to note: users is a valid table name and it does contain fields called lat & lon (latitude … |
| | Ii have been working on a shopping cart, the way my cart works is that for each item in a users cart the data is stored in a database. So if the users has a hat and a glove there are 2 rows in my table, the rows are joined …  |
| | Hi i'd like to know how to store dynamic string into MySQL database from c#.net desktop application. I was able to store only fixed data . Help me pls as i 'm new in database . thanks |
| | Table name: upload [B][U]Id[/U][/B] [U][B] Name[/B][/U] [U][B]Email[/B][/U] [U][B]File[/B][/U] 153 Jegan [email]jeg@yahoo.com[/email] id.doc 154 Alex [email]Alx@gmail.com[/email] de.doc Consider the above table, I want to delete the [email]Alx@gmail.com[/email] in 154. Plz give the idea. |
| | Hi, I am designing a new db for my website. It is a database of events with the following tables. Events Category Owners Countries Regions Subregions I am left with the following dilemma, I use foreign keys to ensure fast links between the table Events and other tables (category, countries,...) … |
 | Hey, I have a problem in my database. I have these two tables: [CODE] Table "File": +----------+--------------+-----+----------------+ | Field | Type | Key | Extra | +----------+--------------+-----+----------------+ | idFile | int(11) | PRI | auto_increment | | path | varchar(255) | | | +----------+--------------+-----+----------------+ Table "Media": +----------+--------------+-----+----------------+ | Field | … |
| | hello guys i hav db as to store firstname,lastname,email,addr,city. if i select any id i want that particular row and also at that same page i click next button next row want to preview. please help for this by send code as possible soon  |
| | I have a search where I want to be able to search a string of words. The search is going to be looking in 2 different table joined by a left outer join. The tables are "quotes" and "categories". <?php $sql="SELECT q.id, q.username, q.quote, q.by, q.voteup, q.votedown, q.servtime, c.label FROM … |
| | I have an update statement which should update a product using information the user has submitted from a form The error being that nothing gets updated, the sql code does nothing, and changes nothing in the database Can anyone see an error in the code? [CODE] $user_id = ($_SESSION['user_id']); $product_id … |
| | I'm sure this is stupidly simple, but I havent been able to figure it out with lots of Google searching and pouring through tutorials. I'm building a simple computer trade-in value calculator PHP app. Using a form to select the type of computer and the various specs, I need it … |
The End.