need help for query code export from 2table (by php) in mysql
31
April 16, 2019, at 02:10 AM
i need code for export favs in table.
i make 2 table in mysql
one : tbl_post
two : tbl_markshow .
in tbl_post : id,masterid,note and
in tbl_markshow : id,masterid,studentid .
I need only to display the records that masteruser has registered for the student !
Table mark show
Table post
Approach
i make code but don't work
$result = $conn->query("Select * From tbl_markshow,tbl_post Where tbl_post.masteruser=tbl_markshow.masteruser AS tbl_markshow.studentuser='943167348' order by id desc");
Answer 1
Final query:
$result = $conn->query("SELECT *
FROM tbl_post
WHERE masteruser IN
(SELECT masterid
FROM tbl_markshow
WHERE studentuser = $studentuser)
ORDER BY id DESC");
Just need this code:
tbl_post where masteruser in(select masterid from tbl_markshow where studentuser = $studentuser)
POPULAR ONLINE
- search for elements in a list 13289 visits
- Adding methods to es6 child class 12079 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 9629 visits
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 8038 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 7065 visits
- Conflict: Multiple assets emit to the same filename 5865 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 5794 visits
