Working with 2 tables

Hi,

I have a reports page and on the reports I have a team line up:

[code=php]

<input name=”shirtone” type=”text” size=”35″ maxlength=”128″ value=”<?php echo $shirtone?>”>
<select name=”shirtone_quickpick” onChange=”window.document.reportform.shirtone.value = this.options[this.selectedIndex].value”;>
<option>Quick pick name…</option>
<option value=”Allaway”<? if ($shirtone == ‘Allaway’) echo ‘ selected’ ?>>Allaway
<option value=”Parkin”<? if ($shirtone == ‘Parkin’) echo ‘ selected’ ?>>Parkin
<option value=”Whincup”<? if ($shirtone == ‘Whincup’) echo ‘ selected’ ?>>Whincup
</select>

[/code]

When I hit submit the data I select from the dropdown either ‘Allaway’, ‘Parkin’ or
‘Whincup’ is then recorded in the $shirtone variable in that record in a ‘reports’ table.

So When I add 5 reports records with different id’s and for example have picked ‘Allaway’ five times I want that information that he has made 5 appearances to appear in a different table called ‘players’ in an input box with the value ‘5’

[code=php]


<input name=”allaway” type=”text” id=”allaway” value=”<?php echo $allaway?>” size=”36″>

[/code]

Then when I add another report again in the ‘report’ table and he is picked his appearances goes up to ‘6’ automatically in the ‘players’ table and appears in the above input box.

And so on…

How do I go about doing this – can anyone provide me with a code example.

Thanks

Chris

Also in #PHP _↴