Using 2 LIKE variables

droms

Hi there, I was hoping to use 2 LIKE variables to one: Order my results by category and 2 order my results by letter.. It appears I am unable to run 2 at once.. Can someone let me know what they think i'm doing wrong here?

<?
if ($id == "") {
$sql="SELECT * FROM roms WHERE category LIKE '" . $_GET["category"] . "%' ORDER BY link ASC";
$result=mysql_query($sql);
$ncount=0;
echo "<font size=1> </font>";
while ($myrow=mysql_fetch_array($result)) {
if ($ncount<100)
{
$ncount=$ncount+1;
$newsbody = str_replace("\'", "'", $newsbody);
?>

Thanks a lot!
Andy

Weedpacket

And where are you trying to order by category?
PS:

echo "<font size=1> </font>";

is a hanging offence in some jurisdictions.

Weedpacket

And where are you trying to order by category (are you asking for "order by link, category")?
PS:

echo "<font size=1> </font>";

is a hanging offence in some jurisdictions.

NogDog

Is this what you mean?

$sql="SELECT * FROM roms WHERE category LIKE '" . $_GET["category"] . "%' ORDER BY category ASC, link ASC";

droms

Hey! It was more so I could select it as follows : files.php?category=SYSTEM&letter=A

Does that make sense?
Thanks,
Andy

NogDog

I'm still guessing, as it's hard to read your mind this early in the morning in order to understand your database structure 😉 :

$sql = "SELECT * FROM roms WHERE category LIKE '{$_GET['category']}%' AND link LIKE '{$_GET['letter']}%' ORDER BY category, link";