Comments by previned - CodeProject

previned 19-Jan-20 16:56pm View

I added can you help me

previned 17-Jan-20 16:32pm View

Deleted

i have one problem can you help me

previned 17-Jan-20 15:42pm View

thank you very much

previned 17-Jan-20 15:08pm View

Deleted

i used it like this

$sql = "SELECT pm.*,
(SELECT u.username FROM users u WHERE u.userid = pm.from_id) AS from_username,
(SELECT u.username FROM users u WHERE u.userid = pm.to_id) AS to_username,
(SELECT u.username FROM users u WHERE u.userid = ?) AS my_username,

(SELECT count(*) FROM pm where pm.to_id=? and pm2.read=0)as unread
FROM pm
WHERE pm.from_id = ?
or pm.to_id = ?
ORDER BY pm.id DESC";

previned 17-Jan-20 15:04pm View

Deleted

i added it display like this message Fatal error: Call to a member function get_result() on boolean in C:\xampp\htdocs\demo\npm\cons.php on line 419

previned 17-Jan-20 14:52pm View

I checked your script but same results display all users unread messages same

previned 16-Jan-20 11:40am View

i cant understand brother plz help me i have tried on one month but still i couldn't do that

previned 16-Jan-20 11:33am View

please help me i have lot of tried

previned 16-Jan-20 11:29am View

i added you script but Fattel error message display

previned 16-Jan-20 6:05am View

can you add like this
$sql1 = "SELECT from_id, COUNT(*) unread FROM pm WHERE to_id=? AND read='0' GROUP BY from_id";

$sql2 = "SELECT *,

(SELECT username FROM users WHERE userid=from_id) AS from_username,
(SELECT username FROM users WHERE userid=to_id) AS to_username,
(SELECT username FROM users WHERE userid=?) AS my_username

FROM pm WHERE from_id = ? or to_id=? ORDER BY id DESC";

previned 16-Jan-20 5:56am View

can you join this as two sql statetement to one sql1= and sql2= like this

previned 16-Jan-20 5:48am View

not counting

previned 16-Jan-20 5:48am View

not working brother display like this Notice: Undefined index: from_id in C:\xampp\htdocs\demo\npm\cons.php on line 423
User - 2

previned 16-Jan-20 5:35am View

but same results error

previned 16-Jan-20 5:34am View

i checked like this $sql = "

SELECT u.username ,COUNT(*) unread FROM pm join users u
on pm.to_id=u.userid
WHERE read=0 GROUP BY u.username )AS unread

FROM pm WHERE from_id = ? or to_id=? ORDER BY id DESC";

previned 16-Jan-20 5:30am View

i checked but same results Fatal error: Call to a member function get_result() on boolean in C:\xampp\htdocs\demo\npm\cons.php on line 417

previned 16-Jan-20 4:55am View

when i added here like this SELECT u.username , it not working fattal error message display

previned 16-Jan-20 4:53am View

i added like this $sql = "SELECT *,

(SELECT username FROM users WHERE userid=from_id) AS from_username,
(SELECT username FROM users WHERE userid=to_id) AS to_username,
(SELECT username FROM users WHERE userid=?) AS my_username,

(SELECT COUNT(*) unread FROM pm join users u on pm.from_id=u.userid where to_id=? and pm.from_id=u.userid and read=0 group by from_id)AS unread

FROM pm WHERE from_id = ? or to_id=? ORDER BY id DESC";

previned 16-Jan-20 4:52am View

one by one users messages not counting same row display

previned 16-Jan-20 4:39am View

please help me i have lot of tried to create

previned 16-Jan-20 4:38am View

now problem one by one users unread message not counting display same row example user1 unread 2,user2 unread 2, userid3 unread 2,

previned 16-Jan-20 4:22am View

not working display Fatal error: Call to a member function get_result() on boolean in C:\xampp\htdocs\demo\npm\cons.php on line 423

previned 15-Jan-20 23:24pm View

please anyone can help me

previned 15-Jan-20 20:28pm View

please help me i have lot of tried to create

Comments by previned (Top 24 by date)