How to add two sql rows to a php array

Question

I want to add two values from two rows to an array. One is a path and the other is a tag. I'm then encoding the array. So I can display the image and then I'm going to using the tags to order the new javascript array dynamically. I would like "echo $data;" to say something like [{path, tag}, {path, tag}]

<?php

include("mysqlconnect.php");

$select_query = "SELECT `ImagesPath`,`Tag` FROM `offerstbl` ORDER by `ImagesId` DESC";
$sql = mysql_query($select_query) or die(mysql_error());   
$data = array();
while($rows = mysql_fetch_array($sql,MYSQL_BOTH)){
$data[] = $rows['ImagesPath']['Tag'];
}
echo json_encode($data);
echo $data[0];
?>

["h","h","h","h","h"] for the full echo and h for the single one. This makes no sense to me. h doesn't represent anything in the database — James121
– James121, Commented Aug 27, 2014 at 14:35

Gabe Spradlin · Accepted Answer · 2014-08-27 14:53:14Z

1

I'm going to guess that "h" is the first character in the ImagePath string that is being returned from $rows['ImagesPath']['Tag']. I'm guessing that $rows['ImagePath'] is a string and you've asked for the ['Tag'] key within that string. Which isn't found for obvious reasons and the first character is then returned.

Since ImagePath and Tag are separate columns in the table you can't access both simultaneously. If you want the output to be [{path, tag}, {path, tag}] then you will need to change:

$data[] = $rows['ImagesPath']['Tag'];

to

$data[] = array($rows['ImagesPath'], $rows['Tag']);

answered Aug 27, 2014 at 14:53

Gabe Spradlin

2,0674 gold badges25 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

How to add two sql rows to a php array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related