62 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for RC_820

hii how can i make self join and sum data in other table by username i have table like this members (id, username, referral) ref_bonus (id, username, bonus) members id | username | referral ---------------------- 1 id1 id2 2 id2 null 3 id3 id2 ref_bonus id | username | bonus …

Member Avatar for pritaeas
0
96
Member Avatar for steven.rose.94

Good Day:) I'm trying to figure out how to remove the % sign that is returned from scraping Yahoo Finance **without** removing the decimal point (or a possible negative sign in front of number returned as netProfit). My goal is to convert the string without the % sign a float …

Member Avatar for Slavi
0
2K
Member Avatar for ehpratah

Hi need some insight on how to show record from different database on the same server. i also tried using join but didnt get the correct output. im finding a way to make it work using just one query. my last resort will be using different query to select the …

Member Avatar for ehpratah
0
335
Member Avatar for Lethugs

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Member Avatar for Dani
0
365
Member Avatar for david.roun.7_1

Hi all. I have this code: <html> <title> </title> <head> <script> function add(){ var first=document.getElementById("form").value; var second=[first]; for (i=0;i<second.length;i++){ var third=second.join("+"); } document.one.answer.value=third; } </script> </head> <body> <input type="text" id="form" onChange="add()"/> <form name="one"> <input type="text" name="answer"/> </form> </body> </html> What I want to do is allow the user to enter …

Member Avatar for david.roun.7_1
0
193
Member Avatar for Fernando_4

Hi all, I've made a query that gathers info from several tables, after it was working, there was the need to integrate yet another table, however I can't seem to put it to work. I've seen some of this "witchcraft" before, but can't seem to find a tutorial, basically because …

Member Avatar for Fernando_4
0
466
Member Avatar for Gobble45

Hi All, Firstly I will say that this exercise is for my learning experiences through an online course. However I have spent a combined total of about 6 hours working on this question and I am completely stumped on how to get the correct answers. The question: > List the …

Member Avatar for rajkumar007
0
265
Member Avatar for Gobble45

Hi there, I have 3 tables to extract data from. My query thus far is: SELECT `ministry`.`pm_name` AS 'Name', DATE_FORMAT(`ministry`.`min_begin`, '%Y') AS 'Election Year', `ministry`.`party` AS 'Party Led', `deputy_name` AS 'Deputy PM', COUNT(DISTINCT `ministry`.`min_begin`) AS 'Times Elected PM', `GG_name` as 'GG Name', `gg_title` as 'GG Title' FROM `ministry` JOIN `deputy_pm` …

Member Avatar for Gobble45
0
287
Member Avatar for sagisgirl

Hi, I'm confused right now about mysql statement I have four tables : form1 | form2 | form3 | form4 | ----------------------------------------------------- k8regNo | form2_ID| k9regNo | form4_ID | consignee | goods | out_date| k9regNo | moveDt | k8regNo | | form2_ID | can i join this four tables..?

Member Avatar for sagisgirl
0
461
Member Avatar for developer707

Hello, I have two tables one for the company staff and one for their projects(table name objecte). The table objekte has 4 colums that are connected with the id of the staff. The problem is that I want a query that shows all staff's names. I have also included the …

Member Avatar for 1stDAN
0
253
Member Avatar for PriteshP23

I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i …

Member Avatar for PriteshP23
0
1K
Member Avatar for Marie22

I have a problem that I've racked my brain with for two weeks without success. I have a table named 'user_answers' containing columns 'user_answer_id' and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count the number of rows where user A and user B match answer_id. SELECT COUNT (*) …

Member Avatar for Marie22
0
657
Member Avatar for eburlea

Hi. I am using Zend Framework Models. I have 2 tables: 'results' and 'resources'. Table 'results' has the columns: 'results_id', 'resource_id_team1', 'resource_id_team2', 'match_result'. Table 'resources' has the columns: 'resource_id', 'resource_name'. I want to retrieve the results from the table 'results' and I want to join 2 times the table 'resources', …

Member Avatar for eburlea
0
966
Member Avatar for savedlema

Hi all! I don't know if that was a good title, but; I have this query (I will call it query1): "SELECT InvID, quantity FROM Recipe WHERE MenuID = 1" In my tables, this will give me something like Water(20), Oil(30) Now, from this result of a SELECT query1 (i.e …

Member Avatar for savedlema
0
319
Member Avatar for klemme

Hi all, I have a very simple question, for many of you.. I need to write out a select list like this : From table pages, I need id and link to fill up the options in my select list. But I need to tjeck in another table, if there …

Member Avatar for klemme
0
168
Member Avatar for marifard

Hi, I made a page to show the information of the applications I apply and the interviews I made for selected applications and I use the inner join and left join to display data from different tables. This week I add another table to enter in it the comments. I …

Member Avatar for pritaeas
0
349
Member Avatar for joseph.lyons.754

Hey guys, I was wondering if you could tell me if this is even possible or if it can be done another way??? So i have a database with 6 tables all the databases have the same columns except for the tables name ahead of the generic headers pub_name, Hotel_name, …

Member Avatar for Webville312
0
210
Member Avatar for anjerodesu

Hi everyone, I would like to ask a question about MySQL. Say, I have a database like this: database 1: articles |- id |- title |- description database 2: tags |- id |- articleID |- tag I needed to search from articles.description and tags.tag and while doing so, the searched …

Member Avatar for anjerodesu
0
316
Member Avatar for khushhappy

Sir, having a problem. I have two tables i.e directives and para_comments_sect. there is no direct connection with each other . what i want is to get the data field from directives and para_comments_sect of para_id=15 ( its a foreign key from para table). any suggestions and guidance for it …

Member Avatar for adam_k
0
162
Member Avatar for thendrluca

hi all! :) well i wrote a sample code to test threads and i don't get what i want the problem is that the thread i created is starting directly after i create it? but he must start when my j is equal to 25 and then i joining the …

Member Avatar for thendrluca
0
172
Member Avatar for Lethugs

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Styl T10 1 1 Repair 1 2 Monitor 2 MPS 1 2 Repair 3 3 ImpSonic 2 I need to count how many printers, Monitors etc. are …

Member Avatar for Lethugs
0
308
Member Avatar for code739

Hi guys, im kind of curious, is there a query or some way to fuse two colums like `select a.col1,b.col1 from table1 a left join table2 b on a.id=b.table_a_id` then as a result i want to display only one column containing a.col1,b.col1 thanks =)

Member Avatar for code739
0
289
Member Avatar for Lethugs

Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …

Member Avatar for john.knapp
0
184
Member Avatar for Lethugs

Hi, I have 3 tables Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are in Item and …

Member Avatar for darkagn
0
303
Member Avatar for mhaselip

hi, im trying to write a mysql query to join tables. I basically i have the following tables: tblwinners = table that shows all the winners PK reward_id customer_id tbluser = table that holds all the user accounts PK customer_id tblcompleterewards = completed rewards PK reward_id tblrewards = holds a …

Member Avatar for mhaselip
0
218
Member Avatar for garyjohnson

I am trying to join two database tables, the tables are set up like this, This is table fgusers3, which stores my users login information. id_user name email phone_number username password confirmcode 1 Bob bob@email 000000 bob1 bobby 12345 This is table videos, which stores my users video upload information. …

Member Avatar for garyjohnson
0
235
Member Avatar for poojavb

Hello Friends, I have three table ->PatientDetails ->ParentDetails ->InsuranceDetails -Patient id is the common column in all the three tables... While saving the data in table using VB.Net there is a column in PatientDetails i.e. Insured If the patient is insured then only the values from text boxes and the …

Member Avatar for poojavb
0
325
Member Avatar for baig772

Hi all I have following table structure [CODE] pk_cat_id(int) cat_name(varchar) cat_desc(text) fk_cat_id(int) [/CODE] table is self related as one to many i want to select cat_name, cat_desc and parent_cat_name() i.e. from fk_cat_id, how i can get cat_name

Member Avatar for baig772
0
106
Member Avatar for Biiim

Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data …

Member Avatar for smantscheff
0
285
Member Avatar for pwolf

The exercise says the following: """ Pairwise comparision of DNA sequences is a popular technique used in Bioinformatics. It usually involves some scoring scheme to express the degree of similarity. Write a function that compares two DNA sequences based on the following scoring scheme: +1 for a match, +3 for …

Member Avatar for TrustyTony
0
1K

The End.