On Fri, Dec 12, 2008 at 4:52 PM, Terion Miller <webdev.ter...@gmail.com>wrote:
>
>
> On Fri, Dec 12, 2008 at 4:02 PM, Daniel P. Brown <
> daniel.br...@parasane.net> wrote:
>
>> On Fri, Dec 12, 2008 at 16:54, Terion Miller <webdev.ter...@gmail.com>
>> wrote:
>> >
>> > $query = "SELECT * FROM importimages WHERE Category='Obits' ";
>> > $result = mysql_query ($query);
>> >
>> > $arr = mysql_fetch_row($result);
>> > $result2 = $arr[0];
>> > echo ($result2);
>>
>> Try this to get yourself started:
>>
>> <?php
>> $sql = "SELECT * FROM `importimages` WHERE `Category` = 'Obits'";
>> $result = mysql_query($sql) or die("Error in ".__FILE__.":".__LINE__."well
>> I changed it to
>> - ".mysql_error());
>> while($row = mysql_fetch_array($result)) {
>> foreach($row as $k => $v) {
>> echo stripslashes($k).": ".stripslashes($v)."<br />\n";
>> }
>> }
>> ?>
>>
>> NOTE: You shouldn't need stripslashes(), but it's put there just
>> for backwards-compatibility in case you're on an older (or
>> poorly-configured) installation.
>>
>> --
>> </Daniel P. Brown>
>> http://www.parasane.net/
>> daniel.br...@parasane.net || danbr...@php.net
>> 50% Off Hosting! http://www.pilotpig.net/specials.php
>>
>
> Thanks Daniel that did get me further, am I now to build an object from the
> array, or take off one of the array to make an object, your snippet did grab
> the names of the images and print them to the page but then I get stuck
> where the page is trying to "get the property of a non-object" ..so I guess
> i"m asking is a possible to turn an array into an object? or in this case
> separate objects?
>
Well I did some changes and I must be learning because although I have the
same error I don't have new ones...
so now the code is like this:
$sql = "SELECT * FROM `importimages` WHERE `Category` = 'Obits'";
$result = mysql_query($sql) or die("Error in ".__FILE__.":".__LINE__."
- ".mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k => $v) {
echo stripslashes($k).": ".stripslashes($v)."<br />\n";
}
}
$FileName = $object->Image; <-------This is the line that is telling
me it is "trying to get the properties of a non-object....
