jigsawsoul Posted August 14, 2009 Share Posted August 14, 2009 $tablerows is not echoing out and i can't seem to understand why. $requestid = $_GET['id']; is getting the id. any help <?php session_start(); include '../../library/opendb.php'; include '../../library/config.php'; include '../../library/functions/f_login.php'; include '../../library/functions/f_nav.php'; sessionAuthenticate( ); $message .= $_SESSION["message"]; $username = $_SESSION["username"]; $result = "SELECT * FROM wbl_login WHERE username = '$username'"; $result = mysql_query ($result) or die (mysql_error()); $row = mysql_fetch_assoc ($result); $username = $row['username']; $username = ucwords($username); // Current page. $page = "commissionrequest"; $requestid = $_GET['id']; // Get all member's information $result = "SELECT * FROM wbl_commission LEFT JOIN wbl_customers ON wbl_commission.customer_id=wbl_customers.customer_id LEFT JOIN wbl_login ON wbl_customers.customer_id=wbl_login.customer_id WHERE commission_id = $requestid"; $result = mysql_query ($result) or die (mysql_error()); while($row = mysql_fetch_assoc($result)) { $tablerows .= ' <table id="project_members"> <tr class="alt"> <td> <b>Id:</b> '.$row['commission_id'].' <b> Username:</b> '.$row['username'].' <b> Date:</b> '.$row['date'].' <b> Status:</b> '.$row['status'].' <br /><br /> <b>Description:</b> '.$row['description'].' <br /><br /> <b>Comments:</b> '.$row['comments'].' <br /><br /> <a href = "details.php?id='.$row['enquiry_id'].'" >Respond</a> | <a href = "update.php?id='.$row['enquiry_id'].'" >Edit</a> | <a href = "delete.php?id='.$row['enquiry_id'].'" >Delete</a></td> </tr> </table> '; } ?> <?php include ('../../library/template/admin/htmlstart.php'); ?> <div id="wrap" class="clearfix"> <?php include ('../../library/template/admin/adminpanel.php'); ?> <div id="content" class="clearfix"> <?php mainNav($page); ?> <div id="left" class="clearfix"> <div id="left_container"> <?php subNav($page); ?> <?=$message?> <h1 class="section">Current Commission Requests</h1> <?=$tablerows?> </div> </div> <!-- Right Side Bar Here --> <?php include ('../../library/template/admin/footer.php'); ?> </body> </html> <?php unset ($_SESSION["message"]); include '../../library/closedb.php'; ?> Link to comment https://forums.phpfreaks.com/topic/170187-solved-information-is-not-displaying-cant-see-why/ Share on other sites More sharing options...
MadTechie Posted August 14, 2009 Share Posted August 14, 2009 Change <?=$tablerows?> to <?php echo $tablerows; ?> if it works do the same for $message Link to comment https://forums.phpfreaks.com/topic/170187-solved-information-is-not-displaying-cant-see-why/#findComment-897736 Share on other sites More sharing options...
jigsawsoul Posted August 14, 2009 Author Share Posted August 14, 2009 nope doesn't work that way to, i don't get any of the table displayed both ways at all any help out there Link to comment https://forums.phpfreaks.com/topic/170187-solved-information-is-not-displaying-cant-see-why/#findComment-897738 Share on other sites More sharing options...
jigsawsoul Posted August 14, 2009 Author Share Posted August 14, 2009 i keep looking at the code over and over and i dont see anything Link to comment https://forums.phpfreaks.com/topic/170187-solved-information-is-not-displaying-cant-see-why/#findComment-897749 Share on other sites More sharing options...
MadTechie Posted August 14, 2009 Share Posted August 14, 2009 okay add $result = mysql_query ($result) or die (mysql_error()); $found = mysql_num_rows ($result); //ADD $tablerows = "FOUND: $found"; //ADD while($row = mysql_fetch_assoc($result)) If you get FOUND: 0 then the query is the problem Link to comment https://forums.phpfreaks.com/topic/170187-solved-information-is-not-displaying-cant-see-why/#findComment-897752 Share on other sites More sharing options...
jigsawsoul Posted August 14, 2009 Author Share Posted August 14, 2009 haha and we found a 0 thanks ill check the query Link to comment https://forums.phpfreaks.com/topic/170187-solved-information-is-not-displaying-cant-see-why/#findComment-897755 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.