PHP :: Can I Get PHP To Query From Multiple Tables?

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:

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:

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:

Selecting Multiple Values From Multiple Tables Using Checkboxes
I've been struggling with this for a bit but cannot seem to find a simpler, cleaner way of doing this.

a. I have a Table A - Customers , Table B - Contacts .
b. I have a form where a user types the first few alphabets of a customer name and then gets a list of contacts, cities.
c. The user is supposed to select multiple options from this list and then send that data to another form for processing.

I'm able to only pass data from Table A, not from B . Could someone please have a look at the 2 snippets of code and advise? And is there a way both these php scripts could be combined in a single one ? Code:

Grabbing Data From Multiple Tables For Multiple Requests
Here's what I'm trying to get at.

A table that displays all the Process Server's name, the number of summons's he has out within 7 days, 7-14 days and 15+ days...pretty simple, it's just a report so management can stay on top of how many papers are out.

I've got the server_information table with the server name and ID. and a case_information table with the serverID.

I've got a while loop that displays all the server's name, the problem is when I try to get the # of cases....here's what i've got so far. Code:

Multiple Users, Multiple Tables, One Form
I have a small group of users that will submit their 'goals' via one form (placed in a postnuke block). I have created one table (mysql) for each user to collect collect their goals. I need some direction in writing the php that will submit the form data to the correct table based upon the users Postnuke login.

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?

AVG() Through Multiple Tables?
I'm trying to get the average of several columns [all with the name of SIR] in several different tables, and display the result. My code is giving me a "please check the manual depending on your MySQL version.." error. Here's my code:

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?

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?

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:

Search Multiple Tables
I have a search form in PHP for MySQL.

Is it possible to search multiple tables with one select statement?

Inserting Into Multiple Tables?
I need to increment the value of 'id' in 5 tables whenever it is incremented in another table.... Is there any way to do this? How?

Getting Data From Multiple Tables
I was wondering if anyone can tell me how to get data from several tables and save them in variables for further processing?

One Form, Multiple Tables
I have a form which is used insert data into multiple tables. Each table relies on the data inserted from the previous table. The problem I think I am having is that the data is not avialable by the time the next query is run. code:

Searching Multiple Tables
I am trying to create a search system for an existing database.
Because of the way the database is setup, I need to traverse three
different tables, gathering information:

1) Go into table1 and lookup show_id by show name. (For instance,
let's say I am looking for the Mickey Mouse show. I look it up and
find that it's show_id is 6)

2) Go into table2 and lookup all attendee_ids for show_id 6. (For
instance, I lookup show_id 6 and find 5 attendees. 1, 2, 3, 4 and 5
are the attendee_id's)

3) Go into table3 and lookup attendee names, from the 5 attendee_ids.
(For instance, I lookup 1, 2, 3, 4 and 5 to find their names are Jane,
Alice, Tom, Peter and Greg.)

I am not free to adjust the tables, so I have to stick with what is
there. There may be an SQL statement that could do all this in one
command, but I am no SQL expert. I was wondering if anyone had some
PHP oriented solutions. I can get the show_id, no problem. I seem to
be having a problem with the rest, as it involves arrays. After I go
into table2 and get all the attendee_ids, I get an array of
attendee_ids that I need to search table3 for, to create a new array
of attendee names.

Insert Into Multiple Tables
I'm trying to insert data collected on a form into two tables into my database. I know the SQL statements work because I tested them individually, but I keep getting the error "Couldn't execute query 2". Code:

Recordset From Multiple Or All Tables
Can somebody please help me with a simple solution to search either multiple or ALL Tables in a MYSQL Database.

I have a Table for each Merchant.
I need to introduce a Product Search facility accross ALL merchants Tables.

The way it works now is retrieval is confined to each Merchants own Table:
$query_TEST = "SELECT * FROM T101 WHERE product = 'widget'";

I need to search tables from T101 upwards as they are added.
I suppose it's too much to hope that MYSQL will accept wild cards.

Pleae tell me there is a simple way to do this that is not affected as Merchants/Tables are added/removed ongoing.

If this is too cumbersome for me to introduce and maintain, I could at this point retreat to a single Table and use a Merchant Code to select content for each merchants own pages.

My PHP skills are at the evolving stage, so please keep it very simple to understand if possible.

Multiple MySQL Tables
I need some help with tables in MySQL.
I am making a colums of articles in my site.
It has 3 posters that post articles.
I make a little serach page to search for words into articles.

I have the sintax below working, but I need to know what is the syntax
to it select words from several tables. Every table is for a poster
and all tables are in the same DB and have the same fields.

---------------
$searchword="SELECT * FROM table WHERE comment LIKE
'%$searchstring%'";
---------------

I tried
---------------
$searchword="SELECT * FROM table, table1, table2 WHERE selected_row
LIKE '%$searchstring%'";
---------------

and even make an ARRY for table, table1, table2 but it does not work.

Search Multiple Tables
I am trying to search mutiple tables in my PHP code. I believe I only need to get the SQL query correct. Basically I have maybe 5 table where I need t oselect all the data from them but I only want to search one of the fields in each of those tables.

I made a post on the SQL boards but I think it will involve more PHP now because I believe I need to use a join I have something like $search=$_POST["search"]; Code:

Selecting From Multiple Db Tables
I have a table called officers with fields id, office, abbr, member. I have a table called profiles with many, many fields, but of interest, firstname, lastname, badge, and primaryEmail. The fields member and badge are the same (or could be if the person holds an office).

I want to select firstname, lastname, and email from profiles where the member in officers equals badge in profiles (member and badge are both INTs). Does that make sense? Can someone help me? If possible, including an explanation of what is going on so that I can do it myself in the future.

Relationships With Multiple Tables
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:

Multiple Inserts Into Different Tables
I want to list these variables up to 50 then insert the variables into the table. EXACTLY how should I write the code:

Upload To Multiple Tables
I want to create a form that will upload information into a db but I am not sure if I need to use multiple tables. The information is pretty basic really but there will be alot of info to upload, all of which needs to be linked.

The general company info is
Name
Address
Suburb
State
Country
Postcode
Phone
Fax
..and other fileds

Linked to this will be another form that allows them to upload position information such as

positio title
description
hrs of work
responsibilities
...etc

How do I link this information so that once they have uploaded the company information they move on to upload position information. They may have multiple positions that need to be uploaded and may choose to do it at different times.

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;
}

Selecting From Multiple Tables In MySQL.
I need help in trying to retrieve information from different tables, each one having a different primary key (auto-increment).

I have 3 pages, each accessing their respective tables.

(TABLE_internet_arts)
TagID (PK)
name
email
message
date
ip
time
profile_id
site_url
image_url
msg_type
site_title
page_title

(TABLE_losangeles_arts)
TagID (PK)
name
email
message
date
ip
time
profile_id
site_url
image_url
msg_type
site_title
page_title

(TABLE_sanfrancisco_arts)
TagID (PK)
name
email
message
date
ip
time
profile_id
site_url
image_url
msg_type
site_title
page_title

Right now, for each table on it's own, the SELECT statement looks like the following:

SELECT * FROM internet_arts ORDER BY TagID DESC LIMIT $offset, $rowsPerPage";

What I want to do is take the messages from all 3 tables and have them displayed, ordering them in chronological order by the date & time posted onto one page.

Anyone know the correct syntax and how to make the SELECT statement to do this?

Deleting Rows Across Multiple Tables
Using MySQL. Documentation is not clear to me, and it remains clear after doing some searching.

I know this does NOT work

DELETE FROM table1,table2,table3,table4 WHERE dataID='id'

Do I really need to run 4 queries? Seems awfully inefficient.

Select From Multiple Tables In Db From A Newbie
I have a db with 34 tables with all the same feilds, and would like to select 1 columb from all these tables. Is this possible from a select query, if so a example would be great.

You may well ask why have i 34 tables all the same, but i thought is was a good idea to set out the tables as per my catagories when i was constructing them. But now i know i can do them all from 1 table with multiple fields.

MySQL Multiple Tables / Results
I would like to perform multiple queries to a MySQL database and have all
the results in 1 result set.

Selecting From Multiple Tables (Mysql)
The query works fine but I want print also table2 "Name" before the URL below.
I can only get the "Name" from table1.

Here´s the code:

$db = mysql_connect("host", "user", "pass"); mysql_select_db("database",$db);

$result = mysql_query("SELECT table1.CGrpId, table1.CustId, table2.Name, table1.Name FROM table1, table2 where table1.CGrpId=table2.CGrpId AND table1.RegCd=$variable",$db);

if ($myrow = mysql_fetch_array($result))

{ // display list if there are records to display

do {

printf("%s<a href=page.php?CGrpId=%s&codeid=$variable&CustId=%s>%s </a><br>
", $myrow["table2.name"], $myrow["CGrpId"], $myrow["CustId"], $myrow["Name"]);

} while ($myrow = mysql_fetch_array($result));

} else { // no records to display

echo "No information."; }

The "table2.Name" gives me a problem, it won´t print.

Joining Multiple Tables In MySQL
I'm wanting to join four tables, or at least this is what i think i need to do.
These are the table structures: Code:

Updating Multiple Tables In Mysql
I am trying to update a number of tables with the "if action=="update"" command on the attached page. however, when I try to run multiple updates in the same action or multiple actions for each update neither of them work.

Multiple Tables Print To One Page
Is it possible to print information from multiple databases on one page/form. For example, I want to print information that is in three databases, and I want to be able to print a few related fields on one page. Is that possible?

Display Results From Multiple Tables
I have two tables, one table (article_cat) has four fields ("id", "title", "feature1", and "feature2") and the other table has six fields (articles) has ("id", "cat_id", "title", "content", "feature1", and "feature2").

I am looking to display the "title" from the "article_cat" table that has "feature1" with a value of 1. And I want to display beneath that all the "title" results from the "articles" table where "feature1" has a value of 1. I have tried this a thousand ways with no luck. Code:

Echoing Multiple Html Tables
im trying to echo out multiple results from a database and returning them in a table. Each new row in the database leads should lead to a new row in the HTML table. However I can only get it so the first row from the database goes into the html table as it should, the rest go outside it. Any ideas? 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:

Inserting Info Into Multiple Tables Simultaneously
I have some user information that is gathered from a form. The information however is split up into three tables. The one table has all the user info, and creates a user ID with auto_increment option. The other two tables are basically lookup tables, and use the user ID. So i need to get the user ID back from the insertion query. What is the best way to do this? I know in Sequel server you can do this: select @@Identity from tableName. And that returns the last index. Is there an equivalent query in mySQL?

Retrieve Data From Multiple Tables Via Combo
I am working on a small project to create a single web page which retrieves data from 3 tables.

The first table is retrieved by a combo box. It only contains the primary key of the table. I know how to get the data in the combo.

The second table contains other information, related to the primary key of table 1. I know how to retrieve all the data, but not how to retrieve only the data of the selected primary key. I think I should work with a WHERE clause in the SELECT statement, but I have no idea how to get to the selected value.

The third table should work in a similar way, so when I have an answer for the second table, I can also use it for the third table.

Multiple Sorts On A Join Statement Using 3 Tables
I have the foll. $sql which works well.

$sqla = "SELECT * FROM Customers c INNER JOIN Custaddress a USING(CID) INNER JOIN Cities t USING(CITYID) WHERE c.Company LIKE '%$customer%' ORDER BY Company asc";

But if I wish to do a sort on 3 fields in 3 different tables, i'm getting an error.

$sqla = "SELECT * FROM Customers c INNER JOIN Custaddress a USING(CID) INNER JOIN Cities t USING(CITYID) WHERE c.Company LIKE '%$customer%' ORDER BY c. Company asc, t.City asc , a.Zip asc ";

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.

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.

MySQL Inserting Into Multiple Tables Linked Records
Using MySQL can anyone tell me how to most efficiently insert a collumn
in 'table1' retrieve the id from this record and insert mutliple
records into 'table2' with a collumn for the id in 'table1' which links
the two recordsets

Multiple Navigation Tables On One Page (master - Slave)
I just wanted to refresh only part of the page, i.e., table2 on my php page. here is my javascript code which performs the refresh it works fine and my php file display all the records. the only problem is: I have got two tables on the same page and i only want to refresh the second table when i click the a row of my first table rows. Code:

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.

Retrieving,Sorting & Displaying Multiple Results From Mutliple Tables
I need to know how to run a php / mysql query to do the following.

I have 1 database (lets call it "database" for now) within this database there are multiple tables ("News","Feature","Header_feature")

For NEWS I need only the 6 latest results pulled from that table and displayed in a table. The "News" table has the following columns "ID","Title","Date","Body","Image"

For Feature I need only 1 result retrieved from the database and displayed under the variable $ticker as it will display as a scrolling marquee within a table. The "Feature" table has the following columns "ID","Ticker".

For Header_feature I need only 1 result retrieved from the database and displayed in the following manner <a href="$link"><img src"$header_feature">[/url] The "Header_feature table has the following columns "ID","image","link"

How would I code this all into 1 page? I cant seem to get the query to do everything I want it to and display the results properly. You can see what I have so far at www.getlivemedia.com The $ticker is the scrolling text near the top of the page and the news is obviously the bulk of the page and $feature_image is the broken image.

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?