Ask a question    Sign Up Sign In
  1. Home
  2. php - select data from a table and fill specific value from another table

688 votes
1 answers

php - select data from a table and fill specific value from another table

Get the solution ↓↓↓

I have two tablesdiscussions andvotes that are like this

discussions

please see discussions table image

votes

please see votes table image

that parentId in votes is id in discussions table

but exist a problem

I want to have a key with namelikeByMe and want to fill this key when select discussions for specific user. how can I connect these two tables and fill this value when call one query?

I want something like this

select * 
from discussions

and fill likeByMe from votes table for any rows by true or false value

487
votes

Answer

Solution:

Given your description, you can useexists:

select d.*,
       (exists (select 1
                from votes v
                where v.parentid = d.id and v.userid = ?
               )
       ) as likedByMe
from discussions d;

The? is a parameter placeholder for the user you care about.

Write your answer



Share solution ↓

Additional Information:
Link To Source
People are also looking for solutions of the problem: deprecated: directive 'allow_url_include' is deprecated in unknown on line 0

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Similar questions

Find the answer in similar questions on our website.

232 php - Save data to two different tables in CakePHP 3
129 php - extract values from multidemensional array
170 php - Using JQuery UI's sortable('serialize') after loading data in via .load();
467 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP
959 php - How to read value from HTML text input?
943 PHP classes are keeping me from accessing the needed variable
485 linux - Safest way to write into /etc from php application?
861 php - Filter content from mysql db with checkboxes using jQuery?
562 php - Loading controllers from different folder in CodeIgniter
222 php - Check if a variable has been set with the name of the value of another variable

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.





About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Welcome to programmierfrage.com

programmierfrage.com is a question and answer site for professional web developers, programming enthusiasts and website builders. Site created and operated by the community. Together with you, we create a free library of detailed answers to any question on programming, web development, website creation and website administration.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.