Setting HTML table rowspan from $numrows in MySql 1

[ZOR]

I have an HTML table which grows in rows from records being added in MySql database. Is there a way to use my $numrows figure in the MySql query to enter a rowspan(" ") number, as one of the table columns contains a picture. Thanks

 

[ZOR]

I have just tried putting in a very much higher number value of rowspan, and the table opens up okay and gives no errors, will I come unstuck later (providing records do not exceed number of rows) Maybe its an HTML question but I will try here first with PHP bit. Thanks

 

[sleipnir214]

Take a look at mysql_num_rows()



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ZOR]

Thanks sleipnir. I have got a value in variable $num from mysql_numrows($result), but cannot find syntax/way for the Rowspan="" to accept it. Regards.

 

[sleipnir214]

It would seem to me that if $num contains the value, then a print statement including:

print '..... rowspan="'. $num . '" ....';

will output the string you need quite nicely.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ZOR]

Thanks, you are correct, only thing is I have tried every permutation to put that in this line:

<td rowspan="300" width="17%" align="center" bgcolor="#FFFFFF">

I tried:

rowspan=$num
rowspan="$num"
rowspan=$num;
rowspan=<? $num ?>
rowspan=<? $num; ?>
rowspan=<? "$num" ?>
rowspan=<? "$num; ?>
rowspan=<? ..............................

Gaddoing!!

Regards

 

[sleipnir214]

If $num contains the value 300, then the print statement:


print '<td rowspan="' . $num . '" width="17%" align="center" bgcolor="#FFFFFF">';


Will output:

<td rowspan="300" width="17%" align="center" bgcolor="#FFFFFF">



Want the best answers? Ask the best questions! TANSTAAFL!

 

[ZOR]

Many thanks, have a star. Regards