multiple records querying and submitting

mattotto77

{amended with tidier code}

I have the following code below which displays the records from a table, although i can get the query to run and display, im having trouble submitting andy changes back to the table, i know i have to do sort of array thing but im a newbie to php and never done any sort of progamming before.

if anyone can help possibly with an example also with how im going to write back to the table it would be most appreciated, the results can range from 0-30,

Thanks in advance.

<?php

while($query_data = mysql_fetch_array($result)) {
$ResId = $query_data["ResId"];
$Vote = $query_data["Vote"];
$gpVote = $query_data["gpVote"];

TTT

you mean update table? by using insert or update??

mattotto77

hi TTT

update i know loop statements are involved but dont have clue!

Cheers

TTT

$ResId // id
$Vote // vote option1
$gpVote // vote option2

😕

mattotto77

resid = is the number of the resolution and how i suppose will write back to the table ie where resid = $resid

Vote = is basically vote1
and gpvote is yes an alternative vote.

There are more fields involved but this is at a later date :-)

Cheers

TTT

didn't realize what you are doing but.... i think you don't wanna show votes (source), so:
<input type="hidden" name="ResId" value="<?echo $query_data[0];?>">
<input type="submit" name="submit" value="submit">

<?
if(isset($submit)) {
$q = mysql_query("SELECT Vote,gpVote FROM table WHERE ResId = $ResId",$conn);
if(mysql_num_rows($q) != 0) {
$q = mysql_fetch_array($q);
$q[0] = $q[0]+$Vote;
$q[1] = $q[1]+$gpVote;
$q2 = mysql_query("UPDATE table SET Vote = $q[0], gpVote=$q[1] WHERE ResId = $ResId",$conn);

} else {
    //...insert

 }

}

TTT

now i get it... i think 🙂

<TD WIDTH="110" height="1" align="center"><input type = "text" size = "8" name = "Vote[<?echo $ResId;?>]" value ="<? echo $Vote ?>">
</TD>

<TD WIDTH="110" height="1" align="center"><input type = "text" size = "8" name = "gpVote[<?echo $ResId;?>]" value ="<? echo $gpVote ?>">

..... =>
while (list ($key, $val) = each ($Vote)) {
// query here old values ... $ResId = $key
$NewVote = $val+$queryResultVote;
if(array_key_exists($key,$gpVote)) {
$newGPvote = $gpVote[$key]+$queryResultGPvote;
} else {
$newGPvote =$queryResultGPvote;
}
$q = mysql_query("UPDATE table SET Vote = $newGPvote, gpVote = $newGPvote WHERE ResId = $key",$conn);

}

hope this helps...

mattotto77

Hi TTT

Sorry for confusion have been spending time on the query and got something like this to display results

$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
$i++;
echo "<input type=\"text\" name=\"Vote$i\" value=\"$Vote\">\n";
echo "<input type=\"text\" name=\"gpVote$i\" value=\"$gpVote\">\n";
}

   mysql_close();

Im only using 2 fields for now, its generating the input boxes for now according to how many results there are, currently though its not displaying the any data in the text boxes 😕

once this is sorted i will need to come up with a loop statement to write the results back.

Cheers