[GG Dart]

hi
i made a php script with a activation link. but i can't get the variable to show when the link gets sent via email.
the hole thing works so:
1. user puts in data
2. data gets writen in database setting $acountactiv to NULL
3. user gets email with activations link to set $acountactivation to yes

now the problem:

<?php
include("config.php");
$abfrage = mysql_query ("FETCH idx FROM login WHERE userx = '$userx'");
$subjekt = "account activation";
$message = "Your activations link is:
http://blabla.com/activ.php?idx=$idx&accoutactiv=yes";
$from = "xxx";
$from1 = "xxx";
mail($email, $subjekt, $message, "From: $from <$from1>");
?>

email comes this way:
Your activations link is:
http://blabla.com/activ.php?idx=&accoutactiv=yes

but it should come:
Your activations link is:
http://blabla.com/activ.php?idx=$idx=123(or whatever)&accoutactiv=yes

i tried SELECT for FETCH
$userx is declared further up in the script

Have i to change the $message = "......." syntax ?

[mdhall]

I think you need a bit more added after your query, befire you start your mail functions.

PHP Code:

connect to database...
$abfrage = mysql_query ("SELECT idx FROM login WHERE userx = '$userx'");
$result=mysql_query($query);
$num = mysql_num_rows($result);
if(mysql_num_rows($result) == 0){ 
        echo("No Results"); 
    } 
  else
   {
while($row = mysql_fetch_array($result))
{
$idx = $row[idx];
echo '$idx';
}
If you result is displayed, add your mail functions here and test it.
} 

I havent tested this, but give it a try and see what happens.

[dawson_davis]

I have had some problems in the past with variables being properly passed into strings. I'm not sure what caused it, but I do know what fixed it.

PHP Code:

$add = "with";

$string  = "This is a string " .$add. " extra stuff added";

echo $string;

//will be displayed as 

//This is a string with extra stuff added.