想要在数组中单独指向逗号分隔的字符串(want to give separate link to comma seperated string in an array)
我有下表:
在查询中,我使用group_concat来获取bug id。 我想给每个bug id单独链接。 例如:给出的链接是“show_bug.cgi?id = 3743200”
以下是代码,我用过:
$query = "select count(cbm.bug_id) as count,(select concat(round((count(cbm.bug_id)/(select count(*) from techzilla.category_bug_map cbm,techzilla.bugs b where b.assigned_to =$userId and cbm.bug_id=b.bug_id) * 100 ),2),'%')) as Percentage ,group_concat(b.bug_id separator ',') as BugIds from techzilla.bugs b left join techzilla.category_bug_map cbm on cbm.bug_id = b.bug_id where b.assigned_to = $userId and b.creation_ts >= '$fromDate 00:00:00' and b.creation_ts <= '$toDate 00:00:00' and cbm.os IN ('$opess')"; $result = mysql_query($query) or die ("Bad query: " . mysql_error() ); while($row = mysql_fetch_row($result)) { echo "<tr><td>$opess</td> <td>$row[0]</td> <td>$row[1]</td> <td>$row[2]</td></tr>"; }我怎样才能做到这一点?
I have the following table :
In the query I have used group_concat to take the bug id's. I want to give separate link to each bug id. for eg : link to be given is "show_bug.cgi?id =3743200"
following is the code, I have used :
$query = "select count(cbm.bug_id) as count,(select concat(round((count(cbm.bug_id)/(select count(*) from techzilla.category_bug_map cbm,techzilla.bugs b where b.assigned_to =$userId and cbm.bug_id=b.bug_id) * 100 ),2),'%')) as Percentage ,group_concat(b.bug_id separator ',') as BugIds from techzilla.bugs b left join techzilla.category_bug_map cbm on cbm.bug_id = b.bug_id where b.assigned_to = $userId and b.creation_ts >= '$fromDate 00:00:00' and b.creation_ts <= '$toDate 00:00:00' and cbm.os IN ('$opess')"; $result = mysql_query($query) or die ("Bad query: " . mysql_error() ); while($row = mysql_fetch_row($result)) { echo "<tr><td>$opess</td> <td>$row[0]</td> <td>$row[1]</td> <td>$row[2]</td></tr>"; }How can I achieve this?
最满意答案
您可以使用爆炸功能。
$ids = explode(',', $bugs); foreach($bugs as $b) { echo '<a href="...">'.$b.'</a>'; }You can use explode function.
$ids = explode(',', $bugs); foreach($bugs as $b) { echo '<a href="...">'.$b.'</a>'; }更多推荐
发布评论