Ad:

PHP Discussion Thread
Marked Solved
Views: 832

Feb 27th, 2008

OPTION problem

Expand Post »

Hi

i m trying to get the values from database and put it into the select options..
i m using code-

PHP Syntax (Toggle Plain Text)
<?php
$con = mysql_connect("localhost","cdccpl","d123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
					  mysql_select_db("cdccpl_aus", $con);
$result = mysql_query("SELECT * FROM bak_bill_cust");
 while( $row = mysql_fetch_array( $result ) ):
 $option = $row["cust_code"];
 
echo "<option value='$row[cust_code]'>$row[cust_code]</option>";
endwhile;
 mysql_close($con);?>
<?php
$con = mysql_connect("localhost","cdccpl","d123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
					  mysql_select_db("cdccpl_aus", $con);
$result = mysql_query("SELECT * FROM bak_bill_cust");
 while( $row = mysql_fetch_array( $result ) ):
 $option = $row["cust_code"];

echo "<option value='$row[cust_code]'>$row[cust_code]</option>";
endwhile;
 mysql_close($con);?>

but i m getting displayes with the values as--

PHP Syntax (Toggle Plain Text)

Customer auswidestonemanpnicholsonllwmplnewuserguestanftasturnbullanglic

means values getting displayed one after another and not in option..

why so..
plz help

Similar Threads

URGENT :: Odd Windows Booting Problem in Windows NT / 2000 / XP
Dell Laptop Upgrade Problem in Windows NT / 2000 / XP
Folder Option Problem in Windows NT / 2000 / XP
Final GUI JFrame problem with actionlistner method in Java
File and Printer Shareing Problem in Networking

abhi287

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since Dec 2007

Permalink

Feb 27th, 2008

Re: OPTION problem

echo your option tags inside of a select tag like this:

PHP Syntax (Toggle Plain Text)
<select name="test" id="test">
	<option value="value 1">option 1</option>
	<option value="value 2">option 2</option>
	<option value="value 3">option 3</option>
</select>
<select name="test" id="test">
	<option value="value 1">option 1</option>
	<option value="value 2">option 2</option>
	<option value="value 3">option 3</option>
</select>

johnsquibb

Reputation Points: 14

Solved Threads: 14

Junior Poster in Training

Offline

84 posts
since Nov 2007

Permalink

Feb 27th, 2008

Re: OPTION problem

Well firstly

php Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM bak_bill_cust");
 while( $row = mysql_fetch_array( $result ) ):
 $option = $row["cust_code"];
 
echo "<option value='$row[cust_code]'>$row[cust_code]</option>";
endwhile;
$result = mysql_query("SELECT * FROM bak_bill_cust");
 while( $row = mysql_fetch_array( $result ) ):
 $option = $row["cust_code"];

echo "<option value='$row[cust_code]'>$row[cust_code]</option>";
endwhile;

>>>

php Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM bak_bill_cust");
while( $row = mysql_fetch_assoc( $result ) )
{
    $option = $row["cust_code"];
    echo "<option value='$option'>$option</option>";
}
$result = mysql_query("SELECT * FROM bak_bill_cust");
while( $row = mysql_fetch_assoc( $result ) )
{
    $option = $row["cust_code"];
    echo "<option value='$option'>$option</option>";
}

I actually wasn't even aware PHP could use that format for while loops but I wouldn't advise its use given that it completely breaks the Perl-like syntax and just makes for ugly code.

Last edited by ShawnCplus; Feb 27th, 2008 at 3:32 pm.

ShawnCplus

Sponsor

Reputation Points: 520

Solved Threads: 268

Code Monkey

Offline

1,564 posts
since Apr 2005

Permalink

Feb 27th, 2008

Re: OPTION problem

Quote ...

I actually wasn't even aware PHP could use that format for while loops

Yeah.. I wasn't aware too..

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Feb 27th, 2008

Re: OPTION problem

Not sure if your porblem is solved yet, but here is something I use all the time for drop downs.
First get your connection string going. preferably using an include.
then use the following code, adapting statement to your needs:

php Syntax (Toggle Plain Text)
<?php
$result = mysql_query("SELECT * FROM users ORDER BY username ASC") or 
die(mysql_error());
	$sticky= '';
	if (isset($_POST['id']))
	$sticky = ($_POST['id']);
	$pulldown1 = '<select name="id">';
	$pulldown1 .= '<option></option>';
	while($row = mysql_fetch_array($result))
		{
		if($row['id'] == $sticky) {
		$pulldown1 .= "<option selected value=\"{$row['id']}\">
			{$row['username']}&nbsp;-&nbsp;
                                                {$row['id']}				
                                                </option>\n";
                                } else {
                                $pulldown1 .= "<option value=\"{$row['id']}\">					{$row['username']}&nbsp;-&nbsp;
                                                {$row['id']}
                                                </option>\n";
                                           }
                                }
                               $pulldown1 .= '</select>';
                                echo $pulldown1;	
            ?>
<?php
$result = mysql_query("SELECT * FROM users ORDER BY username ASC") or 
die(mysql_error());
	$sticky= '';
	if (isset($_POST['id']))
	$sticky = ($_POST['id']);
	$pulldown1 = '<select name="id">';
	$pulldown1 .= '<option></option>';
	while($row = mysql_fetch_array($result))
		{
		if($row['id'] == $sticky) {
		$pulldown1 .= "<option selected value=\"{$row['id']}\">
			{$row['username']}&nbsp;-&nbsp;
                                                {$row['id']}				
                                                </option>\n";
                                } else {
                                $pulldown1 .= "<option value=\"{$row['id']}\">					{$row['username']}&nbsp;-&nbsp;
                                                {$row['id']}
                                                </option>\n";
                                           }
                                }
                               $pulldown1 .= '</select>';
                                echo $pulldown1;	
            ?>

This works well for holding the users selected values when error checking as well...
hope this helps

JeniF

Reputation Points: 10

Solved Threads: 5

Junior Poster in Training

Offline

52 posts
since Aug 2007

Permalink

Feb 28th, 2008

Re: OPTION problem

Hi all..
thanks for reply..

Problem is solved..

Last edited by abhi287; Feb 28th, 2008 at 12:29 am.

abhi287

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

28 posts
since Dec 2007

Permalink

Feb 28th, 2008

Re: OPTION problem

try

PHP Syntax (Toggle Plain Text)
$sql = "SELECT * FROM bak_bill_cust";
$query = mysql_query($sql) or die('Error: ' . mysql_error());
$select = '<select name="test">';
$select .= '<option value=""></option>';
while ($row = mysql_fetch_assoc($query)) {
$select .= '<option value="' . $row['cust_code'] . '">' . $row['cust_code'] . '</option>';
}
$select .= '</select>';
echo $select;
$sql = "SELECT * FROM bak_bill_cust";
$query = mysql_query($sql) or die('Error: ' . mysql_error());
$select = '<select name="test">';
$select .= '<option value=""></option>';
while ($row = mysql_fetch_assoc($query)) {
$select .= '<option value="' . $row['cust_code'] . '">' . $row['cust_code'] . '</option>';
}
$select .= '</select>';
echo $select;

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Can't create sessions

Next Thread in PHP Forum Timeline: Displaying Data

DaniWeb Message

Cancel Changes

User Name
Password