form values 2

[sofia403]

Hi, how would i display the date that is already in db and was submitted by user when he logs in to their profile?

That code below works for the values like 'approved' 'denied' so on, but how would i do same for a date? thank you.

 

<?php
include('config.php');
$uname=$_SESSION['username'];
if($_SESSION['username']){
$sql="SELECT ApplicationStatus FROM table1 WHERE uname='$uname'";
$result=mysql_query($sql);
$row = mysql_fetch_array($result);}
echo '<form name="test" method="post">
	<select name="ApplicationStatus">
	<option value="">------</option>
	<option value="In process" '.(($row['column1']=='In process')?'selected="selected"':'').'>In process</option>
	<option value="Withdrawn" '.(($row['column1']=='Withdrawn')?'selected="selected"':'').'>Withdrawn</option>
                </select>';
?>

[paul2010]

echo $row['ApplicationStatus'];

 

insert where you want the date to be shown.

[sofia403]

hi, wouldnt it just select the values of the Application status? I have no problem displaying and identifying ApplicationStatus, what i need is for a another column that has Dates in it to have similar query that finds out which entry is already in db and then display it.

[mikesta707]

Oh hey I remember you.

 

Anyways, you are going to do something similar to what you already have. In MySQL queries, you can select multiple things at once. So you don't even have to do another query, but modify your existing one to get the other information you need. For example

//your original query whtat just gets ApplicationStatus
$sql="SELECT ApplicationStatus FROM table1 WHERE uname='$uname'";
//now if we want the column with date information in it, we just select it also by adding it after ApplicationStatus, in a comma seperate list.
//so for example, if the column you are after is named DateInfo, we do
$sql="SELECT ApplicationStatus, DateInfo FROM table1 WHERE uname='$uname'";

 

once you have selected it, its just a matter of displaying it wherever you need using the $row array and echo. So for example, if you simply wanted to display it after your select input

...
$row = mysql_fetch_array($result);}
echo '<form name="test" method="post">
	<select name="ApplicationStatus">
	<option value="">------</option>
	<option value="In process" '.(($row['column1']=='In process')?'selected="selected"':'').'>In process</option>
	<option value="Withdrawn" '.(($row['column1']=='Withdrawn')?'selected="selected"':'').'>Withdrawn</option>
                </select>';
echo "Date Information : {$row['DateInfo']}";

[sofia403]

Great! I got it, thanks again mikesta.

[mikesta707]

No problem. Remember, if your topic is solved, you can click the "topic solved" button at the bottom of the thread