What is the output of the following code? (Assume users table contain data)

[solematejass]

Hi all i am new to this stuff, got one query if possible please explain.

 

mysql_connect("localhost","mysql_username","mysql_password");

 

mysql_select_db("testdb");

 

$result = mysql_query("SELECT id, name FROM users");

 

while ($row = mysql_fetch_array($result, MYSQL_NUM))

 

{

    echo $row['id'],$row[1];

}

 

mysql_free_result($result);

[Pikachu2000]

What do you mean 'what is the output'? It should output the id field and name field. Why, what output do you get when you run it?

[PFMaBiSmAd]

Sounds like a job interview quiz.

 

Depending on your error_reporting and display_errors settings, you will either get a bunch of undefined index messages (for $row['id']) followed by the name values or you will get only the name values.

[Pikachu2000]

Oops. Overlooked the MYSQL_NUM parameter there. Pity if it cost someone a job they obviously aren't qualified for.