[Resolved] SELECT command issues

Mr_Mako

Hi...

I'm trying to select only specific records out of a table, and I'm having some difficulties with my syntax.

This is what I'm trying to do:

$sql = "SELECT * FROM table WHERE enable > 0 AND name == BOB ASC";

... or something like that... I need to have it select both the "enable" and the "bob" and then order by Ascending.

I keep getting a "You have an error in your sql syntax" when I try this.

LordShryku

With SQL, it's just =, not ==. Then you also need to quote your literals(non numeric/dates). Also the order by needs to have a field to order by.

$sql = "SELECT * 
          FROM table 
         WHERE enable > 0 
           AND name = 'BOB' 
      ORDER BY somefield ASC";

Mr_Mako

Awesome... thanks. I figured it out just before you replied... and then realized my ASC cmd was incorrect, and you solved that.

Thanks!

Mr_Mako

Argh... I spoke too soon.

I'm now having trouble getting only the results with "BOB" in the name field.

$sql = SELECT * FROM table WHERE enable > 0 AND name = 'Bob' ORDER BY name ASC";
$result = @mysql_query($sql, $connect) or die(mysql_error());

while ($row = mysql_fetch_array($result)) {
     $name = $row['name'];
     $email = $row['email'];
     $address = $row['address'];

 $display_block = "
      <font color=black size=2>$name, $address ($email)</font>";
}

I have this and instead of just "bob" I get the entire list of people in my table. I've obviously missed something, and I'm not sure where.