Newbi Help please

sjcosh · #1 28-Sep-2009, 21:15

Can someone please help with the below code.

PHP Code:


<tr>
    <td>Application:</td>
    <td><select name="application">
        <option value="<?php echo $appid; ?>"><?php echo $appname;?></option>";
<?php
//for each row we get from mysql, echo a form input
while ($row = mysql_fetch_array($rsapps)) {
echo "<option value=\"$row['`Application Code`']\">$row['`Application Description`']</option>\n";
}
?>
</select></td>
</tr>

I know you should not have spaces in the field names of a mysql table but i didn't design the database so I'm stuck with it.

I'm getting an error on this line of code

Code:

echo "<option value=\"$row['`Application Code`']\">$row['`Application Description`']</option>\n";

Any help would be fantastic.

Thanks.

TurboPT · #2 29-Sep-2009, 07:52

I don't think the back-ticks are necessary, they are probably NOT included with the column name, and that could be causing trouble. Having the column name between the single quotes should be enough.

To see what information you are getting, simply do a print_r() on each $row inside the while loop.

PHP Code:


print_r($row);  // inside the loop. This will show the column => value pairs for each row.

EDIT:
Also, there appears to be a stray double-quote after the </option> tag before the loop.

sjcosh · #3 29-Sep-2009, 19:17

Thanks for a push in the right direction, but the only way i could get it to work was to create 2 variables and asign the field names to the variables, then put the variables in the loop.

If i put the field names in there with the spaces i kept getting syntax errors.

Thanks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Newbi Help please

Re: Newbi Help please

Re: Newbi Help please