PHP Mysql query help

[fighnight]

Ok I am I creating a mysql query with the "like" addition and need help with blocking some features

 

Example is use

 

/changeroster.php?sort=s

 

it shows everything including Shiny's,Shadow's

 

how can I block that

 

$cgstarer= mysql_query("SELECT * FROM username WHERE username like '$sort%' and owner='$u_info[id]'  ORDER BY username ASC LIMIT $limitvalue, $limit");

 

/changeroster.php?sort=%

 

it shows all the users how can I block or change that

 

[Ken2k7]

I don't understand what you mean by "block."

[fighnight]

Like changing it from % to some other letter

[Ken2k7]

What are you trying to do?

 

/changeroster.php?sort=s

 

So what should that return? All names that start with the letter s?

[fighnight]

What are you trying to do?

 

/changeroster.php?sort=s

 

So what should that return? All names that start with the letter s?

 

It supposed to return everything except shinyies and shadow

[twostars]

<?php
$replace_to = $null;
$sort = str_replace('%', $replace_to, $_GET['sort']);
?>

 

Then just use $sort

 

Change $replace_to as you please. Was only there to show you that you can change it. lol

[fighnight]

<?php
$replace_to = $null;
$sort = str_replace('%', $replace_to, $_GET['sort']);
?>

 

Then just use $sort

 

Change $replace_to as you please. Was only there to show you that you can change it. lol

Thank you!

[twostars]

<?php
$replace_to = $null;
$sort = str_replace('%', $replace_to, $_GET['sort']);
?>

 

Then just use $sort

 

Change $replace_to as you please. Was only there to show you that you can change it. lol

Thank you!

No problem.

 

If your problem is now solved, please click the "Solved" button.

[fighnight]

Still need to find out the other question.

[revraz]

% is a wildcard, if you don't want to use it then don't.

[twostars]

/changeroster.php?sort=s

 

it shows everything including Shiny's,Shadow's

 

how can I block that

 

Of course it is.

You're specifying to find *a string* + s.

Its only logical that it will be returning Shiny's and Shadow's.

 

Maybe you should tell us what your script is for exactly, so we can determine a better query.

[Hypnos]

I can only guess that the poster is trying to do one of two things...

 

1. Trying to block ambiguous searches that basicly show every result.

 

2. Trying to make a search for "s" match only " s ".

 

 

I'm strongly guessing it's the first case. If it is, you should set a minimum amount of characters required for your search. Like 3.