Data output

Question

Hello! Help me please. There is a table. It looks like this.

`user_one` int(11) NOT NULL, `user_two` int(11) NOT NULL, `hash` int(11) NOT NULL, `date_group` datetime NOT NULL, `del_user1` int(1) NOT NULL DEFAULT '0', `del_user2` int(1) NOT NULL DEFAULT '0'

And the conclusion itself.

 <? $get_con = $bd->query("SELECT u.id,p.hash,p.user_one,p.user_two,p.date_group, u.username,u.family,u.avatarthb,u.lastdate,u.olddate FROM message_group p INNER JOIN users u ON CASE WHEN p.user_one = '$myrow2[id]' THEN p.user_two = u.id WHEN u.id != '$myrow[id]' THEN p.user_one= u.id END AND ( p.user_one ='$myrow2[id]' OR p.user_two ='$myrow[id]' ) Order by p.date_group DESC Limit 15") or die(mysql_error()); ?> Вот не могу сделать выборку del_user1 и del_user2 помогите пожалуйста.

u.del_user1, u.del_user2 add to the SELECT does not channel?

Accepted Answer · 2014-04-23T12:55:19

 $get_con = $bd->query("SELECT u.id,p.hash,p.user_one,p.user_two,p.date_group, u.username,u.family,u.avatarthb,u.lastdate,u.olddate,p.del_user1,p.del_user2 FROM message_group p INNER JOIN users u ON CASE WHEN p.user_one = '$myrow2[id]' THEN p.user_two = u.id WHEN u.id != '$myrow[id]' THEN p.user_one= u.id END AND ( p.user_one ='$myrow2[id]' OR p.user_two ='$myrow[id]' ) AND ( p.del_user1 =0 OR p.del_user2 =0 ) Order by p.date_group DESC Limit 15") or die(mysql_error());

@yarnik Forgive me, I just forgot to finish writing. Look at me del_user1 or del_user2 equals to beginning 0, and when I click to delete, an update is made to 1. Here I need to output del_user1 and del_user2 where it equals 0.

Data output

1 answer 1

More articles: