66 reputation
10
bio website
location
age
visits member for 4 years
seen Dec 28 '10 at 20:13

Oct
29
awarded  Popular Question
Jul
2
awarded  Curious
Aug
14
awarded  Popular Question
Jun
27
awarded  Popular Question
Jan
14
awarded  Popular Question
Dec
24
accepted Are there action hooks for comments?
Dec
24
answered Are there action hooks for comments?
Dec
24
comment Are there action hooks for comments?
MikeSchinkel thank you for the reply! You definably put me on the right track :)I'll post an example soon and see if it's anything close to what you had in mind.
Dec
23
asked Are there action hooks for comments?
Dec
9
awarded  Supporter
Dec
9
accepted Insert all post IDs in new database table
Dec
5
asked Insert all post IDs in new database table
Dec
4
accepted greatest() function returns undefined property
Dec
4
comment greatest() function returns undefined property
@TheDeadMedic I finally get it! I just have to echo $results :) Thanks again !
Dec
4
comment greatest() function returns undefined property
maybe it's not picking up post_id ?
Dec
4
comment greatest() function returns undefined property
Ok I used get_var() like so $results = $wpdb->get_var($wpdb->prepare( "SELECT GREATEST(up, down) FROM $table WHERE voted_post_id = $post_id" ) ); and then I use <?php echo $results->up; ?> and <?php echo $results->down; ?> to retrieve either up or down, whichever is highest. I get Trying to get property of non-object I don't understand why.. I already have the $wpdb global
Dec
4
comment greatest() function returns undefined property
Thanks Denis!! Sorry again for not properly explaining.
Dec
4
comment greatest() function returns undefined property
also the up and down fields are bigint
Dec
4
comment greatest() function returns undefined property
I tested GREATEST() in phpmyadmin and it works fine. It returns the highest values from either the up or down columns. Maybe my question wasn't clear, sorry. I'm just having trouble with wp
Dec
4
comment greatest() function returns undefined property
Thanks for the answer! I actually want up or down not both otherwise I would use a regular query. I used get_row() but now I get Trying to get property of non-object for echo $results->up; and echo $results->down;, this using the initial greatest()