On Sat, 2004-05-15 at 04:04, David Blomstrom wrote: > --- Jigal van Hemert <[EMAIL PROTECTED]> wrote: > > > If you need to know how to display the resulting > > record sets, example 1 on: > > http://www.php.net/manual/en/ref.mysql.php > > gives you a complete piece of code to print out the > > resulting records. > > OK, I think this example points out what I'm doing > wrong, even if I still don't get it. > > Here's the top portion of my code, which was primarily > inserted by Dreamweaver:
I think your problem is dreamweaver. From these posts it seems like you're new to both PHP and MySQL and dreamweaver is just compounding your confusion over both these problems. Additionally, you can't fix everything at once. For now, dump dreamweaver. Forget about trying to display the data in PHP in the way you want. Concentrate on getting MySQL to do a join and return the data you want. If you have a command line interface to MySQL (or a GUI interface) use that and forget about PHP for the moment. If you don't have access to these tools, copy the code exactly that Jigal gave above to display the results from an SQL query. You need a way to narrow your problems and questions to just the SQL because that is all on which this list will really be able to help you. Once you get an SQL query that returns the data you want, then try to use PHP to format the results in the way you want. If you are successful at that, and you still think Dreamweaver will save you time, then move to using Dreamweaver to create your pages. Only after you've figured out all the intermediate steps will it be possible to fix the code dreamweaver outputs when it goes wrong. Garth -- . Garth Webb . [EMAIL PROTECTED] . . shoes * éå * schoenen * ëí * chaussures * zapatos . Schuhe * ÏÎÏÎÏÏÏÎÎ * pattini * é * sapatas * ÐÐÑÐÐÐÐ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
