[Resolved] Input to select query

reflash

Another Noob question:

I have a page working that querys a database, and it works just fine. My question is: How can I present the user with a form that they input data to, and then when they submit, jump to this page that displays the data? Here's the code I've got:

<HTML>

<HEAD>

<BODY>

<?php

//include 'xpull.inc.php';

// Set Mysql Variables
$host='localhost';
$user='xxxxxx';
$pass='xxxxxx';
$db='xxxxxx';
$table='xxxxxx';

//$xColor=$POST['XColor'];
//$xGroup=$POST['XGroup'];

$xColor='r';
$xGroup='1';

mysql_connect($host, $user, $pass) or die('Connection died!');

mysql_select_db($db) or die('Selection died!');

$get_all = "SELECT * FROM $table WHERE Color='$xColor' AND Group='$xGroup'";

$myquery = mysql_query($get_all);

while ($row = mysql_fetch_array($myquery)) {
echo $row['FName'];?> <?php
echo $row['LName'];?> <?php
echo $row['UName'];?> <?php
echo $row['PWord'];?> <?php
echo $row['EMail'];?> <?php
}

</BODY>

</HTML>

I want to have the user input the values for $xColor and $xGroup. I have a working page with the form on it - the include is commented out because I don't want the form displayed again when the results are displayed.

reflash

Never mind! I figured it out. Here's the code (if anyone is interested):

<HTML>

<HEAD>

<BODY>

<?php

if (isset($HTTP_POST_VARS['xadd']))
{

// Set Mysql Variables
$host='localhost';
$user='xxxxxx';
$pass='xxxxxx';
$db='xxxxxx';
$table='xxxxxx';

$xColor=$POST['XColor'];
$xGroup=$POST['XGroup'];

mysql_connect($host, $user, $pass) or die('Connection died!');

mysql_select_db($db) or die('Selection died!');

$get_all = "SELECT * FROM $table WHERE Color='$xColor' AND Group='$xGroup'";

$myquery = mysql_query($get_all);

}
else
{

include 'xpull.inc.php';

}

</BODY>

</HTML>

The "xadd" in the if statement is the name for the submit button on the page xpull.inc.php that contains the input form.