Hello all,
I need to mod this part code in the page.cgi but i don't know exactly what this does only i think i have to modify it because i need a different build.
# Fetch the subcategory list.
$get_links = $LINKDB->prepare (" SELECT * FROM Links WHERE CategoryID = ? ORDER BY $LINKS{build_sort_order_category} LIMIT 1000 ");
$get_links->execute ($category_r->{'ID'});
$links_r = $get_links->fetchall_arrayref || [];
The part CategoryID = ? have to be something like:
CategoryName = Links.[here the content of Category.CategoryName] and Links.[here the content of Category.CategoryName] = "Yes"
But i don't know what to put in [here the content of Category.CategoryName] maybe $Category{CategoryName} or something like that ? Man i have to learn MySQL quick...
What does the code $get_links->execute ($category_r->{'ID'}); do ?
And maybe you can explain the whole part of code to me?
... well basically i have 12 extra fields in the links table and the 12 records in the category table where the categoryname is the same as the extra fields names in the links table.
I have to modify it this way because i can't use alternative links....
Allready thanks.
Regards Startpoint.
I need to mod this part code in the page.cgi but i don't know exactly what this does only i think i have to modify it because i need a different build.
# Fetch the subcategory list.
$get_links = $LINKDB->prepare (" SELECT * FROM Links WHERE CategoryID = ? ORDER BY $LINKS{build_sort_order_category} LIMIT 1000 ");
$get_links->execute ($category_r->{'ID'});
$links_r = $get_links->fetchall_arrayref || [];
The part CategoryID = ? have to be something like:
CategoryName = Links.[here the content of Category.CategoryName] and Links.[here the content of Category.CategoryName] = "Yes"
But i don't know what to put in [here the content of Category.CategoryName] maybe $Category{CategoryName} or something like that ? Man i have to learn MySQL quick...
What does the code $get_links->execute ($category_r->{'ID'}); do ?
And maybe you can explain the whole part of code to me?
... well basically i have 12 extra fields in the links table and the 12 records in the category table where the categoryname is the same as the extra fields names in the links table.
I have to modify it this way because i can't use alternative links....
Allready thanks.
Regards Startpoint.