[SOLVED] Trying to dynamically link query results php mysql database

[kamaral9696]

I will try to be as detailed as possible here.

 

I have created a query to pull from the database, as an example here is a link to the working query result page.  http://www.katieamaral.net/admin/result_commRent.php

 

What I want to do is to be able to click on the title and have it take you to the next page, which would have all the details pertaining to that particular record.  Here is an example of what it should look like

http://www.katieamaral.net/admin/detail_commRent.php

 

When I go to the site and test it live this is the page it directs to http://www.katieamaral.net/admin/commRent_detail.php?comm_id=2 , but the screen is blank?  It looks like it is going to the right place?

 

I have attached the code below for both pages.

 

Thanks for any help on this.  I am new to this and self-taught.  I have been struggling with this for a few days and just can't seem to figure it out!

 

Thanks again.

 

[attachment deleted by admin]

[Yesideez]

Check the way you're using your comments...

 

	 <?php if ($totalRows_result_commRent == 0) { // Show if recordset empty ?>

 

I could be wrong but I believe you could have commented out the ?>

 

If you must comment like that use this instead:

 

	 <?php if ($totalRows_result_commRent == 0) { /* Show if recordset empty */ ?>

[kamaral9696]

Thanks so much!  That worked.  I knew that it would be something really silly after my hours of trying to fix it.