Location: PHPKode > projects > Pet Grooming Management System > pet/changeVendor2.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<title>PGMS Find Vendor 2</title>
<style type="text/css">
a { font-size: 16pt; } 
td { font-size: 16pt; }
$operator = $_COOKIE['user'];
$a = $_GET['a'];
$a = $a.'%';
require_once ('info.inc');
$link = mysql_connect('localhost',$r,$p) or die("Could not connect to Host.");
mysql_select_db($d) or die("Could not select database.");
$query = "select vid,name
       from vendors
       where name like '$a'";
$result = mysql_query($query) or die("Could not run query.");
$numrows = mysql_num_rows($result);
$numVendors = $numrows;
for ($i=0;$i<$numrows;$i++)
 $row = mysql_fetch_array($result);
 $vid[$i] = $row['vid'];
 $vname[$i] = $row['name'];
require ('header.inc');
echo '<center>';
echo'<p style="font-size: 16pt; color: #ff0000;">Click on the Vendor\'s name</p>';
echo'<table border="0" cellpadding="1" cellspacing="1" summary="">';
echo'<tr><td style="font-size: 16pt;">Vendor</td></tr>';
for ($i=0;$i<$numVendors;$i++)
 echo'<tr><td><a href="changeVendor3.php?vid='.$vid[$i].'">'.$vname[$i].'</a></td></tr>';
require ('footer.inc');
Return current item: Pet Grooming Management System