SEARCH YOUR SOLUTION HERE  

help with a query

hello,

I'm going crazy trying to figure this out:

I have 2 tables named videos and channelsForeign key is Channel_ID where I store the id of the channel the video belongs toRelevant fields for table videos are: Video_ID, Video_PostedOn, Channel_IDRelevant fields for table channels are: Channel_ID, Channel_Name

I need to get the 3 most recent videos for each Channel_ID currently present in the videos table, ordered by Channel_Name ASC.

I would really appreciate it if someone could help me out with this. maybe r937

Posted On: Thursday 25th of October 2012 10:57:52 PM Total Views:  251
View Complete with Replies




Related Messages:

query help requested   (130 Views)
I am querying three cols of one table. I want to get results like this: Menus -> Continental Breakfast -> Full Breakfast Drinks -> White Wines -> Red Wines the query below is returning only 'menus' and 'drinks' but not the others. Code MySQL: SELECT f.business_id , f.subject , f.file FROM files f WHERE f.business_id = and f.live_from = ( select max(live_from) from files where live_from
SQL Server query help   (133 Views)
I have 2 tables as follows: ------- Table1 ------- ID HeatID1 HeatID2 HeatID3 ------- Table2 ------- HeadID HeatValue If I select * from Table1, I would get the ID and the ID for each Heat, for example (1, 3, 2, 2) Instead of that, I would like to write a query that would return (1, Hot, Warm, Warm), which is the value in the HeatValue field in Table2. I'm sure this can be done, but I'm just not seeing how and it's driving me crazy! Hopefully someone can help me out here.
Query help with distinct   (183 Views)
HI, I have a simple query Code: SELECT DISTINCT alt, galID FROM cfm_gallery LIMIT 12 Which works great, but I also want to add another field to the query photo But I don't want that field to be distinct, how do I do this
IN() query help?   (158 Views)
I have the following tables: links link_id----------link_title----------link_desc 1----------------title---------------long description 2----------------title---------------long desc 3----------------title---------------long desc 4----------------title---------------long desc 5----------------title---------------long desc 6----------------title---------------long desc 7----------------title---------------long desc links_data id-------------link_id----------link_data 1----------------3------------------data 2----------------2------------------data 2----------------7------------------data How do I get all the links (with all the fields) which are found in links_data
need help with a query   (152 Views)
The relevant cols in my table are these. |Session_ID | referer | domain_viewed | (please don't worry about the upper and lower case. this is a test/practice db and I have learned about that issue. ;o I am trying to find out the total number of unique viewers (sessions), who were refered by referer AND who visited domain_viewed My query is like this but it gives seems to give me the total number of visitors referred irrespective of session. Code mysql: SELECT count(*) from tbl_Statistics where referer = 'www.refering_domain.com' and domain_viewed = 'www.our_domain.com' group by Session_ID How can I make sure that it returns say a composite result of 4 sessions :: 650 page views (total across those sessions) bazz
Need help with creating a portable application with database.   (140 Views)
I'm planning a portable logbook for employees to replace the current unstable Filemaker Pro one but I've got a few problems from the start. I don't know which database system to use. The project has to meet specific criteria: It is a logbook that stores information in a database and which can be used to produce reports detailing each employee's activity. It must also be: 1. Portable on a flash disk. 2. Easy to set up. Unzipping into a folder and being ready to go would be ideal. 3. Possible to create a backup tool that saves backups of the database from within the application. The frequency of the backups should be controllable and restoring should be easy. 4. Be able to import and export .csv files for integration/migration to and from the existing application. I do JavaScript, PHP, mySQL and general relational database design. I did know some ASP and VB some years ago. (I'm keen on CSS too, but that's icing). Options I've considered: a. MS Access. This would be easy to use since any machine with Access could be used and I could create the database, forms and reporting tools in one package. Cons are it is unstable, dependant on Access version on the machine in question and I don't know how to program it at the moment (I can learn). Even creating linked combo-boxes is hard compared to how easy it is in JavaScript/HTML. b. Portable Apache + mySQL and PHP/Javascript pages. This looks like it has a tough learning curve for me and it doesn't look like it will be easy for the users to setup and use. c. XAMPP and PHP/Javascript pages. You still have the setup difficulties for non-techy users and you have to start and stop services. This will be too much of a headache for the users - they really need something which is double-click and go. d. Online. Users would need net access, which they don't always have. This also means that the host (me) would have responsibility for the data held on my server. The users having responsibility for their own data is far preferable. I'm stumped at the moment. Access seems the easiest option atm but the instability of it is a big problem. Even small projects I've done recently have been prone to crashes (using Access 2007). Has anyone any ideas
Trigger for Duplicate rows (Please help)   (149 Views)
Im creating an employee database for TAFE. I have an employee table with employee_id and place fields. The trigger is activated by the Before Insert event. When there's a duplication of employee_id and place the trigger generates a message. For example if a new inserted row has employee_id 20 place 6, and there is a row with employee_id 20 and place 6 already existed in the Employee table, the trigger generates a message: Duplicate Employee_id 20 Place 6. I don't want a unique constraint. The code is below: Code: CREATE TRIGGER employee_tg ON employee BEFORE INSERT ON employee FOR EACH ROW BEGIN IF NOT EXISTS (SELECT 1 FROM employee e INNER JOIN INSERTED i ON i.employee_id=e.employee_id AND i.place=e.place) INSERT INTO employee(employee_id,place) SELECT employee_id,place FROM INSERTED ELSE RAISEERROR ('Duplicate employee_id 20 Place 6) END IF; END DELIMITER; Im having syntax problem in MYSQL. What could be wrong
Changing value's, query help.   (142 Views)
I have a table i need to edit i want to replace all values of 3 to 1 within a column. eg. change blah to 3 where blah = 1 just not 100% sure on the right syntax. hopefully someone can point me in the right direction.
Need help with this query...   (137 Views)
I need to know if it's possible to have a query that will select products from the database that belong to a certain store...but if there is no product like it that belongs to that store then use the default store. Here would be the table layout: TYPE PRODUCT STORE 1 CoolProduct Walmart 1 CoolProduct default 2 CoolProduct2 default ... So if I wanted to get all the products with 'Type' of '2' that were from Walmart but if Walmart isn't found then use the 'store' called 'default' how would I do that (This part is actually used within a JOIN statement so I can't just LIMIT 1 and do an ORDER BY deal because I'm actually pulling a number of different 'types' at once...just need to use the default if it can't find a 'store' that matches.)
if else stament error please help....   (148 Views)
hi im still not very well familiar with using if else statements in Mysql can anyone help me i made a query like this Code SQL: SELECT degree_code FROM courses_code this query selects all the degree_code from the courses_code table now what i need to do is to filter it Code SQL: IF degree_code = XXXX THEN degree_code= " " END IF how can i incorporate that code from the first query i tried something like this but it didn't work Code SQL: SELECT degree_code IF degree_code=XXXX THEN SET degree_code = " " #or just put a NULL VALUE END IF FROM courses_code
help to make query work on version 5.0.51a   (209 Views)
can someone help me make this query work on version 5 it was working fine on version 4, but now it gives me the message #1054 - Unknown column 'massage_charge.patient_id' in 'on clause' SELECT massage_schedule.show , massage_schedule.new , massage_schedule.finish , massage_patients.active , massage_charge.service_date , massage_charge.amount , massage_charge.tip , massage_patients.first , massage_patients.last , massage_patients.ES , massage_patients.massages , massage_patients.date_created , massage_schedule.finish , CASE WHEN DATE_ADD(massage_therapists.hire, INTERVAL 90 DAY) > CURDATE() THEN CASE WHEN massage_schedule.finish = 60 THEN 18 WHEN massage_schedule.finish = 90 THEN 27 WHEN massage_schedule.finish = 120 THEN 36 END WHEN DATE_ADD(massage_therapists.hire, INTERVAL 180 DAY) > CURDATE() THEN CASE WHEN massage_schedule.finish = 60 THEN 19 WHEN massage_schedule.finish = 90 THEN 28 WHEN massage_schedule.finish = 120 THEN 38 END WHEN DATE_ADD(massage_therapists.hire, INTERVAL 6 MONTH) = DATE_SUB('2008-09-03',INTERVAL 6 DAY) AND massage_charge.service_date
mysql query help required   (371 Views)
In one table there are some records for a field: option=com_content&id=1&task=view option=com_content&id=10&task=view option=com_content&id=91&task=view and so on. How to write a query to get the records only when id=1
MS Access Querie or VBA Code help   (146 Views)
I have an access database table which includes the following 2 fields (vendorID and Frequency) the Frequency column contains the following records (weekly, monthly, quarterly, half yearly and yearly) what i want to do is display the vendor records in a query which are due based on there frequency critea matching the current date. for example weekly in frequency will get displayed every week monthly in frequency will get displayed every month quarterly in frequency will get displayed every 4 months i want this because i have a list of reports that get sent to me based on the frequency criteria, and it would help if i can have a querie that displays the reports i'm suppose to recieve and if not i can chase up on them. i've heard that dateDiff() could be used for this
Creating DB help   (148 Views)
Hi , I need some help for my databases. My know knowledge with SQL is not big. I want to make a database for job candidates. I've made the html form and now im working on the db. So i created a db and i need to creat one table but im not sure now to do it right. The columbs are: 0. ID 1.Name 2.Surname 3.Family Name 4. Personal ID 5. Sex 6. Job Type 7. Email 8. Phone primary key ( ID, Personal ID ). Also the ID and PerID should be unique. I've made a simple sql code but it's not right. pls have a look and tell what to do. The second thing is how the users will fill those tables with info. Code: CREATE TABLE users ( userid int unsigned not null auto_increment, name int char(20) not null, surname int char(20) not null, familyname int char(20) not null, personalid int unsigned char (10) not null, sex int char(10) not null, jobtype int char (20) not null, email , phone , );
Need help writing a query to join multiple fields   (158 Views)
I am trying to write a query for a single table where each record contains five part number fields. I've never done this type of query before and could use some help. Here is the format of the table: Code: Table Name: MyTable Fields: widget_1_partnum widget_2_partnum widget_3_partnum widget_4_partnum widget_5_partnum widget_1_description widget_2_description ... I want a query that will merge and return all distinct widget part numbers in a single result set field called partnum, independent of whether the part numbers are related to widget_a, widget_b, etc. Basically I want to lump all the widget part numbers (from all five fields) into a single group and then have it return distinct part numbers from that group in a single result variable that I can index through in PHP (let's call it "partnum"). Anyone know how to do this Here is the code I'm trying to generate with this query: Code: $result=mysql_query(""); $num_rows=mysql_num_rows($result); for ($i=0;$i
Replace help?   (240 Views)
Hi Guys, I've googled this but can't find the right answer. Say I want to replace all instances of the character & in my database for 1,000's of records. I thought it would be something like so: Code: update table set headline = replace('&','&'); Can anyone help
REPLACE help in a query   (147 Views)
Hi , I want to run a query in phpmyadmin: Code: SELECT story_id, site_id, area_covered FROM `cms_stories` WHERE area_covered = 'ascot'; Which then brings out all my data like so: But then I want to take all of these query results and replace each site_id column with 51 INSTEAD of 52. Is there a way I can do this in a query rather than editing manually
SQL query... please help   (142 Views)
I am trying to generate an sql query but am having problems getting the result in a single query. Could someone please help point me in the right direction. table is as follows: PHP Code: id url timer value 1 localhost/index.php connect 1.0 2 localhost/index.php download 1.3 3 localhost/test.php connect 0.9 4 localhost/test2.php connect 1.1 5 localhost/test2.php download 1.1 What I'm trying to do is generate a list of urls that are the quickest to connect AND download. therefore the results should not include localhost/test.php (only connected). from the data above, the generated list should be something like 1) localhost/test2.php -> 2.2 2) localhost/index.php -> 2.3 so far I've got it working with two queries PHP Code: $query="SELECTCOUNT(url)ask,urlfromtableGROUPBYurl";$result=mysql_query($query);while($row=mysql_fetch_assoc($result)){ if($row['k']==2) { $urls[]=$row['url']; }}$urls='\''.implode('\',\'',$urls).'\'';$query="SELECTurl,SUM(value)asmaxfromtableWHEREurlIN($urls)GROUPBYurlORDERBYmaxASCLIMIT10";$result=mysql_query($query);while($row=mysql_fetch_assoc($result)){ show($row); }functionshow($array){ echo''; print_r($array); echo''; } Is it possible to select the data with a single query
complex query help   (281 Views)
, I'm completely stumped. PHP Code: Table1locationid|location|lat|longTable2routeid|routename|deplocation|arrlocation So that's an abstract of my table structure. One table holds the locations (the airports), and another table (could be routes, reports), etc. locationdep and locationarr both reference back to table 1. Here's my problem... I need lat/long for both of them included into the query, so in the end: PHP Code: routeid|routename|deplocation|deplat|deplong|arrlocation|arrlat|arrlong I figure pulling them from MySQL at once beats doing 3 queries to pull one complete record - when there would be upwards of 20/30 records being pulled per page. I've tried UNION, JOIN, etc, but I can't really wrap my head around this. It's almost 2 am... need some sleep. I'm not even sure what this type of query is called, so it's tough to search for a solution.
3 table join in a php function help?   (170 Views)
Hi , I wrote this function a while ago and it works fine but now I want to make it better by moving the query out of the while loop because I think this is causing alot of mysql overhead. If you can give me some idea as to how I would do this or even just some suggestions that would be great. Also any ideas on how to better write the code in general is greatly appreciated. Well here is the code. Code PHP: function GetGalleries ($user_id) { //this gets the categories that belong to the current user $get_cats = "SELECT id, user_id, cat_name, cat_desc from cats where user_id = '$user_id'"; $cats_res = mysql_query($get_cats)or die(mysql_error()); $num_of_cats = mysql_num_rows($cats_res); while ( $category = mysql_fetch_array($cats_res) ) { $cats_id = $category['id']; $cats_name = stripslashes($category['cat_name']); //then this gets the category name and the first picture to use as the thumnail link on the page $get_cat = "SELECT cat_id, photo_id from cat_photo JOIN photos on cat_photo.photo_id = photos.id WHERE cat_id = ".$cats_id." ORDER by photos.date limit 1"; $cat_res = mysql_query($get_cat)or die(mysql_error()); $cat = mysql_fetch_array($cat_res); $pid = $cat['photo_id']; $cats[] = array( 'cat_id' => $cats_id, 'cat_name' => $cats_name, 'pid' => $pid); } //then it returns an array of the galleries return($cats); }