A problem i can't explain in a sentence!

pb1uk

Hello all,

I'm having a bit of head scratching problem that i just can't get my head around. I'm using Dreamweaver CS4
and phpmyadmin for my site.

I have a form that inputs a record into a table in my database.
The form is a user picking a fantasy sports team. A user selects a player from a drop down menu.
The players name is got from a recordset that accesses the player database, with the values coming
from the id field and the values from the name, so a user selects a player by there name and not
there unique id value. The code for this is as follows:

<tr valign="baseline">
<td nowrap="nowrap" align="right">GoalKeeper:</td>
<td><select name="gkid_team">
<?php
do {

?>
<option value="<?php echo $row_rs_pt_gk['gkid_gk']?>" ><?php echo $row_rs_pt_gk['gkname_gk']?></option>
<?php
} while ($row_rs_pt_gk = mysql_fetch_assoc($rs_pt_gk));
?>
</select></td>

The form is displayed as a table. In a row that i have added below i would like to display the players value, however this will not
be input into the database, it's purely there so the the overall value of the team can be calculated, as the teams total value must
not exceed a certain amount. I need the players value to be shown for the correct player. So for example if the user changes
there choice from the menu of player name the players value will change to the player selected.
I guess i need to use some kind of onclick javascript function, but i haven't used javascript before and i'm not even sure if
it's the correct way to go.

Any help or advice would really be appreciated as i just can't seem to get my head around it,

Thanks,
pb1uk

igorek

dreamweaver has built onclick javascript for menu.

save the selected player name into a variable and display it when the page reloads.

$selectedplayername=$_POST['gkid_team'];

<?php if($selectedplayername IS NOT NULL) { ?>
<?php echo $selectedplayername; ?>
<?php } ?>

// i am not sure about the string comparements (IS NOT NULL may not work)

js:

pb1uk

Thanks for the quick response.

I'm not too sure about what you said though. The players name is displayed in the dropdown menu. What i need to try and do is display the players value after a name has been selected. The players value is held in the same table in my database as the name if this helps

igorek

you need to query the data depending on the selection of the drop down menu.

write a SQL with the dynamic variable to retrive the Players Value from database depending on the users pick from the drop down menu.

pb1uk

Thanks igorek, that's what i need to do.

But i have no idea of how to do it

igorek

okay well lets see...

<?php
$selectedplayername=$_POST['select_name'];

mysql_select_db($database, $connection);
$query_playervalue = sprintf("
SELECT col_playervalue 
FROM tbl_players
WHERE col_playername='%s'", $selectedplayername);
$rsplayervalue = mysql_query($query_rsplayervalue, $connection) or die(mysql_error());
$row_rsplayervalue = mysql_fetch_assoc($rsplayervalue);
$totalRows_rsplayervalue = mysql_num_rows($rsplayervalue);
?>

// then in the html table echo the $playervalue

pb1uk

sorry i'm still stuck, My sql statement is at present:

mysql_select_db($database_conn_fyp09, $conn_fyp09);$query_rs_pt_gk = "SELECT tbl_gks.gkid_gk, tbl_gks.gkname_gk, tbl_club.clubname_club, tbl_gks.playervalue_gks FROM tbl_gks INNER JOIN tbl_club ON tbl_gks.clubid_gk=tbl_club.clubid_club";$rs_pt_gk = mysql_query($query_rs_pt_gk, $conn_fyp09) or die(mysql_error());$row_rs_pt_gk = mysql_fetch_assoc($rs_pt_gk);$totalRows_rs_pt_gk = mysql_num_rows($rs_pt_gk);

igorek

mysql_select_db($database_conn_fyp09, $conn_fyp09);
$query_rs_pt_gk = "
SELECT gkid_gk, gkname_gk, clubname_club, playervalue_gks 
FROM tbl_gks INNER JOIN tbl_club 
ON tbl_gks.clubid_gk=tbl_club.clubid_club";

$rs_pt_gk = mysql_query($query_rs_pt_gk, $conn_fyp09) or die(mysql_error());

$row_rs_pt_gk = mysql_fetch_assoc($rs_pt_gk);

$totalRows_rs_pt_gk = mysql_num_rows($rs_pt_gk);

if that is the sql to get the recordset of teams into the <select> then you need to create a new one.

igorek

js for the menu to go to link:

<script type="text/javascript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
//-->
</script>

html, you need to point the link to go to _self in order to get the selected team value and then save it into a variable... use that variable to QUERY the db for the correct data depending on the selected team

<tr valign="baseline">
<td nowrap="nowrap" align="right">GoalKeeper:</td>
<td>
<select name="gkid_team">
<?php do { ?>
<option value="http://yoursite.com/?gkid_team=<?php echo $row_rs_pt_gk['gkid_team']; ?>" >
<?php echo $row_rs_pt_gk['gkid_team']; ?>
</option>
<?php } while ($row_rs_pt_gk = mysql_fetch_assoc($rs_pt_gk)); ?>
</select>
</td>

php code you do before <html> tag so when the page reloads you get values



mysql_select_db($database_conn_fyp09, $conn_fyp09); 

$selectedteamname=$_REQUEST['gkid_team'];

$query_rs_pt_gk = sprintf("
SELECT gkid_gk, gkname_gk, clubname_club, playervalue_gks 
FROM tbl_gks INNER JOIN tbl_club 
ON tbl_gks.clubid_gk=tbl_club.clubid_club
WHERE gkname_gk='%s'", $selectedteamname); 

$rs_pt_gk = mysql_query($query_rs_pt_gk, $conn_fyp09) or die(mysql_error()); 

$row_rs_pt_gk = mysql_fetch_assoc($rs_pt_gk); 

$totalRows_rs_pt_gk = mysql_num_rows($rs_pt_gk);

pb1uk

Thanks igorek, i really appreciate your help on the matter.

Is there a way to do it so the page doesn't have to reload? As this is only for one player. The user will select a whole team, so i will have to do this eventually for every player.

igorek

javascript does not require requests to server so if you create an array of the same team names in the database in js you willl be able to provide the same data on the page without requiring the server.

i myself am learning js to fullest there are so many intersting things i just started but i can suggest that if you create an array and JS uses DOM which means that it acts upon the users actions on the website basicly when the user clicks the form or in your case the <select><option> it will generate an output without requiring the server. automaticaly that is the cool thing about javascript. the reason i want to learn it much more but everything comes in time. for example i just learned how to understand group by condition in sql and that functions such as min() max(), avg(), count(), COUNT(), sum(), are a part of group by. Even though they are not but they are IMPLICIT they do what group by does without giving the commmand to group by.

I love sql very intersting I wish I sat behind my laptop more and less drinking and chilling with the girls its just i do not have a friend that understands me in my work... sadly ... its okay though.. but the fact remains that "two minds are better than one"

if you need to talk i am in skype.... igorekastahov

P.S. $REQUEST[' '] is a superglobal which gives us the output of either $POST superglobal or $GET superglobal $GET gives you the variables you pass through the link such as ex. : http://www.website.com/index.php?number=10001

result equals to 10001 of the $_GET['number']

its an array so you must specify the name of the variabkle you are getting passed on through a link.

$_POST is an array containing everything submitted in the form for ex. :

we have the following:

<form name="form_test" action="<?php echo($PHP_SELF); ?> method="post" >
<input name="fname" type="text">
<input name="lname" type="text">
<input type="submit" name="submit" value="enter data">
</form>

in the $POST array we will have $POST['fname']; $POST['lname']; we will also have the same values in $REQUEST['fname']; since the request array stores everything that comes from post and get. so... $_REQUEST['number']; will also be valid.

pb1uk

Hi again igorek,

Sorry i haven't responded any sooner, haven't been able to work for a few days, i'm back to it now. Going to try the above, will keep you posted.

Cheers,

pb1uk