[frobak]

Hi

I am displaying dynamically the rows from a databse table, and inside this i want to display a php variable, which is a download count, the code:

<?php echo $dl_count; ?>

but when the html table is dynamically displayed, it isnt reading it as php and isnt doing anything with it.

ive tried this withough the php tags also which doesnt work.

Is it possible to have this small php script within dynamically produced html?

the code for producing the html is below:

PHP Code:

                <?php

                include("includes/db_connect.inc.php");



                $query="SELECT * FROM pbzarchive ORDER BY date_added";

                $result=mysql_query($query);



                $num=mysql_numrows($result);



                mysql_close();



                $i=0;

                while ($i < $num) {



                $mix_title = mysql_result($result,$i,'mix_title');

                $djname = mysql_result($result,$i,"djname");

                $mix_length = mysql_result($result,$i,"mix_length");

                $mix_size = mysql_result($result,$i,"mix_size");

                $filename = mysql_result($result,$i,"filename");

                $dl_count = mysql_result($result,$i,"dl_count");



                echo "<div class='mix'>

                        <table id='mix'>

                        <th colspan='2'>$mix_title

                        </th>

                        <tr>

                            <td id='mix'>DJ's : 

                            </td>

                            <td id='mix'>$djname

                            </td>

                        </tr>

                        <tr>

                            <td id='mix'>Mix length : 

                            </td>

                            <td id='mix'>$mix_length

                            </td>

                        </tr>

                        <tr>

                            <td id='mix'>Mix size : 

                            </td>

                            <td id='mix'>$mix_size

                            </td>

                        </tr>

                        <tr>

                            <td id='mix'><A href='../downloads/$filename.php' onClick='popup = window.open('downloads/$filename.php', 'PopupPage', 'height=135,width=265,scrollbars=no,resizable=no'); return false' target='_blank'>Download</a><?php echo $dl_count; ?>

                            

                            </td>

                            <td id='mix'>

                            </td>

                        </tr>

                    </table>

                </div>";

                $i++;

                }

                ?>

</div>

any help would be much appreciated as its driving me a little crazy.

thanks

alan

[dgreenhouse]

You're already echoing $dl_count inside of a php command,
so you don't need to (nor will it work), enclose $dl_count in "<?php ?>"again.

[frobak]

but when i do that, it displays nothing actually in the html page, but if i view source it has the full php code eching the variable that i want it to, inside the php tags??

PHP Code:

<?php echo dl_count_show; ?>

but it isnt treating it as php?

[dgreenhouse]

I thought the variable was: dl_count not dl_count_show...

[dgreenhouse]

Anyway, if something is in the variable after querying the database, it should display.

If you're not getting output, and you know there's something in there, you're obviously
doing something else wrong along the way.

[frobak]

yes the variable is dl_count, and the value of that variable is dl_count_show, which is correct, but its blank on the actual screen, and as above, if i view source it has the php tags displayed?

[frobak]

i want the variable to display another variable, that will be populated by an sql query also run on this page

[frobak]

I managed to get it to print the value of variable dl_count, and the value is $dl_count_show, but i want $dl_count_show to display the count of an sql query that has been run and is sat in the variable.

but when it is diplayed dynamically it is not reading it as php, but as just normal text?

[dgreenhouse]

I do not understand what you mean by: "not reading it as php".

Do you mean it's not an integer?