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

Re: [PHP] multiple queries, one transaction

2005-05-20 Thread Richard Lynch
On Fri, May 20, 2005 2:02 pm, mayo said: > I have a site where I need to do multiple queries in sequence. In sequence, or as one single atomic un-interruptable action? Cuz, like, just doing them in sequence is real straight forward: $query = "select ... "; $meaningful_variable_names_are_good = m

Re: [PHP] Multiple Queries

2004-01-15 Thread CPT John W. Holmes
From: "Arthur Pelkey" <[EMAIL PROTECTED]> > I have a page that has multiple queries on it, I want to do doing the > following: > > Query a mysql db multiple times in the same page, but i must be missing > something, I keep getting these AFTER the first queryis successful: > > Warning: mysql_fetch_

RE: [PHP] Multiple Queries

2004-01-15 Thread Arthur Pelkey
[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 10:52 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] Multiple Queries Can you paste the code please... Humberto Silva World Editing Portugal -Original Message- From: Arthur Pelkey [mailto:[EMAIL PROTECTED] Sent: quinta-feira, 15

Re: [PHP] Multiple queries

2002-05-31 Thread Analysis & Solutions
Heya: On Fri, May 31, 2002 at 09:55:27AM +0100, Caspar Kennerdale wrote: > I have one table, with a name and info about the project and upto 5 > urls of where the jpeg lies. Are you talking about five fields in the table containing up to five URI's for each project? That's not cool. You shou

RE: [PHP] Multiple queries on multiple databases

2002-05-24 Thread John Holmes
Just use MySQL_select_db() to switch between databases between your queries. Remember to switch back, too. Or you can just give the database name in your query: SELECT * FROM database.table WHERE ... ---John Holmes... > -Original Message- > From: d3crypt [mailto:[EMAIL PROTECTED]] > Se