How to get number of current mysql frield by php?

web_designer_iq

Hi,
I want get current MySQL record number by php code.

for example:

while ($row = mysql_fetch_assoc($DB->result) ) {

echo 'current record number is: '.$rec_number;

}

thanks,

Installer

I'm not sure what the difference is between "field number" and "index number". Do you mean you want the row number (as your code suggests)?

web_designer_iq

Ok dear.
i will to explain.
i.e:
I have a table with the following fields:
1) id (primary key)
2) name

I want to show the record number:
i.e:

record Number is: 10
Name is: Jimmy

thanks

Installer

OK. (Records are not fields. Records contain fields.)

This might be what you want:

$query = "SELECT name FROM my_table";
$result = mysql_query($query);
$rn = 0;  // "1" if you want to start there.
while ($row = mysql_fetch_assoc($result)) {
    echo 'record Number is: ' . $rn++ . '<br />';
    echo 'Name is: ' . $row['name'] . '<br />';
}

web_designer_iq

Ok. sorry.
but it not worked.
see.
i want to split records and put it HTML code with 6 rows.
see the following code:


// show html tag
echo '<table width="100%" cellpadding="3" cellspacing="3">';

$num = $DB->query_num;

$i = 1;

while($row = mysql_fetch_assoc($DB->query_result)){

$start_tr = ($i == 6 || $i == 12 || $i == 18)?'<tr>':'';
$end_tr   = ($i == 6 || $i == 12 || $i == 18)?'</tr>':'';

echo "
	$start_tr
	<td valign=\"top\" class=\"cust_td\"><p class=\"cust_title\">{$row['uname']}</p></td>
  	$end_tr
  ";
$i++;
}

echo '</table>';

if total of records is 21 output was:
6 rows
1 row
6 rpws
1 row
6 rows
1 row
3 row

you have any idea for this code?
i want to split 6 rows
ie:
records is (n) record:
6 rows
6 rows
6 rows
etc...

Thanks

Installer

My code works just fine. Take a look at your html source to see the output yours produces.

You strart and end your table rows on the same count, so most of your cells aren't even enclosed by row tags.

Installer

Not to mention that your first row won't have an opening table row tag, and, unless your results are exactly divisible by six, your last row won't have enough cells. And if you have a lot of query results you'll have to manually change the condition expression (imagine 500 results).

Try this

$num_cols = 6;
$i = 0;
echo '<table width="100%" cellpadding="3" cellspacing="3">'; 
while ($row = mysql_fetch_assoc($DB->query_result)) { 
    $i++; 
    if (($i % $num_cols) == 1) {
        $start_tr = '<tr>';
    } else {
        $start_tr = '';
    }
    if (($i % $num_cols) == 0) {
        $end_tr = '</tr>';
    } else {
        $end_tr = '';
    }
    echo $start_tr . 
         '<td valign="top" class="cust_td"><p class="cust_title">' .
         $row['uname'] . 
         '</p></td>' . 
         $end_tr; 
}

while ($i % $num_cols) {
    echo '<td>&nbsp;</td>';
    $i++;
}
echo '</tr>';
echo '</table>';