PHP / SQL help for a n00b
Hello.
Right now PHP is "creating" a form based on some contents in my database.
Code for the form:
<?php
$con = mysql_connect("localhost","XXXXX","XXXXX");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("kristina_ponyisland", $con);
$result = mysql_query("SELECT DISTINCT club FROM colours");
print "
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>\n
<html xmlns='http://www.w3.org/1999/xhtml'>\n
<head>\n
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />\n
<title>RGB Compare Tool</title>\n
</head>\n
<body>\n
<form action='compare.php' method='post'>\n
RGB COMPARE TOOL<p/><p/>\n
Points:<select name='range' id='range'>\n
<option value='100'>100</option>\n
<option value='75'>75</option>\n
<option value='50'>50</option>\n
<option value='25'>25</option>\n
</select><p/><p/>\n
Clubs:<br/>\n";
while($row = mysql_fetch_array($result))
{
print"<INPUT TYPE=CHECKBOX NAME='";
print $row['club'];
print "' >";
print $row['club'];
print "<BR/>\n"
}
print "</p>\n
Eyes:<input type='text' name='eyes'><br\>\n
Main Hair:<input type='text' name='hair_1'><br\>\n
Second Hair: <input type='text' name='hair_2'><br\>\n
Body: <input type='text' name='body'><br\>\n
Main Extra:<input type='text' name='extra_1'><br\>\n
Second Extra:<input type='text' name='extra_2'><br\>\n
<input type='image' src='images/compare.png' value='Submit' alt='Submit'>\n
<input type='reset' value='Reset!'>\n
</form>\n
</body>\n
</html>";
mysql_close($con);
?>
What I am confused about is before I added the club checkboxes it would go to compare.php and run. Normally when I pass variables it's fairly straightforward but in this case I'm not sure.
Here's a copy of the previous compare . php. I haven't even tried adding the club variables because I have no idea how to go about it. Maybe someone can give me a hint.
<?php
$eye_colour = $_POST[eyes];
$eyes_r = substr($eye_colour,0,3);
$eyes_g = substr($eye_colour,4,3);
$eyes_b = substr($eye_colour,8,3);
$main_hair_colour = $_POST[hair_1];
$hair_r = substr($main_hair_colour,0,3);
$hair_g = substr($main_hair_colour,4,3);
$hair_b = substr($main_hair_colour,8,3);
$second_hair_colour = $_POST[hair_2];
$hair2_r = substr($second_hair_colour,0,3);
$hair2_g = substr($second_hair_colour,4,3);
$hair2_b = substr($second_hair_colour,8,3);
$body_colour = $_POST[body];
$body_r = substr($body_colour,0,3);
$body_g = substr($body_colour,4,3);
$body_b = substr($body_colour,8,3);
$extra_colour = $_POST[extra_1];
$extra_r = substr($extra_colour,0,3);
$extra_g = substr($extra_colour,4,3);
$extra_b = substr($extra_colour,8,3);
$second_extra_colour = $_POST[extra_2];
$extra2_r = substr($second_extra_colour,0,3);
$extra2_g = substr($second_extra_colour,4,3);
$extra2_b = substr($second_extra_colour,8,3);
$point_range = $_POST[range];
$con = mysql_connect("localhost","kristina_pony"
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("kristina_ponycolours", $con);
$result = mysql_query("SELECT * FROM colours ");
print "<table><th>Eye Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$eye_points = abs($db_r - $eyes_r) + abs($db_g - $eyes_g) + abs($db_b - $eyes_b );
if ($eye_points <= $point_range)
{
print "<tr> <td>";
print $eyes_r;
print "|";
print $eyes_g;
print "|";
print $eyes_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $eye_points;
print "</td><td>";
print "Eye colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $eye_points;
print"</td></tr>";
}
elseif ($eye_points = 0)
{
print "<tr> <td><b>";
print $eyes_r;
print "|";
print $eyes_g;
print "|";
print $eyes_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $eye_points;
print "</b></td><td><b>";
print "Eye colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $eye_points;
print"</b></td></tr>";
}
}
print "</table><p><p><table><th>Hair Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
$result = mysql_query("SELECT * FROM colours ");
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$hair_points = abs($db_r - $hair_r) + abs($db_g - $hair_g) + abs($db_b - $hair_b );
if ($hair_points <= $point_range)
{
print "<tr> <td>";
print $hair_r;
print "|";
print $hair_g;
print "|";
print $hair_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $hair_points;
print "</td><td>";
print "Hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair_points;
print"</td></tr>";
}
elseif ($hair_points = 0)
{
print "<tr> <td><b>";
print $hair_r;
print "|";
print $hair_g;
print "|";
print $hair_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $hair_points;
print "</b></td><td><b>";
print "Hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Extra Hair Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$hair2_points = abs($db_r - $hair2_r) + abs($db_g - $hair2_g) + abs($db_b - $hair2_b );
if ($hair2_points <= $point_range)
{
print "<tr> <td>";
print $hair2_r;
print "|";
print $hair2_g;
print "|";
print $hair2_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $hair2_points;
print "</td><td>";
print "Second hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair2_points;
print"</td></tr>";
}
elseif ($hair2_points = 0)
{
print "<tr> <td><b>";
print $hair2_r;
print "|";
print $hair2_g;
print "|";
print $hair2_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $hair2_points;
print "</b></td><td><b>";
print "Second hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair2_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Body Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$body_points = abs($db_r - $body_r) + abs($db_g - $body_g) + abs($db_b - $body_b );
if ($body_points <= $point_range)
{
print "<tr> <td>";
print $body_r;
print "|";
print $body_g;
print "|";
print $body_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $body_points;
print "</td><td>";
print "Body colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $body_points;
print"</td></tr>";
}
elseif ($body_points = 0)
{
print "<tr> <td><b>";
print $body_r;
print "|";
print $body_g;
print "|";
print $body_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $body_points;
print "</b></td><td><b>";
print "Body colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $body_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Extra Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$extra_points = abs($db_r - $extra_r) + abs($db_g - $extra_g) + abs($db_b - $extra_b );
if ($extra_points <= $point_range)
{
print "<tr> <td>";
print $extra_r;
print "|";
print $extra_g;
print "|";
print $extra_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $extra_points;
print "</td><td>";
print "Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra_points;
print"</td></tr>";
}
elseif ($extra_points = 0)
{
print "<tr> <td><b>";
print $extra_r;
print "|";
print $extra_g;
print "|";
print $extra_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $extra_points;
print "</b></td><td><b>";
print "Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Extra Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$extra2_points = abs($db_r - $extra2_r) + abs($db_g - $extra2_g) + abs($db_b - $extra2_b );
if ($extra2_points <= $point_range)
{
print "<tr> <td>";
print $extra2_r;
print "|";
print $extra2_g;
print "|";
print $extra2_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $extra2_points;
print "</td><td>";
print "Second Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra2_points;
print"</td></tr>";
}
elseif ($extra2_points = 0)
{
print "<tr> <td><b>";
print $extra2_r;
print "|";
print $extra2_g;
print "|";
print $extra2_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $extra2_points;
print "</b></td><td><b>";
print "Second Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra2_points;
print"</b></td></tr>";
}
}
print "</table>";
mysql_close($con);
?>
Also, if anyone has suggestions on how to improve the speed, or organization of the code that would be welcome too.
I know once I get the club part sorted out, I want to make the compare.php sort each table it prints based on the points. In the case of the eye table (AKA first table that gets printed out) it would be sorted based on the $eyes_points variable. Anyone who has a suggestion how to go about that would be awesome too.
Remember I'm a PHP / SQL n00b. It would be helpful to me to explain how something works in the case of the sort thing, or the form bit.
Thank you so much.
Right now PHP is "creating" a form based on some contents in my database.
Code for the form:
<?php
$con = mysql_connect("localhost","XXXXX","XXXXX");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("kristina_ponyisland", $con);
$result = mysql_query("SELECT DISTINCT club FROM colours");
print "
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>\n
<html xmlns='http://www.w3.org/1999/xhtml'>\n
<head>\n
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />\n
<title>RGB Compare Tool</title>\n
</head>\n
<body>\n
<form action='compare.php' method='post'>\n
RGB COMPARE TOOL<p/><p/>\n
Points:<select name='range' id='range'>\n
<option value='100'>100</option>\n
<option value='75'>75</option>\n
<option value='50'>50</option>\n
<option value='25'>25</option>\n
</select><p/><p/>\n
Clubs:<br/>\n";
while($row = mysql_fetch_array($result))
{
print"<INPUT TYPE=CHECKBOX NAME='";
print $row['club'];
print "' >";
print $row['club'];
print "<BR/>\n"
}
print "</p>\n
Eyes:<input type='text' name='eyes'><br\>\n
Main Hair:<input type='text' name='hair_1'><br\>\n
Second Hair: <input type='text' name='hair_2'><br\>\n
Body: <input type='text' name='body'><br\>\n
Main Extra:<input type='text' name='extra_1'><br\>\n
Second Extra:<input type='text' name='extra_2'><br\>\n
<input type='image' src='images/compare.png' value='Submit' alt='Submit'>\n
<input type='reset' value='Reset!'>\n
</form>\n
</body>\n
</html>";
mysql_close($con);
?>
What I am confused about is before I added the club checkboxes it would go to compare.php and run. Normally when I pass variables it's fairly straightforward but in this case I'm not sure.
Here's a copy of the previous compare . php. I haven't even tried adding the club variables because I have no idea how to go about it. Maybe someone can give me a hint.
<?php
$eye_colour = $_POST[eyes];
$eyes_r = substr($eye_colour,0,3);
$eyes_g = substr($eye_colour,4,3);
$eyes_b = substr($eye_colour,8,3);
$main_hair_colour = $_POST[hair_1];
$hair_r = substr($main_hair_colour,0,3);
$hair_g = substr($main_hair_colour,4,3);
$hair_b = substr($main_hair_colour,8,3);
$second_hair_colour = $_POST[hair_2];
$hair2_r = substr($second_hair_colour,0,3);
$hair2_g = substr($second_hair_colour,4,3);
$hair2_b = substr($second_hair_colour,8,3);
$body_colour = $_POST[body];
$body_r = substr($body_colour,0,3);
$body_g = substr($body_colour,4,3);
$body_b = substr($body_colour,8,3);
$extra_colour = $_POST[extra_1];
$extra_r = substr($extra_colour,0,3);
$extra_g = substr($extra_colour,4,3);
$extra_b = substr($extra_colour,8,3);
$second_extra_colour = $_POST[extra_2];
$extra2_r = substr($second_extra_colour,0,3);
$extra2_g = substr($second_extra_colour,4,3);
$extra2_b = substr($second_extra_colour,8,3);
$point_range = $_POST[range];
$con = mysql_connect("localhost","kristina_pony"
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("kristina_ponycolours", $con);
$result = mysql_query("SELECT * FROM colours ");
print "<table><th>Eye Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$eye_points = abs($db_r - $eyes_r) + abs($db_g - $eyes_g) + abs($db_b - $eyes_b );
if ($eye_points <= $point_range)
{
print "<tr> <td>";
print $eyes_r;
print "|";
print $eyes_g;
print "|";
print $eyes_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $eye_points;
print "</td><td>";
print "Eye colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $eye_points;
print"</td></tr>";
}
elseif ($eye_points = 0)
{
print "<tr> <td><b>";
print $eyes_r;
print "|";
print $eyes_g;
print "|";
print $eyes_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $eye_points;
print "</b></td><td><b>";
print "Eye colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $eye_points;
print"</b></td></tr>";
}
}
print "</table><p><p><table><th>Hair Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
$result = mysql_query("SELECT * FROM colours ");
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$hair_points = abs($db_r - $hair_r) + abs($db_g - $hair_g) + abs($db_b - $hair_b );
if ($hair_points <= $point_range)
{
print "<tr> <td>";
print $hair_r;
print "|";
print $hair_g;
print "|";
print $hair_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $hair_points;
print "</td><td>";
print "Hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair_points;
print"</td></tr>";
}
elseif ($hair_points = 0)
{
print "<tr> <td><b>";
print $hair_r;
print "|";
print $hair_g;
print "|";
print $hair_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $hair_points;
print "</b></td><td><b>";
print "Hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Extra Hair Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$hair2_points = abs($db_r - $hair2_r) + abs($db_g - $hair2_g) + abs($db_b - $hair2_b );
if ($hair2_points <= $point_range)
{
print "<tr> <td>";
print $hair2_r;
print "|";
print $hair2_g;
print "|";
print $hair2_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $hair2_points;
print "</td><td>";
print "Second hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair2_points;
print"</td></tr>";
}
elseif ($hair2_points = 0)
{
print "<tr> <td><b>";
print $hair2_r;
print "|";
print $hair2_g;
print "|";
print $hair2_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $hair2_points;
print "</b></td><td><b>";
print "Second hair colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $hair2_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Body Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$body_points = abs($db_r - $body_r) + abs($db_g - $body_g) + abs($db_b - $body_b );
if ($body_points <= $point_range)
{
print "<tr> <td>";
print $body_r;
print "|";
print $body_g;
print "|";
print $body_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $body_points;
print "</td><td>";
print "Body colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $body_points;
print"</td></tr>";
}
elseif ($body_points = 0)
{
print "<tr> <td><b>";
print $body_r;
print "|";
print $body_g;
print "|";
print $body_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $body_points;
print "</b></td><td><b>";
print "Body colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $body_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Extra Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$extra_points = abs($db_r - $extra_r) + abs($db_g - $extra_g) + abs($db_b - $extra_b );
if ($extra_points <= $point_range)
{
print "<tr> <td>";
print $extra_r;
print "|";
print $extra_g;
print "|";
print $extra_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $extra_points;
print "</td><td>";
print "Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra_points;
print"</td></tr>";
}
elseif ($extra_points = 0)
{
print "<tr> <td><b>";
print $extra_r;
print "|";
print $extra_g;
print "|";
print $extra_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $extra_points;
print "</b></td><td><b>";
print "Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra_points;
print"</b></td></tr>";
}
}
$result = mysql_query("SELECT * FROM colours ");
print "</table><p><p><table><th>Extra Colour</th><th>Colour Type </th><th>Colour Name</th><th>Colour RGB</th><th>Points</th><th></th>";
while($row = mysql_fetch_array($result))
{
$db_r = $row['color_r'];
$db_g = $row['color_g'];
$db_b = $row['color_b'];
$extra2_points = abs($db_r - $extra2_r) + abs($db_g - $extra2_g) + abs($db_b - $extra2_b );
if ($extra2_points <= $point_range)
{
print "<tr> <td>";
print $extra2_r;
print "|";
print $extra2_g;
print "|";
print $extra2_b;
print "</td><td>";
print $row['colour_type'];
print "</td><td>";
print $row['colour_name'];
print "</td><td>";
print $row['colour_rgb'];
print "</td><td>";
print $extra2_points;
print "</td><td>";
print "Second Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra2_points;
print"</td></tr>";
}
elseif ($extra2_points = 0)
{
print "<tr> <td><b>";
print $extra2_r;
print "|";
print $extra2_g;
print "|";
print $extra2_b;
print "</b></td><td><b>";
print $row['colour_type'];
print "</b></td><td><b>";
print $row['colour_name'];
print "</b></td><td><b>";
print $row['colour_rgb'];
print "</b></td><td><b>";
print $extra2_points;
print "</b></td><td><b>";
print "Second Extra colour is a match to ";
print $row['colour_type'];
print " ";
print $row['colour_name'];
print " ";
print " by ";
print $extra2_points;
print"</b></td></tr>";
}
}
print "</table>";
mysql_close($con);
?>
Also, if anyone has suggestions on how to improve the speed, or organization of the code that would be welcome too.
I know once I get the club part sorted out, I want to make the compare.php sort each table it prints based on the points. In the case of the eye table (AKA first table that gets printed out) it would be sorted based on the $eyes_points variable. Anyone who has a suggestion how to go about that would be awesome too.
Remember I'm a PHP / SQL n00b. It would be helpful to me to explain how something works in the case of the sort thing, or the form bit.
Thank you so much.
