CountryGirl

Sorry if this is the wrong board to put this under, but . . . How do I edit older posts that I've done? There's a link I want to remove from some of my posts, but I can't figure out how to edit the post! Thanks!

Is there a freeware program out there that works similarly to SQLyog to convert an MS Access DB to MySQL? This is the only program that will work with the company my website is hosted through, but I didn't want to have to buy it if I didn't need to (since I've used the trial version already). So, I thought I'd see if there's a freeware program that works similarly. Thanks!

What value are you talking about when it comes to the $search? Maybe that's where I'm confused. I haven't specified any value to it or length of anything. Maybe you could explain a little? Yes, I just tried the "=" several times and with several different combinations. And nothing works. It still is only returning some and not returning others, that I know are in the database. The definition of that column I'm trying to search from are account numbers. They are all the same length and are 9 numbers long. If you have suggestions on a better way to do something, that'd be great! I am really lost in how to fix this problem. Thanks!

When I put the code example you gave and I searched an account number, this is what I get: No results show up at all though. I'm not sure what you mean by "where is ' $_POST['search']' coming from?" . . . Is that where my problem is? Should I have something else there? Thanks!

In one of my searches, some of the searched queries aren't returning, even though I know the data is in the database. I've run searches in my PHPMyAdmin to make sure the account number I'm searching with is in the DB and it is. But, when I run the search with the account number, nothing pulls up. Just an empty result. My search coding is below. My coding is working totally fine with my other searches, it just won't pull up every record searched with this search, even though it is in the DB. Exact search query: $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Appr_Value.Account LIKE '{$search}' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); My whole coding: $search = $_POST['search']; if ($search) // perform search only if a string was entered. { $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Appr_Value.Account LIKE '{$search}' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); if ($result) { echo "Results:<br><br>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#4A6B3F>Account</td> <td align=center bgcolor=#4A6B3F>Owners Name</td> <td align=center bgcolor=#4A6B3F>Situs</td> </tr>"; while ($r = mysql_fetch_array($result)) { // Begin while $act = $r["Account"]; $name = $r["OwnersName"]; $situs = $r["Situs"]; echo "<tr> <td><a href='formresults.php?id=".$r['id']."'>$act</td> <td>$name</td> <td>$situs</td> </tr>"; } // end while echo "</table>"; } else { echo "Sorry, please try your search again."; } } else { echo ""; } ?> Thanks!

Thanks guys! I figured it was something like that, just wasn't sure of the exact thing to do .

The code I'm using for my search is: WHERE Asmnt_Parcel.OwnersName LIKE '{$search}' Now, this works for two of the searches I've built. But, I'm needing the results to return a bit differently on this search page. I can't just type in someone's last name, like "Bennett" and have all "Bennett"s show up in the results. It'll only return exact results (which is good for the other two searches), so someone has to enter the full name as it is in the database, like "Bennett, John P." What would be the best way to let people do more "general" searches? This is the rest of my coding incase it'll help answer my question any ~ $search = $_POST['search']; if ($search) // perform search only if a string was entered. { $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Asmnt_Parcel.OwnersName LIKE '{$search}' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); if ($result) { echo "Results:<br><br>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#4A6B3F>Account</td> <td align=center bgcolor=#4A6B3F>Owners Name</td> <td align=center bgcolor=#4A6B3F>Situs</td> </tr>"; while ($r = mysql_fetch_array($result)) { // Begin while $act = $r["Account"]; $name = $r["OwnersName"]; $situs = $r["Situs"]; echo "<tr> <td><a href='formresults.php?id=".$r['id']."'>$act</td> <td>$name</td> <td>$situs</td> </tr>"; } // end while echo "</table>"; } else { echo "Sorry, please try your search again."; } } else { echo ""; } ?> Thanks for any tips, advice & help!

Thank you!! I changed my WHERE clause to just be WHERE Appr_Value.ApprID = '{$apprID}' . And I got the correct results! This is so great! You've been a huge help! Qadoshyah

THANK YOU SO MUCH!! That is a huge help! Now I can visually see it all and it makes much more sense. It's not returning any results, which doesn't make any sense to me. Since everything looks correct (I've read over it several times). I'm going to come back to it later, but if you have any ideas off the top of your head, let me know . If you go to www.wagonerassessor.com/searchlink.php and use something like "730000450" to search, you'll be able to follow the linked account number to the detailed search page. It's coming up, but just doesn't have any results in it. I'll have to look at it more later to see if I'm missing something or what's going on. Thanks so much again !

You still confused? Basically, mjdamato is telling you what a good approach is. Though it may be a bit more complicated than you wanted it to be. He's basically telling you that you should keep PHP code and HTML code separate so they don't look like a mess. Since you already have the HTML, you can use it as a template, which you can think of as a Mad Lib story lol. Basically, you have some text, and you just want to replace a value here and there. That is simple. In your PHP code (the one you have now), you've done the query and now, you just have to put them in the HTML. This is easy. Just replace them with the respective variable. For example: <?php $dbHost = ''; $dbUser = ''; $dbPass = ''; $dbDatabase = ''; $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Appr_Value.Account LIKE '{$search}' AND Appr_Value.ApprID = '".mysql_real_escape_string($_GET['id'])."' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); ?> .. some HTML ... <span><?php echo $result['name']; ?></span> .. some more HTML ... Does that help or not? Yes, that does help. That is more what I was looking for. Thank you. I will keep the information mjdamato has written and look into it more. But, at the moment I'm just trying to get something up. I can always go back and revise. Yes, I know I should read up more on PHP and I plan to do that. But, at the moment since I know the basics of it, this is where I'm at. Sorry if these are stupid questions, but the help is really appreciated . Okay, back to this code. This is what I've put on my page. I'm not returning any results for some reason though, even though I know there are results in these spots (that return on the not as detailed page). Where am I going wrong at? PHP: $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account WHERE Appr_Value.Account LIKE '{$search}' AND Appr_Value.ApprID = '".mysql_real_escape_string($_GET['id'])."' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); ?> Some of the HTML: <td><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Account:</strong></font><span><?php echo $result['Appr_Value.Account'];?></span> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Name:</strong></font></p><span><?php echo $result['Asmnt_Parcel.OwnersName'];?></span> Thanks for the help!

Hmm, okay. I'll try to figure it out. Thanks.

Okay, I'm a little lost. This doesn't make all that much sense to me, as I think I just need a few more things explained. Sorry, but yes I am quite new to PHP :-\. Questions: Do I need to create something like these: " $name = htmlentities($record['OwnersName']); $nameid = htmlentities($record['NameID']); " for each result I want in my HTML? And the formatting? What exactly does that do? Tie in the results to the PHP? If someone could break this down a bit more for me, that'd be very appreciated! Thanks!

My initial search result page only returns a few results (as I want) and then the account number is linked to a more detailed search result page (www.wagonerassessor.com/searchlink.php - search example "730000003"). Now, I gotta be able to have the detailed results show up in the appropriate spaces on a page that looks like this - www.wagonerassessor.com/formresults.html, just in a .php page. I'm sure it's not too difficult and it's just a matter of linking the $result to the tables. But, how exactly would I do that? Would I add the table/field name to the right spot in the table HTML and then have it linked back to the PHP coding? Here's the code I have on formresults.php. I know I have some extra coding in there, that I'm not going to use (in the $result) spot, but I'm thinking I probably have to tie in all that table HTML somehow similarily to how the $result table area is. Ideas? Suggestions? Any help is greatly appreciated! <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <?php $dbHost = $dbUser = $dbPass = $dbDatabase = $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Appr_Value.Account LIKE '{$search}' AND Appr_Value.ApprID = '".mysql_real_escape_string($_GET['id'])."' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); if ($result) { echo "Results:<br><br>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#4A6B3F>Account</td> </tr>"; while ($r = mysql_fetch_array($result)) { // Begin while $act = $r["Account"]; echo "<tr> <td>$act</td> </tr>"; } // end while echo "</table>"; ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <meta name="generator" content="Adobe GoLive" /> <title>Search Results</title> </head> <body background="(EmptyReference!)" bgcolor="#bba86d"> <div align="left"> </div> <div align="center"> <div style="position:relative;width:871px;height:912px;-adbe-g:p;"> <div style="position:absolute;top:384px;left:2px;width:434px;height:138px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr align="left"> <td><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Account:</strong></font> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Name ID:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Address:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Situs:</strong></font></p> </td> </tr> </table> </div> <div style="position:absolute;top:384px;left:436px;width:434px;height:122px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Instrument Number:</strong></font> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Grantor:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Sale Date:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Sale Price:</strong></font></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:544px;left:2px;width:434px;height:69px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr align="right"> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Legal Description:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:350px;left:34px;width:800px;height:33px;"> <table width="800" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="center"> <font size="4" color="#003300" face="Georgia, Times New Roman, Times, serif">Wagoner County Public Records Search Results:</font></div> </td> </tr> </table> </div> <div style="position:absolute;top:544px;left:436px;width:434px;height:94px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr align="right"> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Exemption Type:</strong></font> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Exemption:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Code:</strong></font></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:1px;width:209px;height:77px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Land Value:</strong></font></div> <p></p> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:227px;width:209px;height:77px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Improvements:</strong></font></div> <p></p> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:437px;width:209px;height:77px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Mobile Home:</strong></font></div> <p></p> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:659px;width:209px;height:69px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Total Value:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:752px;left:128px;width:306px;height:69px;"> <table width="306" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Assessed Value:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:752px;left:436px;width:306px;height:69px;"> <table width="306" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Total Taxable:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:0px;left:111px;width:648px;height:350px;"> <img src="toplogo3.jpg" alt="" height="350" width="648" border="0" /></div> </div> <p></p> </div> </body> </html> Thank you!

Okay, as I figured, another question. Now, I gotta be able to have the detailed results show up in the appropriate spaces. I'm sure it's not too difficult and it's just a matter of linking the $result to the tables. But, how exactly would I do that? Would I add the table/field name to the right spot in the table HTML and then have it linked back to the PHP coding? Here's the code I have on formresults.php. I know I have some extra coding in there, that I'm not going to use (in the $result) spot, but I'm thinking I probably have to tie in all that table HTML somehow similarily to how the $result table area is. Ideas? Suggestions? [code=php:0]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <?php $dbHost = 'sql5c25d.carrierzone.com'; $dbUser = 'wagonerass854431'; $dbPass = 'W5485H6551'; $dbDatabase = 'fix_wagonerassessor_com'; $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.ApprID as id, Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Appr_Value.Account LIKE '{$search}' AND Appr_Value.ApprID = '".mysql_real_escape_string($_GET['id'])."' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); if ($result) { echo "Results:<br><br>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#4A6B3F>Account</td> </tr>"; while ($r = mysql_fetch_array($result)) { // Begin while $act = $r["Account"]; echo "<tr> <td>$act</td> </tr>"; } // end while echo "</table>"; ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html;charset=utf-8" /> <meta name="generator" content="Adobe GoLive" /> <title>Search Results</title> </head> <body background="(EmptyReference!)" bgcolor="#bba86d"> <div align="left"> </div> <div align="center"> <div style="position:relative;width:871px;height:912px;-adbe-g:p;"> <div style="position:absolute;top:384px;left:2px;width:434px;height:138px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr align="left"> <td><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Account:</strong></font> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Name ID:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Address:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Situs:</strong></font></p> </td> </tr> </table> </div> <div style="position:absolute;top:384px;left:436px;width:434px;height:122px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Instrument Number:</strong></font> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Grantor:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Sale Date:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Sale Price:</strong></font></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:544px;left:2px;width:434px;height:69px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr align="right"> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Legal Description:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:350px;left:34px;width:800px;height:33px;"> <table width="800" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="center"> <font size="4" color="#003300" face="Georgia, Times New Roman, Times, serif">Wagoner County Public Records Search Results:</font></div> </td> </tr> </table> </div> <div style="position:absolute;top:544px;left:436px;width:434px;height:94px;"> <table width="434" border="1" cellspacing="2" cellpadding="0"> <tr align="right"> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Exemption Type:</strong></font> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Exemption:</strong></font></p> <p><font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Code:</strong></font></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:1px;width:209px;height:77px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Land Value:</strong></font></div> <p></p> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:227px;width:209px;height:77px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Improvements:</strong></font></div> <p></p> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:437px;width:209px;height:77px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Mobile Home:</strong></font></div> <p></p> </td> </tr> </table> </div> <div style="position:absolute;top:656px;left:659px;width:209px;height:69px;"> <table width="209" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Total Value:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:752px;left:128px;width:306px;height:69px;"> <table width="306" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Assessed Value:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:752px;left:436px;width:306px;height:69px;"> <table width="306" border="1" cellspacing="2" cellpadding="0"> <tr> <td> <div align="left"> <font size="2" color="#352200" face="Georgia, Times New Roman, Times, serif"><strong>Total Taxable:</strong></font> <p></p> </div> </td> </tr> </table> </div> <div style="position:absolute;top:0px;left:111px;width:648px;height:350px;"> <img src="toplogo3.jpg" alt="" height="350" width="648" border="0" /></div> </div> <p></p> </div> </body> </html> [/code] Thank you!

Thank you so much!! That worked (www.wagonerassessor.com/searchlink.php). Now, I just gotta get the formresults.php figured out completely. I will probably be back with more questions as I work on the detailed results page . Again, thank you so much! I've been stressin' over how to get this all figured out and couldn't find anywhere on how exactly to do it .

Okay, I was wondering that. I have an ID (an Appr_ID) that relates most of the tables together, but then some of the tables are related together by an Account number. Because not all the tables have an Appr_ID. The Appr_ID is my primary key (on the Appr_Value table). There is one table that has Appr_ID & Account and that table (my base one in the code - Appr_Value) is what links the Appr_ID to the account numbers. Which is why I was linking some of it by Account, but I could switch some of the coding to have it link by the ID number. Seeing my code, what would you suggest as far as coding goes for trying to link it to a more detailed search results page? Qadoshyah

Thanks! Here's my code: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd"> [code=php:0]<?php $dbHost = $dbUser = $dbPass = $dbDatabase = $search = $_POST['search']; if ($search) // perform search only if a string was entered. { $con = mysql_connect($dbHost, $dbUser, $dbPass) or die("Failed to connect to MySQL Server. Error: " . mysql_error()); mysql_select_db($dbDatabase) or die("Failed to connect to database {$dbDatabase}. Error: " . mysql_error()); $query = "SELECT Appr_Value.Account, Asmnt_Parcel.OwnersName, Asmnt_Situs.Situs FROM Appr_Value INNER JOIN Asmnt_Parcel ON Appr_Value.Account=Asmnt_Parcel.Account INNER JOIN Asmnt_Situs ON Appr_Value.Account=Asmnt_Situs.Account WHERE Appr_Value.Account LIKE '{$search}' ORDER BY Appr_Value.Account ASC"; $result = mysql_query($query, $con) or die(mysql_error().": $query"); if ($result) { echo "Results:<br><br>"; echo "<table width=90% align=center border=1><tr> <td align=center bgcolor=#4A6B3F>Account</td> <td align=center bgcolor=#4A6B3F>Owners Name</td> <td align=center bgcolor=#4A6B3F>Situs</td> </tr>"; while ($r = mysql_fetch_array($result)) { // Begin while $act = $r["Account"]; $name = $r["OwnersName"]; $situs = $r["Situs"]; echo "<tr> <td>$act</td> <td>$name</td> <td>$situs</td> </tr>"; } // end while echo "</table>"; } else { echo "Sorry, please try your search again."; } } else { echo "Start your search"; } ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head><title>Searching Another Test</title> </head> <body bgcolor="#bba86d"> <div align="center"> </div> <h1></h1> <h1></h1> <h1>Search Records</h1> <form method="post" action="searchjoin2.php"> <table width=90% align=center> <tr><td>Search:</td><td><input type=text name='search' size=60 maxlength=255></td></tr> <td></td> <td><input type=submit value="Search Records"></td> </tr> </table> </form> <p></p> <p></p> </body> </html>[/code] If there's anymore you could add that'll help with my code, that'd be great. I think I get the general idea of what I need to do, but if there's anything you can be more specific about with seeing my code, that'd be great. I'm quite new to PHP, so, thanks for any and all help!

Hi all, I am trying to make a link from a PHP search result. To see what I'm trying to do, you can go to this page that I'm working on - www.wagonerassessor.com/searchjoin2.php. You can search by "730000450." I want to link the account number on the results to another results page that has more detailed information about that specific account. I want to link it to this page that'll have specified results on it, www.wagonerassessor.com/formresults.html. How do I create a link in PHP search results? Thank you!

Okay, is there any site or tutorial on that, since I'm no pro at PHP/MySQL at the moment . Thanks! I'll take a look at the PHP Doctrine link you sent too.

I'm trying to make my database layout more organized and therefore am making it a relational database. I need foreign keys to be able to do so, from what I understand. At the moment my database type is MyISAM, but foreign keys aren't available in MyISAM. So, I need InnoDB. The web hosting company for the website I’m working on says their server does not support an InnoDB type. At the moment, my database format is MyISAM. I know how to change the database format. Is there a way to use something in MyISAM as the foreign keys? Like apply a Unique key to a table. Or, do I have to use an InnoDB type? This isn’t the first time the company has claimed their server doesn’t support something with PHP/MySQL. So, if I push hard enough I might be able to get around this, as I have been able to do before . But, I thought I’d see if there’s a way that I could do this without using InnoDB. Thanks for any tips/info! Qadoshyah

I talked to them again today and since I threatened to leave the company, they actually do have a way that I can convert an Access DB into the PHP. They're supposed to be calling me back with all that info. We'll see how it goes. Thanks guys!

Hi all, Alright, I've run into an issue (again!) with our web hosting server. They have been a complete nightmare since we switched to them 3 months ago. The company I'm working for gives me all their data in a Microsoft Access database, so since I'm using PHP & MySQL, obviously I have to convert the Access DB to an SQL DB. I have the BullZip MS Access to MySQL and it's working fine. But, I keep getting an error message saying "Access denied for user such and such." Now, this is an error message I've gotten before when trying to do certain things in the PHPMyAdmin, so I know this is something at the server's end. I called them last Friday to have them look into it. Today I heard back from them and I'm shocked with what I was told. They said that their company does not support database conversion. So, basically there's nothing I can do with all the data that I have to get into the PHP database on their server. This is such a simple conversion and thing to do, I don't get why in the world they wouldn't support database conversion. Has anyone else ever had this happen? Where your server doesn't support DB conversion? If so, what did you do? I've seriously had it with this web hosting company and I'll be sure to let them know that (as politely as I can ) tomorrow when I call to try to talk to someone higher up than the person I just got off the phone with. And see if they are really telling me the straight-facts. Thanks !

Thanks! I have the basics of PHP down, but it's still a bit daunting . Qadoshyah

Where would be a good tutorial on how to make the results return like that? Thanks! Qadoshyah

http://www.wagonerassessor.com/RogersCounty1.jpg Is there a way to make PHP search results return like the link above? The results return above is done in ASP. But, I was curious if this can be done in PHP. Thanks! Qadoshyah