Easy A
Would you like to react to this message? Create an account in a few clicks or log in to continue.


 
HomeHome  Latest imagesLatest images  SearchSearch  RegisterRegister  Log inLog in  

Easy A :: How do i select entries from a mySQL database to use as options in a form? Edit-trash Useless :: TrashShare
 

 How do i select entries from a mySQL database to use as options in a form?

View previous topic View next topic Go down 
AuthorMessage
Twerk
Member
Member
Twerk

Posts : 26
Join date : 2011-04-17

How do i select entries from a mySQL database to use as options in a form? Empty
PostSubject: How do i select entries from a mySQL database to use as options in a form?   How do i select entries from a mySQL database to use as options in a form? EmptyFri Jun 17, 2011 2:30 am
Hi,

I was wondering, is it possible for me to select entries from my database, to use in a dropdown list in a form.

The form is for a sports website. In the database, i have all the players and the teams of which they play for.

I would like for the drop down list to just show players from a certain team using php.

Is this possible? If so, what would the code look like?

Thanks,
Back to top Go down
DreamsFade
Member
Member
DreamsFade

Posts : 12
Join date : 2011-04-17

How do i select entries from a mySQL database to use as options in a form? Empty
PostSubject: Re: How do i select entries from a mySQL database to use as options in a form?   How do i select entries from a mySQL database to use as options in a form? EmptyFri Jun 17, 2011 2:31 am
Code:

<form action="updateprovider.php" method="post">
<input type="hidden" name="providerid" value="<?php echo $_GET[provider]; ?>" />
<table bgcolor="#D5EDB3" border="1" width=100% height="400">
<tr><td align="right">Provider Name:</td>
<td><input type="text" name="provider_name" value="<?php echo $row[provider_name]; ?>"/></td></tr>
<tr><td align="right">Address:</td><td><input type="text" name="provider_address" value="<?php echo $row[provider_add]; ?>"/></td></tr>
<tr><td align="right">City:</td><td><input type="text" name="provider_city" value="<?php echo $row[provider_city]; ?>"/></td></tr>
<tr><td align="right">State:</td><td><input type="text" name="provider_state" value="<?php echo $row[provider_state]; ?>"/></td></tr>
<tr><td align="right">Zip Code:</td><td><input type="text" name="provider_zip" value="<?php echo $row[provider_zip]; ?>"/></td></tr>
<tr><td align="right">Phone:</center></td><td><input type="text" name="provider_phone" value="<?php echo $row[provider_phone]; ?>"/></td></tr>
<tr><td align="right">Email:</td><td><input type="text" name="provider_email" value="<?php echo $row[provider_email]; ?>"/></td></tr>
<tr><td></td><td><input type="submit" /></td></tr>

</table>
</form>
Back to top Go down
Twerk
Member
Member
Twerk

Posts : 26
Join date : 2011-04-17

How do i select entries from a mySQL database to use as options in a form? Empty
PostSubject: Re: How do i select entries from a mySQL database to use as options in a form?   How do i select entries from a mySQL database to use as options in a form? EmptyFri Jun 17, 2011 2:32 am
Cheers, will try and implement that into my site
Back to top Go down
Twerk
Member
Member
Twerk

Posts : 26
Join date : 2011-04-17

How do i select entries from a mySQL database to use as options in a form? Empty
PostSubject: Re: How do i select entries from a mySQL database to use as options in a form?   How do i select entries from a mySQL database to use as options in a form? EmptyFri Jun 17, 2011 2:33 am
Cant get my head around this at all.

Any way you could break it down a bit?

I want the part of the form to look like "player - 'drop-down-list of players playing for that club'"

The table in the database is called "players". The row names are "playername" and "teamname"

I dont understand how to make it so it only shows players from say "Manchester United" in the drop down list.
Back to top Go down
DreamsFade
Member
Member
DreamsFade

Posts : 12
Join date : 2011-04-17

How do i select entries from a mySQL database to use as options in a form? Empty
PostSubject: Re: How do i select entries from a mySQL database to use as options in a form?   How do i select entries from a mySQL database to use as options in a form? EmptyFri Jun 17, 2011 2:35 am
See this thread There are some examples
Back to top Go down
Sponsored content




How do i select entries from a mySQL database to use as options in a form? Empty
PostSubject: Re: How do i select entries from a mySQL database to use as options in a form?   How do i select entries from a mySQL database to use as options in a form? Empty
Back to top Go down
 

How do i select entries from a mySQL database to use as options in a form?

View previous topic View next topic Back to top 
Page 1 of 1

 Similar topics

-
» Can you use a select parameter as a field in the dataset?
» MySQL over SSL socket?
» how to connect to mysql
» Problem when using ORDER BY a date field from MySQL
» C / C++ code for Database connectivity

Permissions in this forum:You cannot reply to topics in this forum
Easy A :: How do i select entries from a mySQL database to use as options in a form? Edit-trash Useless :: Trash-