It doesn't work

Sapper

Here is the session id line in the asp page

strFinalTeamID = Session("TeamID")

here is the line passing it to the next page

and here is the line in the php page

$sql = "select * from players where teamid = '$_Post[TeamID]' order by 'Position'";

Any ideas as to why it doesnt work would be appreciated....

This post is relating to the one i made earlier titled ASP & PHP sorry I meant to post this on that thread but created a new post by accident.

jpmoriarty

well i'd start by jest trying to echo it out first - worry about including it into html etc when you're sure it's echoing out.

You're code also needs to be:

echo $_POST['TeamID']

i think, with the single quotes inside the square tags.

For later, you'd be better off having the code:

$sql = "select * from players where teamid = \"$_Post['TeamID']\" order by \"Position\"";

so you dont get confused between single and double quotes.

Try that then.

Sapper

I will try that then come back to you, I had a problem yesterday using the $Post['variable'] line and it only worked when i did it like '$Post[variable]' which is why its like that now.

Cheers for your help I will now go and try your suggestions :-)

Sapper

Ok I have tried it and there is no echo at all so any other ideas???

jpmoriarty

Doh - when you append it to a URL it's a GET:

so you want $_GET['TeamID']

Note:
Yes you'll need the single quotes
it's GET, not Get (just as it was POST before, not Post) - they're not the same thing

Sapper

I have tried both options and neither work, I have also looked at several other forums and the general concensus is it can't be done.

So would you care to help me prove them wrong?

jpmoriarty

post up both your asp and your php - because it most definitely can be done, so it's likely to be errors in your code now.

Sapper

Ok heres the php

<?php
$conn = mysql_connect("localhost", "username", "password")
or die("Could not connect to mysql.");
$selected = mysql_select_db("football", $conn);
echo $GET['TeamID'];
$sql = "select * from players where teamid = '$POST[TeamID]' order by 'TeamID'";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {

printf("<a href=\" %s.php\" target=blank>%s<font color=black align = left size = 2
face = Arial></a>\n",
$row["PlayerID"], $row["Name"]);
print "<br><img src=\"/gfx/".(string)$row["Strip"].".gif\">";

printf("Value £<font color=\"blue\"> %s</font>\n",
$row["Value"]);

printf("Age <font color=\"blue\">%s</font>\n",
$row["Age"]);

printf("Form <font color=\"blue\">%s</font><br>\n",
$row["Fitness"]);

printf("&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<font color=\"black\">%s</font>\n",
$row["Position"]);

printf("Level<font color=\"blue\"> %s</font>\n",
$row["Skill"]);

printf("Caps <font color=\"blue\">%s</font><br><br>\n",
$row["Caps"]);

}
mysql_close($conn);
?>

And the ASP

strFinalTeamID = Session("TeamID")

Dim RsPlayerSelect
Set RsPlayerSelect = Server.CreateObject ("ADODB.RecordSet")

Response.Write "<Select Name=PlayerGoalieBox ONCHANGE=""DupePlayers(document.teamord.PlayerGoalieBox.options[document.teamord.PlayerGoalieBox.selectedIndex].value,'Goalie');"">" & "<option></option>"

Sql = "Select * From Players Where  Position='Goalie' And TeamID =" & strFinalTeamID & " Order by name"

Set RsPlayerSelect = objConn.Execute(Sql)

Do Until RsPlayerSelect.EOF
	Response.Write "<option value=" & RsPlayerSelect("PlayerID") & ">" & RsPlayerSelect("Name") & "</option>"	
	RsPlayerSelect.MoveNext
Loop

Response.Write "</select>"

RsPlayerSelect.Close
Set RsPlayerSelect = Nothing

And The form Data on the ASP page

jpmoriarty

okay i need you to post everything: if that is everything, then you'll need:

a <form> tag:

ie <form action="phppage.php" method="POST">
a submit button <input type="submit" value="Send this!">
a closing form tag </form>
etc etc

Note that if your action is POST, then your php page should have $POST (and similarly for get and $GET)

Also check when your asp page runs that it's generating the HTML hidden input line properly (ie is actually putting in the value that you want).

Also, can i ask why you're using echo, print and printf all in the same script? I think they can all be echo's...

Sapper

Shall I send the files it's easier because they are pretty big and I havent put the entire file up as the forum probably won't allow it.

I have just copied the layout from a diff page thats why its using all the different commands I will change it when it finally gets the TeamID from the asp page.

I know that it is passing on the session between asp pages because it works from the login page throughout the site and is only pulling the relevant information for each user.

So the error has to be in the php.

jpmoriarty

you can send them if you want - my email is on myprofile.

Can i ask what your method is for the form?

Sapper

Yes it is post and I think I just sussed the problem.

2 secs while I check it.

Sapper

Ok I have sorted it out it works with the $POST method but how do I get it to work with the $Get method because I don't want a button on it, a link is fine but not a grey button :-( or is there a way to get it to auto submit to the php page???

Last question then I will stop bugging you :-)

Thanks for your help anyway its valued...

jpmoriarty

the $GET (NOT $Get!!!!!) will work if you do something like a meta refresh to a url like:

or a simple link

you have to append it to the end of your url for the $GET to work (just as you have to POST the data to the page for the $POST to work). If you dont want the standard button then you can do something like an image and have it as your sumbit button, in the same way they do on this site (notice the go button by the forum jump, which has the code
```
<input type="image" src="images/go.gif" border="0" 
align="absbottom">
```
)