http://img293.imageshack.us/img293/857/tablez.jpg Here is a picture of the 2 tables. The mybb_users table is the table that has the users that signed up for the forum. The mybb_userfields is the table that contain custom profile field data that they are able to customize & change in their profile. Now, all I want to do is display all ...
What I wanna do is replace ALL columns in the "subject" field & that has a "0" in "replyto" with the subject ( as long as it is 0) because when replying it leaves a "RE" thing which i dont like... so i just wanna replace it with the subject matching 0 How can I accomplish this?? $result = mysql_query(" SELECT * FROM mybb_posts ...
hi, So similar questions have been asked with not much of an answer.... I have a Stats Table related to a Branch table. The Stats records contain pc stats of a particular bank branch. Branch +Code +Name +Area ... Stats +BranchCode +IP +UpSpeed +DownSpeed ... Here is my linq query... var stats = from st in store.Stats ...
check out the page [url]http://www.mujak.com/test/test3.php[/url] It pulls the users Post,username,xbc/xlk tags etc which is perfect... BUT since I am pulling information from a MyBB bulletin board system, its quite different. When replying, people are are allowed to change the "Thread Subject" by simplying replying and changing it. I ...
Hello, I am curious on the most efficient way to query exclusion on sql. E.g. There are 2 tables (tableA and tableB) which can be joined on 1 column (col1). I want to display the data of tableA for all the rows which col1 does not exist in tableB. (So, in other words, tableB contains a subset of col1 of tableA. And I want to display t...
I's like to do a join between 2 tables on a specific ID. At the moment, I have this DQL: $q = Doctrine_Query::create() ->select('e.*, i.itemName, i.itemtypeId') ->from('Model_EventItem e') ->leftJoin('Model_Item i ON e.itemId = i.itemId') ->where('e.eventitemId = ?', $event->eventId) ->orderB...
Hi I have a query as - var query=from e in DataContext.Employees join d in DataContext.Dept on e.DeptId equals d.Id join o in DataContext.OtherInfo on e.Id equals o.EmployeeId where e.EmployeeId==4 select new Employee_Dept//DTO { EmployeeName=e.Name,...
Hi all, I want to build a query using Zend_db_select and JOIN. The database is as follows: [AUTHOR table] pk: 'id' attr: 'name' [BOOK table] pk: 'id' attr: 'name' fk: 'author.id' I have author.name as a parameter. I want to retrieve all related books (only book.name, not the other columns) Please help. Thanks ...
I seem to be a bit stuck on this, but my experience in Linq is not great. Basically, I have something like this code: public class Point { public int X { get; set; } public int Y { get; set; } } public class B { public List<Point> Points { get; set; } public B(IEnumerable<int> Xs, IEnumerable<int> Ys) { // H...
I have two MySQL tables (product and price history) that I would like to join: Product Table: Id = int Name = varchar Manufacturer = varchar UPC = varchar Date_added = datetime Price_h table: Id = int Product_id = int Price = int Date = datetime I can perform a simple Left Join: SELECT Product.UPC, Product.Name, Price_h.Price, Price_...
I'm using Ruby on Rails to develop a web application. I have a wiki article system as part of my project. As part of the wiki, articles can be linked to authors, and those links also need to be tracked by the revision system. Authors is an attribute of the Article as a whole, and not related to who enters particular Revision, and is a ...
This is the query (a search query basically, based on tags):- select SUM(DISTINCT(ttagrels.id_tag in (2105,2120,2151,2026,2046) )) as key_1_total_matches, td.*, u.* from Tutors_Tag_Relations AS ttagrels Join Tutor_Details AS td ON td.id_tutor = ttagrels.id_tutor JOIN Users as u on u.id_user = td.id_user where (ttagrels.id_tag in (210...
table name: holi id country hdate (holiday date) description link and the above table is split into many tables to reduce redundancy as table countries id name table holidays id holiday table holiday_countries id holiday_id (fk of id from holidays) country_id (fk of id from countries) link SO now i need to ...
I have this query:- SELECT SUM(DISTINCT( ttagrels.id_tag IN ( 1816, 2642, 1906, 1398, 2436, 2940, 1973, 2791, 1389 ) )) AS key_1_total_matches, IF(( od.id_od > 0 ), COUNT(DISTINCT( od.id_od )), 0) AS tutor_popularity, td.*, u.* FROM tutor_deta...
We're experiencing a performance issue with a MySQL database that's so weird we need another set of eyes to tell us whether we're going crazy or not. We've got 2 MySQL Certified Developers in the team, but all they can say is : "this is impossible". Anyway, here's the situation : we have a query that in theory should be reasonbly fast, ...
Two tables. emails id (int10) | ownership (int10) messages emailid (int10) indexed | message (mediumtext) Subquery (which is terrible in mysql). SELECT COUNT(*) FROM messages WHERE message LIKE '%word%' AND emailid IN (SELECT id FROM emails WHERE ownership = 32) The usage here is that I run a search on emails (which is obviously...
My users have and belong to many roles, and likewise my roles have and belong to many users. How can I select all users who have the role "editor"? How can I select all users who have only the role "editor"? ...
It's a bit difficult getting my problem into a short form, so I apologise if the title doesn't make sense. Anyway, here is the problem: $query = ' SELECT issues.*, comments.author AS commentauthor, favorites.userid AS favorited FROM issues LEFT JOIN comments ON comments.issue = issues.id AND comments.when_posted = issues.when_upda...
I have two tables Orders table and customers table, both have customerid as common field, customer table have firstname, lastname, phone and email address fields. Now if I have to search/select the orders according to customer firstname and/or lastname and/or phone and/or email and/or orderid, then what should be the mysql format of ...
I have five tables: tab_template template_group group user_group user Tab_template's are organized into groups with the template_group relational table. Users's are organized into groups with the user_group relational table. Group's can be public or private (using a tinyint boolean column in the table). I want to query for all of th...