PHP - Searchbar With Multiple Select Options

I'm trying to figure out why the options aren't appearing inside the select dropdown. Any ideas why?

Code: [Select]
echo "<label for=" . $row2['fullName'] . ">" . $row2['fullName'] . "</label>";
                       echo "<select name=" . $row2['fullName'] . " id=" . $row2['fullName'] . " class=dropdown title=" . $row2['fullName'] . " />";
                       if ($styleID == 1 || $styleID == 2 || $styleID == 6) {
                         $charactersQuery = "
                                SELECT
                                    characters.ID,
                                    characters.characterName
                                FROM
                                    characters
                                WHERE
                                    characters.styleID = 3
                                ORDER BY
                                    characters.characterName";
                         $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                         while ( $row3 = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                         }   
                       } else {
                         $charactersQuery = "
                                SELECT
                                    characters.ID,
                                    characters.characterName
                                FROM
                                    characters
                                WHERE
                                    characters.styleID IN (1,2,6)
                                ORDER BY
                                    characters.characterName";
                         $charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query
                         while ( $row3 = mysqli_fetch_array ( $charactersResult, MYSQL_ASSOC ) ) {
                            print "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
                         }
                       }
                       echo "</select>";
                   }

I have set up a form page with a select box of colleges to select. I want the "options" in the select box to be values taken from a field called "name" in a table called "colleges" and they should be ordered alphabetically. I also want the default selected option to be "none."

I have attached a picture to describe what i want. Please be detailed with the code. I am fairly new to php and mysql. Thank you.

Hi, Im not sure whether this is a PHP or MySQL question, but im trying to get a select menu to only display the number of options that are defined in the mysql database.   For example   The code I have that retrieves the $quantity from the database.   Lets say that   $quantity = 3   Now I would like the option menu to only display three options, like this:

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
</select>

but for example, if the $quantity was equal to 10 then I would like the menu to be displayed as such

<select name="quantity">
<option value="<?php echo $quantity ?>"><?php echo 'Maximum of ' . $quantity . ' available'?></option>
<option value="1">1</option> 
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
</select>

How is it possible to do this? I am completely at a loss here.   Many Thanks   aquaman

Okay so I'm trying to come up with as many alternative methods to accomplish something. So I'm just seeking input from anyone who is willing to supply some.

After the user clicks on a match type it'll know HOW MANY sides to the match there are so say for a singles match it'd have 2 sides (1 vs. 1) for a Triple Threat Match it'd have 3 sides (1 vs. 1 vs. 1) and so on. All matches have a stored field in the database of how many sides they have.

So I'm thinking that I could have it create 3 divs (or something) down in the competitors area of how many sides there are in the match (separated by a VS. text block) and when the user selects a character from the dropdown and adds a character the user can maybe drag and drop the character's name to whatever side they choose.

Its one idea. If you think of an EASIER more EFFICIENT way to do something like this and have an idea say something please or even if you can't let me know that you think it's a worth while idea.

Code: [Select]
<label for="matchtypedrop<?php echo $i+1 ?>">Match Type:</label>
            <select class="dropdown" name="matchtypedrop<?php echo $i+1 ?>" id="matchtypedrop<?php echo $i+1 ?>" title="Match Type <?php echo $i+1 ?>">
                <option value="0">- Select -</option>
               <?php
                $query = 'SELECT id, matchtype FROM matchtypes';
                $result = mysqli_query ( $dbc, $query ); // Run The Query
                while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                    print "<option value=\"".$row['id']."\">".$row['matchtype']."</option>\r";
                }
                ?>
            </select>

<label for="competitors<?php echo $i+1 ?>">Competitors:</label><ul id="competitors<?php echo $i+1 ?>" style="list-style: none; margin-left: 195px;"></ul>
            <select class="dropdown" name="charactersdrop<?php echo $i+1 ?>" id="charactersdrop<?php echo $i+1 ?>" title="Characters Dropdown <?php echo $i+1 ?>" style="margin-left: 195px;">
                <option value="0">- Select -</option>
               <?php
                $query = 'SELECT id, `character` FROM characters ORDER BY `character`';
                $result = mysqli_query ( $dbc, $query ); // Run The Query
                while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) { 
                    print "<option value=\"".$row['id']."\">".$row['character']."</option>\r";
                }
                ?>
            </select>
            <input type="button" value="Add Character" class="" onclick="Competitors(<?php echo $i+1 ?>)"/>

Hey Guys,

Here is my issue. I have a MySQL database with a table of products. I use this table to generate a mutliselect form element that is used int a larger form. The larger form contains other information relevant to an issue that we are having with that product (such as an outage). Anyway, the form works fine and the form validation works fine and I write it to the database fine. The issue I'm having is how to save the mutliselect options most efficiently.

This is my current process:

1. User creates a new entry from the form and clicks save
2. The form is validated
3. All entries are written to the database in a table called "incidents" (content inclues, timestamps, description of the problem, the impact, who to contact, etc)
4. Because the products list can vary from 1 product to all (~30) products I broke it out into a separate table called "impacted_products". I then loop through each of the selected products and write one row for each product using the id from the row in the "incidents" table to define the tables relationship.

Example of DB results:

"incidents"

+-----------------+------+----------+---------------------+---------+---------+
| notification_id | what | impact   | time_start          | summary | contact |
+-----------------+------+----------+---------------------+---------+---------+
| 235235          | Test | None.... | 2011-02-08 13:41:00 | Test    |       3 |
+-----------------+------+----------+---------------------+---------+---------+

"impacted_products"

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

5. Now the users wants to go back and make some updates.
6. They click the edit button from the menu on screen and the form is brought back up and all options/fields are filled out from that which is stored in the database.
7. They make their edits and save again.
8. Now this time it simple updates the "incidents" table but for the products table I do a:

"UPDATE impacted_products SET deleted=1 WHERE notification_id='$ID'"

and "delete" all the old impacted_products for this particular incident and then loop through all the products that the user still had selected and write them to the database again.
9. And repeat

So as you can see this could end up with a lot of "useless" entries in the database since my scripts only pay attention to those "impacted_products" whose deleted value is set to 0.

Example:

+-----+-----------------+------------+---------------------+---------+
| id  | notification_id | product_id | timestamp           | deleted |
+-----+-----------------+------------+---------------------+---------+
| 176 | 235235          |         37 | 2011-02-08 15:26:25 |       1 |
| 177 | 235235          |         43 | 2011-02-08 15:26:25 |       1 |
| 178 | 235235          |         37 | 2011-02-08 15:37:58 |       1 |
| 179 | 235235          |         43 | 2011-02-08 15:37:58 |       1 |
| 180 | 235235          |          1 | 2011-02-08 15:39:49 |       1 |
| 181 | 235235          |          7 | 2011-02-08 15:39:49 |       1 |
| 182 | 235235          |         37 | 2011-02-08 15:39:49 |       1 |
| 183 | 235235          |         43 | 2011-02-08 15:39:49 |       1 |
| 184 | 235235          |          1 | 2011-02-08 15:40:53 |       1 |
| 185 | 235235          |          7 | 2011-02-08 15:40:53 |       1 |
| 186 | 235235          |         37 | 2011-02-08 15:40:53 |       1 |
| 187 | 235235          |         43 | 2011-02-08 15:40:53 |       1 |
| 188 | 235235          |         37 | 2011-02-10 10:00:47 |       1 |
| 189 | 235235          |          1 | 2011-02-10 12:17:05 |       1 |
| 190 | 235235          |          7 | 2011-02-10 12:17:05 |       1 |
| 191 | 235235          |         13 | 2011-02-10 12:17:05 |       1 |
| 192 | 235235          |         37 | 2011-02-10 12:17:05 |       1 |
| 193 | 235235          |         23 | 2011-02-10 12:17:05 |       1 |
| 194 | 235235          |          1 | 2011-02-10 12:21:52 |       1 |
| 195 | 235235          |          7 | 2011-02-10 12:21:52 |       1 |
| 196 | 235235          |         13 | 2011-02-10 12:21:52 |       1 |
| 197 | 235235          |         37 | 2011-02-10 12:21:52 |       1 |
| 198 | 235235          |         23 | 2011-02-10 12:21:52 |       1 |
| 199 | 235235          |          7 | 2011-02-10 12:22:26 |       1 |
| 200 | 235235          |         37 | 2011-02-10 12:22:26 |       1 |
| 201 | 235235          |         23 | 2011-02-10 12:22:26 |       1 |
| 202 | 235235          |          7 | 2011-02-10 14:30:42 |       0 |
| 203 | 235235          |         37 | 2011-02-10 14:30:42 |       0 |
| 204 | 235235          |         23 | 2011-02-10 14:30:42 |       0 |
+-----+-----------------+------------+---------------------+---------+

I did it this way beacuase it seems the easiest and fastest way. Otherwise I would have to lookup all the impacted_products from the table that match that notification_id and check

1) Was there a new product selected? If so, add it.
2) Was a product that was selected no longer selected? If so, delete it.
3) Was a product that was selected before still selected now? If so, leave it alone.

This seemed like a lot of extra looping and a lot of extra DB queries to essentially end up at the same place.

However, I feel that there has still got to be a more efficient way of doing this where I won't have all the extra entries in the impacted_products table. 

Any ideas?

Thanks in advance!

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1



but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc


it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc


so that i am specifiying which colums from which tables to query??

thanks

Hi everyone.

I have a search bar on my site here is the form:

Code: [Select]
<form method="post" action="search2.php">
  <input type="text" onFocus="if(this.value=='Search')this.value='';" onBlur="if(this.value=='')this.value='Search';" value="Search"  id="search-field"/>
  <input type="submit" value="" id="search-btn"/>
  </form>

What is the variable to use here? so i can make search2.php.. or can i NOT use this with php?

Please help, many thanks

Hello,

I'm using PHP and I have a list box where I should be able to select multiple values, that I then submit to run multiple reports. However, when I select two values I only get results for the last selected value instead of both value a & value b.

Can anyone help me with my problem?

Code: [Select]
<td style="text-align: right">Job Type:</td>
<td>
<select name="job_type" multiple="multiple" size="4">
<option value="0" selected>ALL</option>
{section name=jt loop=$job_type_list}
<option value="{$job_type_list[jt][0]}">{$job_type_list[jt][1]}</option>
{/section}
</select>
</td>
I've read that I can change name="job_type" to name="job_type[]", but I'm not getting any luck with that...

I have some code that selects one column from mysql table. However when I try to add more it doesn't work.   First the working code....

$query = "SELECT `profile_privacy`  FROM `users` WHERE `user_username` = '$username'";
$result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
$profile_privacy = mysql_result($result, 0);

And here is where I have added another column....

$query = "SELECT `profile_privacy`, `profile_pictures`  FROM `users` WHERE `user_username` = '$username'";
$result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
$profile_privacy = mysql_result($result, 0);
$profile_pictures = mysql_result($result, 1);

What have I done wrong?

Many thanks,

Code: [Select]
if($keyword == ""){}else{

$get = mysql_query("SELECT * FROM domains, domains_keywords, keywords WHERE domains_keywords_domain=domains_id AND domains_keywords_keyword=keywords_id AND keywords_keyword='$keyword'");

}
so i have a textbox at the mo that you can put one keyword in and get results based on this one keyword.

how can I change this to a textarea and if say someone enters two keywords.. it will find results based on them having both keywords.

thanks in advance

hi im trying to echo out all the possibilities from one column in 2 different tables, both with the same structure. if that makes sense

this is what i have

$query = mysql_query("SELECT * FROM stanjamesprem,centrebetprem GROUP BY eventname ORDER BY eventtime ");
while($row = mysql_fetch_assoc($query))
   {
   echo $row[eventname];
   }

if i take one of the tables out it works fine but if i have 2 table names it doenst work

please help me

cheers matt

any questions please ask away

I'm trying to select multiple peoples ID's where different values in different databases tables match. For instance, I want to make sure the person is a different gender than what the person logging in is, which would be set as 1(male) 2(female) in a Genders Column in the Membership_Profile table, while I am also checking to make sure that they are not blocked inside the Membership table and making sure they have a profile image in a user_profilepic table. How would I do this? This all needs to sort by the Date they were added inside the Membership Table and Limit it to 5 results. When I use the below code tho, it pulls up both Male and Females, but seems to look at the Membership correctly.

Code: [Select]
$sql2 = "SELECT Gender FROM Membership_Profile where UserID = '$user_ID'";
                    $sql_result2 = mysql_query($sql2);
                    $login_row2 = mysql_fetch_assoc($sql_result2);
                    $user_gender = $login_row2['Gender']; 

                    $true_query = mysql_query("SELECT Membership.ID, Membership_Profile.ID, user_profilepic.UserID FROM Membership, Membership_Profile, user_profilepic WHERE Membership_Profile.Gender != '$user_gender' AND Membership.ID = user_profilepic.UserID  AND Membership.IsApproved='1' AND Membership.IsLockedOut = '0' AND Membership.UserLevel = '1' AND user_profilepic.Profile_Pic = '1' ORDER BY Membership.CreateDate DESC LIMIT 5;");
                     $is_odd_row = 1;
                     while ($true_row = mysql_fetch_assoc($true_query))
                      {
                        $right_user = $true_row['UserID'];
                        $right_user2 = $true_row['ID'];



                    $sql = "SELECT * FROM Users where ID = '$right_user' AND ID = '$right_user2'";
                    $sql_result = mysql_query($sql);
                    $login_row = mysql_fetch_assoc($sql_result);
                    $right_user_ID = $login_row['ID'];
                    $rightGUID = $login_row['UserId'];
                    $right_name = $login_row['UserName'];
                   
                    $sql = "SELECT DOB, City, State FROM Membership_Profile where ID = '$right_user' AND ID = '$right_user2'";
                    $sql_result = mysql_query($sql);
                    $login_row = mysql_fetch_assoc($sql_result);
                    $user_dob = $login_row['DOB'];
                    $City = $login_row['City'];
                    $State = $login_row['State'];
                   
                    if ($is_odd_row)
                  {
                  echo "<tr style=\"background-color: #e1ebf8\">\n";
                  $is_odd_row = 0;
                  }
                  else
                  {
                  echo "<tr style=\"background-color: #f3f7fc\">\n";
                  $is_odd_row = 1;
                  }

                    echo "
                    <td align=\"left\">
                    <img width=\"85px\" style=\"margin-right:10px\" src=\"profilepics/$rightGUID/profile/$right_user_ID.jpg\"><br />
                    <span style=\"font-size:13px; font-weight:900; color:#ffae00;\">$right_name </span><br />
                    Location:<br /><b>$City, $State</b><br />
                    Age:<b>";echo CalculateAge("$user_dob");
                    echo "</b></td></tr>";   
                     
                      }

I'm trying to select multiple peoples ID's where different values in different databases tables match. For instance, I want to make sure the person is a different gender than what the person logging in is, which would be set as 1(male) 2(female) in a Genders Column in the Membership_Profile table, while I am also checking to make sure that they are not blocked inside the Membership table and making sure they have a profile image in a user_profilepic table. How would I do this? This all needs to sort by the Date they were added inside the Membership Table and Limit it to 5 results. When I use the below code tho, it pulls up both Male and Females, but seems to look at the Membership correctly.

Code: [Select]
$sql2 = "SELECT Gender FROM Membership_Profile where UserID = '$user_ID'";
                    $sql_result2 = mysql_query($sql2);
                    $login_row2 = mysql_fetch_assoc($sql_result2);
                    $user_gender = $login_row2['Gender']; 

                    $true_query = mysql_query("SELECT Membership.ID, Membership_Profile.ID, user_profilepic.UserID FROM Membership, Membership_Profile, user_profilepic WHERE Membership_Profile.Gender != '$user_gender' AND Membership.ID = user_profilepic.UserID  AND Membership.IsApproved='1' AND Membership.IsLockedOut = '0' AND Membership.UserLevel = '1' AND user_profilepic.Profile_Pic = '1' ORDER BY Membership.CreateDate DESC LIMIT 5;");
                     $is_odd_row = 1;
                     while ($true_row = mysql_fetch_assoc($true_query))
                      {
                        $right_user = $true_row['UserID'];
                        $right_user2 = $true_row['ID'];



                    $sql = "SELECT * FROM Users where ID = '$right_user' AND ID = '$right_user2'";
                    $sql_result = mysql_query($sql);
                    $login_row = mysql_fetch_assoc($sql_result);
                    $right_user_ID = $login_row['ID'];
                    $rightGUID = $login_row['UserId'];
                    $right_name = $login_row['UserName'];
                   
                    $sql = "SELECT DOB, City, State FROM Membership_Profile where ID = '$right_user' AND ID = '$right_user2'";
                    $sql_result = mysql_query($sql);
                    $login_row = mysql_fetch_assoc($sql_result);
                    $user_dob = $login_row['DOB'];
                    $City = $login_row['City'];
                    $State = $login_row['State'];
                   
                    if ($is_odd_row)
                  {
                  echo "<tr style=\"background-color: #e1ebf8\">\n";
                  $is_odd_row = 0;
                  }
                  else
                  {
                  echo "<tr style=\"background-color: #f3f7fc\">\n";
                  $is_odd_row = 1;
                  }

                    echo "
                    <td align=\"left\">
                    <img width=\"85px\" style=\"margin-right:10px\" src=\"profilepics/$rightGUID/profile/$right_user_ID.jpg\"><br />
                    <span style=\"font-size:13px; font-weight:900; color:#ffae00;\">$right_name </span><br />
                    Location:<br /><b>$City, $State</b><br />
                    Age:<b>";echo CalculateAge("$user_dob");
                    echo "</b></td></tr>";   
                     
                      }

Hi all:

I start an application in PHP and SQL Server for a company car and I need some recommendations.

The application tracked him to the maintenance of the cars. On one side are the car brands (Ford, Chevrolet, etc.) with the relevant goods and associated services. A relationship many-to-many.

On the other hand, the executives (stage 1) enter the customer associated with their cars and the corresponding products and services. The customer goes to the mechanic who performs the action (step 2) and finally counter that the collection (step 3).

My main problem is how to link Client - Automobile - Services in the first form. Enter the name and telephone number after a multi-select will select the brand and asynchronously checkbox must be loaded in all services and check the corresponding to that mark.


I find it difficult to incorporate all the links on the form. Appreciate design recommendations database (customer table) and how to assemble the form. Maybe some of you made any similar application or know a reference.

Finally thank you in advance for the time can provide for review this post.

I'm having a hard time grasping how to select data from several tables.

Here's the code

Code: [Select]
<?php 
require_once "config.php";
$gamedate = $_SESSION['date'];
echo "These umpires are not currently scheduled on this date, and have not asked for the day off:<br />";

$umpirelist = Array('umpire 1 name', 'umpire 2 name', 'umpire 3 name');

$dbc = mysql_pconnect($host, $username, $password);  
mysql_select_db($db,$dbc);  

foreach($umpirelist as $data) { 

//now get stuff from a table           
$sql = "SELECT calendar.date, calendar.ump1, calendar.ump2, calendar.ump3, calendar.ump4, calendar.ump5, vacation.date, vacation.umpire FROM umps, calendar, vacation WHERE umps.full_name = $data AND $gamedate = `calendar.date` AND $gamedate = `vacation.date` AND $data NOT IN ('calendar.ump1', 'calendar.ump2', 'calendar.ump3', 'calendar.ump4', 'calendar.ump5') AND $data NOT IN ('vacation.umpire') order by umps.full_name asc"; 

$rs = mysql_query($sql,$dbc);  
$matches = 0; 
while ($row = mysql_fetch_assoc($rs))  {
$matches++; 
echo "$row[$data]<br />";
}
}
?>

The table CALENDAR holds the date of the game, who is playing, and what umpires are schedule for that game.  it does have a unique "row_number" column as well, but didn't think I'd need it in this select.

The table VACATION has the date, and umpire's name that is on vacation.

The table UMPS contains the umpires name (same names as the array in the code) and email addresses and login info.

I'm getting this error:

Quote

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource on line 152



This is line 152

Quote

while ($row = mysql_fetch_assoc($rs))  {



Can someone please point me in the right direction as to where I'm going wrong?

Thanks!