[SOLVED]Getting data and checking off in one field

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bdeonline
Forum Commoner
Posts: 42
Joined: Sun Jul 18, 2004 10:45 am

[SOLVED]Getting data and checking off in one field

Post by bdeonline »

Ok I have 2 tables antennas and antennas_to_products I need to get a checkbox of all antennas but the ones that are linked to a product needs to be checked. Here is what I have so far.

Code: Select all

$result = $db->query('SELECT ap.antennas_id, a.id, a.title FROM antennas_to_products AS ap JOIN antennas AS a ON a.id = ap.antennas_id');
while($row = $db->fetch_assoc($result)) {
	if($row['id'] == $row['antennas_id']) {
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
	} else {
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	}
}
But this will only give me the list of antennas thats linked to the product. Not the full list so I can add more if needs be.
Last edited by bdeonline on Fri Jul 15, 2005 10:30 am, edited 1 time in total.
bdeonline
Forum Commoner
Posts: 42
Joined: Sun Jul 18, 2004 10:45 am

Post by bdeonline »

Code: Select all

$result = $db->query('SELECT a.id, a.title, ap.antennas_id FROM antennas_to_products AS ap, antennas AS a WHERE ap.products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	if($row['id'] == $row['antennas_id']) {
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
	} else {
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	}
}
This is closer and actually works except when they are all checked then doubles them. Shows up with a set all checked and a set all unchecked.
bdeonline
Forum Commoner
Posts: 42
Joined: Sun Jul 18, 2004 10:45 am

Post by bdeonline »

So does anyone know how I can get all the antennas and have checked or selected the ones that are already associated to the product.
bdeonline
Forum Commoner
Posts: 42
Joined: Sun Jul 18, 2004 10:45 am

Post by bdeonline »

Well for at least my own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.se needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db-&gt;fetch_assoc($result)) {
	$antennas&#1111;] .= $row&#1111;'antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=ve figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET&#1111;'id']);
while($row = $db-&gt;fetch_assoc($result)) {
	$antennas&#1111;] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; nl;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; 16]
$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '&lt;input tmy own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pumy own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.nnas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.dth:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
Itave figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value=&qu]
$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET&#1111;'id']);
while($row = $db-&gt;fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#11ng a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value=&amtennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; /&gt;' . $row&#1111;'title'];
	} else {
		$checked = false;
	}
}
[/ph1;'antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row&#1 and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.ET['id']);
while($row = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
for($i = 0; $i &lt; $antennas_count; $i++) {
if($antennasї$i] == $rowї'id']) {
$checked = true;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $rowї'title'];
}
}

if($checked == false) {
$checked = false;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;width:auto;&quote; /&gt;' . $rowї'title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and j
$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.lue="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.OM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
for($i = 0; $i &lt; $antennas_count; $i++) {
if($antennasї$i] == $rowї'id']) {
$checked = true;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $rowї'title'];
}
}

if($checked == false) {
$checked = false;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&ow = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;tennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;&quomy own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == fals = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It put;query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.e else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value= WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value=&amid FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; /&gt;' . $row&#1111;'title'];
	} else {
		$checked = false;
	}amp;gt;query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style=&quote;width:auto;&quote; checrow['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" check:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.nd for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.ennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennasї$i] == $rowї'id']) {
$checked = true;
echo '&lt;input type="checkbox" name="antennas[]" valumy own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db-&gt;query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db-&gt;fetch_assoc($result)) {
	$antennas&#1111;] .= $row&#1111;'antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; /&gt;' . $row&#1111;'title'];
	} else {
		$checked = false;
	}
}
);
while($row = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
for($i = 0; $i &lt; $antennas_count; $i++) {
if($antennasї$i] == $rowї'id']) {
$checked = true;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $rowї'title'];
}
}

if($checke to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db-&gt;query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET&#1111;'id']);
while($row = $db-&gt;fetch_assoc($result)) {
	$antennas&#1111;] .= $row&#1111;'antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; /&gt;' . $row&#1111;'title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 fieldmp;amp;gt;query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GETї'id']);
while($row = $db-&gt;fetch_assoc($result)) {
$antennasї] .= $rowї'antennas_id'];
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.my own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" /&ampuery('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;&e;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row&{
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="unt = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.my own record and for anyone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tableslem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
	for($i = 0; $i &lt; $antennas_count; $i++) {
		if($antennas&#1111;$i] == $row&#1111;'id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'yone else needing a answer to this problem I have figured it out:

Code: Select all

$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
	$antennas[] .= $row['antennas_id']; 
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
	for($i = 0; $i < $antennas_count; $i++) {
		if($antennas[$i] == $row['id']) {
			$checked = true;
			echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $row&#1111;'title'];
		}
	}

	if($checked == false) {
		$checked = false;
		echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennas&#1111;]&quote; value=&quote;' . $row&#1111;'id'] . '&quote; style=&quote;width:auto;&quote; /&gt;' . $row&#1111;'title'];
	} else {
		$checked = false;
	}
}
It pulls data from 2 separate tables and joins them into 1 field.b->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $rowї'id']) {
$checked = true;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&asult = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db-&gt;fetch_assoc($result)) {
$antennasї] .= $rowї'antennas_id'];
}

$antennas_count = count($antennas);

$result = $db-&gt;query('SELECT id, title FROM antennas');
while($row = $db-&gt;fetch_assoc($result)) {
for($i = 0; $i &lt; $antennas_count; $i++) {
if($antennasї$i] == $rowї'id']) {
$checked = true;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;width:auto;&quote; checked=&quote;checked&quote; /&gt;' . $rowї'title'];
}
}

if($checked == false) {
$checked = false;
echo '&lt;input type=&quote;checkbox&quote; name=&quote;antennasї]&quote; value=&quote;' . $rowї'id'] . '&quote; style=&quote;widt
$antennas = null;
$checked = false;

$result = $db->query('SELECT antennas_id FROM antennas_to_products WHERE products_id=' . $_GET['id']);
while($row = $db->fetch_assoc($result)) {
$antennas[] .= $row['antennas_id'];
}

$antennas_count = count($antennas);

$result = $db->query('SELECT id, title FROM antennas');
while($row = $db->fetch_assoc($result)) {
for($i = 0; $i < $antennas_count; $i++) {
if($antennas[$i] == $row['id']) {
$checked = true;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" checked="checked" />' . $row['title'];
}
}

if($checked == false) {
$checked = false;
echo '<input type="checkbox" name="antennas[]" value="' . $row['id'] . '" style="width:auto;" />' . $row['title'];
} else {
$checked = false;
}
}
It pulls data from 2 separate tables and joins them into 1 field.
Post Reply