select name = $ symbol?

[Monkuar]

$query = "LOWER(name)="$tabB";

 

on my forums, speakwhatsreal.com

 

new message page, let's say somone on my site has the name "$tabB" how do i make the above query work so it selects a username with the $ symbol in it?

 

 

 

because with that query it's linked to

 

 

 

 

 $DB->query("SELECT name, id, mgroup, language, email FROM ibf_members WHERE ".$query);
         $to_member = $DB->fetch_row();

         if (empty($to_member['id']))
         {
             $this->send_form(0, $ibforums->lang['err_no_such_member']);
             return;
         }

 

pretty much says no results.. lol

 

any help?

[Pikachu2000]

You'd need to escape the $ with a backslash, but something tells me there's another reason this isn't going to work.

[scootstah]

Use single quotes.

$query = 'LOWER(name)="$tabB"';

[Monkuar]

$ibforums->input['to'] = str_replace("$", "\$", $ibforums->input['to']);

 

I FIXED IT!!

 

YES

 

Thanks!!!

 

Topic Resolved!!