ipPHPadmin Posted December 1, 2010 Share Posted December 1, 2010 Hello everyone, I am trying to search through a table in my database using a form. When the form redirects to this page it's just automatically running through the if statement no matter what. Any ideas? Thanks in advance. $HANDI_ID = $_REQUEST["HANDI_ID"]; $query = mysql_query("SELECT * FROM Handicraft WHERE HANDI_ID = '".$HANDI_ID."'"); $numrows = mysql_num_rows($query); echo $HANDI_ID; if($numrows != 1) { ?><h2> Please enter a valid handicraft number. </h2> <meta HTTP-EQUIV="REFRESH" content="5; url=http://www.integratedpeople.org"> <?php } else { ----code i want to display---- } Link to comment https://forums.phpfreaks.com/topic/220319-search-field/ Share on other sites More sharing options...
dawsba Posted December 1, 2010 Share Posted December 1, 2010 if($numrows != 1) should be if($numrows <= 0) Link to comment https://forums.phpfreaks.com/topic/220319-search-field/#findComment-1141682 Share on other sites More sharing options...
ipPHPadmin Posted December 1, 2010 Author Share Posted December 1, 2010 I actually got it past that part now, not exactly sure how though. Now I can't get the third table (Artisan information) table to display. It cuts off at the 'echo "teset" .$ART_ID;' line. It outputs the teset but not the $ART_ID value and from there the rest of the code doesn't display. I made the text red where the problem is starting. Thanks for the help. $HAND_ID = $_REQUEST["HANDI_ID"]; $query = mysql_query("SELECT * FROM Handicraft WHERE HANDI_ID = '$HAND_ID'"); $numrows = mysql_num_rows($query); if($numrows != 1) { ?><h2 align="center"> Please enter a valid handicraft number. </h2> <meta HTTP-EQUIV="REFRESH" content="5; url=http://www.integratedpeople.org"> <?php } else { //Start handicraft table while(mysql_fetch_array($query)) { $ART_ID = $row["ART_ID"]; ?><h2 align="center"> Handicraft found!</h2> <table align = "center" width = "90%" border="0" style="font-size: 12px; margin-top: 30px; font-family: Tahoma;"> <tr> <td align="center">Picture here</td> <td align="center"><b>Handicraft ID: </b> <?php echo $HAND_ID; ?></td> </tr> </table><?php $HandiQuestions = mysql_query("SELECT * FROM HandicraftQuestion ORDER BY HCQ_ID"); ?> <div class="padded"> <table align = "left" width="35%" border="0" style="font-size: 12px; margin-top: 30px; font-family: Tahoma;"> <?php while ($row = mysql_fetch_array($HandiQuestions)) { $QID = $row["HCQ_ID"]; $Ques = $row["HCQ_Question"]; ?> <tr> <td valign="top" align="left" height="70px"> <?php echo "<b>".$QID. ".</b> ".$Ques; ?> </td> </tr> <?php }?></table></div><?php $answers = mysql_query("SELECT * FROM HandicraftAnswer WHERE HANDI_ID = '".$HAND_ID."' ORDER BY HCQ_ID"); ?> <div class="pad"> <table align = "right" width = "35%" border="0" style="font-size: 12px; margin-top: 30px; font-family: Tahoma;"> <?php while ($row = mysql_fetch_array($answers)) { $ans = $row["HCAN_Answer"]; ?> <tr> <td valign="top" align="left" height="70px"> <?php echo $ans; ?> </td> </tr> <?php }?></table></div><?php //Start Artisan table echo "teset" .$ART_ID; $ArtQuery = mysql_query("SELECT * FROM Artisan WHERE ART_ID = '".$ART_ID."'"); while($row = mysql_fetch_array($ArtQuery)) { $A_Name = $row["ART_Name"]; ?> <table align = "center" width = "85%" border="0" style="font-size: 12px; margin-top: 30px; font-family: Tahoma;"> <tr> <td align="right" width="50%">Artisan Name:</td> <td align="left" width="50%"><?php echo $A_Name; ?> </td> </tr> <tr> <td align="right" width="50%">Artisan ID:</td> <td align="left" width="50%"><?php echo $ART_ID; ?></td> </tr> </table> <?php $QuestionQuery = mysql_query("SELECT * FROM ArtisanQuestion ORDER BY ARQ_ID")or die ("Error retrieving artisan questions." . mysql_error()); ?> <div class="padded"> <table align = "left" width="35%" border="0" style="font-size: 12px; margin-top: 30px; font-family: Tahoma;"> <?php while ($row = mysql_fetch_array($QuestionQuery)) { $QuesID = $row["ARQ_ID"]; $Ques = $row["ARQ_Question"]; ?> <tr> <td align="left" height="50px"><?php echo $QuesID. ". ".$Ques; ?></td> </tr> <?php }?></table></div><?php $AnswerQuery = mysql_query("SELECT * FROM ArtisanAnswer WHERE ART_ID = '".$ART_ID."' ORDER BY ARQ_ID "); ?> <table align = "right" width = "35%" border="0" style="font-size: 12px; margin-top: 30px; font-family: Tahoma;"> <?php while ($row = mysql_fetch_array($AnswerQuery)) { $Ans = $row["ARAN_Answer"]; ?> <tr> <td align="left" height="50px"><?php echo $Ans; ?> </td> </tr> <?php } ?></table><?php } } } ?> Link to comment https://forums.phpfreaks.com/topic/220319-search-field/#findComment-1141693 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.