[thelist] PHP/MySQL odd problem

Chris Murtland chris at studiomoxie.com
Fri Jul 9 15:37:02 CDT 2004


On Fri, 09 Jul 2004 16:21:15 -0400, Mr. Tenuta wrote:
> 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.

If you already have the query result in a variable, why do you need to execute the query again a second time on the same page? Can't you just reuse the variable you already have?

Chris Murtland





More information about the thelist mailing list