Re: SELECT * FROM Command *REVISED*

--- Michelle Whelan <webmaster@dirtjobs.com> wrote: > > -Ok, this is what I have. I hope this is what you are looking for. > I'm looking to format this search results page so that the > results come back with the entire entry that also matches the > zipcode that was searched. > > ex: zipcode search = 90210 > > results for 90210 are: > > contactname > > phone number > > city > > date posted > > etc. > > AND, somehow ( I'm thinking ordered list) to have a format for > multiple results sorted by date. > > Is this possible? > > Thanks again in advance > > Michael > > <html> > <head> > <title>www..com</title> > </head> > > <body BACKGROUND="images/dirt.gif" text="#FFFFFF" > link="#FFFFFF" > vlink="#FFFF00" alink="#FFFF00" BGPROPERTIES="fixed"> > > <? > > /* MySQL details */ > $dbHost = "mysql"; > $dbUser = ""; > $dbPass = ""; > $dbName = ""; > $table = "havedirt"; > > /* Attempt connection to MySQL server */ > $link = @mysql_connect($dbHost, $dbUser, $dbPass); > > /* If connection wasnt successful... */ > if (!$link) > { > print ("<b>Error:</b> Could not connect to database."); > exit; > } > > /* Attempt to select our database */ > if (!@mysql_select_db($dbName)) > { > print("<b>Error:</b> Could not find $dbName database."); > exit; > } > > $ZipCode = "$_POST["zipcode"]"; > > /* Build SQL query to fetch all entries from the table */ > $query = "SELECT * FROM $table WHERE zipcode = "$ZipCode"; > > /* Execute query */ > $result = mysql_query($query); > > /* If there was a problem with the query... */ > if (!$result || @mysql_num_rows($result) < 1) > { > print("No entries in table $table."); > exit; > } > print("<table>"); print("<tr>"); $fields = mysql_list_fields($dbName,$table,$link); $columns = mysql_num_fields($fields); for ($i = 0; $i < $columns; $i++) { print ("<th>".mysql_field_name($fields, $i)."</th>"); } print ("</tr><tr>"); foreach ($row as $key=>$val) { print ("<td>$val</td>"); } print ("</tr>"); > print("</table>"); > > /* Close link to MySQL */ > mysql_close($link); > > ?> > > </body> > </html> ===== Mark Weinstock mark_weinstock@yahoo.com *************************************** You can't demand something as a "right" unless you are willing to fight to death to defend everyone else's right to the same thing. *************************************** __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com