Hi, thanks for replying.
Yes, it's the second join that's giving me problems. In the first iteration, I did try to call the storeURL as I did everything else, namely:
function show_menu() {
foreach ($this->records as $store) {
echo "<tr>";
print(
"<td>".$store['Title']."</td>".
"<td>".$store['brand']."</td>".
"<td>".$store['storeName']."</td>".
"<td>".$store['price']."</td>".
"<td>".$store['storeURL']."</td>"
);
echo "</tr>\n";
}
echo "</table>\n";
}
(After having changed the value to 1 in the previous portion of code)
I thought that would work (initially), and it does output results, but doesn't appear to pick up the value for the storeURL... in other words, it prints out all of the rows but the cell for storeURL is always blank.
I can't help but think it has something to do with the fact that the storeURL is a dropdown, and that (for a reason I can't for the life of me figure out) is why it's returning blank values when I try to call it as I've called everything else.
The XML looks like this:
- <result>
<Title>A Sample Title</Title>
<storeName>Safeway</storeName>
<price>75</price>
- <storeURL>
http://www.safeway.com/
</storeURL>
<brand>Generic Brand</brand>
</result>
I think if it looked like this:
- <result>
<Title>A Sample Title</Title>
<storeName>Safeway</storeName>
<price>75</price>
- <storeURL>
<storeURL2>http://www.safeway.com/</storeURL2>
</storeURL>
<brand>Generic Brand</brand>
</result>
Then I could call it like everything else, but since the http:// part isn't stored within a tag that isn't collapsible, it doesn't work. But, I can't figure out why it won't work, or what I'd need to change. Or maybe I'm way off?
Can anyone shed some light? I'm really at a loss here... 😕