how should i get ONE row from mysql? ( fetch_array etc? )

Question

I'm pretty sure i'm doing an extra loop here:

    $q = "SELECT * FROM genres WHERE genre.g_url = '$genre_url' LIMIT 1";   
    $res = mysql_query($q);
    while ($r = mysql_fetch_array($res, MYSQL_ASSOC)){
        foreach( array_keys($r) as $k ){
            $g[$k] = $r[$k];
        }
    }
    return $g;

Progman · Accepted Answer · 2010-05-01 10:55:48Z

3

$q = "SELECT
          columns,
          you,
          want,
          to,
          read
      FROM
          genres
      WHERE
          genre.g_url = '".mysql_real_escape_string($genre_url)."'
      LIMIT 1";
$result = mysql_query($q) or die(mysql_error());
return mysql_fetch_assoc($result);

If there is no row in the database this will return false, otherwise the data of the row. And don't forget to escape user inputs...

answered May 1, 2010 at 10:55

Progman

20.1k7 gold badges58 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

outis Over a year ago

Except that or die(...) is almost certainly the wrong thing to do (phpfreaks.com/blog/or-die-must-die), and outputting the result of mysql_error discloses too much information (msdn.microsoft.com/en-us/library/…).

Collectives™ on Stack Overflow

how should i get ONE row from mysql? ( fetch_array etc? )

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related