www.webdeveloper.com

Search:

Type: Posts; User: annice

Search: Search took 0.01 seconds.

  1. This SQL-code actually did the trick: SELECT ...

    This SQL-code actually did the trick:

    SELECT
    filmer.*,
    regissorer.fornamn,
    regissorer.efternamn
    FROM filmer
    INNER JOIN regissorer ON regissorer.id = filmer.regissor_id
    WHERE...
  2. I've also tried this now: $sql = "SELECT...

    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 =...
  3. I tried this now: $sql = "SELECT filmer.*,...

    I tried this now:


    $sql = "SELECT filmer.*, regissorer.fornamn, regissorer.efternamn FROM filmer 'filmer', regissorer 'regissorer'
    WHERE id = $id GROUP BY filmer.id";


    Still nothing...
  4. I've also tried this by the way, where I use...

    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...
  5. In this part of code where I'm trying to print...

    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...
  6. I've tried your code but I still can't make it...

    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:

    <?php
    $id =...
  7. Problem with SELECT JOIN when trying to print out a name once

    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...
  8. That solved the problem, thank you very much! :-D

    That solved the problem, thank you very much! :-D
  9. Cannot reach id from table when using SELECT JOIN

    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...
Results 1 to 9 of 9
HTML5 Development Center



Recent Articles