[man]mysql_num_rows/man would not suit the situation here. From what I understand, you have a field in a row with a column name of Threadprefix that has a value of something like:
pre
fix
something__
[RESOLVED]
[ISSUE]
[ERROR]
[SOLUTION]
And you want to display something like:
1 pre_
2 fix_
3 something_
4 [RESOLVED]
5 [ISSUE]
6 [ERROR]
7 [SOLUTION]
right?
[indent]
If so, then you need to run a query using [man]mysql_query/man to retrieve that field. Then, you'd need to create an array by using [man]explode/man to break apart the text based upon line-breaks ("\n" or "<br>"). Then loop through with [man]for/man and display the current counter as well as the value of the array.
Some pseudo code:
<?php
$query = "SELECT fieldname FROM table LIMIT 0,1";
$result = mysql_query($query);
if(!$result)
die('Query failed to return results. ['.mysql_errno().']');
$field = mysql_result($query, 0, 'fieldname');
$lines = explode("\n", $field);
for($i=0, $k=1, $max=count($lines); $i<$max; $i++)
{
echo $k.'. '.$lines[$i].'<br />';
}
[/indent]
If not...
[indent]Then you'd just return the field (as above) and then explode the lines (as above) and instead of looping through, you can use the [man]count/man function to give you the number of lines in that field.[/indent]
Hope that helps.
