... first query should loop through the users list, within the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like:
$result=mysql_query($user_list_query);
while($row=mysql_fetch_assoc($result)) ...
... open c1;
fetch c1 into student_no;
if c1%notfound then
student_no := 0;
end if;
close c1;
RETURN student_no;
EXCEPTION
WHEN OTHERS THEN
raise_application_error(-20001,'An ...
This is for Joomla 1.5.x sites!
Note that this article is for Joomla 1.5.x sites to be converted to Wordpress 3.2.x sites. I started with a Joomla 1.5 as the move from Joomla 1.6 or greater is a lot ...
... create an array of search terms with their frequency count
$search_table_results=mysql_query("SELECT DISTINCT column1 FROM table1");
while($row=mysql_fetch_assoc($search_table_results)) {
$this_value=trim($row['column1']);
$this_value_num=mysql_num_rows(mysql_query("SELECT ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.