PHP :: Can I Update 2 Tables In The Same Query?

UPDATE Mysql TABLES With PHP
Ok, I know I can update my tables using phpmyadmin, but it becomes very difficult when I have a table with hundreds of rows all with different information. Now, what I want to do is be able to change the information that is in the table already. Meaning...if I have customer A, B and C all with different attributes, say one of them calls me and wants to change his shipping address. I know I could go to phpmyadmin, search this customer and edit his info. But it becomes really hard when I have 200 customers who change their info, not only their addresses but Contact info, etc.

Now what I am trying to do now is create a PHP script that will help with to accomplish that.

Update JOin Two Tables
I gotta the Two tables..

Table1 = inside
--------------------
id
email

table2 = mailfile
---------------------
id
code
from
to
inorout

I want to compare the emails of inside with emails of mailfile and then if there is match I want to update "inorout" with a * Now what I did is run a query on inside checking for emails and while it does that I put another query in that while loop to match it , but I get timeouts... Is there anyother way, I was thinking the LEFT JOIN query but not sure how to do that.

Update MySQL Tables / Web Enviroment
I have some PHP and MySQL knowledge, I am trying to update some mysql tables but within a web enviroment , I know how to update them through phpMyAdmin.

Update 2 MySQL Tables In One Form
I have a form with two fields in it. Each field updates its own table. I would like for the user to be able to enter data in either fields and the form update the appropriate tables. If one of the fields is empty then it doesn't update the table.

mcat - Updates mcatTable.mcatname
mtype - Updates mtypeTable.mtypename
PHP Code:

PHP Update Query Mysql: Query Succussful?
I can't seem to successfully test an update query. Below is a piece of code that updates a statistics table. If row today doesn;t exist, a new day must be created. But this doesn't work...

thank you for your reply.

$today= date("Y-m-d");

$qq="update totals_r set hits_r=(hits_r+1), lang_$lang=(lang_$lang+1), cat_$cat=(cat_$cat+1), rating_$rating=(rating_$rating+1), bussite_$bussite=(bussite_$bussite+1) where date='$today'";

$result_6 = mysql_query ("$qq");

if (!$result_6){ /// IF !ROW_TODAY ==> CREATE NEW DAY

$qq_2="insert into totals_r (hits_r, lang_$lang, cat_$cat, rating_$rating, bussite_$bussite, date) values(Ƈ',Ƈ',Ƈ',Ƈ',Ƈ','$today')";

$result_6_2 = mysql_query ("$qq_2");

if (!$result_6_2){
$err_msg_sql_6= mysql_error();
$err_loc_6="$PHP_SELF"." // Query6: update totals_r";
}
}

Getting A Query From Different Tables
I have different tables with product. Every tables is a different category, and has prod_id, name, description, price and already sold(int, how many already sold). I want to make a top 10 most sold products. For this is have to make a query from different tables, sort by 'already sold' and limit to 10, but how to do this? This all in mySQL/PHP3.

Query Different Tables
I've got a DB with let's say 3 tables (each registered user has one)... and in each table there is let's say id, username, totalmoney, amountA, amountB... I also have one fix external paramter let's say "5"...

I need to query the different tables, in such way that I multiply 5*amountA, 5*amountB, add them both to totalmoney into a new variable let's say $totalwealth... then query the other tables and make an array with the $totalwealth values...

Can this be done, in a relatively short script or do I need to write one for each table, insert into a database and then compare?

Query For Joining Tables
I'm trying to display some info from my vbulletin and a hack. I am using the new Karma hack and want to display the 10 users with the highest karma.

The karma table has the following:

CREATE TABLE storepoint (
uid int(200) DEFAULT Ɔ' NOT NULL,
newthread int(20),
reply int(20),
view int(20),
admin_mod int(20),
morereply int(20),
totalpenalty int(20),
date date
);

So how can I join this with the user table to display user name and then add all the points from the above table and display the top 10?

Multiple Tables Query
I have a roster script that handles multiple tables ($orderof) and within those tables multiple divisions ($sword). The only problem is that, nothing is getting displayed -- though there are no errors (systematic [to my knowledge] or parse). PHP Code:

Can I Get PHP To Query From Multiple Tables?
I will have several tables in my database, several of which will contain similar products. Is there a way to set up my pages where PHP will get the items I request from EACH table?

Multi Tables In Query?
I am still somewhat new at this stuff, been able to modify code to my likings, but am starting to write my own script for my schedules. I am having difficulty trying to build a relationship with different tables. Code:

Update Query
I am having a problem with the update script. I making a group update and i keep on getting "cant execute query" error. I am wondering if its my SQL statement. PHP Code:

Update Query
I have wrote a system to mange revision guides for a school. The pages that assign a book to a student works fine. When a student returns the book i simply want to change the status to "Returned" from "With Student". Code:

Update Query
i wanted to update all my tables field value to "0", but the problem is i got 20 fields

the usual way "update table1 set field1=0,field2=0,field3=0....field20=0 where id='my_id'";

is there a way to update all fields without specifying the fields to update?

Query Update
i have a form wherein once submitted it:

1. update table 1
2. insert in table 2

the form has a "specialization" select box wherein you can select multiple items
and those items are updating "hits" row in table 1 adding 1 for every item that is being selected.

my codes are working if i only select 1 item from the "specialization" select box but the problem comes if i select more that 1 item on the select box.

this is the code for my form:

Tricky Query, Joining Tables
So, imagine that I have two tables:

Items
+------+--------+
¦ItemID¦ColorIDs¦
+------+--------+
¦`````1¦1,2`````¦
+------+--------+
¦`````2¦1```````¦
+------+--------+
¦`````3¦2,3`````¦
+------+--------+

Colors
+-------+---------+
¦ColorID¦ColorName¦
+-------+---------+
¦``````1¦White````¦
+-------+---------+
¦``````2¦Burgundy`¦
+-------+---------+
¦``````3¦SteelBlue¦
+-------+---------+

How can I write a query which will give me a result like this:

+------+------------------+
¦ItemID¦Colors````````````¦
+------+------------------+
¦`````1¦White,Burgundy````¦
+------+------------------+
¦`````2¦White`````````````¦
+------+------------------+
¦`````3¦Burgundy,SteelBlue¦
+------+------------------+

... in other words, where I get the a comma separated list of color names back in place of the comma separated list of color IDs?

So far I have tried:

SELECT IF( LENGTH( @itemid ) = LENGTH( @colors ),
(
@itemid := NULL
AND @colors := NULL
),
'set'
) as Init,
IF( CAST(@itemid AS CHAR) = CAST(i.ItemID AS CHAR),
@colors := CONCAT( @colors, ',', c.ColorName ),
@colors := c.ColorName
) as Setting,
@itemid := CAST(i.ItemID AS CHAR),
i.ItemID,
@colors as Colors
FROM Items i
INNER JOIN Colors c ON FIND_IN_SET(c.ColorID, i.ColorIDs)
WHERE 1
ORDER BY i.ItemID ASC

... but it doesn't seem to work ....

Merging 2 Tables With A Select Query?
I have two tables in my database. One is called 'hotfood', the other is 'coldfood'. What I want to do is have a single SELECT query for both of these tables. This is so I can then use 'mysql_num_rows' on this query, like so.

if(mysql_num_rows($id)==0)
{
print "Food type does not exsist";
}
else
{
--
}

It basicaly to do a search type thing, the above checks that the food name exists by checking both the hot and cold food table, therefore I need to two merged into the select query so that I can search it.

Loop Through Tables And Execute Query
I have a database that has many tables. How can I write php code to loop through all tables and run the following query:

LOOP THROUGH ALL TABLES {
DELETE FROM {table_name} WHERE deleted = 1;
}

Databse Update Query
im trying to update a row PHP Code:

PHP: MySQL UPDATE Query
I need to have a page where the user can update his info and/or delete his record. I haven't tested the DELETE query yet.

When I open the page it shows all the info stored in the database. When I change something and hit the update button I get the message that the record was successfully updated, but nothing really hapens.

If you want to see what's happening go to URL , click on the 'directory' link
The user ID is 'scooby', and password 'dooby'. If it does not work, try the following combination: user ID: 'sunny', password: 'trout' . Then click on the 'edit profile' link and try to change something and see what happens. I am attaching a php file of the 'edit profile' page, the one I am having trouble with so you can see the entire code.

Update From Single Query
Anyone know if this script is capabale of doing a multiple update in MySQL from a single form? It basically pulls out all the players from a particular team and adds static list boxes for games played/games won. The script works... but am having troubles with this part. code:

Interesting Update Query
I have a column that contains names in upper case like:

JOE, LAST NAME
THOMAS JEFERSON MORS
MIKE LEE
..
..
..

and i wat it to be like:

Joe, Last Name
Thomas Jeferson Mors
Mike Lee

Get Update Query Working
I have always had a problem with updating rows in SQL, and now this is the best piece of update code I have and it wont work?!?

I send the url like this edit.php?id=$id

and this is my code, which just brings up a blank page weather ID is posted or even just edit.php Code:

Splitting Html Tables (from MySQL Query)
I have built a mySQL query that prints html tables. I need to split the tables into 2 equal parts. code:

Session To Query Multiple Tables & Fields
I'm trying to load up data where by the session is carrying the user ID.. and i need the session to call up the user table which is working fine. But i also need to call up info about gangs that the user is in. Now it gets complicated cos the user could be 1 of 30 members (30 being the max a gang gang can have).

But how is this done? This is what i got at the moment. But this is only calling up the one table. I need this now to also check if the user ID is in another table which could be in a possible 30 fields. Code:

PHP ODBC Update Query To Access
For some reason I am getting a datatype mismatch on the following SQL query and I do not understand why because the field datatype is number in the access database and the update query is using a number to update to that field? PHP Code:

Parse Error In Update Query
This is the first time I have ever used the update query. I am not having any luck figuring it out. Please post if you find my mistake,

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting

T_STRING or T_VARIABLE or T_NUM_STRING in
[bleeped] on line 46
here is the location of the problem:

$sql = "UPDATE $table
SET pagecontent = $_POST['T']
WHERE id = $_POST['id2']";

Results Of Same Field Names But Different Tables In MySQL Query.
I have a SQL string with a couple of JOINs that works perfectly in
command prompt. I get results for all the fields selected just fine.
But when I put it into a PHP page, I can't make variables(?) out of
fields that have the same field name from different tables.
Here's the SQL statement:

$sql = "SELECT orders.companyid,orders.ordernum,orders.address,tb l_ih_accounts.company,tbl_ih_accounts.address
FROM orderstatus ".
"LEFT JOIN orders ON (orderstatus.ordernum = orders.ordernum) ".
"LEFT JOIN tbl_ih_accounts ON (tbl_ih_accounts.id = ihid) ".
"WHERE submitted <> 'yes' ORDER BY orders.ordernum ASC";

Then in the "WHILE" clause after the database is queried:
$o_address = $row[orders.address];
$ih_address = $row[tbl_ih_accounts.address];

I've tried it without the table names in the $row statements, but then
I'll just get the results for tbl_ih_accounts.address.
I'm thinking there must be some way to uniquely "name" the results of
a particular field up in the SQL statement, and then just use that
unique name in the WHILE. But I have no clue, and can't find anything
about anything like that.

Loop Problem When Trying To Query Multiple MySQL Tables
I will try and explain this as best I can. I have a database with tables separated by year (exp. 1994data, 1995data, 1996data, etc.). I am trying to perform a search that will allow the user to enter a value, iterate through the tables and echo the result. Here is the code I am using: Code:

Select Count Query, 2 Tables With Identical Structures
I have 2 Tables that have the exact same structures, One is for Inventory, the other is for Relief Inventory (ie. when an item is sold it is moved to relief).

What i want to be able to do is to run a query that will count the number of items tested by one person and display that sorted and grouped by the date cleared. I can get this to work when working with just the Inventory table, but the problem is that as items are moved out to relief the counts will change.

$query = "SELECT COUNT( * ) AS `Count` , `Date Cleared` , `Tested By` FROM `Inventory` WHERE `Tested By` = ".'"'.$tester.'"'." GROUP BY `Date Cleared` ORDER BY `Date Cleared` DESC ";

My question is, how do i run a similar query that will search both tables and combine the results. I have tried adding the other database to the FROM statement, and have been tring to figure out if i can use a join statement but that hasn't yielded any favorable results.

Using Record Identifier From Select In Update Query?
Just wondering if I can get a record identifier from a query. The basic idea is to process the data in a user-specified field in a user-specified table.. and write it back without modifying any other field. So the program would go something like this:

$qid=mysql_query("SELECT $field FROM $table");
WHILE ($list($field_value)=mysql_fetch_row($qid)) {
new_field = process($field_value);

and then the tricky part - how do I write back $field to $table? If I use an update query (eg: UPDATE $table SET $field=$new_field WHERE $field='$field_value') it will update all the fields where $field is $field_value.

Is there a way of getting a (unique) record identifier from the select query and using it in the update query? Since the table is user-specified, I have no way of knowing what the primary index is.

Query Array, Sort Results And Display In Seperate Tables
The problem I have it breaking out the results and displaying them (broken out) alphabetically in seperate tables. For instance, I have generated (bookmarked) tables, one for each letter (A-Z) and want to display all recordsets with say, last name
beginning with "A" in one 2 column table, "B" in another 2 column table, and so on... each
table would have two columns (with 2 background colors alternating), each cell containing values of one recordset.

Even more tricky is if I have an odd number of cells, still generating the last cell with empty values (for asthetics). And can anyone say "sort" (yes, I am nuts)? The ability to sort the whole mess by any column value. I have looked at freeware and other third part apps, but they can only do what I already can do (mine is actually cleaner) but not as complicated.

How To Update A Table's Field With Another Tables Field?
I need to take the state field from dt_profile table and update the dt_matchfinder with this state making sure the member_id field matches.

the problem is the dt_matchfinder table has null set for many of the state field but in the dt_profile each member ID has a specific state and I need the same to be true in the dt_matchfinder table.

SQL Query "UPDATE" Question
I want to write a query something like this:

"UPDATE database SET data='data + 1'"

but I'm not quite sure of the syntax I should use. I want to do it like this so I can minimize the number of SQL queries I have to execute. Also, would I be able to use division and multiplication and such instead of a +/- sign?

Generating Multiple Alternating Columns And/or Tables Within Tables
I am having a little bit of trouble generating the code for a table with 2 columns. The columns contain tables within themselves. Not sure why as that part was an existing design. Here is the output so far and it is correct but not how i want it to be (i'll explain) Code:

Select And Update Vs Update
For doing update or insert code, its worth noting that Example 1 seems to be around 60% faster than Example 2 PHP Code:

REGEX: Can't Seem To Replace LIMIT Clause In Query Using Preg_replace ($pattern, $replacement, $query)
Want to replace the limit clause in a query, but can't get it right.
What's wrong with this:

$pattern = "(.*)limit (.*)";
$replacement = '$1'
$replacement .= "LIMIT $limit";
$replacement .= '$2'
$query = preg_replace ($pattern, $replacement, $query);

Speeding Up Query/code (query Within Result Set)
I'm looking for ideas on how to speed up this script. Basically it finds all the zip codes in a zipcode table, then looks for all the records in another table with those zip codes.

Right now it finds all the zips then within that WHILE, it looks for a record in another table with that zip: PHP Code:

Using Query Result To Do Another Query In Loop
I have 2 tables, one called users2 and one called books. Books has a field called UserId, which is the ID of the user that added the book to the database.

My problem, is that i need to take this ID from the book table, and use it to get some information from the user table. Here is my code to get the ID from the book table: Code:

Empty Query, Query Fail
i am doing a user authentication but my problem is that when i type in user name and password it is Code:

Tables
I was able to get MySQL to output to an HTML Table with the following code. I was even able to add color to the columns. The following code causes the color to run vertical. Anyone have suggestions on making the color run horizontal? Sorry for the length, but you some might find this useful. Code:

Tables &
I would like to display some php output using the table in the first code. I copied the table I'd like to have it display, with the appropriate "$whatever" in each cell. Code:

SQL Tables
I am using php to create a form. I would like that forms
information to go into a database. When creating tables where the
information that i entered into the form will be stored, where exactly
do i place the code for creating the tables. Do I have to create a new
php file? and how do i link the information from the form to the
tables.

<html>

<title>Service Station</title>
</head>

<SCRIPT language="JavaScript">
<!--
function validateSelect(){
var errors="";
var form = document.customer;

var first = form.first;
if(first.value==""){
errors+="
You must enter a first name.";
}

var last = form.last;
if(last.value==""){
errors+="
You must enter a last name.";
}

var add=form.add;
if(add.value==""){
errors+="
You must enter an address.";
}

var city=form.city;
if(city.value==""){
errors+="
You must enter a city name.";
}

var province=form.province;
if(province.value==""){
errors+="
You must enter a province name.";
}

var phone=form.phone;
if(phone.value==""){
errors+="
You must enter the phone number's area code.";
}

var phone2=form.phone2;
if(phone2.value==""){
errors+="
You must enter the phone number's next three
digits.";
}

var phone3=form.phone3;
if(phone3.value==""){
errors+="
You must enter the phone number's last four
digits.";
}

var make=form.make;
if(make.value==""){
errors+="
You must enter the make of the vehicle.";
}

Tables
i want to select categorys from the table forumtutorial_cats and then it will select forums from forumtutorial_subforums where catid=the catid from the previous query. in a table it would list the category name then all the forums underneith it then it would list the 2nd categorys name and the forums underneith it.

it would keep doing thin until it didn't find any more categorys. i am not sure how i would get it to do this.

Tables Next To Each Other
I use this code to make a table with two rows, and four columns, all together.

<tr>
<td>top</td>
<td>top</td>
<td>top</td>
<td>top</td>
</tr>
<tr>
<td>bottom</td>
<td>bottom</td>
<td>bottom</td>
<td>bottom</td>
</tr>

How would I make it so that for each column, it displays one of the 4 most recent rows in my database? The most recent rows in my database can be determined because the row with the highest id (AUTO_INCREMENT) is the newest one.

I need to select the most recent 4, and display the most recent four on those tables. For "top", I need it to display " . $row['upload_preview'] . " and for the "bottom" I need it to display " . $row['upload_name'] . "

Any ideas how to accomplish this?

Question About Tables
I have what may be a simple question, but here goes anyway.

I need to split my data up into two columns, i.e.:

[data] [data]
[data] [data]

I need to do this while I'm looping through the database. I can't seem to figure out how to switch to the second cell while in the midst of the loop.

Two Tables To Sort
I have two tables. Table 1 has the following columns: id, number and headline. Table 2: id, number, description.

What I need to do is sort the rows from both tables to one page sorted by the field "number".

I had two solutions:
1. Two queries from which I create one array. The array can then be sorted with PHP's function. The problem with this is that a "number" can have the same value in both tables.
2. Creating a temporary mysql table, inserting the data there and then selecting it ordered by the number. The problem with this one is concurrent users. If the table exists already and another user starts shoving "his data" to the table it all gets messed up.

Dynamic Php Tables
As you'll notice, each new result appears in a new table, which is very annoying. I am trying to make it so that all ther results appear in 1 table.

This is what I have so far;

<?
//error message (not found message)
$XX = "No Record Found";
$query = mysql_query("SELECT * FROM $usertable WHERE $metode LIKE '%$search%' LIMIT 0, 30 ");
while ($row = mysql_fetch_array($query))
{
$variable1=$row["Model"];
$variable2=$row["Creator"];
$variable3=$row["Title"];
print ("$variable1, $variable2 ,$variable3");
}

//below this is the function for no record!!
if (!$variable1)
{
print ("$XX");
}
//end
?>

Can anyone help please?

Can I Update 2 Tables In The Same Query?

I want to update 2 or more tables. Can I do this in the same query?