populating form from sql

[puremm]

I have a form with seven categories, each has a title and a answer, but one has three answers and another two... I have the data stored in a table, each entry is identified by a entry_no.

I want to get each category and display them in the form here's the code I'm using at present;

$entry_uid = 12340001

$msql = " SELECT category,entry_title,entry_file_1,entry_file_2,entry_file_3,entry_uid FROM entry_categories WHERE entry_uid = '$id' ";
$qry = mysql_query($msql);


while ($cat = mysql_fetch_assoc($qry)) {

if ($cat['category'] == '1') {
echo '<label class="field-entry">
1. Exclusive News/Sports Story of the Year (title)<input type="text" name="" value="'. $cat['entry_title'] .'" disabled /></label>
<label class="field-upload1">Select story file (any .doc, .docx, .txt, .rtf format)<input type="text" name="" value="'. $cat['entry_file_1'] .'" disabled="disabled" /></label>';
} else {
echo '<label class="field-entry"><input type="hidden" name="Cat_1" value="1" />
1. Exclusive News/Sports Story of the Year (title) <input type="text" name="Title_1" value="" /></label>
<label class="field-upload1">Select story file (any .doc, .docx, .txt, .rtf format) <input type="file" name="File_1_1" value="" /></label>';
}

if ($cat['category'] == '2') {
echo '<label class="field-entry">
2. Spec News/Sport Story of the Year (title) <input type="text" name="" value="'. $cat['entry_title'] .'" disabled /></label>
<label class="field-upload1">Select story file (any .doc, .docx, .txt, .rtf format)<input type="text" name="" value="'. $cat['entry_file_1'] .'" disabled="disabled" /></label>';
} else {
echo '<label class="field-entry"><input type="hidden" name="Cat_1" value="1" />
2. Spec News/Sport Story of the Year (title) <input type="text" name="Title_2" value="" /></label>
<label class="field-upload1">Select story file (any .doc, .docx, .txt, .rtf format) <input type="file" name="File_2_1" value="" /></label>';
}

 

[jpadie]

first off, please post code within [ignore]

[/ignore] tags. it makes it enormously easier to read.

secondly, can you explain what the difference is between cat 1 and 2? so far as I can see from your code if something is cat 2, then the else of cat 1 is executed and THEN the if true condition of the second conditional is fired off. If something is cat 2 then vice versa. and if something is cat something else then the else's of both conditionals are fired. is this really your intention?

 

[puremm]

Category (cat) is basically a number for a criteria

So in total there are seven categories, each requiring a title and a file (of text) to be uploaded...

 

[jpadie]

could you answer my question? is the behaviour that i set out above representative of your intention?