Problem with query and php variable

Question

Hello I have the following php script

$db =& JFactory::getDBO();
$sql = "select uid from #__zcalendar_events where article_id = " . $article->id;
$db->setQuery($sql);
$results = $db->loadObjectList();
    if(count($results)) {
        foreach($results as $r => $value) {
            $sql = "select catid from #__zcalendar_event_categories where uid = " . $r->field1;
        print_r($results);
        print_r($sql);

My problem start in this line:

$sql = "select catid from #__zcalendar_event_categories where uid = " . $r->field1;

the . $r->field1; does not add the value to the string $sql.

But if I print_r($results); I get the this information:

Array ( [0] => stdClass Object ( [uid] => [email protected] ) )

And I need just this: [email protected]

and . $r->field1; have to had this information but it's always empty.

Can someone please help me to solve this problem, because I have the information. But never works.

Also, you have 7 questions and you've not accepted any of them. You might want to work on that. — Jonnix
– Jonnix, Commented Sep 19, 2011 at 13:58

Alex Hadley · Accepted Answer · 2011-09-19 14:37:58Z

1

A foreach is usually like this:

foreach($array as $key => $element)

Are you sure you want to be using the $r not the $value?

edited Sep 19, 2011 at 14:37

answered Sep 19, 2011 at 13:50

Alex Hadley

2,1252 gold badges28 silver badges50 bronze badges

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

6 Comments

vstm Over a year ago

+1 - and the other mistake was to use $value->field1 but there is no field1 instead he should write $value->uid

Jean Over a year ago

Yes I want the uid, but I don't know how to get it.

Alex Hadley Over a year ago

So does $value->uid give you [email protected]?

Alex Hadley Over a year ago

You're very welcome. Please mark an answer as correct or up if it helped you out.

Jean Over a year ago

Hey I have another proble, the value that I get goes to this link $link = "option=com_zcalendar&vmode=e&view=".$eventview."event&format=html&tmode=m&eid=$eid"; in the .$eventview. but I get this empty but it have the value. Can you help me with this, too???

|

Collectives™ on Stack Overflow

Problem with query and php variable

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related