Type: Posts; User: annice
Search took 0.00 seconds.
This SQL-code actually did the trick:
INNER JOIN regissorer ON regissorer.id = filmer.regissor_id
I've also tried this now:
$sql = "SELECT filmer.*, regissorer.fornamn, regissorer.efternamn
FROM filmer 'filmer', regissorer 'regissorer'
WHERE id = $id AND regissorer.regissorer_id =...
I tried this now:
$sql = "SELECT filmer.*, regissorer.fornamn, regissorer.efternamn FROM filmer 'filmer', regissorer 'regissorer'
WHERE id = $id GROUP BY filmer.id";
I've also tried this by the way, where I use "regissor_id = $id" instead of "id = $" in the end of the string. But then it prints out one director in some pages, and none in others, and where the...
In this part of code where I'm trying to print out the director name I've tried (except from the code above) this:
//Select data from regissorer-table to print it out once:
$sql = "SELECT...
I've tried your code but I still can't make it work. Here is the code I'm using right now on the page where I want the director name to be printed out under the movie title:
I have a problem when I'm attempting to print out a specific director name for specific movie. I can print out info such as "title" and "production year" for a specific movie, which is stored in a...
That solved the problem, thank you very much! :-D
Hello, I have a problem to select the id from the filmer-table when I use JOIN in the SQL-string below. At the moment I only reach the id from the regissorer-table, but I want to reach both id:s from...