| |
|
| Enter a phrase to search our product database |
|
|
$name=$name;
if ($name =="") {
// Set The Connection
$dbName = "moneyclip";
$MysqlName = "moneyclipsrus";
$MysqlPW = "xxxYYY0675";
mysql_connect("localhost",$MysqlName,$MysqlPW);
// Determine Committee
// Print Header
// Set Variables
$SelectStr = "SELECT * FROM moneyclip where PRODUCT_NAME like'%money%' or PRODUCT_DESC like'%money%' order by PRODUCT_NAME";
$Results = MySQL($dbName,$SelectStr);
$RowCount = MySQL_NUMROWS($Results);
// Start Running Through The Database
$i = 0;
WHILE ( $i < $RowCount)
{
// List
ECHO " | | ";
ECHO "| ";
ECHO "". MySQL_RESULT($Results,$i,"PRODUCT_NAME")." | ";
ECHO "";
ECHO "". MySQL_RESULT($Results,$i,"PRODUCT_PRICE")." | ";
ECHO " | ";
ECHO "". MySQL_RESULT($Results,$i,"PRODUCT_DESC")." | |
| ";
ECHO "";
ECHO " | ";
$i++;
} // End of while $i"") {
// Set The Connection
$dbName = "moneyclip";
$MysqlName = "moneyclipsrus";
$MysqlPW = "xxxYYY0675";
mysql_connect("localhost",$MysqlName,$MysqlPW);
// Determine Committee
// Print Header
// Set Variables
$SelectStr = "SELECT * FROM moneyclip where PRODUCT_DESC like'%$name%' and PRODUCT_NAME like'%money%' order by PRODUCT_NAME";
$Results = MySQL($dbName,$SelectStr);
$RowCount = MySQL_NUMROWS($Results);
// Start Running Through The Database
$i = 0;
WHILE ( $i < $RowCount)
{
// List
ECHO " | ";
ECHO "| ";
ECHO "". MySQL_RESULT($Results,$i,"PRODUCT_NAME")." | ";
ECHO "";
ECHO "". MySQL_RESULT($Results,$i,"PRODUCT_PRICE")." | ";
ECHO " | ";
ECHO "". MySQL_RESULT($Results,$i,"PRODUCT_DESC")." | |
| ";
ECHO "";
ECHO " | ";
$i++;
} // End of while $i
|