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 on

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

[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

Re: [PHP] Multiple queries in PHP

2009-01-25 Thread Stuart
2009/1/25 Ashley Sheridan a...@ashleysheridan.co.uk: 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,

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

[PHP] multiple queries, one transaction

2005-05-20 Thread mayo
I have a site where I need to do multiple queries in sequence. I see there is a way to do consider all querys and to fail the entire procedure if one query fails. It's a BEGIN and COMMIT statement. mysql_query(BEGIN); // starts the transaction mysql_query(COMMIT); // ends the

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 =

[PHP] Multiple Queries

2004-01-15 Thread Arthur Pelkey
I am new this. 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_array(): supplied argument is not a

RE: [PHP] Multiple Queries

2004-01-15 Thread Arthur Pelkey
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 de Janeiro de 2004 15:46 To: [EMAIL PROTECTED

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_array():

[PHP] Multiple queries

2002-05-31 Thread Caspar Kennerdale
Sorry If this is the wrong list for this topic, I hope someone can shed some light onto my problem. I am building a php/ Mysql web site for a client which is a picture gallery. The web site has 3 frames (required by the designer so that the whole thing doesnt refresh all the time). Frame 1-

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

[PHP] Multiple queries on multiple databases

2002-05-24 Thread d3crypt
Hello, I'd like to know the method to connect and query multiple databases in the same php script ... I've to do something like this : do query on db1_on_server_1 while( get results of query on db1_on_server_1){ do query on db2_on_server_2 } the

RE: [PHP] Multiple queries on multiple databases

2002-05-24 Thread John Holmes
: Friday, May 24, 2002 5:35 PM To: [EMAIL PROTECTED] Subject: [PHP] Multiple queries on multiple databases Hello, I'd like to know the method to connect and query multiple databases in the same php script ... I've to do something like this : do query on db1_on_server_1 while