[SOLVED] Get my Location!

[Bullet]

    <th class="TableArea" scope="row"><div align="center"><? print"<a href='profile.php?viewuser=$buttock->target'>$buttock->target</a>"; ?></div></th>

    <td class="TableArea"><div align="center"><? print"".maketime($buttock->stime).""; ?>

  <?

$f_query222=mysql_query("SELECT location FROM users WHERE username='$s_query->target'");

$gett=mysql_fetch_object($f_query222);

 

if($buttock->status == Success){

echo "Success, found in $gett->location.";

}elseif($buttock->status == Pending){

echo "- Search pending.";

}elseif($buttock->status == Failed){

echo "Search failed.";

}

?></div></td>

 

But it won't get the location when it's a success, anyone know why?

[trq]

Assuming Success, Pending and Failed are meant to be strings they need be surrounded in quotes. eg;

 

if($buttock->status == 'Success') {

 

besides that, how do you know your query is working? Youy fail to check.

[Bullet]

Makes no difference

 

I've changed the query though to: $f_query222=mysql_query("SELECT location FROM users WHERE username='$buttock->target'");

 

[trq]

Your query is likely failing, you need to check it succeeds prior to using anything it might return.

 

<?php

if ($f_query222 = mysql_query("SELECT location FROM users WHERE username='{$buttock->target}'")) {
  if (mysql_num_rows($f_query222)) {
    $gett = mysql_fetch_object($f_query222);
    if ($buttock->status == 'Success') {
      echo "Success, found in $gett->location.";
    } elseif ($buttock->status == 'Pending') {
      echo "- Search pending.";
    } else {
      echo "Search failed.";
    }
  } else {
    echo "Search failed.";
  }
} else {
  echo "Query failed<br />" . mysql_error();
}

?>

 

ps: Complex variables ought be surrounded by curly braces when within strings.

[Bullet]

Thanks so much!