Recordset field behaving erratically

[Lauren_LCM]

Ave to all gurus of the PHP empire.

I have an “headache” that I would like someone to help me find the right drug for.
I have been trying to solve this for the past 2 days or so and I guess I really need a good pharmacist.

Here is the problem in a short summary. I have a PHP page loading with a recordset (MySQL) running in front of the page to give its variables.

The page doesn’t load with the content due to this line of code. The problem child is in bold.

<ul>
<li><a href="prodmaster.php?cat_ID=<?php echo $row_rsprodmaster['cat_ID']; ?>&amp;prod_type_ID=1&amp;prod_Desc=<?php echo $row_rs_prodcat['prod_Desc']; ?>">E-Cards</a></li>

      <li></li>

</ul>

Now if I where to run this same line with a punched_in value rather than the recordset it will work!!!!!

<ul>
<li><a href="prodmaster.php?cat_ID=DP&amp;prod_type_ID=1&amp;prod_Desc=<?php echo $row_rs_prodcat['prod_Desc']; ?>">E-Cards</a></li>

                        <li></li>
                        </ul>

OK, wait a sec.. I can see that you are thinking..hummmm. the recordset doesn’t select the correct record value, which is the first thing I thought about, but consider this. The following line of code is actually further up in the page and it extracts the variable from the same field of the same recordset to display the value in a dynamic field.

<div align="left" class="style8"><?php echo $row_rsprodmaster['cat_ID']; ?></div>

AND BELIEVE IT OR NOT THE DISPLAYED RESULT SHOWS “DP”.

I need a strong pain killer.
If someone feels like it can spray some good on human kind right now I will be first in line.

Your forever thanksful servant.

[jib0]

Can you please show us more of your code? And use the PHP tag to display it nicely!

[bogu]

Set Error Reporting to E_ALL ([man]error_reporting[/man])

[Lauren_LCM]

Well Bogu I believe you will need some pain killer soon too.:evilgrin:

In fact the PHP.INI file was already set to E_ALL.
I am not getting any error because the page loads correctly except that its empty (no content aka images) and therefore there is no error to report to start with. My problem is that when I plug in manually the variable "DP" the content (images) loads.

You will find below some more code for that page where I have highlighted the code being problematic.

This is where the dynamic field display the correct value.

<table width="640" border="0" cellspacing="0" cellpadding="0">
                                  <tr>
                                    <th width="522" valign="middle" scope="col"><!-- InstanceBeginEditable name="EditRegion6" -->
                                      <div align="left" class="style8"><?php echo $row_rsprodmaster['cat_ID']; ?></div>
                                    <!-- InstanceEndEditable --></th>
                                    <th width="102" valign="middle" scope="col"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('cartbtn','','image/cart-2.png',1)"><img src="image/cart-1.png" alt="cart btn" name="cartbtn" width="49" height="41" border="0" id="cartbtn" /></a><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('cartbtn','','image/image/cart-2.png',1)"></a></th>
                                  </tr>
                                </table>
                                </ul>
                          </div></th>
                        </tr>
                        <tr>
                          <td align="left" valign="top" scope="col"><div align="right"><a href="#" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('cartbtn','','image/image/cart-2.png',1)"></a></div></td>
                        </tr>
                    </table></th>

And this is where the dynamic field displaying the correct value is being used without success. Now remember if you change the cat_ID=<?php echo $row_rs_proddetail['cat_ID']; ?> with a hard value (aka:cat_ID=DP) it will work.

</table></th>
                            <th scope="col"><p><a href="proddertail.php?prod_ID=<?php echo $row_rsprodmaster['prod_ID']; ?>"></a></p>
                                <p align="center">&nbsp;</p></th>
                            <th scope="col"><p><a href="proddertail.php?prod_ID=<?php echo $row_rsprodmaster['prod_ID']; ?>"></a></p>
                                <p align="center">&nbsp;</p></th>
                          </tr>
                          <tr></tr>
                        </table>
                        <br />
                        <!-- InstanceEndEditable --> </blockquote>
                    </blockquote></th>
                  </tr>
                </table>
                <!-- InstanceBeginEditable name="navcatalogue" -->
                <table width="640" border="0" cellspacing="0" cellpadding="0" align="center">
                  <tr>
                    <th scope="col"><div id="navsite1">
                      <div align="center">
                       <ul>
                            <li><a href="prodmaster.php?cat_ID=<?php echo $row_rs_proddetail['cat_ID']; ?>&amp;prod_type_ID=1&amp;prod_Desc=<?php echo $row_rs_prodcat['prod_Desc']; ?>">E-Cards</a></li>

                        </ul>
                  </div>
                </div></th>
              </tr>
            </table>

As always, many, many, many thanks for the time you will be spending on this issue.

[Sxooter]

This could be a question of scope. Are those references inside functions perhaps?

[Lauren_LCM]

Hi Sxooter,

I am interested by your comment regarding scope and inside functions, you might have lead us on the right path here.

Can you please develop some more what you are thinking about?

Thanks,