(( Ugh! I'm having a big problem with variables ))

[evenstar7139]

Oh, I'm all frustrated! I put a string in my database like this: $callName looks very happy that you've given it the $toy and when I retrieve it in a PHP page and echo it, it doesn't evaluate the darn variables. It just prints it like this: $callName looks very happy that you've given it the $toy How do I get it to evaluate the variables.

[gesf]

I guess you´re making something like:

<?php

echo '$callName looks very happy that you've given it the $toy';

?>

Right !?
Try this:

<?php

echo $callName . ' looks very happy that you've given it the ' . $toy;

?>

[evenstar7139]

No, no. Here is what I'm trying to do.

The variables, first, are defined, then the string is pulled from the database, then I put it in a varaible and echo it. And it just print the variable name, and not the value in the variable.

$item=horses;
$callName=Roonie;

if 
($item == horses 
OR $item == sheep 
OR $item == asdfsdafd)
 {
   $requestFrom=itemEndingPlur;
   $plur=yes;
   print $plur;
  }

$linkID=mysql_connect(xxxxx,xxxx,xxxx);
mysql_select_db(users, $linkID);

$result=mysql_query("SELECT message FROM socialize WHERE name='$requestFrom'");
$message=mysql_result($result, socialize);
print $message;

You see, what I want to do, is put a string in a database with variables in it, and have it so when I print the string, it puts the value int he variables, not the variable names.

[Xnuiem]

I am kinda unclear about what you are actually attempting, but there are several errors in that code.


Use quotes around strings in your declarations
Drop the OR's they are much slower than ||
The resource link ID is not required if you only have a single connection open.
The second argument in mysql_result is a row number, not a string (http://www.php.net/mysql_result

So, with that said, lets clean it up a little bit and try again, maybe it will work with some of the errors removed.

$item = "horses";
$callName = "Roonie";
$checkItem = array("horses", "sheep", "asdfsdafd");

if (in_array($item, $checkItem)){
 Â* Â*$requestFrom = "itemEndingPlur";
 Â* Â*$plur = "yes";
 Â* Â*print($plur);
}

mysql_connect(xxxxx,xxxx,xxxx);
mysql_select_db(users);

$result=mysql_query("SELECT message FROM socialize WHERE name = '$requestFrom'");
$message = mysql_result($result, 0);
print($message);

[gesf]

That´s it !