What is the use of the MYSQL_BOTH in the code?

Asked By chillz18 0 points N/A Posted on - 03/19/2013

For example from this code if($count>0){

if($count>0){

while($row=mysql_fetch_array($result,MYSQL_BOTH)){

$username=$row['username']; $user_id=$row['user_id'];

$query5 ="UPDATE message SET status='read' WHERE user='$userdata'";

$result5=mysql_query($query5,$link) or die("Error". mysql_error());

 

$query1="select * from message Where user='$user_id' ORDER BY date DESC, time DESC";

$result1=mysql_query($query1,$link) or die ("Error". mysql_error());

$count1=mysql_num_rows($result1);

• Status: Open
• Question Views: 2391
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PHP

Answered By Joseph S Peterson 35 points N/A #177669

What is the use of the MYSQL_BOTH in the code?

Hi Chillz18,

When mysql_fetch_array() is used, it fetches the result row as an associative or numeric array.You can choose to fetch both associative and numeric array by using the MYSQL_BOTH type. To fetch only the associative array, you can use MYSQL_ASSOC.To fetch only the numeric array you can use MYSQL_NUM.

Here using MYSQL_BOTH you can access both the fields in the column, the username and user id.

Regards,

About Joseph S Peterson

Questions
19

Answers
101

Best Answers
13

• Vote Up 0 Vote Down

• Posted on - 04/06/2013
• Question Category: PHP