# Help with PHP and MySQL

**URL:** <https://forum.kirupa.com/t/help-with-php-and-mysql/312558>\
**Category:** programming\
**Created:** [August 6, 2010, 12:57pm UTC](https://forum.kirupa.com/t/help-with-php-and-mysql/312558 "2010-08-06T12:57:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![fathed](https://avatars.discourse-cdn.com/v4/letter/f/b5ac83/32.png) [@fathed](https://forum.kirupa.com/u/fathed)\
**Post date:** [August 6, 2010, 12:57pm UTC](https://forum.kirupa.com/t/help-with-php-and-mysql/312558/1 "2010-08-06T12:57:57Z")

</div>

I am not sure how to frame my questions so I will just do my best.

I have a table called rooms and it has three fields: roomsP§, roomNumber, imageDate

I am populating a drop down menu with the roomNumber field. What I want to do from here is populate a text field with the image date that is in the same entry as the shown roomNumber,. So, I choose room number 1 and its imageDate appears in the text field.

Any help would be greatly appreciated. Thank you in advance.