mysql_fetch_array not working for 1 row query result

Question

My query works fine. but wen trying get unique value from the table mysql fetch array not work.

this is my sql A-2815 is the item code of the vehicle. this field is unique. Expecting result is item_code A-2815 's vehicle details.

$sql  = "SELECT vehicle.id, item_code, make, model, vehicle_type, color, showroom_id, "; 
$sql .= "adding_user_Id, approved, image_1 ";
$sql .= "FROM  images,  vehicle ";
$sql .= "WHERE vehicle.id=images.item_id ";
$sql .= "AND (item_code LIKE '%A-2815%' ";
$sql .= "OR  make LIKE '%A-2815%' ";
$sql .= "OR model LIKE '%A-2815%' ";
$sql .= "OR vehicle_type LIKE '%A-2815%' ";
$sql .= "OR color LIKE '%A-2815%' ";
$sql .= "OR showroom_id LIKE '%A-2815%') "; 
$sql .= "AND activate=1 ";
$sql .= "AND type_of_image=1 ";

this is my php code.

<?php
      $query = mysql_query($sql);
      while($result = mysql_fetch_array($query)){
           echo $result['item_code'];
           echo $result['make'];
           echo $result['model'];
           echo $result['vehicle_type'];
           echo $result['color'];
           echo $result['showroom_id'];
      }
 ?>

this working ok when results are more then 1 row. but problem is when result is 1 row then it is not working.

Can you provide the result of single record which is not displaying — Vineet1982
– Vineet1982, Commented Feb 26, 2013 at 6:26
The 'mysql' extension is deprecated it seems as of 5.5.0? See the PHP.net Manual Page for more details. — David 'the bald ginger'
– David 'the bald ginger', Commented Feb 26, 2013 at 6:38
You could also use heredoc to build your Query. It would remove the repetitive step to keep adding a new string to an existing variable. — David 'the bald ginger'
– David 'the bald ginger', Commented Feb 26, 2013 at 6:45
I have wacking my brain out to resolve this problem, but nothing helped me. Have anyone solution or any idea why is this happening? — supermus
– supermus, Commented Aug 4, 2013 at 0:33

Madan Sapkota · Accepted Answer · 2013-02-26 06:52:06Z

3

while ($result = mysql_fetch_array($query, MYSQL_ASSOC)) {

    // assoc
    echo $result['item_code'];
}

MySQLi solution for this

$connect = mysqli_connect('localhost', 'root', 'pwd', 'dbname');

$sql = "select * from sometable";

$query = mysqli_query($connect, $sql);

while ($result = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
    // assoc
    echo $result['item_code'];
}

edited Feb 26, 2013 at 6:52

answered Feb 26, 2013 at 6:28

Madan Sapkota

26.2k11 gold badges116 silver badges118 bronze badges

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

1 Comment

David 'the bald ginger' Over a year ago

Is 'MYSQL_BOTH' not the default for mysql_fetch_array()?

Collectives™ on Stack Overflow

mysql_fetch_array not working for 1 row query result

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