Join issue

[closer2u2]

I have a table with videos (vid) and a table with the ratings (ratings)

I want to sort the videos by rating, from hi to low.

this query does not want to work:

$sql="SELECT * FROM vid where type='public' LEFT JOIN ratings ON vid.id=ratings.id ORDER BY ratings.total_value DESC limit $startfrom, $config[items_per_page]";

any pointers?

[leatherback]

what is the error you are getting?

Is rating.id the field that links to the video id?
$config[items_per_page] might need to be $config['items_per_page']

[closer2u2]

I got this error

PHP Fatal error:  Call to a member function getrows() on a non-object

and it pointed to this last line

$rs = $conn->Execute($sql);
$users = $rs->getrows();

[jenks517]

It sounds like whatever was assigned to $conn is either not an object or was done improperly. $rs was assigned $conn so the only other possibility would be that getrows is not a method of the object but I think PHP will specifically list that as the problem if it is so.

It's hard to tell without knowing more about the object itself. If it doesn't reside directly within the object would it be necessary to make reference to the object.

$conn should be set someplace that says $conn = new Dbquery (or whatever)
then the way your calling the Execute would require it to be a method within the Dbquery object itself not outside of the object. I think if it is part of another object you can call it by object::method but I'm not quite sure.

The error is definitely unrelated to the join.