1
konaafob
debaser 0.92
  • 2005/1/28 20:08

  • konaafob

  • Just popping in

  • Posts: 57

  • Since: 2005/1/10


I uploaded music file. After that it shows Music(1) in the category list. But If I try to approve it from admin module it says "No Files to Approve" If try to play it from user view it says There are no files currently available in this category?

What am I doing wrong.

Thanks in advance.

-- Kona

2
konaafob
Re: debaser 0.92
  • 2005/1/29 1:45

  • konaafob

  • Just popping in

  • Posts: 57

  • Since: 2005/1/10


$resultarts = $xoopsDB->query("$sql2");
$result = $xoopsDB->query( $sql2, $xoopsModuleConfig['indexperpage'], $start );

I looked into the code and I guess problem with the above piece of code.

I tried to execute $sql2 at database level and is returning values but $result and $resultarts are not getting any values from database .. any clue please ..

3
konaafob
Re: debaser 0.92
  • 2005/1/31 20:38

  • konaafob

  • Just popping in

  • Posts: 57

  • Since: 2005/1/10


FYI.
I was able to figure out the problem.

$sql="
select .....
";

changed it to

$sql="select ....";

then it worked fine.

Re,
Kona

4
Anonymous
Re: debaser 0.92
  • 2005/2/1 9:30

  • Anonymous

  • Posts: 0

  • Since:


Sorry for responding so late.

This is very strange, because I never experienced a problem like the one you described.

I thought it was a good idea to write the queries in such a way, because of better readability.

OK, then back to the old one-line-method. Thanks for figuring this out.

Login

Who's Online

350 user(s) are online (273 user(s) are browsing Support Forums)


Members: 0


Guests: 350


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits