What is wrong with this code?

Isabella

I'm making shopping cart, and I have s problem displaying the products. Here's a part of the code where I think the problem is. I'm using xampp. Is something wrong with the query? Please help, Thanks

Expand|Select|Wrap|Line Numbers

 
<table border="0" cellpadding="2px" width="600px">

        <?

            $result=mysql_query("select * from products");

            while($row=mysql_fetch_array($result)){

        ?>

        <tr>

            <td><img src="<?php=$row['picture']?>" /></td>

            <td>       <b><?php=$row['name']?></b><br />

                    <?php=$row['description']?><br />

                    Price:<big style="color:green">

                        $<?php=$row['price']?></big><br /><br />

                    <input type="button" value="Add to Cart" onclick="window.location='shoppingcart.php'" />

            </td>

        </tr>

        <tr><td colspan="2"><hr size="1" /></td>

        <? } ?>

    </table>

Post Reply

Dormilich

Is something wrong with the query?

not syntax-wise but the * (wildcard) character should be avoided since it will give you a hard time in debugging.

while I’m at debugging, does your query succeed, at all?

Isabella

No nothing shows. And when i run var_dump($row) it give me NULL.

Dormilich

a strong indication that either your query fails or does not contain a result.

What is wrong with this code?

Post your reply

Question stats

Most Active

Most Questions Answered

Top Questions

Latest Questions

Similar topics

More