guess it is hard to answer this with so less information first show us how the table defenition is... how it is build up and then which fields you want to show to the user! then I or others can help you much more!! _______________________________ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : Mark.Snijders@atosorigin.com * :+31 (0)40 - 2785992 (tel) * : +31 (0)40 - 2788729 (fax) The information in this mail is intended only for use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. Access to this mail by anyone else than the addressee is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken omitted to be taken in reliance of it, is prohibited and may be unlawful. -----Original Message----- From: Michelle Whelan [ mailto:webmaster@dirtjobs.com <mailto:webmaster@dirtjobs.com> ] Sent: woensdag 19 maart 2003 9:06 To: php-db@lists.php.net Subject: SELECT * FROM Command Hi, I have a question about how to display results. I am using PHP with a mysql database through yahoo webhosting. I've created a form (html & javascript) that lets the user post data to one of the tables in my database. On a separate page, I've created a form that will do a SELECT * FROM search (by zipcode) on the database that the user posted data to. Now here's my question.. I want the query to search the db and return results for matching zip codes and display that plus the other info that was posted by the user. I have it right now so that the results displayed are simply only the zip code that matches is coming back and it displays how ever many times in matches. I hope this makes sense. Thanks in advance for any help. Michael
