Cant get the data to pass on. Please help

black_dragon1

I am trying to update 2 rows from one table in a mysql database. At the same time I need to pass the data from both rows to another table. Can someone please help me figure out where the problem in my code is.

Echo("<br><br>");
Echo("<table width='90%' align='center' border='0' cellspacing='0' cellpadding='0'>");
Echo("<td><p align='center'><h3>Report Match Scores</h3></p></td>");
Echo("</table>");
Echo("<table width='90%' align='center' border='.5' cellspacing='0' cellpadding='0'>");

$result = mysql_query(
"SELECT * FROM bracket$round WHERE matchnum=$match.1");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}

while ( $row = mysql_fetch_array($result) ) {
$clannum=$row["clan1"];
$clanname=$row["clanname"];

Echo("<tr><td width='48%'><p align='center'>$clanname</p></td><td width='5%'><p align='center'>VS</p></td>");

$result1 = mysql_query(
"SELECT * FROM bracket$round WHERE matchnum=$match.2");
if (!$result) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}

while ( $row = mysql_fetch_array($result1) ) {
$clannum=$row["clan2"];
$clanname=$row["clanname"];

Echo("<td width='47%'><p align='center'>$clanname</p></td></tr>");

Echo("<FORM ACTION = 'modules.php??op=modload&name=Supportsys&file=updated&round=$round&sore1=$score1&clan1=$clan1&score2=$score2&clan2=$clan2' METHOD = 'POST'>");
Echo("<tr><td width='48%'><p align='center'>Score <input type='text' name='score1' size='5' maxlength='55'></p></td><td width='5%'> </td><td width='47%'><p align='center'>Score <input type='text' name='score2' size='5' maxlength='55'></p></td></tr>");
Echo("</table>");
Echo("<table width='90%' align='center' border='0' cellspacing='0' cellpadding='0'>");
Echo("<input type='submit' name='Submit' value='Report Scores'><input type='reset' name='reset' value='reset'>");
echo("</table>");
Echo("</form>");

}}

I have gotten a lot of information and help just from reading this site. However, I can not find this one anywhere. This is the last page I have left to write for this site and am completely stumped.

Weedpacket

What is the problem you're having?

black_dragon1

Sorry I thaught I put that in there. For some reason it is not passing the information on to the page that actually updates the database.

When i click on submit it actually puts this as the address:

http://www.opsclantourney.net/modules.php??op=modload&name=Supportsys&file=updated&round=1&sore1=&clan1=&score2=&clan2=

The only information that is included is the round number. I need the rest for the next page to update the database correctly.

Weedpacket

Ah, I see now.

For one thing, there should only be one ?. For another, you don't need all that querystring stuff there anyway. If you want to put current values into form fields, use the field tag's value= attribute, e.g.

<input type='text' name='score2' size='5' maxlength='55' value='<?php echo $score2?>'>

black_dragon1

Well the problem is I have to pull from 2 rows based on $matchnum and every row has a different value for this. For instance
"SELECT FROM bracket$round WHERE matchnum=$match.1");
and
"SELECT FROM bracket$round WHERE matchnum=$match.2");
both of them start with the same number eg 1.1 and 1.2.

Unless there was a way to get the data from both rows with one querry i have to use the 2 querries.

And I am trying to pass the information on to another page. Not put it in the form.

black_dragon1

First thing sorry I think I sounded kind of rude in that last sentance.

OK I think I got it to pass all the information on to the next page.

Now do I have to update all the information in a row or can i just pick and chose.

Sorry if I sound kind of ignorant but I am still knew to php and trying to do something a little more complicated then I am used to.

Bye the way, thanks for all the help.

black_dragon1

ok thanks to your help the page now passes on all the information it needs to pass on. However, the second row that needs to be updated is not updating. Here is the code on the page:

   if ($score1>$score2) {
   $win1="1";
   }else{
   $win1="0";
 }  

$sql = "UPDATE bracket$round SET
	score='$score1',
	win='$win1'
	WHERE clannum='$clan1'"; 
	$result=mysql_query($sql,$db);

if (!$sql) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}else{
Echo("<br><br>Clan# $clan1 score has been updated.<br><br>");
}

if ($score2>$score1) {
   $win2="1";
   }else{
   $win2="0";
}

$sql = "UPDATE bracket$round SET
	score='$score2',
	win='$win2'
	WHERE clannum='$clan2'";

if (!$sql) {
echo("<P>Error performing query: " .
mysql_error() . "</P>");
exit();
}else{
Echo("Clan# $clan2 score has been updated.");
}

Again I appreciate all the help. You guys rock!!!!

black_dragon1

I figured it out I was missing

$result=mysql_query($sql,$db);

in the second update.

Thanks again for all your help.