Check value in array returned by mysql_fetch_row in PHP

Question

Hello i am new at php.

$res=mysql_query('SELECT `order` FROM `competitions`');
    $row=mysql_fetch_row($res);

    if($row[order] == "1")
            {
            $res=mysql_query('SELECT `name`, `persp`, `teamp` FROM      `competitions_rank` WHERE `comp_id` = '.$_PARAMS[0].' ORDER BY `persp` DESC');
            }
    else
            {
            $res=mysql_query('SELECT `name`, `persp`, `teamp` FROM `competitions_rank` WHERE `comp_id` = '.$_PARAMS[0].' ORDER BY `teamp` DESC');
            }

In the database the possible values of the field is null, 1 or 2 .The code always enter in else statement. What i do wrong ? How i should check value in array returned by mysql_fetch_row ?

Madara's Ghost · Accepted Answer · 2011-08-01 12:08:53Z

1

Well, first of all, you shouldn't use mysql_* functions. They're (unofficially) deprecated and not recommended for further use. Second, use $row["order"] and not $row[order] as there is no such thing as order in PHP.

Also, mysql_fetch_row returns the row as a numeric array, and not associative. if you insist on using mysql_, use mysql_fetch_assoc().

In addition to that, that entire statement should be inside a while loop because there could be more then one line that you are missing. If you want to make sure you only have 1 line, add LIMIT 1 to the end of your SQL query.

answered Aug 1, 2011 at 12:08

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

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

2 Comments

Grigori Rangelov Over a year ago

This isnt working either. What is the alternative of mysql* functions ?

Madara's Ghost Over a year ago

@Grigori Rangelov Like I said, you shouldn't use mysql_* consider rewriting your database coding style to PDO or at least to mysqli. It would help you with later projects as well!

Haim Evgi · Accepted Answer · 2011-08-01 12:13:36Z

1

this mysql_fetch_row function, Returns a numerical array that corresponds to the fetched row and moves the internal data pointer ahead.

so in your example you need to check it like :

if ($row[0] == "1")

edited Aug 1, 2011 at 12:13

answered Aug 1, 2011 at 12:07

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Comments

Adriano Carneiro · Accepted Answer · 2011-08-01 18:16:03Z

1

I think problem is in mysql_fetch_row()... mysql_fetch_row — Get a result row as an enumerated array.

USE

mysql_fetch_array()

then

use $row['order']

edited Aug 1, 2011 at 18:16

Adriano Carneiro

58.8k12 gold badges94 silver badges123 bronze badges

answered Aug 1, 2011 at 12:09

Poonam Bhatt

10.4k16 gold badges56 silver badges73 bronze badges

Comments

Adriano Carneiro · Accepted Answer · 2011-08-01 18:12:41Z

0

I'm not quite sure what you're asking but could you update your sql query to

$res=mysql_query('SELECT `order` FROM `competitions ORDER BY order`');

Failing that you need to change

if($row[ 'order' ] == "1")

edited Aug 1, 2011 at 18:12

Adriano Carneiro

58.8k12 gold badges94 silver badges123 bronze badges

answered Aug 1, 2011 at 12:09

CBusBus

2,3672 gold badges18 silver badges28 bronze badges

Collectives™ on Stack Overflow

Check value in array returned by mysql_fetch_row in PHP

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related