TOPIC:

Hi,

i have a view in CB conected to the DB with 2 Select options.

The first one let you choose the name and id from "test_table1"

what I want to do is the second select to display filtered fields (name2) based on the first select id


Test_table1:
id
name1

test_table2:
id
foreing key - name1(id)
name2

thx for your time

Hi,

in item wrap code for name2 try something like this:
<?php
$db =& JFactory::getDBO();
$sql = "SELECT name1
FROM test_table1 WHERE id =$value";
$db->setQuery($sql);
$value = $db->loadResult();
?>

Hope this helps

Regards,
Tihana

Thank you for your quick answer, it helped me solve one of my problems.

Even so i still need to find a way to do the next:

I have this first table named “gestión_carreras”

id	nombre_carrera
1	carrera_1
2	carrera_2

Now i have this second table where “nombre_carrera” is a foreing key from the first table (id).

id	nombre_materia	nombre_carrera
1	materia_1	1
2	materia_2	2

And this third table “gestión_cursada” is used to insert 2 foreign keys from tables 1 and 2 on this table, using two dropdowns.

id	nombre_carrera	nombre_materia	alumno
1	1	1	alumno1
2	2	3	alumno1

Foreing keys:
Nombre_carrera (use id from table 1)
Nombre_materia(use id from table 2)


I adapted one of the codes from your forums to fill my first dropdown using the first table, and it works.

Now that i have an id selected in this first dropdown. I would like to know if it is posible to make the second to only show values from the second table that only have that id(nombre_carrera).

Sorry for the mess im pretty new with this.

Hi,

this requires javascript code.
But as far as I understand you only use content builder. With ContentBuider alone you're not able to solve this.

Regards,
Tihana