Problem in Getting values from an array item in db

[indrajit_m]

Dear All,
In my work I have to select multiple items from a list box which contains values from database. In the next page I have to show all the selected values and unselected values in the list box when user submits the selected values. The problem I am facing is: I am able to display all the selected values but I am unable to display unselected values. Hence I request you please find a solution for me and solve this problem.

I am putting my code that I used to get values and display them in the next page.

1) display.php

<?
<!....Normal db arguments and other items.....>

echo"<TR>";
echo"<TD vAlign=\"top\" align=\"left\" width=\"283\" height=\"14\" colspan=\"2\">";
echo"<SELECT size=\"4\" multiple name=\"paperchoices[]\">";

$qryarlist = "select article_id,article_name from nuke_user_articles";
$arlistname=$dbconn->Execute($qryarlist);
while(list($atid,$aname) = $arlistname->fields)
{
//print "\t<option>";
//print "$aname\n";
echo "<option value=$atid>$aname\n";
//echo "<option value=$aname>$aname\n";
$arlistname->MoveNext();
}

echo"</SELECT></TD></TR>";

echo"<TR>";
echo"<TD vAlign=\"top\" align=\"left\" width=\"283\" height=\"14\" colspan=\"2\">";
echo"<input type=\"submit\" value=\"Submit\" name=\"buttonSubmit\"><input type=\"reset\" value=\"Reset\" name=\"buttonReset\"></TD></TR>";

?>

2) confirm.php

<?
<!....Normal db arguments and other items.....>

if(count($paperchoices)!=null)
{
echo"<TR>";
echo"<TD vAlign=\"top\" align=\"left\" width=\"283\" height=\"14\" colspan=\"2\">
<font class=\"pn-normal\"><B><br>
Send me article(s): <br></font></B>";
echo"<SELECT size=\"4\" multiple name=\"paperchoices[]\">";

foreach($paperchoices as $value)
{
$qryselect="select article_id,article_name] from nuke_user_articles where article_id]=$value";
$arlistnames = $dbconn->Execute($qryselect);
list($atid,$aname) = $arlistnames->fields;
echo "<option selected value=$atid>$aname\n";
}
echo"</SELECT></TD></TR>";
}

<!... other items...>
?>

regards,
Indrajit.

[the_Igel]

It's too much for me to read tour code (oh i'm lazy 🙂 ), still I can't believe there can be a problem.
You take the complete list from db, yeah? And then you have the list of selected items. Then the list of not-selected items is COMPLETE - SELECTED, shouldn't it? 🙂

Anyway, try to keep your question shorter and marked up with [ php ] [ / php ] tags. It's hard to scan your code for problems.

[[deleted]]

"I am able to display all the selected values but I am unable to display unselected values."

Simple: an item can be SELECTED or NOT_SELECTED. So, if it is not SELECTED then it is NOT_SELECTED.

If you have a list of what was selected, then everything that is not in the list is not-selected.

[indrajit_m]

Dear Mr.Vincent and Igel,
May be the way I represented my problem is wrong. So I will try to explain my requirement and problem again.
1) When a list box is declared as multiple selection=true, it will return an array of items based on our selection. If it contains strings like "Beyond commerce: Bringing business relationships and community to the web", and a user selects this item, it will return only "Beyond". So one has to pass an id as value to each item in that list box.
2) Based on the id we can select items from database and make them selected items as
echo "<option selected value=$atid>$aname\n";
3) Now the problem is: I am not able to club selected items and non-selected items if I want to show the remaining items as non selected items in the same list box "which are to be grabbed from database."
4) To come out this problem I wrote a query to select non-selected items as

foreach($paperchoices as $value)
{
$qryselect="select article_id,article_name from nuke_user_articles where article_id != $value";
}

which is returning some other value and first value from db.
Hope that I am clear now. Hence I request to please find a solution for this problem.
regards,
Indrajit.

[the_Igel]

No, I don't see any problem still. Do I look a little dumb today? 🙂

You wrote:
Based on the id we can select items from database and make them selected

But you can as well select all items from db and make them selected based on id.

$r = mysql_query("select id, name from whatever");
while ($row = mysql_fetch_array($r))
    {echo '<option value='.$row['id'];
     if (in_array($row['id'], $selected_items)) echo ' selected';
     echo '>'.$row['name'].'</option>';

[Eep__]

How would I take a database table string "1,2" from a MySQL table "set" column type and separate it into individual numbers ("1","2") to be passed as the same field ("genreID") to be used to create checked checkboxes?

Here's what I have so far:

$sql = "SELECT
	*
	FROM
	compare,games,genres,publisher,engine
	WHERE id=$id
	AND compare.gameID=games.gameID
	AND compare.genreID=genres.genreID
	AND compare.publisherID=publisher.publisherID
	AND compare.engineID=engine.engineID";

  $result = mysql_query($sql);
  $row = mysql_fetch_array($result);

  $id = $row["id"];
  $game = $row["game"];
  $circa = $row["circa"];
  $genreID = $row["genreID"];
    $genreID = explode(",",$genreID);
//    foreach ($genreID as $genreID) { $genreID=$genreID; }
  $genre = $row["genre"];
  $publisherID = $row["publisherID"];
  $publisher = $row["publisher"];
  $engineID = $row["engineID"];
  $developer = $row["developer"];

Then the HTML code:

<input type=text name=genre[] maxlength=40 value=<?=$genreID?>><br>
<input type=checkbox name=genre[] value=action <?if($genreID=='1'){echo checked;}?>>action<br>
<input type=checkbox name=genre[] value=adventure <?if($genreID=='2'){echo checked;}?>>adventure<br>
<input type=checkbox name=genre[] value=role-playing <?if($genreID=='3'){echo checked;}?>>role-playing (RPG)
<br>
<input type=checkbox name=genre[] value=simulation <?if($genreID=='4'){echo checked;}?>>simulation:
	<dd><input type=checkbox name=genre[]>city/empire-building
	<dd><input type=checkbox name=genre[]>driving/racing/riding
<br>
<input type=checkbox name=genre[] value=strategy <?if($genreID=='5'){echo checked;}?>>strategy
	(<input type=checkbox name=genre[]>real-time
	<input type=checkbox name=genre[]>turn-based)

But what happens is $genreID comes out to "3" and so "role-playing" is checked when I want "action" ("1") and "adventure" ("2") checked. How do I do that?