[mysql] Forum Topics

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 …

Hi guys/gals! I've read through a lot, great site but I'm stuck and have started pulling out teeth:( I would like to selectively display markers (that change everyday) on a Google map, using a a couple of checkboxes (areacode)and a selection list (prices). [CODE] <!--Based off of code from: http://tips4php.net/2010/10/use-php-mysql-and-google-map-api-v3-for-displaying-data-on-map/--> …

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 …

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!

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 …

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

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

I'd like to make standalone desktop application which is connected to mysql. i mean my app will be used in different network rather than mysql DB . DB will be set up in other network. Is it possible to build this kind of application? If so, how can i implement …