Counting Check boxes

[Infinitous]

Hi, i'm having a problem with this webpage. I have it set so that it is supposed to count the checkboxes checked using a SQL statement for naming. (I don't know if I am explaining this correctly). Long story short, the second SQL query (one query, second time it is used) won't return any results. Any ideas? Here is the code:

<?
$query = mysql_query("SELECT * FROM pic_locations", $db);
switch($option)
{
case "pack10":
if ($process == "1")
{

		}
			else
				{
				echo "<form name='pictures10' method='post' action='$PHP_SELF?link=products&package=card&option=processpack12'>";
				if ($array = mysql_fetch_array($query))
					{
					do {
						$dbindex = $array['index'];
						$dbpicture  = $array['picture'];
						$dbalt = $array['alt'];
						echo "<tr>
								<td><img src=\"http://www.fins-n-flash.com/dbtest/images/".$dbpicture."\" alt=\"".$dbalt."\"></td>
								<td><input type=\"checkbox\" name=".$dbindex." value=\"".$dbpicture."\" onClick='return KeepCount()'></td>
							</tr>";
						}
					while($array = mysql_fetch_array($query));
					}
				echo "</table><input type='submit' value='Order'>
				<SCRIPT LANGUAGE='javascript'>
				function KeepCount() 
				{
				var NewCount = 0";
				if ($array = mysql_fetch_array($query))
					{
					do {
						$dbindex  = $array['index'];
						echo "
						if (document.pictures10.".$dbindex.".checked)
						{NewCount = NewCount + 1}";
						}
					while($array = mysql_fetch_array($query));
					}
				echo "
				if (NewCount == 11)
				{alert('You have already chosen 10, if you wish to choose this picture, uncheck another and check this one')
				document.pictures10; return false;}
				}
				</SCRIPT>";
			}
break;

case "pack12":
	if ($process == "1")
	{
	}
	else
	{
	}
break;

default:
	echo "<table border='0' width='75%'>
		<tr>
			<td><center><a href='$PHP_SELF?link=products&package=card&option=pack10'>10 Pack</a></center></td>
			<td><center><a href='$PHP_SELF?link=products&package=card&option=pack12'>12 Pack</a></center></td>
		</tr>
		<tr>
			<td width='50%'><center>Mix-and-Match 10 different cards of your choice</center></td>
			<td width='50%'><center>Mix-and-Match 6 different cards of your choice, 2 of each of your choice</center></td>
		</tr>
		<tr>
			<td><center>$25.00</center></td>
			<td><center>$25.00</center></td>
		</tr>
	</table>";
break;

}
//Put the check boxes in an array and then use the count function, then an if statement

?>

😕 😕 😕 😕 😕

[nemonoman]

It looks like you expect your Javascript to somehow talk to the database? That's not going to happen. Javascript affects the actions within the client's browser only...only when the form is submitted does the server begin to work, and PHP then kicks in.

[Infinitous]

The problem isn't that, also, I set it up so that it doesn't talk to the database. Still, even if it wasn't able to talk to the database, why isn't that SQL query getting any results, that should be done before any javascript is ran.

[nemonoman]

Son:
You have some stuff to learn.

Your php script executes on the server. The script may talk to the database. Typically the results of the script are 'echoed' or 'printed' in the form of a web page.

In the script you submitted, your php script creates a nice html webpage. Embedded in that page is some javascript.

Javascript lives in THE BROWSER. Php lives far away on the server. Javascript doesn't know about the server. It doesn't know about the database. It only knows about the browser.

You can load some javascrript variables into the web page you built using PHP. If you do this, javascript can access those variables -- without any server or database activity.

You can only access your php scripts and database by sending information to your server. Typically this is done by FORM submission or by LINKING to a particular script file. (There are other methods, but based on your code, those are way out of your league at the moment.)

By the way, your php code doesn't make a ton of sense...If you have been adapting existing code, I highly suggest reverting and being more precise about your desired changes.

Hope this helps.