Skip to Content Skip to Menu

🌟Discover the Joomla AI Plugin that wrote its own story! - CB Editor Assistant 1.1now for Joomla 3, 4 & 5!
✍️ 5-Day Free Trial, then 🎯 save up to 30% with our 🛍️ Intro Offer (First 50 users, ends Dec. 31)
🌲 Merry Christmas! Great savings on Professional and Developer Memberships! Get 25% off now with code XMAS-2024!

a valid mysql query doesn't work in my script, why

  • paatoche
  • paatoche
  • OFFLINE
  • Posts: 1
  • Thanks: 0
  • Karma: 0
14 years 5 months ago #137784 by paatoche
hi mates,

i have a strange problem

i try to add a fonction in community builder component to display a kind of directory of registred users

and this code doesn't work and i don't know why

function show_annuaire() {
global $_CB_database;

$rubriqueid = intval( mosGetParam( $_GET, 'rubrique', 0 ));
$query = "SELECT * FROM #__comprofiler_field_values WHERE fieldvalueid = $rubriqueid";
$_CB_database->setQuery($query);
$dataObj = null;
$_CB_database->loadObject( $dataObj );

print_r($dataObj);
}



obviously, the query worked well in my phpmyadmin but not in my script

one day lost on this problem at this moment and i'm going a bit crazy

thanks for attention and help,
Patrick

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum