Copying a Field from one table to another

astralweeks

I am using the following:
<TD><a href=\apply.php?job_title=$job_title\"> I want the field called job_title from Table A to be stored in the Field JOBTITLE in Table B. apply.php asks for user input for all field to be posted to Table B, except for the Job Title which needs to be filled in from the value from Table A carried over by the above statement.

I tried:

$JOBTITLE = $_GET[job_title];

and INSERTING a VALUE for JOBTITLE using '$_GET[job_title]'

no errors but the latter simply inserts the text: $job_title\"

Help is appreciated.

astralweeks

I have determined that I may need that value carried over to an HTML form. Is that possible ?

laserlight

Um, try to give the code snippet properly.

Use $_GET['job_title'] instead.

astralweeks

I didn't do a good job of describing what I am trying to do, so I will post a new thread. Thanx

Davy

Change this

Originally posted by astralweeks
<a href=\apply.php?job_title=$job_title\">

to this:

echo "<a href=\apply.php?job_title='";
echo $job_title;
echo "\'>"

Oh yeah and rename that page you're referring to as .php because anything in a .HTML page wetehr it's valid PHP syntax or not, will not get processed as php on the server unless the page ext is *.php .

I have suggested the above changes because even if you change the extension of the file, it will still show the variable name instead of carrying the actual variable VALUE over because
a) You haven't assigned this text or any thing in side of it to be PHP
b) You type the variable name $job_title which is basically outputting as a normal string. You must seperate the text which is string and that which is meant to be a variable value such as :

"Hello ".$name

will work over

Hello $name

Or at least it does on my cranky IE6 browser