For Loop using MS SQL and PHP

[pnathan]

Ok, I have a problem, here is my code:

                <?
                for ($num = 1; $num <= 5; $num++)
                {
                ?>
                    <TR>
                        <TD WIDTH=500 ALIGN="LEFT" VALiGN="TOP">
                        <a name="section1"></a>
                        <FONT FACE="Arial" size=2 COLOR="#B50042"><b><?= $Row_c->section_heading[$num]?></b></font>
                        </TD>
                    </tr>
                    <tr>
                        <TD VALIGN="TOP">
                        <FONT FACE="Arial" size=2>
                        <?= $Row_c->section_content[$num] ?>
                        </FONT>
                        </TD>
                    </TR>
                    <tr>
                        <td>
                            <table WIDTH="100%" BORDER=0>
                                <?
                                $Query_i = ("Select * from product_images WHERE language='$mode' AND title_url='$title_url' and section_number=$num");
                                $Query_b = ("Select * from products_images_bubble WHERE language='$mode' AND title_url='$title_url' and section_number=$num");
                                $Result_i=mssql_query($Query_i);
                                $Result_b=mssql_query($Query_b);
                                $Row_i = mssql_fetch_object($Result_i);
                                $Row_b = mssql_fetch_object($Result_b);
                                ?>
                                <tr>
                                    <? if ($Row_i->image1){?>                                    
                                    <td  ALIGN="CENTER" width="30%"><IMG SRC="/images/<?= $Row_i->image1 ?>" ALT="<?= $Row_p->title_url ?>" BORDER=0>
                                    <br>
                                    <FONT FACE="Arial" size=1>
                                    <?= $Row_b->bubble1 ?>
                                    </font>
                                    </td>
                                    <?} if ($Row_i->image2){?>                                    
                                    <td  ALIGN="CENTER" width="30%"><IMG SRC="/images/<?= $Row_i->image2 ?>" ALT="<?= $Row_p->title_url ?>" BORDER=0>
                                    <br>
                                    <FONT FACE="Arial" size=1>
                                    <?= $Row_b->bubble2 ?>
                                    </font>
                                    </td>
                                    <?} if ($Row_i->image3){?>                                    
                                    <td  ALIGN="CENTER" width="30%"><IMG SRC="/images/<?= $Row_i->image3 ?>" ALT="<?= $Row_p->title_url ?>" BORDER=0>
                                    <br>
                                    <FONT FACE="Arial" size=1>
                                    <?= $Row_b->bubble3 ?>
                                    </font>
                                    </td>
                                    <?}?>
                                </tr>
                            </table>                        
                        </td>
                    </tr>
                    <tr>
                        <td align="right"><FONT FACE="Arial" size=2><a href="#TOP">Back to Top</a></font></td>
                    </tr>
                <!-- Section1 End -->
                <?
                }
                ?>

Now my problem is that I keep getting error messages for these type of variable:

<?= $Row_c->section_content[$num] ?>

Is there a different way of adding on the $num section because I am using MS SQL. If I had a MySQL db, this code would work.

Thanks.

[redux]

well...what kind of error messages are you getting ? cross post, btw... http://www.sitepointforums.com/showt...threadid=61854

[pnathan]

here is the error I am getting:

Warning: Undefined property 

And I know that it does exist in the database. Its just not recognising/accepting the variable with $num at the end of it!

[redux]

well...it could be this: bear in mind that array indices start at 0, not 1. try changing you for loop accordingly

for ($num = 0; $num <= 4; $num++) 

[pnathan]

Nope I tried that, I think is something to do with the way I am declaring the variable

<?= $Row_c->section_content[$num] ?>

Anybody know another way of doing this?

[pippo]

Hi,

I saw that

$Row_c->section_heading[$num]

gives no error, while

$Row_c->section_content[$num]

yes.

Php reports that "section_content" properties does not exists.
I think that you have to check that section_content is a valid column or "column alias".
You said that it exists ( that column ),
so maybe you had not selected that column with your query.

I think you have to check the query that you did to obtain $Row_c.

---
hth

[pnathan]

Nope $Row_c is fine. I personally feel it has something to do with delaring variables using MS SQL. I think that until I come across some one who has actually done this, I will persist with my feeling that it is the whole MS SQL problem.

Thanks for the advice.

And pippo, are Italy going to win the world cup this year?

[pippo]

>>And pippo, are Italy going to win the world cup this year?

eh eh, I hope so...I have a far memory of 1982...Go Italy but also Go Chievo too!

[pnathan]

I think they have a great chance, and especially because everybody is talking about France and Argentina.

Who are what is Chievo?

[pippo]

Chievo ( in local slang Ceo ) is the small quartier of Verona that has ranked the 5th position in our football championship.