strange results, different each time

horstuff

Hi. This code will return results in one of the selects one time,
with nothing in the other. Then when you refresh the page, it is
the opposite. I have no idea why. Anybody else? Thanks.

$post1 = mysql_query ("SELECT aw_id,warranty_comment,aw_tag FROM warranty 
ORDER BY warranty_comment ASC"); 
while ($row=mysql_fetch_array($post1) ) { 
$fid = $row["aw_id"]; 
$fname1 = $row["warranty_comment"]; 
$trimmed = trim($fname1); 
$option_value1 .= "<OPTION value=\"$fid\">$fname1</option>";  

} 

$post2 = mysql_query ("SELECT ar_id,return_comment,ar_tag FROM return 
ORDER BY return_comment ASC"); 
while ($row=mysql_fetch_array($post2) ) { 
$ffid = $row["ar_id"]; 
$fname15 = $row["return_comment"]; 
$trimmed = trim($fname15); 
$option_value1232 .= "<OPTION value=\"$ffid\">$fname15</option>";  

} 

$strSql = "select * from product_status,warranty where product_status.warranty = 
warranty.aw_id and product_id = $pid";
$result = mysql_query($strSql);
while ($a_row = mysql_fetch_array($result)){ 
$warranty_comment = $a_row['warranty_comment']; 
} 

$strSql = "select * from product_status,return where product_status.return = 
return.ar_id and product_id = $pid";
$result = mysql_query($strSql);
while ($b_row = mysql_fetch_array($result)){ 
$return_comment = $b_row['return_comment']; 
} 

print "<tr bgcolor='#000066'><td width='150'><font face='Verdana' size='1' color='#FFFFFF'>
Warranty<br>
<font color='#cccccc'>(View Warranties Below)</font></font></td><td width='600'>
<select name='warranty'><option selected>$warranty_comment</option>
<? echo $option_value1; ?></select></select></td>";

print "<tr bgcolor='#000066'><td width='150'><font face='Verdana' size='1' color='#FFFFFF'>
Return Policy<br>
<font color='#cccccc'>(View Return Policies Below)</font></font></td><td width='600'>
<select name='return'><option selected>$return_comment</option>
<? echo $option_value1232; ?></select></select></td>";

horstuff

I think I know why now, but still don't know how to fix it. When the selected option is submitted, it ignores the "fid" value and inserts the actual comment text into product_status, so when you go back to it, there is text in that field so the query can't reference it with the aw_id number. Any ideas?

horstuff

now i fixed that, but have a new problem. I changed the code to add the selected option value, like this:

print "<tr bgcolor='#000066'><td width='150'><font face='Verdana' size='1' color='#FFFFFF'>
Warranty<br>
<font color='#cccccc'>(View Warranties Below)</font></font></td><td width='600'>
<select name='warranty'><option selected value='$fid'>$warranty_comment</option>
<? echo $option_value1; ?></select></select></td>";

and now it works EXCEPT every now it will pull up a number that wasn't there, which changes the text pulled from table "warranty" (or "return"). I THINK it is automatically inserting the last (or highest) alphabetical entry in table "warranty" (or "return"), because if I update table "warranty", then next time you view it the select result generated from table "return" is the highest alphabetical entry in table "return", and vice versa. Ideas? Thanks.