Using mysql_fetch_array to retrieve a field value

Question

I'm using the following PHP code to retrieve a name from a table matching an ID:

$qry = "SELECT league_name FROM Leagues where league_id = '".$_SESSION['SESS_LEAGUE_ID']."'";
$row = mysql_fetch_array($qry);
$leaguename = $row['league_name'];

I know that SESS_LEAGUE_ID is correct as I can output it to a variable and see it, however when I try and grab the name that matches the ID from the table Leagues I get nothing back.

$leaguename is always blank. I've checked the database and there should definitely be some text returned. The league_name field is a varchar type.

I know it's something simple that I'm not doing but I can't think what!

Please do not use mysql* functions in new code, it is deprecated. Try using PDO instead. — zajd
– zajd, Commented Mar 29, 2013 at 19:14
Thanks for the advice on mysql. I'll read up on mysqli and PDO and try to implement them on my site as an alternative :-) — Chris
– Chris, Commented Mar 29, 2013 at 19:23
If I do a replace on 'mysql' for 'mysqli' using CTRL+F are there any functions that might stop working? — Chris
– Chris, Commented Mar 29, 2013 at 19:25

Kermit · Accepted Answer · 2013-03-29 19:13:42Z

4

You need to execute the statement

$result = mysql_query($qry);
$row = mysql_fetch_array($result);

Stop using mysql_ functions. They are no longer maintained and are officially deprecated. Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which.

answered Mar 29, 2013 at 19:13

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

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

1 Comment

Chris Over a year ago

Perfect! Works as intended. Thanks for the quick response.

Collectives™ on Stack Overflow

Using mysql_fetch_array to retrieve a field value

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related