[Resolved] Fun with Checkboxes - and I'm enjoying every minute

[neo100101]

I am trying to create dynamic checkboxes as part of the array I called in my last post, here's a refresher

<tr bgcolor = "<? echo $color; ?>">
<td width="7%" style="padding-left: 5; padding-right: 5"><? echo $a_row[Ph_ID]; ?></td>
<td width="19%" style="padding-left: 5; padding-right: 5"><? echo $a_row[Pharmacy_Name]; ?></td>
<td width="43%" style="padding-left: 5; padding-right: 5"><? echo $a_row[Address_Line_1]; ?>&nbsp;|&nbsp;<? echo $a_row[City]; ?>,&nbsp;<? echo $a_row[Province]; ?>&nbsp;|&nbsp;<? echo $a_row[Postal_Code]; ?></td>
<td width="15%" style="padding-left: 5; padding-right: 5"><? echo $a_row[Phone]; ?></td>
<td width="5%" style="padding-left: 5; padding-right: 5"><a href="details.php">Details</a></td>
<td width="11%" style="padding-left: 5; padding-right: 5"><p align="center"><input type=checkbox name="hotlist"></td>
</tr>

pretty basic... I have check boxes and in my database I want to accomplish the following, from the menu I want to select said boxes and when I update mark each field with a one instead of a zero. Thereby flagging the selected records for future queries.

Here is the bare bones of the update script.

if ($hotlist)
{
$shortlist = '1';
$query = "UPDATE pharmacies SET shortlist = '$shortlist'";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());
}
// close database connection
mysql_close($connection);
echo "update successful!";

?>

When I select update it updates 'shortlist' (ALL 'shortlist') with '1's'. Does anyone have a suggestion on how I can update particular arrays instead of the whole field.

[HalfaBee]

You need a WHERE in your sql.

HalfaBee

[neo100101]

$query = "UPDATE pharmacies SET shortlist = '$shortlist' WHERE Ph_ID='$a_row[Ph_ID]";

$query = "UPDATE pharmacies SET shortlist = '$shortlist' WHERE Ph_ID='$Ph_ID'";

Both have been used but neither work. Maybe a little more explanation is needed... I have a list of several records and I want to flag several at the same time, but only one update button at the bottom of the column linked to the script.

It has been suggested I take the easy way out and like a button to each record but I find that unacceptable and an 'eater' of resources.

So I think there may be a way to declare each checkbox a value based on the Ph_ID and when selected update that record.

Does any of this sound feasible to the community?

[HalfaBee]

You need to give hotlist a value that defines the Pharmacy you wish to update.

HalfaBee

[neo100101]

Do you mean
<input type=checkbox name="<? echo $a_row[Ph_ID]; ?>">
as opposed to...
<input type=checkbox name="hotlist">
and
if ($a_row[Ph_ID])
instead of...
if ($hotlist)

oops... scratch that, I'm thought name not value 🙂

[HalfaBee]

<input type=checkbox name='hotlist' value="<? echo $a_row[Ph_ID]; ?>">

[neo100101]

nope... I have uploaded the entire script, that may help 🙁

the adjoining script is as follows.
hotlist.php---------------------------------------------------------
<? session_start();

	//includes
	include("config.php");
	include("functions.php");

	// open database connection
	$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

	// select database
	mysql_select_db($database) or die ("Unable to select database!");
	$query = "SELECT Ph_ID, Pharmacy_Name, Chain, Address_Line_1, Address_Line2, City, Province, Postal_Code, FSA, Phone FROM pharmacies WHERE Ph_ID = '$Ph_ID'";
	$result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error());
	$a_row = mysql_fetch_array( $result );

// generate and execute query
if ($hotlist)
{
$shortlist = '1';
$query2 = "UPDATE pharmacies SET shortlist = '$shortlist'";
$result2 = mysql_query($query2) or die ("Error in query: $query2. " . mysql_error());
}
// close database connection
mysql_close($connection);
echo "update successful!";

?>

[HalfaBee]

Change this line like this

    <td width="11%" style="padding-left: 5; padding-right: 5"><p align="center"><input type=checkbox name="hotlist[]" value="<? echo $a_row[Ph_ID] ?>"></td>



// and this line

foreach( $hotlist as $hotlistme )
{
$shortlist = '1';
$query2 = "UPDATE pharmacies SET shortlist = '$shortlist' WHERE PH_id = '$hotlistme' ";
$result2 = mysql_query($query2) or die ("Error in query: $query2. " . mysql_error());
} 

HalfaBee

[neo100101]

Thanks H, works like a charm 🙂