Cant pass a var along..

Litninfingers63

I have NO idea what is wrong.

I'm a PHP n00b and I'm trying to have a user click a drop down menue and choose a client. Then they hit "edit" and it takes them to editprofile.php?CID=[insert the correct ID here]. That's all I'm trying to do.

I had it so it was working, but it would only bass editprofile.php?CID=1 for any choice.

Here is my code for the index page:

<form name="edit" method="post" action="editprofile.php?CID=<?php echo $CID; ?>">
<p>EDIT EXISTING ACCOUNT<br>
<select name="editclient" id="editclient" MM_jumpMenu('parent',this,0)>
  <?php

$query = mysql_query("SELECT * FROM clients ORDER BY CNAME");
$n = mysql_num_rows($query);

$x = 0;

while( $n > $x){
            $row = mysql_fetch_array($query);

$CNAME  = $row['CNAME'];
$CID = $row['CID'];

echo "<option value=\"$CID\">$CNAME</option>";

$x++;
}

?>

  </select> 
  <input name="edit" type="submit" id="edit" value="Edit">
  </form>

Now, I know there is no variable defined for the first $CID at the top... but I don't know how to define it. I know it's a simple task, but I dont get how.

Any help?

Also, I'm confused as to what to put in the

echo "<option value=\"$CID\">$CNAME</option>"

part... For the value, I mean.

mykg4orce

I assume global vars is off on your server.

the name of your menu is "editclient."

So to get the value from it, do this on the edit page:

echo $_POST['editclient'];

this will get you the value that the user selects from the menu.

Litninfingers63

Originally posted by mykg4orce
I assume global vars is off on your server.

the name of your menu is "editclient."

So to get the value from it, do this on the edit page:

echo $_POST['editclient'];

this will get you the value that the user selects from the menu.

I'm not sure I follow.

Does this help with actually defining the variable before the calling of it on the index.php?

LordShryku

I'm curious as to how you're passing it through the URL when using a method of "post"...

Litninfingers63

Well, I've never passed a variable through a form, so I really don't know how. heh.

What should the method be?

LordShryku

If you want to have it go through the URL, use the "get" method.

Litninfingers63

On the first page, I'd use that, too?

Then it'd work on the second page, even though it's not "posting" the form? Hmm. I'm too new to understand 😉 I'll try doing it though.

Weedpacket

Originally posted by Litninfingers63
On the first page, I'd use that, too?

Then it'd work on the second page, even though it's not "posting" the form? Hmm. I'm too new to understand 😉 I'll try doing it though.

If you've got a form variable that's being passed through the URL - named 'foo' in the form, so that it appears in the URL as "foo=something", then its value will be available on the next page as $_GET['foo'].

There is a section on this subject in the Newbies' Forum FAQ. I'll recommend that you, as a newbie, have a look at that.

Litninfingers63

Originally posted by Weedpacket
If you've got a form variable that's being passed through the URL - named 'foo' in the form, so that it appears in the URL as "foo=something", then its value will be available on the next page as $_GET['foo'].

There is a section on this subject in the Newbies' Forum FAQ. I'll recommend that you, as a newbie, have a look at that.

in the next page I do have that code, thuogh. THat's why I'm confused as to why it's not working.

<?php

$CID = $_GET['CID'];
//This is the other part - EDIT //

$tCID  = $_POST['CID'];
$tCPASS = $_POST['CPASS'];
$tCNAME = $_POST['CNAME'];
$tJTYPE = $_POST['JTYPE'];
$tJDESC = $_POST['JDESC'];
$tsubmit = $_POST['submit'];

$query = mysql_query("SELECT * FROM clients WHERE CID = '$CID'");
	$row = mysql_fetch_array($query);


$CPASS = $row['CPASS'];
$CNAME = $row['CNAME'];
$JTYPE = $row['JTYPE'];
$JDESC = $row['JDESC'];
$submit = $row['submit'];

if( isset( $submit ) ){

	$upPASS = "UPDATE clients SET CPASS='$tCPASS' WHERE CID='$CID'";
	$upNAME = "UPDATE clients SET CNAME='$tCNAME' WHERE CID='$CID'";
	$upTYPE = "UPDATE clients SET JTYPE='$tJTYPE' WHERE CID='$CID'";
	$upDESC = "UPDATE clients SET $JDESC='$tJDESC' WHERE CID='$CID'";

	mysql_query($upPASS);
	mysql_query($upNAME);
	mysql_query($upTYPE);
	mysql_query($upDESC);


echo "Thank you";
}

?>

Then the form comes up to edit..

This is an edit profile page, so it is going to first pull the CID from the form on the previous page (the first post in this thread), then it should pull the information from the database and load it into the form, then the rest is for whe you hit submit and edit the feilds.

What am I doing wrong?