[Resolved] Last Value In Output Field From Database Is Blank

Volitics

The code below extracts the column headings from a database table, starting with the 18th column, and outputs them in a select statement. The problem is that in the last value for the select statement the code below outputs a BLANK output. I realize that the mysql_field_name() functions, they way I've got them written below, are a bit "hacked up". I couldn't get them to work any other way.

Does anyone see why the last value in the <option value=""></option> is blank?

//This code snippet outputs all table column headings starting at column #18.
require_once "./conf/config.inc.php";
$TableName = "State"."$State";
$Result = mysql_query("SELECT * FROM $TableName", $db_connection);
for($i=17; $i<=mysql_num_fields($Result); $i++){
echo "<option value=\"";
echo mysql_field_name($Result, $i);
echo "\">";
echo mysql_field_name($Result, $i);
echo "</option>\n";
}

//This is the output from the code snippet above.
<option value="Albany">Albany</option>
<option value="Allegany">Allegany</option>
//etc.
//etc...
//etc....
<option value="Yates">Yates</option>
<option value=""></option>//****THE LAST ONE HERE IS BLANK!!!

Thanks.

Volitics

stolzyboy

change this line

echo mysql_field_name($Result, $i);

to this

echo mysql_field_name($Result, $i) . $i;

to see what number occurence in the loop it is happening

Volitics

stolzyboy;

Thank you for your help.

You're not going to believe this but someone suggested that I remove the "=" sign from the "<=" like so

//Changed from this:
for($i=17; $i<=mysql_num_fields($Result); $i++){

//to this:
for($i=17; $i<mysql_num_fields($Result); $i++){

and it works!

According to a couple of books that I have the books do not say anything about omitting the "=" sign. Odd.

Gee, I guess you learn something every day.

Thanks again.

Volitics

stolzyboy

that was my next step, if the first didn't work, was just troubleshooting as i went

no problem, mark this resolved with the link below if you are satisfied

Volitics

stolzyboy;

I'm still kind of new to the programming business. Do you think that it might cause problems if I leave it that way (i.e. "<" instead of "<=")?

Thanks.

Volitics

stolzyboy

no it is merely saying that it has to be less than it, rather than less than or equal to it

Volitics

stolzyboy;

Thank you for your help.

Best Regards;

Volitics