$row values not getting displayed in form

[varai]

Hi,

Does anyone know on why $row['cr_no'], $row['exp_mth'] and $row['exp_yr'] is getting not displayed for cr_no, exp_mth and exp_yr? only cr_card is getting displayed properly.

The following is my code:

while ($row=mysql_fetch_array($result))
	       {	            echo "cr_no: ". $row['cr_no']; 
             $sql="select cr_card from credit_card_det where cr_card<>'".$row['cr_card']."'";

		$result=mysql_query($sql) or die(mysql_error());

		?>
		<div class='form_general'>
		<form action="manage_credit_cards.php" method="post">

		<div class='form_label' style='left:7%;top:inherit;'>Payment</div>
		<div class='form_element' style='top:inherit;left:14%; vertical-align:middle;'>
		<select name='cr_card'>
		<?php
		echo "<option selected>".$row["cr_card"]."</option>";
		while ($row=mysql_fetch_array($result))
			echo "<option>".$row['cr_card']."</option>";

		echo "</select>";
		echo "Card Number:";
		[COLOR="Red"]echo "<input type='text' name='cr_no' maxlength='16' value='".$row["cr_no"]."'>";[/COLOR]			?>

		Expiration Date:
		<select name="exp_mth">
		<?php 
			for ($mth=1; $mth<=12; $mth++)
				 {if ($row['exp_mth']=="0".$mth)
						[COLOR="red"]printf("<option selected>%02u</option>", $row['exp_mth']);[/COLOR]					  else
						printf("<option>%02u</option>",$mth);     //0 padding 2 unsigned decimal numbers --- refer to php.net sprintf function
				  }

		?>
		</select>
		<?php 
		$today = getdate();

		?>
		<select name="exp_yr">
		<?php 
		for ($yr=$today["year"]; $yr<=$today["year"]+20; $yr++)
		   //if (isset($_SESSION['exp_yr']) || isset($_POST['exp_yr']))
			  { [COLOR="red"]if ($row['exp_yr']==$yr)
					 echo "<option selected>".$row['exp_yr']."</option>";[/COLOR]					else
					 echo "<option>".$yr."</option>";
			  }
		?>
		</select>

		</div>
		<div class="form_element" style="top:inherit;left:70%;">
		<input type='submit' value='OK' />
		</div>
		</form>
		</div>
<?php
              }//end while ($row= mysql_fetch_array....)
           ?>

thank you.

[BIOSTALL]

A couple of questions for you varai:

1. What happens if you output $row like so:

while ($row=mysql_fetch_array($result)) {
   print_r($row);

Do the required values contain values?

2. Can we have a look at your query?

3. Do the fields you mention (cr_no, exp_mth and exp_yr) contain values in the database?

Thanks 🙂

[varai]

1. What happens if you output $row like so:

PHP Code:
while ($row=mysql_fetch_array($result)) {
print_r($row);

Do the required values contain values?

Array ( [0] => 10 [card_id] => 10 [1] => 7 [cust_id] => 7 [2] => Master [cr_card] => Master [3] => 22222 [cr_no] => 22222 [4] => 11 [exp_mth] => 11 [5] => 2013 [exp_yr] => 2013 )

2. Can we have a look at your query?

$sql="select * from credit_card where card_id=".$_GET['card_id']."";

3. Do the fields you mention (cr_no, exp_mth and exp_yr) contain values in the database?

Yes they do, coz in the previous
page (manage_credit_cards.php), all the fields from the credit_card table is getting displayed for the particular customer.

thank you.

[BIOSTALL]

It couldn't be to do with the fact you are overwriting $row could it? You have two 'while' loops, both using 'while ($row=mysql_fetch_array($result)'.

Change the second one to something like while ($row2=mysql_fetch_array($result2) and that may solve it. Without knowing more about the code it's hard to tell though.

Hope that helps

[varai]

It couldn't be to do with the fact you are overwriting $row could it? You have two 'while' loops, both using 'while ($row=mysql_fetch_array($result)'.

Yes, exactly that was the problem, when I renamed the second $row and $result to $row2 and $result2, everything worked fine.

thanks a lot.