Hi friends,
Can anyone tell me how can i write a php script which extract all the unique values of a field from multiple tables?
and also if anybody enters some new values it also should be stored in the unique table.
That is exactly what i meant is that
consider different category of courses offered and stored in different tables. Now, i need to extract all the unique courses with its id and keep it in a separate table. I know this should be done by 'group by' clause. Is it right?
What i'm asking is if anybody creates a new course how that should be stored in my new table? also this script should be run everyday from when i log on to my system to log off.
Thanx n regards
Yas
Can anyone tell me how can i write a php script which extract all the unique values of a field from multiple tables?
and also if anybody enters some new values it also should be stored in the unique table.
That is exactly what i meant is that
consider different category of courses offered and stored in different tables. Now, i need to extract all the unique courses with its id and keep it in a separate table. I know this should be done by 'group by' clause. Is it right?
What i'm asking is if anybody creates a new course how that should be stored in my new table? also this script should be run everyday from when i log on to my system to log off.
Thanx n regards
Yas
Comment