What's the error message you're getting? Can you forward the entire PHP script? ***************************** Jonathan R. Karlen President/Senior Developer Infoniq E-Business Solutions, Inc. http://www.infoniq.com/ (914)-630-4509 -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Mr. Tenuta Sent: Friday, July 09, 2004 4:21 PM To: thelist at lists.evolt.org Subject: Re: [thelist] PHP/MySQL odd problem > What is the syntax you are using for your second SELECT attempt? Matt, I use $res = mysql_query("SELECT * FROM freeroll_menu WHERE category = 'freeroll_main' ORDER BY order_num", $link); for both attempts. First time working, second time not. I added different records and such and still the same problem. The first SELECT always works, and i know the syntax is fine because when i switch the first SELECT with the second one it works. I find it really odd. There must be a restriction somewhere. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Lawrence Tenuta @ neoDesignz http://www.neodesignz.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !