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");
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)
Firebase Cloud Functions: PubSub, "res.on is not a function"
TypeError: Cannot read properties of undefined (reading 'createMessageComponentCollector')
Currently working on a project and could use some advice for how to approach implementing an Auto-Bidding system for a web application similar to Ebay
In a booking system I want to calculate the sum of hours a resource has been booked between two dates (2019-01-01 to 2019-01-02) from 8am to 4pm
I have a MySQL select query that I am trying to get the third Thursday from a date in my table here is what I have for the query any help would be greatly appreciated