How To Use A Value From A Pick List?
I'd like to have a form that does the following:
User picks a site from a dropdown list from a MySQL db (that works -
code below, thanks to all those on the web who posted code for this).
Once the value is selected, a second query is run using the site as the
'where' clause and the results are displayed back to the user.
mysql, php, htlm noob. I think once I get this bit,
I'll be able to move forward with more interesting and complex code.
ps - if this message shows up 3 times, my apologies but I've been having
trouble posting.
<html>
<body>
<?php
// connect to db
$db = mysql_connect("localhost");
mysql_select_db("test",$db);
// build query
$sitequery = "SELECT site from sitedata order by site";
// generate result set
$siteresult = mysql_query($sitequery);
// use results
echo "Select a site from the list below: <br><br><select name='site'>";
while($siterow = mysql_fetch_array($siteresult))
echo "<option
value='".$siterow["site"]."'>".$siterow["site"]."</option>";
echo "</select></td>";
?>
</body>
</html>
View Complete Forum Thread with Replies
Related Forum Messages:
Dynamic Pick List
I have been developing programs in perl and oracle and have recently switched to php. I need to create a form that has four of five seperate pick list on it. Each item in each of the pick list depend on the users previous entry. For instence if the user picks Ford then Taurus, Ranger, Focus,.etc show up in the next pick list then the user picks Ranger and 2 wheel drive, 4 wheel drive, etc show in the next pick list box on so on. I know how to this if the screen is refresed after each user entry. What I would like to fugure out how to make the screen automatically update each pick list and not refreshing the whole screen.
View Replies !
Pick And Choose List
You have two list boxes on a page. On the left are all the choices, the right box is empty. In the middle you have "arrow buttons". A single one pointing right says "move the selected choice into the right box". A single pointing left does the opposite. A double pointing right says "move all choices from left to right". A double pointing left does the opposite. I am not sure if I can do this with PHP. Maybe Javascript? Or is it just impossible to do with web pages?
View Replies !
Allows Someone To Change The Given Attribute Via A Pick-list
I have a form that lists query results (members, attributes) side by side, and allows someone to change the given attribute via a pick-list. I'd like to know how all of the member attributes (one for each member listed in the query results) can be updated at once. I have no problem implementing this when just one record is being updated, but as soon as there is more than one record I get into trouble. Here's a little diagram of what I'm trying to do: ------------------------------------------ Name | Attribute ------------------------------------------ Member1 | Pick List Member2 | Pick List Member3 | Pick List " etc " | " etc " ------------------------------------------ | Update |
View Replies !
Identifying User's Pick From Selection List
I have an application that uses PHP to access a MySQL table and extract rows which match the user's search entry. Data from the matching rows are loaded into an HTML selection list, and the user can scan the list and highlight a selected item. My question: In PHP, what is the syntax for identifying which row is highlighted? My goal is to pass the unique row ID of the selected item to a subsequent form where all the fields will be displayed for the user to edit. I already have the code that loads the selection list and the code that displays the fields. I just need to know how to determine the highlighted item. I have two PHP books, and both discuss loading the selection list, but there is no mention of what to do next.
View Replies !
Pick From A Drop Down List That Automatically Gives Options In A Second Dropdown Box
does anyone know how to create a form that allows the user to firstly pick from a drop down list that automatically gives options in a second dropdown box. eg. 'category1' is selected from dropdown box 1, this then populates dropdown box 2 with the options 'category1.a' or 'category1.b' or if 'category2' is selected from dropdown box 1 then dropdown box 2 gives the options of 'category2.a' or 'category1.b' i f any one knows how I should code this please help, if not point me in the direction of a tutorial that can.
View Replies !
PHP To Pick A Table
In my attempt to be more organized I setup my database like this: DB: -Table1 -Table2 -Table3 -Table4 and each table has 4 forms for information.
View Replies !
How To Pick The Closest Number
I've been wondering about this for a few days. I have an array containing 4 numbers: $listofnumbers = array(0,15,30,45); Then there's a variable that could contain any number between 0 and 59. $actualtime = date('i'); Using the above I want to find out which of the numbers in the array is numerically closest to the value of $actualtime. So if $actualtime = 34 then I want to return the number 30 if $actualtime = 11 then I want to return the number 15 etc. I'm sure there's a simple solution but can't figure it out.
View Replies !
Gmail Does Not Pick Up Sender Id
I had a shared hosting account with Godaddy earlier. I have script in my code which sends automatic emails to users when they sign up on the website. All these emails were going in a proper format earlier. When i changed to Virtual Dedicated Server on Godaddy, emails which are automatically being shot to yahoo, hotmail or any other accounts are going properly. Code:
View Replies !
Pick Records Between Dates
I have this table id_hotel | ratesin | ratesout | rate 1 | 2007-06-07 | 2007-07-15 | 100.00 1 | 2007-09-07 | 2007-12-10 | 150.00 2 | 2007-05-07 | 2007-08-10 | 150.00 3 | 2007-04-07 | 2007-09-10 | 120.00 What I want to do is to make a selection and show only records between desired dates, example: If I post via form: id_hotel = 1 ratesin=2007-07-07 and ratesout=2007-07-10, the result will show only the records in those dates range in this case the result will be: id_hotel | ratesin | ratesout | rate 1 | 2007-06-07 | 2007-07-15 | 100.00 Maybe is easier than I think, how to achieve this.
View Replies !
Need A 'pick A Date' Script
where I can find a good, quick, clean script to provide a calendar from which the user can pick a date to populate a field? Ideally Im looking for a small pop-down as aprt of a larger page wide data form.
View Replies !
Checkbox Problem, He Always Pick The Variable Of The Last One
I have currently 2 awards in the database, with this script i pick them out of the database and define if they are selected and if the user unselect it then pass a variable to the database. Now it works almost good except that the script always looks to the 2nd award(last one), if the 2nd one is unselected then it updates award 1 and award 2 as unselected, when i unselect the 1st award and select the 2nd award then he updates the database with both selected(1st one and 2nd one), so the problem is that he always listening to the 2nd(last) variable/award. Does someone have a solution for this problem because i cant figure it out, greatly appreciated. PHP Code:
View Replies !
How Can I Pick All Checked Value In Action Page?
I have a dynamic category list, I have printed those list with check box in the form. I have to check those boxes and submit. How can I pick all checked value in action page? Right now only one value passing from several check boxes while several check boxes checked. Code:
View Replies !
Pick Apart Post Variable Names
i am dynamically creating a list of checkboxes for each job title in a db. the checkbox array names are something like 'job2quest[]' & the 'job5quest[]'... since i dont necessarily kno which jobs will appear, i dont want to hardcode the variables when the form is submitted. is there a way to pick apart post variable names, so the script can find the checkbox arrays?
View Replies !
List Contents Of A Folder, Make List Of Links
Does anyone know how I can write a script that: - reads in all the files in a particular directory - displays the file names in a html list and makes a link of them: <ul> <li><a href="filelocation1">filename 1</li> <li><a href="filelocation2">filename 1</li> <li><a href="filelocation3">filename 1</li> </ul> etc.? So basically it creates a list of links with the contents in that directory, so you can download them from there.
View Replies !
Get List Of Messages From One Table, Message List Indicator From
I have two tables. One has a list of messages left by users using fields named mbxno for the mailbox and msgno for the message number. I have another table that has mailbox settings for each user that contains a field named "messagelist" to indicate if they want to be included on the message list or not. What I'm trying to create is a list of the most-recent messages with a lookup on the users table to indicate whether a message in the list should be included in the message list based on the user's mailbox settings. SELECT messages.msgno, messages.mbxno, users.messagelist FROM messages, users WHERE (users.messagelist = Ƈ') ORDER BY msgno DESC LIMIT 100 What I'm getting, though is a list that looks like this: mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 1114 msgno: 0412141623 msglist: 1 I think what's happening is that I'm using the wrong type of join and more rows are being created than necessary. If I add "DISTINCT" to the query, I get a list of the most-recent messages as I expect, but the "messsagelist" value is sometimes wrong (again, probably because the data is getting jumbled). For example, the messagelist value for the second row (2214) should be 0, not 1. mbxno: 1114 msgno: 0412141623 msglist: 1 mbxno: 2214 msgno: 0412141622 msglist: 1 mbxno: 2189 msgno: 0412141408 msglist: 1 mbxno: 0000 msgno: 0412141213 msglist: 1 mbxno: 0003 msgno: 0412141213 msglist: 1 mbxno: 2265 msgno: 0412132029 msglist: 1 mbxno: 0000 msgno: 0412131950 msglist: 1 How should I be doing this? If nothing else, what kind of join will work with a long list compared to a value from a short list?
View Replies !
Mailing List Manager, Send To List
I'm looking for a mailing list script (php) that has a function to let users to reach out to all recipient on the list by simple send the email to a specific maillist- address. Mailman has this functionn but as a just got a webserver account I can't use mailman nor install it.
View Replies !
List Dir / List Files
Is there a fast way to read files/directory recursively? Instead of inspecting each file(s)/dir(s), is there a way to know that its a file or a directory from its hidden attribut both for windows or unix filesystem?
View Replies !
List To Populate Another List
i have a form with 3 dropdown list. the first is for a canditate, 2nd is for party, 3rd is for state and 4th is for the local areas in the state. I want if the user selects a state, the dropdown list for the local area to be populated automatically. But since they are on the same form i am not sure how.here is my code <td><select name="state" tabindex="3"> <?php #this is to get listing for roles in a drop dowm menu #the sql query $sql1 = "SELECT distinct(state_name) FROM state order by state_name "; #execute query $rs1 = mysql_query($sql1, $myConn) or die ("could not execute query $sql"); if ($rs1){ while ($row1 = mysql_fetch_array ($rs1)){ echo("<option>" . $row1['state_name'] . "</option>"); } } ......................
View Replies !
Using List
when my form is loaded i populate a list with a database query. now when user selects a value from the list. on "onChange" another query runs and other fields on the form are populated according to the value selected by the user but at this time when page is loaded again and the fields on the form are filld. every thing goes write but the select list doesn't have the same value selected that was selected by the user...the selected list shows the default valuse selected instead. i want to know that how can we do this that when we select a value from the list and page is populated using this vale and refreshed then again i want to see the selected value in the list box not the dafault value.
View Replies !
Mp3 List
I can't figure why I can't list only mp3 files with this code : <?php $dir = opendir("."); while($file = readdir($dir)) { $ext = getFileExtension($file); if ($ext = "mp3") { echo "<a href=" .$file.">".$file; echo "<p>"; } } closedir($dir); function getFileExtension($str) { $i = strrpos($str,"."); if (!$i) { return ""; } $l = strlen($str) - $i; $ext = substr($str,$i+1,$l); return $ext; } ?>
View Replies !
Mp3 XML List
I have an mp3 player for my site. Now I still have to make an upload script but I am wondering something. How would I go about making the scritp write the needed information to the playlist.xml file? So for instance a member uploads a file called "Cowboys_from_hell.mp3" how would I insert this info to the play list? <track> <title>Cowboys From Hell</title> <creator>Pantera</creator> <location>cowboys_from_hell.mp3</location> </track> The tags are already in the playlist so I just need to insert the data between the tags. I have never done anything with xml or saving info to files so this is new to me. Maybe this is even a db thing to, i dont know. if it helps any i am using the jw_mp3_player.
View Replies !
List Box
i know its possible using php to create a list box populated from a database and this i have done in the past. What i want to do now is: I have records that have colour options in a single field seperated by a comma eg red,yellow,green,blue What i want to do is add each of those colours into a list box using php pulling that data from the db. These colours are different for each record in the db and are all in one field. Is this doable?
View Replies !
Get Tag List
I want to creat Tag list shown in below web site. http://www.technorati.com/tags/ Can anybody tell me how to write code for this.
View Replies !
Php List
Code: function showlist() { global $db_table_files, $db_files_link_url, $db_files_link_total, $db_files_link_date, $db_files_id; $result=mysql_query("SELECT * FROM `$db_table_files` order by '$db_files_link_date' desc limit 10 "); echo mysql_error();
View Replies !
Get Dir List
Code: <?php $real_path = realpath("test/"); $d = dir($real_path); while (false !== ($entry = $d->read())) { if($entry != "." && $entry != "..") { echo "<a href="$entry">$entry</a> "; } } $d->close();
View Replies !
List()
I have a question about the list() function that I could not find on php.net; I am using the following code: PHP Code: $query = "SELECT blog_id, title, entry, DATE_FORMAT(date_entered, '%M %e, %Y') AS formatted_date                                   FROM blog_entries ORDER BY blog_id DESC LIMIT 3";                         if ($r = mysql_query ($query))  // Run the query.                         {                             // Retrieve and print every record.                             while ($row = mysql_fetch_array ($r))                             {list($id, $title, $entry, $date) = $row;                                 //$date = date("F d, Y");                                 $title      = htmlspecialchars($title);                                 $title2     = trim(strtolower(str_replace(' ', '-', $title)));                                 $entry      = nl2br($entry);                                 $cut        = substr($entry, 0, 300);                                 $new_text   = substr($cut, 0, strrpos($cut, ' '));                                 echo "<h2>{$title}</h2>{$date}<br />
View Replies !
Buddy List
I have a community, now it´s time to upgrade and make a buddy list. Ive started wtih the file that ask´s the other member for a relation. The code looks like this PHP Code:
View Replies !
Problems With List()
I am having some problems with the list() function. Here is some code: <? $USERDB = fopen("users.db", "r"); while ($line = fgets ($USERDB, 4096)) { list ($name, $occupation, $favcolor) = split ("|", $line); print ("Name: $name<br>"); print ("Job: $occupation<br>"); print ("Favorite Color: $favcolor<br>"); } fclose ($USERDB); ?> And here is whats in the text file: Van Tate|Software Engineer|Green Now...when I execute the script I get this error: Warning: bad regular expression for split() in /var/www/html/v2/getusers.php on line 7.
View Replies !
Loop Through A List
I want to loop through a list and display it in a table with three columns per row, yet haven't had much luck in doing so. I was thinking if would be something like so Quote: for ($x = 0; $x < mysql_num_rows($query); $x++) { if ($x / 3) { ?> <tr> <? } ?><td> Blah </td></tr></table> Well, that's as much as I know so far.
View Replies !
Add Number In List
I am outputing a list of 10 values. 10, 20, 30, 40, etc I can add 15 to one of the values then reorder the values from smallest to highest but i want to update every single value and assign it values increamenting by 10 so after the update the second number of 20 and add 15 I get 10, 30, 35, 40 now i want to re output the values above as 10, 20, 30, 40
View Replies !
PHP Link List
On a page from Thredz (http://www.thredziii.com) I saw a script (it's not on anymore...cause he didn't want the script to be on his page) and I love it... It's a script that makes it possible that on a page links are sorted ALPHABETICALLY with the first letter of the "URL name"... (take a look on Thredz' site to c what I mean,K?) Then people got 2 have the abbility to fill in a small form, ON THE SAME PAGE WHERE THE LINKS ARE ON, where they fill in 2 fields; #1 = Name of the Site ($sitename) #2 = URL of the site ($url) When they fill out it form I want the PHP-script to put the information away as a link (in a *.txt-file...if possible) <A href="$url" target="_blank">"$sitename"</A><br> (something like this??? I'm not sure......) These links have to be sorted alphabetically (on the site's name,$sitename... I don't know how this works or how I have to make something like this... Could somebody please help me and give me a bit of help with it? Some explaining would be gr8 but the script written for me is the best wish I have.
View Replies !
Dropdown List
I have a Dropdown list with Select with 1, 2, 3, 4, after select on of them it bust to refresh the page to what you select but it don't do it. PHP Code:
View Replies !
Getting List Of Newsgroups Via Php
I am trying to write a PHP script that will download a list of all the newsgroups on a news server and put them into a MySQL database. I bought a $50 book that had some NNTP examples in it, but none of them show how to just download the groups, not the articles. I tried on my own for about 2 hours with no luck. If someone can point me in the right direction to download the group list using PHP, I think I can figure out how to write it to a database.
View Replies !
FTP List Problem
I used ftp_rawlist, not ftp_list. [color=blue] > I used ftp_list and ftp_nlist. Both of them worked when the target is Sun > or Linux machine. However, it didn't work when the destination is VXWorks > (embedded platform). The version of php I am using is 4.3.2. According[/color] to[color=blue] > my search on google that problems for ftp_list and ftp_nlist for some > platforms were fixed in 4.3. > > If I manually ftp to the VXWorks, I could use the "dir" or "ls" to see the > listing at the destination. >[/color]
View Replies !
List Certain Files In A Dir
I am working on a news script were my members can post what they are currently working on. I have a dir were all of there images are going to be uploaded, and I need to know if the following is possable to do. $username = the members name selected from the database $projname = the projects name selected from the database What I want to do is select only images with the filename containing the info. The filenames are like this: TheBlackshinobi_3dmountain_1.jpg TheBlackshinobi_3dmountain_2.jpg TheBlackshinobi_3dmountain_3.jpg
View Replies !
Php And Drop Down List
I am coding an email form on a site. A user enters their name and contact email and then selects from a drop down list to which particular email the message should be sent: User1, User2, User3. Then the user types out a message and hits submit. My problem is that I am unsure as to how to grab the selection in the drop down list and pull the selection and place it like this: "$selection@domain.com". Here is the php code:
View Replies !
PHP Shortand List
Is there a place where I can find a list of all the shorthand/shortcuts in PHP's syntax. IE: $_POST, $counter++, etc? Anyone know?
View Replies !
Getting A List Of Newsgroups With PHP
Does anybody know of a quick and dirty way that I can connect to a news server, retrieve a list of all newsgroups beginning with alt. (or comp., or blah., or wibble., doesn't really matter), and also the newsgroup descriptions, and then dump them all in an html file?
View Replies !
Php Mailing List
Is it possible to implement a mailing list using PHP?. I know I could maintain a list of emails addresses in a db and send mail to them through my website, but how can I get true mailing list behaviour where emails are sent to a particular address (like mailinglist@mydomain.com) and then distributed to all of the email addresses?.
View Replies !
Select List
I'm creating a form that has three select lists. The first one has two values EMAIL and SMS. What I want to do is have the two other select lists (named EMAIL and SMS) work so that if EMAIL is selected only e-mail select list can be altered and vice versa with the SMS. How can I do this? I know to use disabled in <select> -tag, but how can I check the what the value is (and the value changes) and then act acording to it?
View Replies !
Best Way To List Pages A - Z
I now have my emulator site up and running, no longer html but php! Even my vote script now works, thank for all your input. Now I want to have roms on my site for download, but it's a fair long list so you have to devide in sections a - z or something. Can this be done in a way to create those pages with php/mysql instead of have to write html files for every emulator roms page from a to z? If anyone have done this before I would like to here what the possibilties are.
View Replies !
How To List A Directory
I would like to get a list of a local directory content using php. I would be very appreciative if anybody could tell me how to do that. I loocked in the php manual but coulsn't find anything (probably I just missed it).
View Replies !
Problems With List..
I have a function returning smth like list($a,$b): var_dump says: list(string $a, string $b) blabla() How can use this strings now? I try: list($a, $b) = blabla(); print($a); but it's won't work returning empty string. I tried also: $result = blabla(); print $result[0]; but it also won't work. The only thing I can do is to iterate result with foreach, then it works nicely, but how should I use the result of blabla() function without foreach? I just want to get to $a and $b.
View Replies !
|
TRACKER
