PHP Help

THS · 2012-03-07 20:14:09

Sorry to ask this here. PHP is not my primary language (Flex,AS,CF), so I have hit a bit of a stumbling block. I have it narrowed down to the query row. I know the query works, but the count of $videos is returning 0 so I don't get output. I am unsure of how to fully execute this query using the ASP framework.

If someone could be so kind as to point my error, I would appreciate it.

In the module code:

    public function render()
    {
      $db = VF::factory('database');
      $tpl = VF::factory('template');
      $videos = $db->get_rows("SELECT title FROM #__video LIMIT 2");
      $tpl->videos = $videos;
      $tpl->menu = 'main';
      $tpl->submenu = 'tool';
      $tpl->meta_title = 'Admin::Tools::Hello World';
      $tpl->load(array('header', 'helloworld', 'footer'));
      $tpl->display();
    }

Last edited by THS (2012-03-07 20:56:12)

symtab · 2012-03-08 07:19:51

What does:

echo VF::debug($tpl->videos)

reurn?

THS · 2012-03-08 07:33:08

It returns (NULL). I ran the exact query in phpMyAdmin and it returns results, so I guess I am not initializing something correctly.

Last edited by THS (2012-03-08 08:08:59)

symtab · 2012-03-08 09:25:37

The code seems correct. Sincerly i dont know what the problem is

THS · 2012-03-08 18:35:07

I sent an email with the files. I am sure I have just made a simple error. Once I get it figured out, I promise to not bother you!

symtab · 2012-03-09 07:02:56

Will check my email asap.

THS · 2012-03-10 05:23:58

Thanks! Did you get the files?

Adult Script Pro Community Forums

#1 2012-03-07 20:14:09

PHP Help

#2 2012-03-08 07:19:51

Re: PHP Help

#3 2012-03-08 07:33:08

Re: PHP Help

#4 2012-03-08 09:25:37

Re: PHP Help

#5 2012-03-08 18:35:07

Re: PHP Help

#6 2012-03-09 07:02:56

Re: PHP Help

#7 2012-03-10 05:23:58

Re: PHP Help

Board footer