Fetch Data from Two or more Table Join using PHP and MySql 

Thank you, spending 2 days searching for this $sql code for fetching data from two table....done my job, thank you again sir

You are gift brother and your are unselfish person.. Until now ur all video tutorial helps me a lot in doing my thesis..

FROM 3DAYS OF SEARCHING, I FINALLY FOUND THIS! GREAT JOB!!! thank you so much

wow your video is much best 2 days searching this cose but not found you are best

Thankx alot sir!!!!! Your video helped me alot to done my job in few seconds.

Your examples are very helpful. Thanks for uploading.

The speech bot is kinda bad, but this is such a great and very straight to the point video, good job

Thank you friend, this presentation was awesome friend.

Brief and clear, thank you

Thanks buddy you made my project with help of this video for my university project

OMG!!! THANK YOU SO MUCH!!!

Thank you very much!, that worked!

Great Tutorial!

Thanks alot sir. Your video helpd me alot to learn how to Join.. Again thanx

Great, this is good. Thank you sir.

Great video solve my problem ]You got like Searching from last 3 days to write such a query but at last, I find it thanks a lot

thank you very much !

Your every tutorial is so helpful and easy to understand.

Thanks a lot bro. This is a nice tutorial

wont it be easier if you talked instead of using text to speech?

thank you so much.......at last I got this

Thank you sir, Great explanation

Excuse me! Can you please tell me whether there are ways to display the results so that the duplicate Brand Names e.g. Samsung can be grouped and presented in one row while keeping its corresponding three Product Names? Thank you so much!

what if you gonna join other data to its specific user , like grading system it this. kind of function would be still working.?

thanks friend

thanks a lot guys

Thx Broo

the best tutorial ever.. GOD bless who ever you are Webslesson

thanks :D

THANK YOU

good job

thank you very much sir

Well done dear it helped me

very nice tutorial sir but can you make drop list where input text rely on drop down-list category before searching?

thank you

sir i have a question please notice me thank you .. my question is i have another form then if i search the ID in the text field, form will show the data by imputing only id and show only the firstname, lastname, email, address and contact and insert the new data in another table and how i build the code in php thank you your number 1 subscriber in this channel THANK YOU

Can't help but smirk after hearing "friend" in this weird skipping automated voice message XD

Thanks Boss

Good video

thanks

how to access data from two table and and insert into anther table in mysql n php

nice video

thanks sir for a good tuorial.. but may i know how can i put the button to go to the next page that carry the product_id?

niceeeee

i presume the output data is dynamic, not automatically recorded in a separate table. How to save then as a new table ?

I got two tables and one of them is users and the other one is called user_access where the user is either a primer level, level 1, level 2 or level 3 user

Good one

thnx

i don't know if this code is good,,,PDO seems to be stack overflow way...but this worked in 5 minutes...took me an hour and still no results in pdo connection.

Guys...How can I make multiple join in one sql? To get data from 2 foreign keys in the same table?

Thanks for the tutorial, Only the text to speech voice is beared to listen , otherwise rest of the thing is very good. I earnestly request you please use your own voice it would be very thankful.

two table data one table1 (add , category) and table2 (subcategory) how to display in hyperlink tag

Hi Sir. I have a problem. I want to insert first the data to my recycle_bin table before I delete it. how can I do that? thank you Sir and Godbless

How can I display database table name. In PHP

How to reduce redundancy of the brand name like for example, I only want to output one Samsung Brandname but outputting 3 product name?

bro!! is it possible to generate id's dynamically.i mean if a user enters some data then it will store into a database and to this row i want to assign a id,,so i want to increase the id automatically whenever a user enters some data, so i can get that user entered data somewhere else!!!!

how to table data display in hyperlink tag

kaneez fatima 1 second ago nice video sir ,i have one question ,i have two table A and B ,how can i edit data from both table at a time using php mysql ...it my request plz plz

Please can any one tells me that it is mandatory to use foreign key constraint before using joins in mysql ???

i want to show brand name only one time but product show all .. how can I marge same record cell when execute code ..

please make a video for update and delete

i have made signup and login form and it works fine and it save the user data into "user" table in mysql. my actual problem was after user login because i have another form like "some questions" that user have to fill this and have to submit this form and it is also works fine and user entered answer data will also saved in my mysql "answer" table now my problem i have "answer" table in mysql but in don't know which user have filled this answer table form because it only contains "answers" My question is? I have two tables one is user filled registration tables and another one is user filled answer table in mysql and now how to connect the answer tables with exact user name? example: connect "user" name (this is user registration table contains user name in table 1) to with same users answers (which is answered by users by filling html form the answers in table 2) how to connect answer table to exact users

How to insert this type of data

how can i get data inform of cols not rows

Plz how fatch data from two table using datatable library ajax php

I want to show brand name only once. How can I do that?

İnsan kendinden başka bir şeyi arayıp bulmaya kalkışsa; Gerçekten her geçen saat hem kendinden, hem de her şey den her an uzaklaşır.

query not working - I get this message - Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in ....line 25 - please explain.

How to use where on join table

what about if we giving input????/

I'm making a login page. This is what I want, teacher, user and admin all login using a one page. That's a login page and the three actor is logged in with this page. And the three tablets are separate in the database. like your vedio two saprate table in database. So plz help me. What method of use do you use? You have to send me this code. Only this logic is use if there is no data in database in student table then login teacher. if the teacher is not inthe table then login admin. plz help plz plz

Please send a codeing

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\Alumni\sample.php on line 25 i have error

Great video. I’m looking to make a table compromised of two MySQL tables with a many to one union. Using your example, I would like to have the Brand Name for each brand as one cell. Like this: BRAND NAME____|____PRODUCT NAME Samsung...............|.......Samsung Galaxy All ...............................|.......Samsung Galaxy 7 ...............................|.......Samsung Whatever Apple.....................|.......iPad ...............................|.......iPhone 10 ...............................|.......iPhone 9 Suggestions anyone? Thanks in advance to the many good and helpful people online.

Artık kimseye bir şey yazmak istemiyorum. Basit bir yazıyı adam ya anlamıyor. Ya da zekası yetmiyor. Çocuklar gibi anlayıp cevap veriyor. Okuduğu bir cümleden bile hafızasında bir kelime yok.Ha gelmiş, ha gitmiş.

When i heard the word "Friends" recurring more than usual i knew this was def an indian

you should have seen error on line 17

Damn, this is the first tutorial from stephen hawking i've ever seen!

Good job bro JESUS IS COMING SOON;PREPARE

Nice one. Just stop telling "friends". It's kind of annoying. Thanks.

This guys maybe fearing to speak due to lack of a good accent(English). But he/she should not.

thanks friend

thanks

How can I display database table name. In PHP