PHP - Creating To Do List ?

Can anyone help me with how to create those lists which expand when you click a (+) .

I want to create a list of urls by a list of words:
http://example.com/word1
http://example.com/word2
http://example.com/word3

but I cannot do this with the instruction provided in http://php.net/manual/en/function.http-build-url.php 

Hello,
I've created a page search to return results from my database inventory. On top of these results I would like to display a seperate list of five products not included in the search results but share the same sub_category_b (a column in my SQL table).

Posted below is my primary query of the database. If anyone can help me out with this it would be appreciated.
 
Code: [Select]
$colname_product = "-1";
if (isset($_GET['title'])) {
  $colname_product = $_GET['title'];
}
mysql_select_db($database_inventory, $inventory);
$query_product = sprintf("SELECT * FROM inventory WHERE item_name LIKE %s OR item_desc LIKE %s  ", GetSQLValueString("%" . $colname_product . "%", "text"),GetSQLValueString("%" . $colname_product . "%", "text"));
$product = mysql_query($query_product, $inventory) or die(mysql_error());
$row_product = mysql_fetch_assoc($product);

I've fooled around with this one for some time and haven't come up with a clear cut answer. Thank you in advance!

Ok, so I've spent quite a bit of time piecing together this solution from a variety of sources. As such, I may have something in my code below that doesn't make sense or isn't neccessary. Please let me know if that is the case.

I'm creating an administrative form that users will you to add/remove items from a MySQL table that lists open positions for a facility. The foreach loop generates all of the possible job specialties from a table called 'specialty_list'. This table is joined to a second table ('open_positions') that lists any positions that have been selected previously.

Where I'm stuck is getting the checkbox to be checked if the facility_ID from the open_positions table matches the $id passed in the URL via ?facility_id=''. Here's where I am so far:


$query = "SELECT specialty_list.specialty_displayname
 , specialty_shortname
     , open_positions.position
     , facility_ID
  FROM specialty_list
LEFT OUTER
  JOIN open_positions
    ON open_positions.position = specialty_list.specialty_shortname
ORDER 
    BY specialty_list.specialty_shortname";

$results = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_assoc($results)) 
{ 
$positions[$row['specialty_shortname']] = $row['specialty_displayname'];
}

echo "<form method='POST' action='checkbox.php'>";
foreach($positions as $specialty_shortname => $specialty_displayname) 
{
$facility_ID = $row['facility_ID'];
  
$checked = $facility_ID == $row['facility_ID'] ? ' checked' : ''; 

echo "<input type='checkbox' name='position[]' value=\"{$specialty_shortname}\"{$checked}>&nbsp;&nbsp;{$specialty_displayname}</input><br/>"; 

}  
echo "<input type='hidden' name='facility_ID' value='$id'>";
echo "<input type='submit' value='Submit Checkboxes!'>";
echo "</form>";


Any ideas how to get this working? I feel like I'm very close, but I just can't get it. I also tried starting from scratch with a WHILE statement instead of a FOREACH, but haven't tweaked it enough to prevent duplicate checkboxes. With that in mind, here it is, just in case that's a better direction:


$query = "SELECT specialty_list.specialty_displayname
 , specialty_shortname
     , open_positions.position
     , facility_ID
  FROM specialty_list
LEFT OUTER
  JOIN open_positions
    ON open_positions.position = specialty_list.specialty_shortname
ORDER 
    BY specialty_list.specialty_shortname";

$results = mysql_query($query) or die(mysql_error());

echo "<form method='POST' action='checkbox.php'>";

while($row=mysql_fetch_assoc($results))
{ 
$facility_ID = $row['facility_ID'];
$specialty_shortname = $row['specialty_shortname'];
$specialty_displayname = $row['specialty_displayname'];


if ($facililty_ID==$id) {

$checked=' checked';
}

echo "<input type='checkbox' name='position[]' value=\"$specialty_shortname\"$checked>&nbsp;&nbsp;$specialty_displayname</input><br/>"; 
}

echo "<input type='hidden' name='facility_ID' value='$id'>";
echo "<input type='submit' value='Submit Checkboxes!'>";
echo "</form>";

Hi,
In my mysql database i have a text input option, in the registration form and edit my details form i have a multiple select dropdown list, which user selects options to populate the text input box, which ultimately populates the text field in the mysql database.
All works perfectly.

The dropdownlist consists of 3 parts <optgroups> first is current selection (what is the usesr current selection)works fine, The second <optgroup> is existing words, what words we(the site) have given as options, and the third <optgroup> is the words that others have used. This is where im having a small problem.
Because its a text field when i call the data from the database, it calls the entire text box as a single option in my select list..

I want to break the words in the text field (at the comma) and have them listed each one as an option in the select list.


Example what i need:

Words in text box:(my input allows the "comma")
word1, word2, word3, word4, word5, word6,

How i want them called/displayed:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>

here's my code:
$query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $original_functionsexperience =doSelectSql($query,1);
         $query = "SELECT allwords FROM #__functions_experience WHERE  profile_id  = '".(int)$profileId."' LIMIT 1";
         $functionsexperiencelist=doSelectSql($query);
          $funcexpList ="<select multiple=\"multiple\" onchange=\"setFunctionsexperience(this.options)\">";   
         foreach ($functionsexperiencelist as $functionsexperienceal)
            {
            $selected="";
            if ($functionsexperienceals->allwords == $original_functionsexperience)
               $selected=' selected="selected"';
            $allwords=$functionsexperienceal->allwords;
            $funcexpList .= "<optgroup label=\"Current selection\">
            <option value=\"".$allwords."\" ".$selected." >".$allwords."</option>
            </optgroup>      
              <optgroup label=\"Existing Words\">
              <option value=\"existing1,\">existing1</option>
              <option value=\"existing2,\">existing2</option>
              <option value=\"existing3,\">existing3</option>
              <option value=\"existing4,\">existing4</option>
              <option value=\"existing5,\">existing5</option>
              <option value=\"existing6,\">existing6</option>
         </optgroup>
         <optgroup label=\"Others added\">    //heres problem
         <option value=\"".$allwordsgeneral."\">".$allwordsgeneral."</option>
         </optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         
      
         
   The result im getting for optgroup others added:
   word1, word2, word3, word4, word5,

how can i get it like this:
<option value=\"word1\">word1</option>
<option value=\"word2\">word2</option>
<option value=\"word3\">word3</option>
<option value=\"word4\">word4</option>
<option value=\"word5\">word5</option>
<option value=\"word6\">word6</option>