Ad:

PHP Discussion Thread
Unsolved
Views: 11865

Jun 22nd, 2004

Double MySQL Query

Expand Post »

I have been looking into ways I to cut down on MySQL Querys in a page and I was wandering if you could up to update querys into one mysql_query function like this:

[php]mysql_query("UPDATE table SET val1=val1+1, val2=val2+1 WHERE id = (int); UPDATE table SET val3=val3+1, val4=val4+1 WHERE id = (int)") or die(mysql_query());[/php]

*Note: both the (int) values are different.

Similar Threads

test mysql query for no results in PHP
how to generate a mysql query from a english question in MySQL
how to generate a mysql query from a english question #1 in Java
Python Tuples and Mysql Query in MySQL
MySQL query's in MySQL

Ragnarok

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

94 posts
since Mar 2004

Permalink

Jun 22nd, 2004

Re: Double MySQL Query

not sure about the update thing, but in your or die statment you should change it to

[php]or die(mysql_error());[/php]

that way you can tell what the error might be that your recieving.

also i dont see a problem with sending various mysql query's its a good way to keep things from getting messy on a single line.

Killer_Typo

Reputation Points: 152

Solved Threads: 39

Master Poster

Offline

778 posts
since Apr 2004

Permalink

Jun 22nd, 2004

Re: Double MySQL Query

it does become a problem when you have to update 5 or 6 different fields on 5 or 6 different rows when you also have a few selects and an inset into as well

Ragnarok

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

94 posts
since Mar 2004

Permalink

Jul 19th, 2007

Re: Double MySQL Query

mysql_query() sends an unique query (multiple queries are not supported) to the currently active database on the server (see http://www.php.net/mysql_query for more info)

mugur

Reputation Points: 16

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jul 2007

Permalink

Aug 25th, 2007

Re: Double MySQL Query

try something like this:

mysql_query("UPDATE table1,table2 SET table1.val1=val1+1, table1.val2=val2+1 , table2.val3=val3+1, table2.val4=val4+1 WHERE id = (int)") or die(mysql_error());

JeniF

Reputation Points: 10

Solved Threads: 5

Junior Poster in Training

Offline

52 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Teaching yourself PHP for idiots

Next Thread in PHP Forum Timeline: Passing Variables

DaniWeb Message

Cancel Changes

User Name
Password