PHP :: Combining Multiple Queries To Make One Simple Query.

Combining Results 2 Queries
I'm writing an application that allows users to book seats for a ride at 10 different times. I have created 2 queries so far:

1. returns all available seats for that day (at all the times combined). The times table holds a list of ride times. BookingDetails table stores booked seat numbers, show time and other booking details customers have already made. The Place table stores all available seat numbers. To find the times that are not booked I write the following Query but it returns the times that havent been booked at all, if one person books at one time, it shows that time unavailable when infact there are still lots of seats available!

$query="SELECT Time FROM Times, BookingDetails, Place WHERE Times.TimeID != BookingDetails.TimeID";

2. returns all available seats during that day

$query2="SELECT PlaceID, SeatNo FROM Place, BookingDetails WHERE Place.PlaceID != BookingDetails.PlaceID AND PlaceID = Ƈ' ";

In my application the user will first select the time of day they want to book for..ie 10am or 12pm etc. This pulldown menu box will only display times if there are seats avaialble, if there aren't then it won't appear in the list.

After the uer submits the time they want, it will then display current seats available at that time in a table. If the seat is available a check box will be available in a table cell, if it's not then it won't appear and the table cell will be greyed-out. This prevents double booking as there won't be the option to.

From the 2 queries above, what's the best way to get the results I need? Do I just need to combine the 2 queries? I don't think Union will work, I thought about creating a VIEW with the results of both queries and then querying the VIEW? Am I on the right track?

Combining Two Variables Together To Make A New One?
Supposing I have one variable, $file=filename, and a second variable, which is $number='99'; How can I make a third variable, $fileno which will equal filename99? I'm guessing it's not as simple as $fileno=$file$number...

PostgreSQL Queries, Storing Results Instead Of Multiple Queries
I have a script that does multiple SQL queries.

So I have something like $result = pg_query($my_query);

After this query I tend to loop through like this to get the result:

while ($entry=pg_fetch_row($result))
{
//do stuff
}

But my question is, how can I make a copy of the result? So I don't run the query more than once.

Combining Query Results
I have two queries which searches for any fixtures your clan (team) is in and then returns some information about the fixtures. Is there any way of combining these results and ordering them by date? Code:

Combining Results From MSQL Query
I have the following 2 queries which each produce a result. I have spent hours reading up and have searched devshed but I can't find how I would go about Adding these two numerical results together using PHP.

Query 1

$sql = "SELECT SUM(total) AS total_price FROM detail_tourdet WHERE voucher_id = '$voucher_id'";
$result = mysql_query ( $sql );
$row=mysql_fetch_array($result);
echo $row['total_price'];

Query 2

php $sql = "SELECT SUM(total) AS total_price FROM retail_acom WHERE voucher_id = '$voucher_id'";
$result = mysql_query ( $sql );
$row=mysql_fetch_array($result);
echo $row['total_price'];

Combining Multiple Form Items To One DB Field
Is there a way to combine the values of multiple form items such as two
textboxes and one radio button for insertion into one MYSQL database
field?

Multiple Queries
I've made a database where I store facts from soccer matches. Every match report is stored with a unique id and the month of the year the game was played (I use date("my"). Each report is also given a "match code" wich tells what tournament the match was played in.

I whant to display a complete list of all the matches played this season, wich month and wich tournament the matches took place in.

So the question is; Is it possible to use a single query to get this information? My idea was to do a query on the "match code" and the month the game was played, but that did not work. Should i rather use the actual date the game was played? Could anyone give me an example of the query i'm looking for?

Example:
List all matches played in Premier League the month of august.

Multiple SQL Queries Under PHP
Im running multiple sql statements to bring in data from 3 tables in a single database. My first two sets of queries accesses the correct tables and returns the data to its correct position within the HTML document. Building the 3rd query though has given me an err about mysql_fetch_assoc(): Supplied argument is not a valid MySql Result Resource in (Page Location) - Now im assuming I should be using subqueries to compile my statements but im not sure how to bring them together. Here are my first two queries in order followed by the 3rd one that does not work.

Multiple Queries
I am trying to query data and most of the process is going well. I have an HTML logon form which posts data to this php script which authnticates the user.

// query to authenticate user
$sql = "SELECT ClientNo FROM users WHERE username='$username' and password='$password'";
$result = mysql_query($sql)or die ("Unable to get results.");

This authnticates a user to the database and works fine. But now I need to show only those records that are unique to the ClientNo from the first script. I am using another query to try and do this and this is as far as I can get Code:

Multiple Queries
I am currently working on coding a forum from scratch. I have never done any massive access website, but I am aware one should always try to optimize the code so as to not have the db do much work (among other optimizations). Yet, I have some across some cases where, either because of ignorance or because of not addressing the issue properly, I have to do two different sql queries in one page. Now, is this common? Is it bad?

Let me give you something concrete to work with. In a forum, when you make a new thread, not only do you add (INSERT INTO...) a thread entry to the thread table, but you also need to add a post entry to the post table (well, of course this depends on how your db is sorted out). Thus, I would have to make two sql insert statements once the form with all the information is submitted.

And on the subject of multiple queries, what is more memory effective? Two sql statements, or one with a JOIN clause?

Multiple Queries With PDO
I want to issue multiple queries in my script using PDO. All of of these queries will either retrieve one row with multiple columns or one row with one column, so I am using either fetch or fetchColumn to get the data.

Now, I ran into an error message telling me: "General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll()."

If there is only one row being retrieved (and I know this for sure), how is it that unbuffered queries are still active?

And whats the most effective way to get around this? I can use fetchAll or loop with fetchColumn or call PDOStatement->closeCursor(); after each query data retrieval statement.

Multiple Queries
is there a qway to put a bunch of queries into one?

Query Inside Queries?
What I'm trying to do is send a query to a DB to select all rows with a matching field. Then sort out all but one that has a perticular value in a different field.

I will also be performing a similure query that will sort the data in an order I specify. I think I can use the sort command but can you tell it what order to sort with?

So theres two problems, if you need more ifo I'd be more then happy to layout everything for you to look over.

Multiple Queries For Data?
I am a beginner to php and mysql and have a question about running
queries to gather information for a page I am building.

I am building a beer website where the member can see infromation
about beers, breweries and rate the beer. When the user finds a
beer they would like information about I would like to display on
one page:

Brewery Information - Name, address, etc.
Beer specifics like type, alcohol percent, etc.
Tasting information.

I have the brewery information in one table, the beer information in
another, and the how members have rated the beer in another.

I have run a query to join the beer and brewery table according to
the beer selected to tale care of the data for the first two items.

SELECT *
FROM `beerstable`
LEFT JOIN (`brewerytable`) ON (beerstable.`BreweryID` =
brewerytable.`BreweryID`)
LEFT JOIN (`beerstyles`) ON (beerstable.`BeerStyleID` =
beerstyles.`BeerStyleID`)
WHERE `BeerID`='$beer_id'

I have another table that is used to capture when memners rate the
beer. There will be numerous records for the same been.

I would like to pull data to display the following on the same page
as above:

Number of people that have reviewed the beer.
Average score for each category.

Do I have to create another query to pull this information or is
there some kind of join I can do to accomplish this?

If you are interested in seeing the site to get a better
understanding I can send you the link and a username and password.

Multiple Queries In One Script
I have the following PHP script which gets a Job Number from a search
form and generates a web page which displays the record for that job:

$username="root";
$password="";
$database="foobar";

$Searchterm = $_GET['JobNumber'];

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query="select * from jobs where JobNumber like $Searchterm";

$result=mysql_query($query);
$num_results=mysql_num_rows($result);
$JobNumber=mysql_result($result,$i,"JobNumber");
$NSN=mysql_result($result,$i,"NSN");

echo various fields here

This part works fine.

----------------------------------

I now want to list other jobs which use the same NSN on the same page
under that display. This is the script I'm using:

$query2="select * from jobs where NSN like $NSN";
$result=mysql_query($query2);
$num_results=mysql_num_rows($result);
$JobNumber=mysql_result($result,$i,"JobNumber");

echo query2; (returns the correct query, including the NSN)
echo $num_results (returns nothing)

$i=0;
while ($i < $num) {

echo various fields here (returns nothing)

$i++;
}

Posting Multiple Queries
$sql = "INSERT INTO customer
(custid,username,password,title,firstname,lastname ,street,towncity,postcode,telno,mobile,email,glass es)
VALUES
('$custid','$username','$password','$title','$firs tname','$lastname','$street',
'$towncity','$postcode','$telno','$mobile','$email ','$glasses')";INSERT
INTO orders(custid,pid)VALUES('$custid','$pid')";

$result = mysql_query($sql);

nothing happens.

So I do a

print "$sql";

and copy the result into a phpmyadmin SQL window

The query works just fine. Anyone know why?

Multiple Queries To MySQL
I am querying each column twice; once to see how many people said 'Yes' to that question, and again to see how many people said 'no' to that question. This means a total of 38 queries. Is this the right way to do it or is there a better way? Like just one BIG query? Code:

Multiple Search Queries
I have no code to post as of yet, just want to know whats going to be the best route to take. Im going to have 3 or 4 drop down boxes each one allowing the user to define the search in differnt ways. Whats going to be the best way to carry the variables? Im thinking the post method but not sure. Any ideas?

Optimise Two Mysql Queries To One Query
$a = mysql_query("Select a,b FROM t WHERE category=1")
while($a) {
$x = $a[a];
//some echo
//another query

$b = mysql_query("Select * FROM t WHERE subcategory=$x")
while ($b) {
//some echo
}
}

Point is that I have menus, parents with childes (childes are not
parents) and I want to display them using only one query.

- Parent 1
-- Child 1
-- Child 2
- Patent 2
-- Child 3

Having Trouble With Multiple Update Queries
I am working an an application to enumerate users and permissions
they have to read certain fax queues on a fax server. The problem I am
having is that I can't figure out a way to let the admin grant
permission to users to users in bulk. What I do is print out a table
with checkboxes for each queue. I can name the checkboxes anything, but
right now I an naming them with fax queue id, but I could just as easily
name then like an array like "queueid[]". The problem is, how do I tell
php that the checkbox and the $queue_id variables are to be processed
together? ...

Multiple Select Box Search Queries
I am trying to create an elegant query together with a multiple select box, tbl_level linked by a foreign key. Sample code below:

$sql = "SELECT DISTINCT Firstname,.... FROM .... ";

//conditional statement to determine whether WHERE clause is needed
if($_POST["FirstName"] != "" {
$sql .= "WHERE ";
if($_POST["Firstname"] != "") {
$sql .= "Firstname LIKE
"".addslashes($_POST["Firstname"]).""" }

//select box entries array Level

if($_POST["Level"] != ""){
$i=0;$query.="( ";
foreach ($_POST["Level"] as $val{
if ($i >0){$query.= " AND ";}
$query .= "tbl_level.LevelCatID LIKE $val ";
$i=1;}
$query.=" )";
$query.= " AND tbl_name.NameID = tbl_level.NameID"; }
//query database

I can't use this as only a single Level select selection works, if user selects more , I can' t search the Level column for 2nd input from the select box using this. I am trying to avoid too many calls to the database, As I have several multiple select options for user to input for searching.Am trying to call single complex query at the end of code.

Executing Multiple SQL Queries (MySQL)
I am writing an install script, which needs to build the tables and insert specific records for the application. There are about 50 or so queries. (format exported via phpMyAdmin) I've got all these queries in a file - how do I go about running them all individually?

Clause - I can't simply use file() and do each like that. The SQL statement for the tables is in a multiline format, like this: Quote:

CREATE TABLE `categories` (
`ID` int(11) NOT NULL auto_increment,
`parentID` int(11) NOT NULL default Ɔ',
`name` text NOT NULL,
`description` text NOT NULL,
`filename` text NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) TYPE=MyISAM;

Multiple Queries Or Sorting Arrays?
I have two tables, one with info about users, and one with gamestatistics. On one page I do four queries to these two tables and present it in four separate tables (ie table one - names and scored goals, sorted by goals desc; table two - names and played games, sorted by games desc ...).

I would like to run one query instead and fetch all the data needed, and then sort the array four times in different orders. Can this be done, and if so, how? What's the most efficient way to do this, multiple queries or sorting an array?

Multiple Queries That Print To The Same Table?
I have a query that is hitting the same table for the same info just by different means.

1st query looks info up by position.
2nd query looks info up by name.

At this moment the 2nd query works. If I free the result for the 2nd query before it starts then the 1st query works and the second one doesn't. Code:

Multiple SELECT Queries Combined
I have several SELECT queries on a few of my webpages, and I have been told that the more query connections that are open the slower the server will run.

So firstly, is it possible to merge/combine 2 SELECT queries into a single query? Code:

Select And Display Multiple Queries / Results
Howdy all, i've been looking through various sites / tutorials and through this php book I have here to try figure out whats causing this problem but haven't had any luck yet.

The problem is that its displaying the Designation as the link url instead of the jcode. Hope i explained this well. Above this bit of code has calls the individual Catagorys, if theres data in that catagory it will display it with whats below. PHP Code:

Displaying Multiple Queries To Same Table Excluding Different Rows!
i've got a table with 224 town listings and their ID's in it from 6 counties, and I want it to displayin a 6 columned table, each county getting their own column. Anyway, here's what I've got and what's happening: PHP Code:

Trying To Make Populated Drop Down Box Query
My host is Godaddy, sql 4.1 - trying to create a populated drop down list that when submitted, displays the info row by row. I can populate the list, and when I post it takes me to the next page. The php on the next page makes the table header but there is no data underneath.

There is data in the table cause I can display it all on another php page I have. Code:

How To Make An Array With Query Results? (Postgresql)
Need help making an array with query results:

$value = $_POST['text'];

$pg = pg_connect('dbname=test user=user password=secret');

$query = "SELECT column FROM information";
$result = pg_query($query);

*** how to create array with $results ***

What To Use In PHP To Make User Input Safe For MySQL Query?
I believe that you want to escape certain characters in a query, like quotes, backslash, semi-colon, etc. Is there a function in PHP to do all this for you and make the string safe to use as a query string?

How To Make MYSQL Query To Sort The Articles By Date ??
I am developing a site using PHP and MYSQL where i can post articles. Each Article has features like author, date, data etc... I want to find out top 5 recent articles.

I store the date of an article in database as $timeStamp = Date("F j, Y");

when i make a query to retrieve the latest article by date as:

$result = mysql_query("SELECT * FROM postData ORDER BY postDate DESC LIMIT 0, 5");

it doesn't give any output...

A Simple Form Query
Can any help me? What I want to do is simple but I can't find anything to help aside from a little php that doesn't help.

I have a form with three text areas, I would like this form, when submit is clicked, to take the user to an HTML formattable output page of the heading of the text areas and the info the user typed in, a preview page if you will. It will be so the user can print the formatted output and file it in their student logs. Or they can save the html output file.

I found a php script that does output to a php file, with the headings and results, only I don't know how to format the php to accept my external css file.

Any help appreciated, I have a headache from searching for options!

Ellie

Here is an example of what I was doing...Any solution is welcome but for a linus server

<?php
$prefer = $_POST["prefer"];
$develop = $_POST["develop"];
$challenge = $_POST["challenge"];
if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Personal INFO</title>
<link rel="StyleSheet" href="style.css" type="text/css" />

</head>
<body>
<form method="post" action="<?php echo $PHP_SELF;?>">
<p>Which opportunity do you prefer and why?
<textarea rows="5" cols="20" name="prefer" wrap="physical"></textarea>
<br />
How could you use this opportunity to develop yourself?
<textarea rows="5" cols="20" name="develop" wrap="physical"></textarea>
<br />
What might challenge you?
<textarea rows="5" cols="20" name="challenge" wrap="physical"></textarea>
<br />
</p>
<input type="submit" value="submit" name="submit">
</form>

<?
include "<link rel='StyleSheet' href='style.css' type='text/css' />";
} else {
echo "<p>Which opportunity do you prefer and why?</p> ".$prefer." <br />";
echo "Which opportunity do you prefer and why?<br /> ".$develop." <br />";
echo "Which opportunity do you prefer and why?<br /> ".$challenge." <br /></p>";
}
?>

Simple POST Query
I have a simple query but due to my lack of php knowledge, can't find the right function.

Let's say I have a form with 3 input fields.

[field1] => 'hello'
[field2] => 'ok'
[field3] => 'goodbye'

When I submit the page, I would like to echo this result:

[field1]
[field2]
[field3]

In other words, I want to have control over the posted header to determine if I should input in database the variable or not. If I use $HTTP_POST_VARS it actually returns the variable inside the header... i actually need the header's name.

Simple Mysql Query
mysql_query("UPDATE table SET field='$value' WHERE class='2'");

How can I make that update every row where the class is 2 or greater?

Simple Query String Not Passing
I've been messing with PHP for a few months now, and have some basics down. However, I thought I understood this issue, but here I am posting... <heavy sigh>.

Two files: register.php which is the form to allow a user to register with the site, and success.php which does the form validation, etc. If invalid input is found, I'm using the code below to go back to the register page.

@header("Location: http://url/register.php?id=1");

The id is examined in a switch statement on the register page to generate a message on the register form telling the user exactly what field the problem occurred in.

Here's the problem: The id value is not being passed in the redirect.

Can anyone tell me what I'm doing wrong?

AJAX, PHP, Mysql Simple Query Example Anyone?
I'm having a heck of a time wrapping mind around AJAX.

Anyone know of a simple, straight-forward example for pulling a simple
query from mysql with PHP using AJAX?

As I understand it I need a PHP script that pulls the query and dumps the
data into XML format, that is called by triggering a javascript event that
reads that file with XMLhttprequest.

Is there a cross-browser way of doing this or do I have to detect whether
I'm using IE or Mozilla?

A good example that doesn't look like rocket science would be nice.

Better MySQL/PHP Query Formatting (simple Question)
I have been using MySQL in conjunction with PHP for many years now...
I have been using the exact same method for not only connecting to a
database and performing the queries but also displaying the results.

I've been told numerous times that my methods are out-dated. I'm more
than willing to cede to this possibility but I need help getting out
of the rut!!! Can anyone help me?

Here are some examples:

<head>
....
<?php include "../../../_private/mysql.inc"; ?>
<?php $db = mysql_connect("$server","$user","$pass"); ?>
....
</head>
<body>
....
<?php
mysql_select_db("database_name",$db);
$result = mysql_query("SELECT * FROM temple_items",$db);
while ($myrow = mysql_fetch_array($result)) {
$id = $myrow["ID"];
$name = $myrow["Name"];
$amount = $myrow["Amount"];
$date = $myrow["Date"];
echo "<div>" . $name . ": " . $amount . " (" . $date . ")</div><br
/>";
}
?>
....
</body>

It's crap, I know... I've been told that there are more efficient ways
of doing nearly all of this. Can someone instruct me in the ways of
better database queries? I'm hopeless until I have this knowledge.

Simple Menu, MySQL Query Question
I'm creating simple menu.

MySQL:

+----+-----+----------------------+
| id | sid | Title |
+----+-----+----------------------+
| 1 | 0 | Main Menu 1
| 2 | 0 | Main Menu 2
| 3 | 1 | SubMenu 1 of menu 1
| 4 | 1 | SubMenu 2 of menu 1
| 5 | 1 | SubMenu 3 of menu 1
| 6 | 2 | SubMenu 1 of menu 2
+----+-----+----------------------

What should be my query? I'm trying to select all titles, and display them:

Main Menu 1
- SubMenu 1 of menu 1
- SubMenu 2 of menu 1
- SubMenu 3 of menu 1
Main Menu 2
- SubMenu 1 of menu 2

Simple Question: Query String Variable And More
suppose i have two html-formatted documents with appropriately coded <?php ?> areas.

a typical query is this: file.php?call=123.html

in 123.html i define a variable $doctitle

How can I display $doctitle in file.php (an html-formatted file as well)

Update Multiple Rows And Fields. Simple?
Hi. Im trying to create a form which will enable the user to update mutiple rows and fields, using checboxes to select and a submit button. The code below updates the field, but it always inserts the last row in the db. It inserts it in the selected row number (catalog), but it inserts the same data over an over (the last row in the db). Also, if more than one checkbox is selected, I get error Error in Query: >>>UPDATE catalog SET Name='Fred' , StreetAddress=ûû yadda, City='somewhere' , Country='USA' WHERE catalog=(8,30)<<<. Error: You have an error in your SQL syntax near ཚ)' at line 1
(8,30) are the numbers/checkboxes I selected and the data (fred, etc.) is from the last row, and is not what I type in the text fields. Ideas? Thanks.

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:

Query With Multiple OR Statements
trying to match the HTTP VARS application_id to the table products.products_application1
The code below works, but I need it to also check products_application2, products_application3, products_application4, products_application5, products_application6 for the same HTTP VARS value. 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?

Multiple Statements In Query
Is it possible to query multiple statements at once?
Like:
$query = "set @p := 1; select @p + 1";
$results = mysql_query($query);

I'm thinking of PHP4. There is in mysqli the prepare statement,
but I can't use that.

Multiple Sql Query Results
I'm trying to do a query from 2 databases. Basically i have
catagories within 2 databases. If both catagories return 0 rows then it
does nothing but if one or both have rows returned then i need it to
echo a result. I guess where i'm wondering if there's an OR statement i
can use or something to that effect...

something like

if($numrows == 0 OR $numrows2 == 0) {
echo ('');
}else{
echo ('$result');

Multiple SELECT COUNT()'s In One Query?
I'm creating a script that, fairly often throughout, I need to use a SELECT COUNT() query on two seperate tables - this seems to be slowing the script down quite a bit, and if the script remains this slow, it won't be of much use to me...which would be very bad!

Is there anyway to combine these two to grab the COUNT() value from both in one query?

Mysql Query Multiple Conditions.
Hi i want to do a mysql select with more than 1 conditions.

I have this:

select * from phpbb_posts where post_time = 1064078039;

but i want to be able to select multiple post_time's. I'm guessing it was something like this:

select * from phpbb_posts where post_time = (1064078039, 1034078039, 10640744039, 10643378039, 1064076039);

but thats obviously wrong. Anyone can help here?

Combining Multiple Queries To Make One Simple Query.

I'm trying to combine 3 queries but having difficulties getting the results I want. the query is:....

I'm trying to combine 3 queries but having difficulties getting the results I want.

the query is:....