Re: [PHP] Multiple queries in PHP

2009-01-26 Thread Chris
Per Jessen wrote: Ashley Sheridan wrote: I've run into a bit of a problem. I put together a query using mysql variables in the form set @m:= 0; with the select that uses it directly after. For any wondering, the select was using it as an incremental value which can't be hard coded, as the value

Re: [PHP] Multiple queries in PHP

2009-01-26 Thread Per Jessen
Ashley Sheridan wrote: > I've run into a bit of a problem. I put together a query using mysql > variables in the form set @m:= 0; with the select that uses it > directly after. For any wondering, the select was using it as an > incremental value which can't be hard coded, as the value will depend

Re: [PHP] Multiple queries in PHP

2009-01-25 Thread Richard Lynch
PHP/MySQL and the various functionality such as @var are all per-connection expressly so that you CAN do this type of stuff. I'd be pretty shocked if you had any problems. -- Some people ask for gifts here. I just want you to buy an Indie CD for yourself: http://cdbaby.com/search/from/lynch -

Re: [PHP] Multiple queries in PHP

2009-01-25 Thread Stuart
2009/1/25 Ashley Sheridan : > I've run into a bit of a problem. I put together a query using mysql > variables in the form set @m:= 0; with the select that uses it directly > after. For any wondering, the select was using it as an incremental > value which can't be hard coded, as the value will dep

[PHP] Multiple queries in PHP

2009-01-25 Thread Ashley Sheridan
Hi all, I've run into a bit of a problem. I put together a query using mysql variables in the form set @m:= 0; with the select that uses it directly after. For any wondering, the select was using it as an incremental value which can't be hard coded, as the value will depend on the ordering of the