<if> conditional for particular row in a table

[sparklywater]

Can someone please tell me how to write an <if> conditional for a particular row in a table, for example if I want to add an attribute to the 13th row of a table, how would I go about doing that?

thanks.

[Lynne]

What variable are you using to count rows?

[sparklywater]

I'm not sure what you mean. This is the query I am using to fetch the rows:

SELECT post.postid, post.pagetext as pagetext, post.userid, post.username, post.dateline AS date, thread.forumid, thread.title as thread_title, thread.threadid, forum.forumid, forum.title as forum_title, thread.replycount as replies, thread.views as views
FROM " . TABLE_PREFIX . "thread AS thread
INNER JOIN " . TABLE_PREFIX . "post AS post on (post.postid = thread.lastpostid)
INNER JOIN " . TABLE_PREFIX . "forum AS forum on (thread.forumid = forum.forumid)
WHERE post.visible = '1' AND thread.visible = '1' AND open = '1'
ORDER BY date DESC
LIMIT $sel_limitlowerminus1,$perpage

And this is the code for constructing the rows:

<tr> 
 
<td alt="Go to last post in thread '$WQfield[thread_title]'" title="Go to last post in thread '$WQfield[thread_title]'" style="cursor:pointer;" onclick="window.location.href='$vboptions[bburl]/showthread.php?$session[sessionurl]p=$WQfield[postid]'" class="alt1" WIDTH="42%" VALIGN="middle" align="left"><div style="font-size: 11px"><a href="$vboptions[bburl]/showthread.php?$session[sessionurl]p=$WQfield[postid]"><b>$WQfield[thread_title]</td><td align="center" class="alt1" WIDTH="23%" VALIGN="middle"><span style="font-size: 11px">$WQfield[date]</span></td>

<td alt="View profile of $WQfield[username]" title="View profile of $WQfield[username]" style="cursor:pointer;" onclick="window.location.href='$vboptions[bburl]/member.php?$session[sessionurl]u=$WQfield[userid]'" align="center" class="alt1" WIDTH="19%" VALIGN="middle"><div style="font-size: 11px"><a href='$vboptions[bburl]/member.php?$session[sessionurl]u=$WQfield[userid]'><b>$WQfield[username]</b></a></div></td>

<td align="center" class="alt1" WIDTH="8%" VALIGN="middle" align="center" style="font-size: 11px">$WQfield[views]</td>

<td onclick="who($WQfield[threadid]); return false;" alt="View who has posted in thread '$WQfield[thread_title]'" title="View who has posted in thread '$WQfield[thread_title]'" align="center" class="alt1" WIDTH="8%" VALIGN="middle" align="center" style="font-size: 11px; cursor:pointer"><a alt="View who has posted in thread '$WQfield[thread_title]'" title="View who has posted in thread '$WQfield[thread_title]'" href="misc.php?do=whoposted&amp;t=$WQfield[threadid]" onclick="who($WQfield[threadid]); return false;">$WQfield[replies]</a></td>

</tr>

Basically I want to be able to add something to a particular row of that table.

[Lynne]

That's just the statement for spitting out the rows. Somewhere in your page, after the query, you do a while/fetch_array on the query, no? And in that while you will need to determine if that is the row you want to add something to. So, are you keeping count in your while loop?

[sparklywater]

To be honest, I don't know. The table is generated by code in the file I am attaching to this post. I did a search on that page and found the while/fetch arrays you are referring to, but I don't know how to manipulate them.

[Lynne]

Well, I'm not gonna try to go through that and figure out what is going on. I'll tell you that if you want to do something to row 13, then you will need to do something to figure out how many times you have spit out the row. Like, set i=0 before you go into the loop. Then, increment it by one just before you spit out the row and do a check to see it you are up to i=13 yet.

[Ted S]

To elaborate a bit on what Lynne said, you can up a counter with the simple i++; line inside your loop and then check it with if($i == '13'){ ... }