ladysniper
-
Posts
2 -
Joined
-
Last visited
Never
ladysniper's Achievements
Newbie (1/5)
0
Reputation
-
I'm having a HORRIBLE time getting my tables to align after a search. Can anyone look at this code and see just what is wrong with it? To get the search results...go to www.azsoma.info/directory.htm and type 86336 in the zip box and you will get the results.php page. It's got to be in the .php coding itself somewhere, but I cannot for the life of me find it. Any help would be GREATLY appreciated! [code] <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <title>Directory Search Results</title> </head> <body bgcolor="#000000"> <div align="center"> <table width="800" border="1" cellpadding="0" cellspacing="0" height="100%"> <table width ="800" border="1" cellpadding="0" cellspacing="0" height="15%> <tr> <td width="4"></td><td valign="top" align="center" height="19%"> <img border="0" src="images/header3.gif" width="800" height="150"></td></tr></table> <table width ="800" border="1" cellpadding="0" cellspacing="0" height="10%"> <tr> <td width ="800" height="19" bgcolor="e1d7a4" valign="top" align="center"> <p style="margin-left: 25"><br> <font face="Rockwell" size="2" color="#990000"> <font color="FF7256"> <a href="/index.htm"><font color="#990000">Home</font></a></font><font color="#990000"> </font> <font color="FF7256"> <a href="application.htm"><font color="#990000">Member Application</font></a><font color="#990000"> </font> <a href="/membership.htm"><font color="#990000">Member Benefits/Products</font></a><font color="#990000"> </font> <a href="/directory.htm"><font color="#990000">Member Directory</font></a><font color="#990000"> </font> <a href="/news.htm"><font color="#990000">Announcements/News/Links</font></a></font></font></p></td></tr></table> <table width="800" border="1" cellpadding="0" cellspacing="0" align="center"> <tr> <td border="0" valign="top" align="center" colspan="3"><img src="/images/qi-gong2_11.jpg" width="800" height="35" alt=""></td></tr> <tr> <td valign="top" align="right"> <img src="/images/qi-gong2_12.jpg" width="80" height="41" alt=""></td> <td valign="top" align="center"> <img src="/images/qi-gong2_13.jpg" width="599" height="41" alt=""></td> <td valign="top" align="center"> <img src="/images/qi-gong2_14.jpg" width="121" height="41" alt=""></td></tr></table> <table width = "800" border ="1" cellpadding="0" cellspacing="0" align="center" background="images/qi-gong2_16.jpg"> <form method="post" action="http://azsoma.info/results.php"> <!-- <table width="800" border="1" cellpadding="1" cellspacing="0" align="center" background="images/qi-gong2_16.jpg" height="100%"> --> <!-- <tr> <!-- <td width="60" valign="top"><b>id</b></td> --> <!-- <td width="20%"><font size="3" color="990000">Full Name</font></td> --> <!-- <td width="30%"><font size="3" color="990000">Address</font></td> --> <!-- <td width="10%"><font size="3" color="990000">City</font></td> --> <!-- <td width="10%"><font size="3" color="990000">Zip</font></td> --> <!-- <td width="10%"><font size="3" color="990000">Phone</font></td> --> <!-- <td width="20%"><font size="3" color="990000">Website Address</font></td> --> <!-- </tr> --> <tr> <?php //print_r($_POST); //echo "<br>\n"; $hostname = "db353.perfora.net"; // The Thinkhost DB server. $username = "dbo161766556"; // The username you created for this database. $password = "f5BAQ6HB"; // The password you created for the username. $usertable = "Members"; // The name of the table you made. $dbName = "db161766556"; // This is the name of the database you made. MYSQL_CONNECT($hostname, $username, $password) OR DIE("DB connection unavailable"); @mysql_select_db( "$dbName") or die( "Unable to select database"); //error message (not found message)begins // $XX = "No Record Found, to search again please close this window"; /*+-------------------------------------------------------------------------------------+ | Query Details Begin: | +-------------------------------------------------------------------------------------+ | Since I don't know if phpForms has a built in search function and I don't have time | | to try to decipher how they are storing/retrieving information from the tables, | | this is the long way around it but it should work. | +-------------------------------------------------------------------------------------+ | May 2006 - AJM re-edited by RJP | +-------------------------------------------------------------------------------------+*/ /*+-------------------------------------------------------------------------------------+ | First we get all distinct records that have the matching criteria from the search | | page (directory.htm) | +-------------------------------------------------------------------------------------+ | Determine which fields they have used: Name, City, Zip - and build the WHERE clause | +-------------------------------------------------------------------------------------+*/ $sql = "SELECT DISTINCT sub_rec_id " ." FROM pf_submissions " ." WHERE "; if($_POST['Name']>"") $sql .= " (sub_fld_name LIKE '%name%' AND sub_fld_value LIKE '%". $_POST['Name']. "%') AND "; if($_POST['City']>"") $sql .= " (sub_fld_name LIKE '%city%' AND sub_fld_value LIKE '%". $_POST['City']. "%') AND "; if($_POST['Zip']>"") $sql .= " (sub_fld_name LIKE '%zip%' AND sub_fld_value LIKE '%". $_POST['Zip']. "%') AND "; $sql .= " 1=1 " ." ORDER BY sub_rec_id ASC"; //echo "sql=".$sql."<br>\n"; $qry = mysql_query($sql); /*+-------------------------------------------------------------------------------------+ | Now, if there are any records, we'll step through getting the name first. | +-------------------------------------------------------------------------------------+*/ while($row=@mysql_fetch_array($qry)) { $sqlName = "SELECT sub_fld_value " ." FROM pf_submissions " ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " ." AND sub_fld_name = 'Full Name'"; //echo "sqlName=".$sqlName."<br>\n"; $qryName = mysql_query($sqlName); $rowName = @mysql_fetch_row($qryName); //print_r($rowName); //print("<br>\n"); print(" <tr height='20'><td valign='top'><p style='margin-left:150'><font size='2'>".$rowName[0]."</font></td></tr><br>\n"); /*+---------------------------------------------------------------------------------+ | Now, if there are any records, we'll step through getting the office address. | +-----------------------------------------------------------------------------------+*/ $sqlAddress = "SELECT sub_fld_value " ." FROM pf_submissions " ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " ." AND sub_fld_name = 'Office Address'"; // echo "sqlAddress=".$sqlAddress."<br>\n"; $qryAddress = mysql_query($sqlAddress); $rowAddress = @mysql_fetch_row($qryAddress); print(" <tr height='20' valign='top'><td valign='top'><p style='margin-left:150'><font size='2'>".$rowAddress[0]."</font></td></tr><br>\n"); /*+-----------------------------------------------------------------------------------+ | Now, if there are any records, For now we get the Office City. | +-------------------------------------------------------------------------------------+*/ $sqlCity = "SELECT sub_fld_value " ." FROM pf_submissions " ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " ." AND sub_fld_name = 'Office City'"; //echo "sqlCity=".$sqlCity."<br>\n"; $qryCity = mysql_query($sqlCity); $rowCity = @mysql_fetch_row($qryCity); print(" <tr height='20'><td valign='top'><p style='margin-left:150'><font size='2'>".$rowCity[0]."</font></td></tr><br>\n"); /*+-------------------------------------------------------------------------------------+ | Now, if there are any records, we'll step through getting the Office zip. | | RJP 05/17/06 | +-------------------------------------------------------------------------------------+*/ $sqlZip = "SELECT sub_fld_value " ." FROM pf_submissions " ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " ." AND sub_fld_name = 'Office Zip'"; //echo "sqlZip=".$sqlZip."<br>\n"; $qryZip = mysql_query($sqlZip); $rowZip = @mysql_fetch_row($qryZip); print(" <tr height='20'><td valign'top'><p style='margin-left:150'><font size='2'>".$rowZip[0]."</font></td></tr><br>\n"); /*+------------------------------------------------------------------------------------+ | Now, if there are any records, we'll step through getting the Office Phone Number. | | RJP 05/17/06 | +-------------------------------------------------------------------------------------+*/ $sqlPhone = "SELECT sub_fld_value " ." FROM pf_submissions " ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " ." AND sub_fld_name = 'Office Phone'"; //echo "sqlPhone=".$sqlPhone."<br>\n"; $qryPhone = mysql_query($sqlPhone); $rowPhone = @mysql_fetch_row($qryPhone); print(" <tr height='20'><td valign='top'><p style='margin-left:150'><font size='2'>".$rowPhone[0]."</font></td></tr><br>\n"); /*+------------------------------------------------------------------------------------+ | Now, if there are any records, we'll step through getting the Website. RJP 05/17/06 | +-------------------------------------------------------------------------------------+*/ $sqlWeb = "SELECT sub_fld_value " ." FROM pf_submissions " ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " ." AND sub_fld_name = 'Website Address'"; //echo "sqlWeb=".$sqlWeb."<br>\n"; $qryWeb = mysql_query($sqlWeb); $rowWeb = @mysql_fetch_row($qryWeb); print(" <tr height='20'><td valign='top'><p style='margin-left:150'><font size='2'>".$rowWeb[0]."</font></td></tr><br>\n"); /*+-------------------------------------------------------------------------------------+ | Now, if there are any records, we'll step through getting the Birthday? There is no | | Birthday record in the pf_submissions table. If it's somewhere else, need to find | | it and point this query to that table. For now we get the Office City. | +-------------------------------------------------------------------------------------+*/ // $sqlCity = "SELECT sub_fld_value " // ." FROM pf_submissions " // ." WHERE sub_rec_id = '" .$row["sub_rec_id"]. "' " // ." AND sub_fld_name = 'Office City'"; //echo "sqlCity=".$sqlCity."<br>\n"; // $qryCity = mysql_query($sqlCity); // $rowCity = @mysql_fetch_row($qryCity); // echo " <td>".$rowCity[0]."</td>\n"; print(" </p></tr>\n"); } //below this is the function for no record!! if (!$variable1) { print ("$XX"); // echo " </tr>\n"; } //end ?> </table> </table> </div> </body> </html> [/code]
-
I need to take a dropdown search box and change it to stand alone search boxes that will pull from my MySQL db. This is the code I have for the dropdown box: [code] <form method="post" action="http://azsoma.info/results.php" target="_blank"> <div align="center"> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td bordercolor="#000000"> <p align="center"> <select name="metode" size="1"> <option value="Name">Name</option> <option value="City">City</option> <option value="Zip">Zip</option> </select> <input type="text" name="search" size="25"> <br> Search for members: <input type="submit" value="Go!!" name="Search"></p> </td> </tr> </table> </div> [/code] Can someone tell me how to take that same code and make standalone search boxes? Like this: Name(input box) City (input box) Zip(input box) If I just try the regular html code I have? It searches everything and ALL the members in the db shows up. Thanks!