blepblep

Thanks for the reply. I've tried both ways and nothing happens. Even in Chrome when I add return true the Sign Off works as expected, but in IE nothing happens. The button clicks but nothing happens after that. Here is my validateForm() if it is any use? function validateForm() { var x = document.forms[0]["qualityRankingOfReview"].value; if (x == null || x == "") { alert("Quality Ranking of Review field is empty."); return false; } else { if (isNumber(x) != true) { alert("Quality Ranking of Review field is not a number from 0 to 5."); return false; } else if (x > 5) { alert("Quality Ranking of Review field should be a number from 0 to 5."); return false; } }

Nothing at all happens, it doesn't go to the saveMom.php page. It just stays on the form page. Any idea's? If anyone needs more code posted just let me no

Hi, wondering could anyone help me here please. I've two problems - 1) I have a submit button which goes to another page, it works fine in Chrome but not in IE. Heres the code for it - <form action = \"saveMom.php\" method = \"post\" onsubmit = \"return validateForm()\"> .... <input type = \"text\" name = \"signOff\" size = \"24\" align = \"right\" value = \"" . $row['signOff'] . "\"/> <input type=\"submit\" name=\"save\" class = 'eBtnSubmit' value=\"Sign off\" align = \"right\" /> What it does is when Sign Off is clicked, it goes to the saveMom.php file and performs an insert query. This works fine in Chrome but nothing happens in IE, an ideas what could cause this?! And my second problem is - 2) I am trying to retrieve data from 4 tables in a database that all have one common field - reviewId. My query looks like this so far, it doesn't work 100% - It prints out the same values 4 times. "SELECT * FROM review, mom, remark, action WHERE review.reviewId IN( ".$_POST['reviewIds']." )" What I am doing is allowing my users to export the results to an Excel file, the above query opens the Excel file but contains the same value 4 times. Could anyone help me on either problem? Thanks!

Bump

Thanks I managed to get it working. I've just a problem now though, my query works if I want to export everything from the database. $result = mysql_query("SELECT * FROM tc_tool.review"); But when I want to export on user input, so if the user inputs document number 5 say, just to have the option to export that. Here is my query for that but it's not exporting anything to excel, but works in the database? $result = mysql_query("SELECT * FROM tc_tool.review WHERE docNumber like '$docNumber'"); Any ideas how I can export on user input?

No I don't need formatting kicken, that doesnt matter. Just once it displays it under the correct headings. Also I've tried phpexcel and it won't work on my server as the root server doesn't allow it and I cant contact the admin.

Anyone?

I've been looking online and found some things so this is how my code looks at the moment - <?php /* $select = "SELECT * FROM tc_tool.review"; $export = mysql_query($select); $rows = mysql_num_fields($export); */ include 'connect_db.php'; $query = "SELECT * FROM tc_tool.review"; $db->setQuery($query); $rows = $db->loadObjectList(); if ($rows) { function xlsBOF() { echo pack("ssssss", 0x809, 0x8, 0x0, 0x10, 0x0, 0x0); return; }; function xlsEOF() { echo pack("ss", 0x0A, 0x00); return; }; function xlsWriteNumber($Row, $Col, $Value) { echo pack("sssss", 0x203, 14, $Row, $Col, 0x0); echo pack("d", $Value); return; }; function xlsWriteLabel($Row, $Col, $Value ) { $L = strlen($Value); echo pack("ssssss", 0x204, 8 + $L, $Row, $Col, 0x0, $L); echo $Value; return; }; // Send Header header("Pragma: public"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0"); header("Content-Type: application/force-download"); header("Content-Type: application/octet-stream"); header("Content-Type: application/download");; header("Content-Disposition: attachment;filename=export.xls "); header("Content-Transfer-Encoding: binary "); // XLS Data Cell xlsBOF(); xlsWriteLabel(1,0,"Review Forum"); xlsWriteLabel(1,1,"Review ID"); xlsWriteLabel(1,2,"Document Title"); xlsWriteLabel(1,3,"Document Number"); xlsWriteLabel(1,4,"Document Type"); xlsWriteLabel(1,5,"Project Name"); xlsWriteLabel(1,6,"Author Name"); xlsWriteLabel(1,7,"Chairperson"); $xlsRow = 2; $i = 0; foreach ($rows as $item) { $reviewForum = $rows[$i]->reviewForum; $reviewId = $rows[$i]->reviewId; $docTitle = $rows[$i]->docTitle; $docNumber = $rows[$i]->docNumber; $docType = $rows[$i]->docType; $projectName = $rows[$i]->projectName; $authorName = $rows[$i]->authorName; $chairPerson = $rows[$i]->chairPerson; xlsWriteNumber($xlsRow,0,"$reviewForum"); xlsWriteNumber($xlsRow,1,"$reviewId"); xlsWriteNumber($xlsRow,2,"$docTitle"); xlsWriteNumber($xlsRow,3,"$docNumber"); xlsWriteNumber($xlsRow,4,"$docType"); xlsWriteNumber($xlsRow,5,"$projectName"); xlsWriteNumber($xlsRow,6,"$authorName"); xlsWriteNumber($xlsRow,7,"$chairPerson"); $xlsRow++; $i++; }; function xlsWriteString( $Row , $Col , $Value ) { $L = strlen( $Value ); echo pack( "ssssss" , 0x204 , 8 + $L , $Row , $Col , 0x0 , $L ); echo $Value; return; } xlsEOF(); exit(); }; ?> When I run it how the code is above I get this error - Fatal error: Call to a member function setQuery() on a non-object in /opt/htdocs/webpages/TC_Tool/Tool2/tc_tool/exportToExcel.php on line 13 And when I change the query part of the above code to this - <?php include 'connect_db.php'; $select = "SELECT * FROM tc_tool.review"; $export = mysql_query($select); $rows = mysql_num_fields($export); if ($rows) { ....... It downloads but when Excel tries to read the file this is what happens -

Does anyone have any idea what to do?

Thanks for that harristweed! That works but doesn't format it in excel in any way, and it returns the names of the tables how their stored in the database rather than written on the web page like so - Is there any way I can format how it is displayed? And have it named correctly?

Hi people. Need some help if anyone could give a hand! I'm currently trying to incorporate an export to Excel feature on search returns on my web page. Here is how my searches are returned, so what I want now is when the user clicks on the 'Export to Excel' button it downloads the search results and opens it in the same format in Excel. I've tried using http://phpexcel.codeplex.com/ but can't understand how to use it properly, does anyone have any suggestions? I don't have any code written for the Export to Excel yet as it's just a submit button. How I see it in my head is the user clicks the button, it goes to a new page and performs a new query then downloads that but I don't no if thats right or not.

Sorry the above should read: Row was updated. string(40) "Rows matched: 1 Changed: 1 Warnings: 5" I think it's working..

@Adam, how does this look now? ........ WHERE (review_id = '{$post['review_id']}')"; //var_dump($post['review_id']); //----------------------------- // Prints error if there is one //----------------------------- if (!mysql_query($insert_query, $connection)) { echo "Query failed: $query<br />" . mysql_error(); } if (mysql_affected_rows() === 1) { echo "Row was updated." . "<br />"; } else { echo "nothing affected" . "<br />"; } var_dump(mysql_info()); function died($error) { // Error code here echo "Error, not saving successfully. "; echo "The errors are below.<br /><br />"; echo $error."<br /><br />"; echo "Please retry.<br /><br />"; //var_dump($_POST); die(); } When I run it how it is above this is my output: nothing affected string(40) "Rows matched: 1 Changed: 0 Warnings: 6" The 'Changed' in the above changes if I enter new data, working so I presume?

Done Muddy, this is returned: bool(false) nothing affected @PFMaBiSmAd - <?php ///------------------------ /// Connecting to database ///------------------------ include 'connect_db.php'; ///----------------------------- /// Inserting data into database ///----------------------------- function sanitize_data($data) // create the function sanitize_data { $data = mysql_real_escape_string(trim($data)); return $data; } $post = array(); foreach($_POST as $key =>$value){ $post[$key] = sanitize_data($value); // call sanitize_data using each value from the $post array } $id = $post['review_id']; //var_dump($id); if(isset($post['save'])) { $insert_query = "UPDATE tc_tool.forms SET quality_ranking_review = '{$post['quality_ranking_review']}', input_doc_rank = '{$post['input_doc_rank']}', correct_doc = '{$post['correct_doc']}', internally_reviewed = '{$post['internally_reviewed']}', reqs_covered = '{$post['reqs_covered']}', correct_storage_library = '{$post['correct_storage_library']}', reports_described = '{$post['reports_described']}', approved_change_requests_included = '{$post['approved_change_requests_included']}', issues_addressed = '{$post['issues_addressed']}', doc_available = '{$post['doc_available']}', statement_problem_chapter = '{$post['statement_problem_chapter']}', major_comments = '{$post['major_comments']}', result = '{$post['result']}', num_of_major_comments = '{$post['num_of_major_comments']}', minor_comments = '{$post['minor_comments']}', next_review_forum = '{$post['minor_comments']}', date = '{$post['date']}', time = '{$post['time']}', venue = '{$post['venue']}', time2 = '{$post['time2']}', location = '{$post['location']}', severity = '{$post['severity']}', resp = '{$post['resp']}', status = '{$post['status']}', comment = '{$post['comment']}', remark = '{$post['remark']}', miscellaneous = '{$post['miscellaneous']}' WHERE (review_id = '{$post['review_id']}')"; //var_dump($post['review_id']); var_dump(mysql_info()); if (mysql_affected_rows() === 1) { echo 'Row was updated.'; } else { echo "nothing affected"; } //----------------------------- // Prints error if there is one //----------------------------- if (!mysql_query($insert_query, $connection)) { echo "Query failed: $query<br />" . mysql_error(); } function died($error) { // Error code here echo "Error, not saving successfully. "; echo "The errors are below.<br /><br />"; echo $error."<br /><br />"; echo "Please retry.<br /><br />"; var_dump($_POST); die(); } mysql_close($connection); } ?>

This is what I get Adam (everything that is returned to me on my screen) - int(-1) nothing affected But it still updates the row..

Yeah, it's updating the rows now I didn't change anything apart from what you guys said on here so I don't no why its working all of a sudden. When I done this Muddy - if (mysql_affected_rows() === 1) { echo 'Row was updated.'; } else { echo "nothing affected"; } It print's out 'nothing affected' but still updates the row...

@Adam, the code hasn't changed, I was in the middle of asking where did Muddy get the 'or die' from, thats all. The error's I'm showing you here is exactly what comes up on my screen when I try to update the record. I've changed JUST my error to this - if (!mysql_query($insert_query, $connection)) { echo "Query failed: $query<br />" . mysql_error() . "<br>-----------------------<br>$insert_query"; } It's still working, but doesnt print out 'Row was updated'. When I have it like this it prints out 'Row was updated' mysql_query($insert_query) or die (mysql_error()."<br>-----------------------<br>$insert_query"); if (mysql_affected_rows() === 1) { echo 'Row was updated.'; } //----------------------------- // Prints error if there is one //----------------------------- if (!mysql_query($insert_query, $connection)) { echo "Query failed: $query<br />" . mysql_error(); }

@jesirose, no, it's just to save from posting a long amount of code each time. @Adam yeah I get you, I'm updating a row so it's an UPDATE, thanks @Muddy, I just added in this mysql_query($insert_query) or die (mysql_error()."<br>-----------------------<br>$insert_query"); Underneath this - WHERE (review_id = '{$post['review_id']}')"; //var_dump($post['review_id']); And its all working now?!

I get this error when I add that - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (review_id = '407')' at line 31 So theres something wrong with this I think - WHERE (review_id = '{$post['review_id']}')"; This is so annoying why wont it work!!!! I thought this part would be easy to do EDIT* To clarify, I'm still doing an UPDATE yeah? Not INSERT? $insert_query = "UPDATE tc_tool.forms SET quality_ranking_review = '{$post['quality_ranking_review']}', ................ WHERE (review_id = '{$post['review_id']}')";

@Adam, cool thanks I understand what you mean now. If I use INSERT though will that not create a new ID instead of saving to the ID it already has? That it was doing originally - saving the data correctly but saving it as a new review_id instead of the ID it already has. @Muddy, I done this - Form code- <table id = "templateHeading"> <form action = "saveMom.php" method = "post"> <tr> <th><h2>MOM</h2></th> <th><input type = "text" name = "booking_number" size = "16" value = "" readonly = "readonly"/></th> <input type="hidden" id="review_id" name="review_id" value="$id" /> Query in saveMom.php- function sanitize_data($data) // create the function sanitize_data { $data = mysql_real_escape_string(trim($data)); return $data; } $post = array(); foreach($_POST as $key =>$value){ $post[$key] = sanitize_data($value); // call sanitize_data using each value from the $post array } $id = $post['review_id']; if(isset($post['save'])) { $insert_query = "UPDATE tc_tool.forms SET quality_ranking_review = '{$post['quality_ranking_review']}', ....... WHERE (review_id = '{$post['review_id']}')"; When I run it how it is above, I get no error but still nothing stores

Thanks Muddy, I changed them there. Didn't realise there was a difference. @Adam, cool thanks. The review ID is generated automatically in my database, it's the primary key and whenever a form is submitted/submit button is clicked, the review_id increments each time. Should I have something like $insert_query = "UPDATE tc_tool.forms SET review_id = '{$post['review_id']}', in my file that I am using to save the data with the ID?

Here it is so, just the form part. Muddy the rest of this file is what we were doing in the last thread, searching for the ID <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel = "stylesheet" type = "text/css" href = "stylesheet.css" /> </head> <script type="text/javascript" language="JavaScript"><!-- function ReverseDisplay(d) { if(document.getElementById(d).style.display == "none") { document.getElementById(d).style.display = "block"; } else { document.getElementById(d).style.display = "none"; } } //--></script> <p></p> <div> <a href="javascript:ReverseDisplay('mom')"> <input type = "button" value = "Show/Hide MOM" /> </a> </div> <div id="mom" style="display:none;"> <p><body> <div style = "width:100%;border:2px dotted #666666;padding:10px 10px 10px 10px;"> <table id = "templateHeading"> <form action = "saveMom.php" method = "post"> <tr> <th><h2>MOM</h2></th> <th><input type = "text" name = "booking_number" size = "16" value = "" readonly = "readonly"/></th> </tr> <tr> <th><u>Quality Ranking of Review</u></th> </tr> <tr> <td>Quality ranking of Review (1-5)</td> </tr> <tr> <td>(To be completed by TC chairperson)</td> </tr> <tr> <td>1 = Undefined</td> </tr> <tr> <td>2 = Document not of sufficient quality to review, missing chapters, clear competence or schedule issue apparent in the review.</td> </tr> <tr> <td>3 = Insufficient participants in the review or insufficient preparation from participants.</td> </tr> <tr> <td>4 = Proper review with some major open issues but in control.</td> </tr> <tr> <td>5 = Proper review with no major open issues.</td> </tr> <tr> <td><input type = "text" name = "quality_ranking_review" size = "1"/></td> </tr> <tr> <th><u>Quality ranking of input document (1-10):</u></th> </tr> <tr> <td><size = "2"><b>Criteria: Score - 1 = Yes or 0 = No</b></td> <td><input type = "text" name = "input_doc_rank" size = "1"/></td> </tr> <tr> <td><size = "2"><b>___________________________</b></td> </tr> <tr> <td>To be completed by TC chairperson using TCOSSRC document checklist</td> </tr> <!-- SET THIS TO BOOL IN DATABASE --> <tr> <td>Has the correct document instruction/template been followed?</td> <td><input type = "text" name = "correct_doc" size = "1"/> </tr> <tr> <td>Has the document been internally reviewed?</td> <td><input type = "text" name = "internally_reviewed" size = "1"/> </tr> <tr> <td>Does the requirements chapter state whether all requirements have been covered, and explain why specific requirements<br /> are not covered?</td> <td><input type = "text" name = "reqs_covered" size = "1"/> </tr> <tr> <td>Is the document stored in the correct storage library with the correct status?</td> <td><input type = "text" name = "correct_storage_library" size = "1"/> </tr> <tr> <td>Have all trouble reports for faults corrected by the system modifications been described? It should be obvious which<br /> applications were investigated to find all relevant trouble reports</td> <td><input type = "text" name = "reports_described" size = "1"/> </tr> <tr> <td>Have all approved change requests been included?</td> <td><input type = "text" name = "approved_change_requests_included" size = "1"/> </tr> <tr> <td>Are all open issues addressed?</td> <td><input type = "text" name = "issues_addressed" size = "1"/> </tr> <tr> <td>Has the document been available at least 5 working days before the review date?</td> <td><input type = "text" name = "doc_available" size = "1"/> </tr> <tr> <td>Does the Technical Solution chapter describe the solution to the problems described in the Statement of Problem chapter?</td> <td><input type = "text" name = "statement_problem_chapter" size = "1"/> </tr> <tr> <td>Are there more than 50% major comments? <b>Yes = 0 No = 1</b></td> <td><input type = "text" name = "major_comments" size = "1"/> </tr> <tr> <th><u>Review Summary<u></th> </tr> <tr> <td>Result</td> <td><select name = "result"> <option value = '' SELECTED>-Please Select-</option> <option value = "Approved">Approved</option> <option value = "Not Approved">Not Approved</option> <option value = "Cancelled">Cancelled</option> </select> </td> </tr> <tr> <td>No. of Major Comments</td> <td><input type = "text" name = "num_of_major_comments" size = "1"/> </tr> <tr> <td>No. of Minor Comments</td> <td><input type = "text" name = "minor_comments" size = "1"/> </tr> <tr> <td>Next Review Forum</td> <td><select name = "next_review_forum"> <option value = '' SELECTED>-Please Select-</option> <option value = "N/A">N/A</option> <option value = "Re Review Full">Re-Review Full</option> <option value = "Re Review Simplified">Re-Review Simplified</option> </select> </td> </tr> <tr> <th><u>Particulars of Meeting</u></th> </tr> <tr> <td>Date</td> <td><input type = "text" name = "date" size = "4"/> </tr> <tr> <td>Time</td> <td><select name = "time"> <option value = '' SELECTED>-Please Select a Time-</option> <option value = "0800">08:00</option> <option value = "0900">09:00</option> <option value = "1000">10:00</option> <option value = "1100">11:00</option> <option value = "1200">12:00</option> <option value = "1300">13:00</option> <option value = "1400">14:00</option> <option value = "1500">15:00</option> <option value = "1600">16:00</option> <option value = "1700">17:00</option> <option value = "1800">18:00</option> <option value = "1900">19:00</option> </select> </td> </tr> <tr> <td>Venue</td> <td><select name = "venue"> <option value = '' SELECTED>-Please Select-</option> <option value = "Lough Mask">Lough Mask</option> <option value = "Lough Neagh">Lough Neagh</option> <option value = "Lough Sheelin">Lough Sheelin</option> <option value = "Lough Allen">Lough Allen</option> <option value = "Shaw">Shaw</option> <option value = "Beckett">Beckett</option> <option value = "Yeats">Yeats</option> <option value = "Heaney">Heaney</option> <option value = "Tyndall">Tyndall</option> <option value = "Lilliput">Lilliput</option> <option value = "Lough Ree">Lough Ree</option> <option value = "Goldsmith">Goldsmith</option> <option value = "Kelvin Meeting Room">Kelvin Meeting Room</option> <option value = "Blyry">Blyry</option> <option value = "Lough Conn">Lough Conn</option> <option value = "Lough Corrib">Lough Corrib</option> <option value = "Lough Derg">Lough Derg</option> <option value = "Lough Owell">Lough Owell</option> <option value = "OSS Demo Room">OSS Demo Room</option> <option value = "Synge Conference Room">Synge Conference Room</option> <option value = "Annexe Conference Room">Annexe Conference Room</option> <option value = "Lars Magnus">Lars Magnus</option> <option value - "Office">Office</option> </select> </td> </tr> <tr> <th><u>Actions<u></th> </tr> <tr> <td>Type</td> <td><select name = "type"> <option value = '' SELECTED>-Please Select-</option> <option value = "remark">Remark</option> <option value = "action">Action</option> </select> </td> </tr> <tr> <td>Time</td> <td><select name = "time"> <option value = '' SELECTED>-Please Select a Time-</option> <option value = "0800">08:00</option> <option value = "0900">09:00</option> <option value = "1000">10:00</option> <option value = "1100">11:00</option> <option value = "1200">12:00</option> <option value = "1300">13:00</option> <option value = "1400">14:00</option> <option value = "1500">15:00</option> <option value = "1600">16:00</option> <option value = "1700">17:00</option> <option value = "1800">18:00</option> <option value = "1900">19:00</option> </select> </td> </tr> <tr> <td>Location</td> <td><input type = "text" name = "location" size = "10"/> </tr> <tr> <td>Severity</td> <td><input type = "text" name = "severity" size = "10"/> </tr> <tr> <td>Resp</td> <td><input type = "text" name = "resp" size = "10"/> </tr> <tr> <td>Status</td> <td><input type = "text" name = "Status" size = "10"/> </tr> <tr> <td>Comment</td> <td><textarea name = "comment" cols = 40 rows = 6/></textarea></td> </tr> <tr> <td>Remark</td> <td><select name = "remark"> <option value = '' SELECTED>-Please Select-</option> <option value = "Remark">Remark Acted</option> <option value = "Action">Remark Not ccepted</option> </select> </td> </tr> <tr> <td>Miscellaneous</td> <td><textarea name = "miscellaneous" cols = 40 rows = 6/></textarea></td> </tr> <tr> <td> <input type="button" name="reset_form" value="Clear Fields" onclick="this.form.reset();"> <input type="submit" name="save" value="Save MOM" /> </td> </tr> <!-- -------------------------------------------------------------------------------- --> </table> </form> </body> </html> </p> </div>

I don't no how to multiquote sorry. @Adam - Thanks, I've done this: WHERE (review_id = '{$post['review_id']}')"; var_dump($post['review_id']); if (mysql_affected_rows() == 1) { echo 'Row was updated.'; } Did you mean to put 3 === in the msql_affected_rows function? I changed it to two. My result when I var_dump()ed review_id was NULL @Muddy, I'll send it in a PM because its wayyy too long to post here, nearly 600 lines.

Woo Muddy! Yes, review_id is the field in the database that the ID defines each record: My code up to date is below: <?php include 'connect_db.php'; function sanitize_data($data) // create the function sanitize_data { $data = mysql_real_escape_string(trim($data)); return $data; } $post = array(); foreach($_POST as $key =>$value){ $post[$key] = sanitize_data($value); // call sanitize_data using each value from the $post array } //var_dump($post); if(isset($post['save'])) { $insert_query = "UPDATE tc_tool.forms SET quality_ranking_review = '{$post['quality_ranking_review']}', input_doc_rank = '{$post['input_doc_rank']}', correct_doc = '{$post['correct_doc']}', internally_reviewed = '{$post['internally_reviewed']}', reqs_covered = '{$post['reqs_covered']}', correct_storage_library = '{$post['correct_storage_library']}', reports_described = '{$post['reports_described']}', approved_change_requests_included = '{$post['approved_change_requests_included']}', issues_addressed = '{$post['issues_addressed']}', doc_available = '{$post['doc_available']}', statement_problem_chapter = '{$post['statement_problem_chapter']}', major_comments = '{$post['major_comments']}', result = '{$post['result']}', num_of_major_comments = '{$post['num_of_major_comments']}', minor_comments = '{$post['minor_comments']}', next_review_forum = '{$post['minor_comments']}', date = '{$post['date']}', time = '{$post['time']}', venue = '{$post['venue']}', time2 = '{$post['time2']}', location = '{$post['location']}', severity = '{$post['severity']}', resp = '{$post['resp']}', status = '{$post['status']}', comment = '{$post['comment']}', remark = '{$post['remark']}', miscellaneous = '{$post['miscellaneous']}' WHERE (review_id = '{$post['review_id']}')"; if (!mysql_query($insert_query, $connection)) { echo "Query failed: $query<br />" . mysql_error(); } function died($error) { // Error code here echo "Error, not saving successfully. "; echo "The errors are below.<br /><br />"; echo $error."<br /><br />"; echo "Please retry.<br /><br />"; var_dump($_POST); die(); } mysql_close($connection); } ?> It's weird because it's not printing out any errors, but also not storing in the database atall now.. I'm nearly sure it has something to do with this line: WHERE (review_id = '{$post['review_id']}')"; I don't no if you remember from the other thread you helped me in but I have nothing in my code defining review_id, although I have $id, done like below: if (isset($post['searchReviewForum']) && $post['searchbyforumtype'] != '') { $id = $post['searchbyforumtype']; $sql = <<<SQL

Bump