Solved

How can I dynamically update an webpage table based on listbox selections?

Posted on 2009-07-05
22
246 Views
Last Modified: 2013-12-13
Hi Experts

I have a list box that shows all the venues available, I also have tables of results generated from mysql database for each of these venues.

Currently I just have links to each new table which is on a seperate web page, but I really need to generate a listbox that shows all the venues and then deending on which is selected have a table generated to show the results that correspond to the selection.

I have the list box working, but am stumped as to how i dynamically change the mysql query.
The query I use is below, the bit I need to dynamically change to match the listbox is the Venue.VenueName in this instance 'The First & Last'

Thanks a million (well 250 at least!)
$query = "SELECT SUM(Position.Points), Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)

FROM Position, Player, Results, Venue

WHERE Player.MembershipNo = Results.MembershipNo

AND Date

BETWEEN '2009-07-05'

AND '2009-10-04'

AND Results.Position = Position.Position

AND Venue.VenueID = Results.VenueID

AND Venue.VenueName = 'The First & Last'

GROUP BY Player.MembershipNo

ORDER BY SUM(Position.Points) DESC";

Open in new window

0
Comment
Question by:DrEvilAces
  • 13
  • 9
22 Comments
 
LVL 7

Expert Comment

by:szewkam
ID: 24779665
you mean something like this?
<?php

if (isset($_POST['vname'] && !empty($_POST['vname']) {

//connection db stuff

$query = "SELECT SUM(Position.Points), Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)

FROM Position, Player, Results, Venue

WHERE Player.MembershipNo = Results.MembershipNo

AND Date

BETWEEN '2009-07-05'

AND '2009-10-04'

AND Results.Position = Position.Position

AND Venue.VenueID = Results.VenueID

AND Venue.VenueName = '".mysql_real_escape_string($_POST['vname'])."'

GROUP BY Player.MembershipNo

ORDER BY SUM(Position.Points) DESC";

//executing the query, fetching and displaying results

}

?>

<form action="" method="post">

  <select name="vname">

    <option value="1stname">1stname</option>

    <option value="2ndname">2ndname</option>

    <option value="3rdname">3rdname</option>

  </select>

  <input type="submit" />

</form>

Open in new window

0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24780287
Hi Szewkam
Thanks for the advice, but can you help me unerstand this a bit more please?

Do I need to change anything in if (isset($_POST['vname'] && !empty($_POST['vname']) to match the name of my listbox?

If i replace the  <option value="1stname">1stname</option>
with  <option value="The First & Last">The First & Last</option> and then presumably then I change the whole list to match the contents of the Listbox.

As you can see I'm still learning can you help me understand what i need to change and how I actually apply it please.

I tried a few things but not got anywhere yet!

Thanks so much for your help
0
 
LVL 7

Expert Comment

by:szewkam
ID: 24780361
of course, you have to change the name of variable ($_POST['vname']) to whatever name has your listbox. My options was only a demonstration to show how it is working. So you should write as mane options as you need and give them proper values.

It would be much easier to me to help you if you post your code here. Then I could change it without playing with my names o variables and speaking with generals
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24780511
Hi Szewkam

Thanks for the help, I've attached all of the php code from the page I'm working on. This includes the list box, but not all the other stuff.
I'll have another play around with the code and see if I can work it out as well, but if you could have a look in context with my code I'd really appreciate it.

Thanks
 <?php

	// Make a MySQL Connection

mysql_connect("XXXX", "XXXX", "XXXX") or die(mysql_error());

mysql_select_db("XXXX") or die(mysql_error());
 
 

//mySQL queries

$query = "SELECT pl.MembershipNo, pl.FirstName, pl.LastName, ve.VenueName, SUM( po.Points ) AS pos_points, COUNT( re.MembershipNo ) AS count_results

FROM Player pl

JOIN Results re ON pl.MembershipNo = re.MembershipNo

JOIN Position po ON re.Position = po.Position

JOIN Venue ve ON ve.VenueID = re.VenueID

GROUP BY 1 , 2, 3, 4

HAVING pos_points >=750

ORDER BY pos_points DESC"; 

$result=mysql_query($query)

		or die ("couldn't execute query");
 

echo <<<html

<table  border="1" width="480" cellpadding="1" cellspacing="1">

	<tr><td align="center"><strong>Pos.</strong></td>

		<td align="center"><strong>First</strong></td>

		<td align="center"><strong>Last</strong></td>

		<td align="center"><strong>Venue</strong></td>

		<td align="center"><strong>Chips</strong></td>

		<td align="center"><strong>Played</strong></td>

		

	</tr>

html;
 

//Now start the loop.
 
 

$pos=1;
 
 

while($r = mysql_fetch_array($result)){

	//and echo each new row

	

	echo <<<html

	<tr><td align="center">$pos</td>

		<td align="center">{$r['FirstName']}</td>

		<td align="center">{$r['LastName']}</td>

		<td align="center">{$r['VenueName']}</td>

		<td align="center">{$r['pos_points']}</td>

		<td align="center">{$r['count_results']}</td>

		

	</tr>

html;

$pos++;	}
 

//And close the table.

echo "</table>";
 
 
 
 

?>
 

	

		       

		</div>

	  </div>

  <div id="secondaryContent">

   	  <h3>Choose your report</h3>

         <form> <?php

			  

	  ////////////// Do not  edit below/////////
 

connecttodb($servername,$dbname,$dbusername,$dbpassword);

function connecttodb($servername,$dbname,$dbuser,$dbpassword)

	{

		global $link;

		$link=mysql_connect ("$servername","$dbuser","$dbpassword");

		if(!$link){die("Could not connect to MySQL");}

		mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());

	}
 

$query="SELECT VenueName, VenueID FROM Venue ORDER BY VenueName";
 

$result = mysql_query ($query);

echo "<select name='Venue' id='Venue' value=''>Venue Name</option>";

// printing the list box select command
 

while($nt=mysql_fetch_array($result))

	{//Array or records stored in $nt

		echo "<option value=\"$nt[VenueID]\">$nt[VenueName] ($nt[VenueID])</option>";

		/* Option values are added by looping through the array */

	}

echo "</select>";// Closing of list box 
 

?></form>

Open in new window

0
 
LVL 7

Expert Comment

by:szewkam
ID: 24780573
if i understand correctly your code the last part is what you want :).
I made a few minor changes you'll see in snippet (PART 1). Then in script where you will be executing the query from first post and displaying the result you put something like in snippet (PART 2)

//PART 1

<form action="script_which_will_be_displaying_results.php" method="post"> 

<?php

//connection to db

 

$query="SELECT VenueName, VenueID FROM Venue ORDER BY VenueName";

 

$result = mysql_query ($query);

echo "<select name='Venue' id='Venue'>";

// printing the list box select command

while($nt=mysql_fetch_array($result))

        {//Array or records stored in $nt

                echo "<option value=\"$nt[VenueID]\">$nt[VenueName] ($nt[VenueID])</option>";

                /* Option values are added by looping through the array */

        }

echo "</select>";// Closing of list box 

 

?></form>
 

//PART 2

<?php

if (isset($_POST['Venue'] && !empty($_POST['Venue']) {

//connection db stuff

$query = "SELECT SUM(Position.Points), Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)

FROM Position, Player, Results, Venue

WHERE Player.MembershipNo = Results.MembershipNo

AND Date

BETWEEN '2009-07-05'

AND '2009-10-04'

AND Results.Position = Position.Position

AND Venue.VenueID = Results.VenueID

AND Venue.VenueName = '".mysql_real_escape_string($_POST['Venue'])."'

GROUP BY Player.MembershipNo

ORDER BY SUM(Position.Points) DESC";

//executing the query, fetching and displaying results

?>

Open in new window

0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24780672
<form action="script_which_will_be_displaying_results.php" method="post">

So do I now need to create a stand-alone .php file that generates the actual table results?
Lol, I'm slowly getting more confused sorry!!

I only have 400 points left but if you can help me get this working your welcome to all of them! (not exactely the offer of a lifetime I know!)
0
 
LVL 7

Expert Comment

by:szewkam
ID: 24780692
well script you gave us is displaying some other results using another sql statements. So the easiest way will be creating another script which will be generating result using the listbox
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24780820
Below is the original full code from the page, this is the original page before i added the list box. This displays the full table in the main part of the page. In the previous code it places the listbox above the links.

So do I need to move the code that creates the table into a seperate file, but leave the code that generates the content of the table and the list box in the main page file...is that right?

I'm sorry for being such a noob, but I didn't think this bit would as hard as this, I though it would be a case of just adding a couple of lines!!

Thanks for your ongoing help!
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<title>GB Poker Club - Chequers</title>

<meta name="keywords" content="" />

<meta name="description" content="" />
 

<link href="css/default.css" rel="stylesheet" type="text/css" />

<style type="text/css">

<!--

#apDiv1 {

	position:absolute;

	left:13px;

	top:878px;

	width:62px;

	height:80px;

	z-index:3;

}

#apDiv2 {

	position:absolute;

	left:154px;

	top:1199px;

	width:108px;

	height:40px;

	z-index:3;

}

#apDiv3 {

	position:fixed;

	left:0px;

	top:0px;

	width:171px;

	height:134px;

	z-index:3;

}

-->

</style>

<style>

.tab{font-family: arial, verdana, san-serif; font-size: 14px;}

.asd{text-decoration: none; font-family: arial, verdana, san-serif; font-size: 13px; color: #6F5129;}

.style16 {font-size: xx-small}

.style19 {font-size: x-small}

</style>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>

</head>

<body>

<div id="outer">

	<div id="header">

		<h1>

		  <?php

		  include 'menubar.js'

		  ?>

	    <span class="style16">.</span>

	<?php

include 'menubar.php';

?>

	<div id="content">

	  <div id="primaryContentContainer">

		<div id="primaryContent">

				<h3>Chequers league positions</h3>

                

                <?php

	// Make a MySQL Connection

mysql_connect("XXXX", "XXXXX", "XXXX") or die(mysql_error());

mysql_select_db("XXXXX") or die(mysql_error());
 
 

//mySQL queries

$query = "SELECT SUM(Position.Points) , Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)

FROM Position, Player, Results, Venue

WHERE Player.MembershipNo = Results.MembershipNo

AND Date

BETWEEN '2009-07-05'

AND '2009-10-04'

AND Results.Position = Position.Position

AND Venue.VenueID = Results.VenueID

AND Venue.VenueName = 'The Chequers'

GROUP BY Player.MembershipNo

ORDER BY SUM(Position.Points) DESC"; 

$result=mysql_query($query)

		or die ("couldn't execute query");
 

echo <<<html

<table border="1" width="480" cellpadding="1" cellspacing="1">

<tr><td align="center"><strong>Pos.</strong></td>

		<td align="center"><strong>First</strong></td>

		<td align="center"><strong>Last</strong></td>

		<td align="center"><strong>Points</strong></td>

		<td align="center"><strong>Played</strong></td>

	</tr>

html;
 

//Now start the loop.
 
 

$pos=1;
 
 

while($r = mysql_fetch_array($result)){

	//and echo each new row

	

	echo <<<html

	<tr><td align="center">$pos</td>

		<td align="center">{$r['FirstName']}</td>

		<td align="center">{$r['LastName']}</td>

		<td align="center">{$r['SUM(Position.Points)']}</td>

		<td align="center">{$r['COUNT(Results.MembershipNo)']}</td>

		

	</tr>

html;

$pos++;	}
 
 

//And close the table.

echo "</table>";
 

?>

	

		       

		</div>

	  </div>

  <div id="secondaryContent">

    <h3>Choose your report</h3>

    

    

    <ul><li><a href="playerslounge.php">Overall League</a></li>

      <li>Season Two

        <ul>

            <li><a href="playersloungePI.php">The Pheasant Inn</a></li>

            <li><a href="playersloungeSL.php">The Old Sugar Loaf</a></li>

            <li><a href="playersloungeCheq.php">The Chequers</a></li>

            <li><a href="playersloungeF&amp;L.php">The First &amp; Last</a></li>

          </ul>

      </li>

    </ul>

    </div>

	  <div class="clear"></div>

  </div>

<div id="footer">

		<p>Copyright &copy; 2009 gbpokerclub.co.uk All rights reserved</p>

  </div>

</div>

</body>

</html>

Open in new window

0
 
LVL 7

Expert Comment

by:szewkam
ID: 24780914
try something like this
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="content-type" content="text/html; charset=utf-8" />

<title>GB Poker Club - Chequers</title>

<meta name="keywords" content="" />

<meta name="description" content="" />

 

<link href="css/default.css" rel="stylesheet" type="text/css" />

<style type="text/css">

<!--

#apDiv1 {

	position:absolute;

	left:13px;

	top:878px;

	width:62px;

	height:80px;

	z-index:3;

}

#apDiv2 {

	position:absolute;

	left:154px;

	top:1199px;

	width:108px;

	height:40px;

	z-index:3;

}

#apDiv3 {

	position:fixed;

	left:0px;

	top:0px;

	width:171px;

	height:134px;

	z-index:3;

}

-->

</style>

<style>

.tab{font-family: arial, verdana, san-serif; font-size: 14px;}

.asd{text-decoration: none; font-family: arial, verdana, san-serif; font-size: 13px; color: #6F5129;}

.style16 {font-size: xx-small}

.style19 {font-size: x-small}

</style>

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>

</head>

<body>

<div id="outer">

	<div id="header">

		<h1>

		  <?php

		  include 'menubar.js'

		  ?>

	    <span class="style16">.</span>

	<?php

include 'menubar.php';

?>

	<div id="content">

	  <div id="primaryContentContainer">

		<div id="primaryContent">

<?php

	// Make a MySQL Connection

mysql_connect("XXXX", "XXXXX", "XXXX") or die(mysql_error());

mysql_select_db("XXXXX") or die(mysql_error());

$query="SELECT VenueName, VenueID FROM Venue ORDER BY VenueName";

 

$result = mysql_query ($query);

echo '<form action="" method="post">';

echo "<select name='Venue'>";

// printing the list box select command

while($nt=mysql_fetch_array($result))

        {//Array or records stored in $nt

                echo "<option value=\"$nt[VenueID]\">$nt[VenueName] ($nt[VenueID])</option>";

                /* Option values are added by looping through the array */

        }

echo "</select>";// Closing of list box 

 

?>

<input type="submit" />

</form>
 

				<h3>Chequers league positions</h3>

<?php 

if (isset($_POST['Venue'] && !empty($_POST['Venue'])) {

//mySQL queries

$query = "SELECT SUM(Position.Points) , Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)

FROM Position, Player, Results, Venue

WHERE Player.MembershipNo = Results.MembershipNo

AND Date

BETWEEN '2009-07-05'

AND '2009-10-04'

AND Results.Position = Position.Position

AND Venue.VenueID = Results.VenueID

AND Venue.VenueName = '".$_POST['Venue']."'

GROUP BY Player.MembershipNo

ORDER BY SUM(Position.Points) DESC"; 

$result=mysql_query($query)

		or die ("couldn't execute query");

 

echo <<<html

<table border="1" width="480" cellpadding="1" cellspacing="1">

<tr><td align="center"><strong>Pos.</strong></td>

		<td align="center"><strong>First</strong></td>

		<td align="center"><strong>Last</strong></td>

		<td align="center"><strong>Points</strong></td>

		<td align="center"><strong>Played</strong></td>

	</tr>

html;

 

//Now start the loop.

 

 

$pos=1;

 

 

while($r = mysql_fetch_array($result)){

	//and echo each new row

	

	echo <<<html

	<tr><td align="center">$pos</td>

		<td align="center">{$r['FirstName']}</td>

		<td align="center">{$r['LastName']}</td>

		<td align="center">{$r['SUM(Position.Points)']}</td>

		<td align="center">{$r['COUNT(Results.MembershipNo)']}</td>

		

	</tr>

html;

$pos++;	}

 

 

//And close the table.

echo "</table>";

}

?>

	

		       

		</div>

	  </div>

  <div id="secondaryContent">

    <h3>Choose your report</h3>

    

    

    <ul><li><a href="playerslounge.php">Overall League</a></li>

      <li>Season Two

        <ul>

            <li><a href="playersloungePI.php">The Pheasant Inn</a></li>

            <li><a href="playersloungeSL.php">The Old Sugar Loaf</a></li>

            <li><a href="playersloungeCheq.php">The Chequers</a></li>

            <li><a href="playersloungeF&amp;L.php">The First &amp; Last</a></li>

          </ul>

      </li>

    </ul>

    </div>

	  <div class="clear"></div>

  </div>

<div id="footer">

		<p>Copyright &copy; 2009 gbpokerclub.co.uk All rights reserved</p>

  </div>

</div>

</body>

</html>

Open in new window

0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781030
That seems so close (to my untrained eye!)

I use Dreamweaver, and in the preview I all seems in place, although you dont actually get to view the php output just the html.
I've re-inserted my db login details, and saved the whole lot into a new test page, but unfortunately still get a white blank page when I view it (www.gbpokerclub.co.uk/playersloungeLB1.php)
I intentionally changed my login details to make them incorrect to see if I would at least get a login error, but I dont even get that!

Does that mean something is wrong before it tries to access the database?
0
 
LVL 7

Expert Comment

by:szewkam
ID: 24781093
try to put lines from snippet at the very beginning of your script. Before doctype declaration
<?php

error_reporting(E_ALL);

?>

Open in new window

0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781110
Still just a blank page!

I assume that is meant to show any php errors on the page?
0
 
LVL 7

Expert Comment

by:szewkam
ID: 24781156
it should show... in that case i have no idea why it is blank.
Right now the only solution I can give you is to remove all my modifications and try to add them practically by one line or one basic operation. Check which line is causing the problems :)
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781165
I'll give it a go!

I'll remove all the php and run it then add it back bit by bit and see what happens!

Thanks for all the help so far I really appreciate it.
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781210
Ok the first part of the php is fine I get the page and the list box and the submit button.
When I put the second art of the code back in things start going wrong and the page just goes blank, so the problem must be in here somewhere...(see snippet)

Also if I take out the If statement before the query and the last curly bracket, i also get a page diesplayed with the listbox and button, but the formatting goes haywire and the left hand links bar ends up n the right!

But I think this means it is in the If statement somewhere!

The test page is here...http://www.gbpokerclub.co.uk/playersloungeLB2.php
<?php 

if (isset($_POST['Venue'] && !empty($_POST['Venue'])) {

//mySQL queries

$query = "SELECT SUM(Position.Points) , Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)

FROM Position, Player, Results, Venue

WHERE Player.MembershipNo = Results.MembershipNo

AND Date

BETWEEN '2009-07-05'

AND '2009-10-04'

AND Results.Position = Position.Position

AND Venue.VenueID = Results.VenueID

AND Venue.VenueName = '".$_POST['Venue']."'

GROUP BY Player.MembershipNo

ORDER BY SUM(Position.Points) DESC"; 

$result=mysql_query($query)

		or die ("couldn't execute query");

 

echo <<<html

<table border="1" width="480" cellpadding="1" cellspacing="1">

<tr><td align="center"><strong>Pos.</strong></td>

		<td align="center"><strong>First</strong></td>

		<td align="center"><strong>Last</strong></td>

		<td align="center"><strong>Points</strong></td>

		<td align="center"><strong>Played</strong></td>

	</tr>

html;

 

//Now start the loop.

 

 

$pos=1;

 

 

while($r = mysql_fetch_array($result)){

	//and echo each new row

	

	echo <<<html

	<tr><td align="center">$pos</td>

		<td align="center">{$r['FirstName']}</td>

		<td align="center">{$r['LastName']}</td>

		<td align="center">{$r['SUM(Position.Points)']}</td>

		<td align="center">{$r['COUNT(Results.MembershipNo)']}</td>

		

	</tr>

html;

$pos++;	}

 

 

//And close the table.

echo "</table>";

}

?>

Open in new window

0
 
LVL 7

Accepted Solution

by:
szewkam earned 405 total points
ID: 24781337
argh... i forgot about one bracket ;) The if statement should look like this:
if (isset($_POST['Venue']) && !empty($_POST['Venue'])) {
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781397
DUDE  your a genius....nearly :-P

That was the problem after all, but for some reason now the tables are not poulating with data, The list box works, the submit button works, the page refreshes and displays the table headers but no data :(

I know the general query structure works because I used it in the old one, the only difference is this line: AND Venue.VenueName = '".$_POST['Venue']."'
Which used to be: AND Venue.VenueName = 'The Chequers'

Is there anything wrong with that line?
I tried removing the " from each end but that made no difference, I also tried without the ' and including () around it inside the ' marks, but that just leads back to a white page...

Soooo close now...
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781399
Oh and I changed to date period to make sure it included some data in it ;-)
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781413
Ah I think I worked it out I placed <h3><?php echo $_POST['Venue'] ?> League Positions</h3> to show which venue was selected, but it shows venue ID number not Venue name, if the array has venueIDs not VenueNames the query wont work.

I'm gonna try a fix..... brb
0
 
LVL 7

Expert Comment

by:szewkam
ID: 24781416
try change this line: echo "<option value=\"$nt[VenueID]\">$nt[VenueName] ($nt[VenueID])</option>";
to:
echo "<option value=\"$nt[VenueName]\">$nt[VenueName] ($nt[VenueID])</option>";
0
 
LVL 1

Author Comment

by:DrEvilAces
ID: 24781428
WOOOOOHOOOOOOOO

It works :-) :-)
Your truly are a genius it works :-)
Oh and I managed to work out that very last change already...yay I did something useful ;-)
Thank you sooo much for all your help and patience, I really really appreciate it.
TYTYTYTYTYTYTYTYTYTYTYTYTYTYTY :-D
0
 
LVL 1

Author Closing Comment

by:DrEvilAces
ID: 31599890
Thanks so much for you patience and expertise
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
simple shopping cart database structure 5 27
get domain with php 7 19
How can I echo a PHP variable in AJAX function? 7 28
SQL Query Syntax Join 4 27
If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now