ASC/DESC MUST be specified!

Du har sikkert et komma for meget.

Står der noget efter limit?

Jeg har ikke ændret noget endnu, og har kopieret scriptet direkte fra config filen. Eller noget af det, resten er password og DB osv..

Men limit?

Pröv at vise koden hvor du har din SQL.

Ja her.
ORDER BY name ASC,nr ASC,year DESC LIMIT 0,'
Der ser du LIMIT 0,'???
Der skulle gerne stå et tal til. Gör der det?

Ikke i koden, der står ikke limit nogle steder

<?
    /* 'main' configuration ******************************************************
    ** various options for the script                                          **
    ******************************************************************************/
    require_once('global.php');

    $cfg['mysql_host'] = 'xx';            // mysql host

    $cfg['mysql_user'] = 'xx';                // mysql user

    $cfg['mysql_pass'] = 'xx';                // mysql password

    $cfg['mysql_db'] = 'xx';                    // database name

    $cfg['stdshipping'] = 0;                // set shipping cost to a set value (no mileage)

    $cfg['pagetitle'] = 'php4flicks';            // the browser window title

    $cfg['email'] = 'xx';            // set email address for outgoing email

    $cfg['autonewacct'] = 1;                //0 = NO, 1 = YES

    $cfg['def_private'] = 1;                //0 = public, 1 = online only, 2 = buddies only

    $cfg['private_only'] = 1;                //0 = NO, 1 = YES

    $cfg['htmldoc'] = 0;                    //0 = NO, 1 = YES

    $cfg['nofflicks'] = 25;                    // # movies per page (main window)

    $cfg['offline'] = 0;                    // test function - removes logon button
                                // and displays offline message

    $cfg['offset'] = 18000;                    // time offset in seconds for movie rec time stamp
                                // this is a time zone diff calc so that if your server is
                                // in a different time zone you can adjust for this.

    $cfg['editlevel'] = 5;                    // access level allowed to change movie titles

    $cfg['mail_host'] = 'xx';            // mail host internet address

    $cfg['mail_host_port'] = '25';                // mail host port number (yes it is a string variable)

// default sort order; must NOT be empty! the max # of rows by which can be sorted is the size of this array.
// ASC/DESC MUST be specified!

    $cfg['defaultsort'] = array('name ASC','nr ASC','year DESC');

    $cfg['version'] = '0.4.1g MU';

    $cfg['old_browsers'] = true;                      // if set to true, javascript/DOM will not be used in the edit mode
                                                    // for compatibility with older browsers

    $cfg['htmldoc_path'] = 'c:/programme/apache2/htdocs/movies/print';  // the data directory for htmldoc
    $cfg['htmldoc_fname'] = 'movies.pdf';                              // name of pdf file outputted by htmldoc


    /* imdb scripts configuration ************************************************
    ** configures fetching of data from imdb                                    **
    ******************************************************************************/

    $cfg['actorLimit'] = 10;                        // how many actors per movie?
    $cfg['searchLimit'] = 25;                      // max # of search results per catecory

    $cfg['actSearchLimit'] = 25;                    // max # of search results for people
        // which categories to search for people:
    $cfg['actCats'] = array('actors','actresses','directors','writers');
        // possible categories include: Actor, Actress, Cinemathographer, Composer, Director,
        // Writer, Editor, Producer, Stunts, and a whole lot of others
        // independent of $actCats and $actSearchLimit, all 'most popular' matches will always be shown

    $cfg['cache'] = true;                          // whether or not to cache last search results

    $cfg['http_cache_size'] = 0;
        // number of html-pages kept in session cache.
        // should be switched off in general, useful when testing app since it reduces traffic from imdb

    $cfg['http_compress'] = true;
        // whether or not to use gzipped html.
        // set to false if you have problems fetching data from imdb (php versions <4.3.x)


    /* media configuration ********************************************************
    ** languages, media, etc...                                                  **
    ******************************************************************************/
    $cfg['cats'] = array(
        // an array to automatically choose category depending on medium. leave empty if not desired.
        // max length for category name is 10 chars.
        'dvd/dvd-r' => 'C',
        'vhs/vhs-c' => 'A',
        'svhs' => 'B',
        'divX/Xvid' => 'D',
        'vcd/Svcd' => 'E',
        '8/16/35mm' => 'F',
        'dv/mini-dv/hi-8' => 'G'
        );

// get available options for media, language, etc directly from mysql table definition.
// DO NOT CHANGE config below this line. to change options, directly edit mysql definitions.

    mysql_connect($cfg['mysql_host'],$cfg['mysql_user'],$cfg['mysql_pass']) or die(mysql_error());
    mysql_select_db($cfg['mysql_db']) or die(mysql_error());

    set_magic_quotes_runtime(0);                // get rid of that plague

    // option columns must be of type set or enum
    $options = array('medium','lang','format','ratio','sound','genre');

    foreach($options as $o){
        $result = mysql_query("describe movies_u $o") or die(mysql_error());
        $row = mysql_fetch_array($result);
        $type = $row['Type'];
        preg_match_all("#\'([^,\']{1,})\'#",$type,$matches,PREG_PATTERN_ORDER);

        $cfg[$o] = $matches[1];
    }
?>

Dette er jo filen config/config.php - der inkluderes fra diverse andre php-scripts.

Hvad er det for et script, du forsøger at udføre ?

<?
/*    php4flicks movie database (c) mr.Fox                    *
*    released under the GNU General Public License                *
*    contact and additional information: http://php4flicks.ch.vu        */

    // index.php -- display main page with movie list

    require_once('config/config.php');

    // columns to be listed
    $cols = ' DISTINCT CONCAT(cat,nr)as nr,movies_d.name,year,insertedby,medium,movies_d.id,fid,user,rqsted,source_cnt,destin_cnt,source_rating,destination_rating,AIM,Yahoo,ICQ,MSN ';

    $nummembers = members();

    $mrankings = 'RR'.get_movie_rankings();

    // check if user is logged in
    $loggedin = false;
    if(!isset($_POST['login']) || $_POST['login'] != '0'){
        session_start();
        if(!isset($_SESSION['user'])){
            session_unset(); session_destroy();
        } else $loggedin = true;
    }
    // if loggedin is true, the logout-button instead of the login-b. are shown, but of course also additional info could be shown!
    if ($loggedin) {
        $numpage = $_SESSION['nofflicks'];
        $loginuid = $_SESSION['uid'];
        $filename = 'members/'.$_SESSION['user'].'-movies.csv';
        if (file_exists($filename)) {
            unlink($filename);
        }
        $filename = 'members/'.$_SESSION['user'].'-movies-mine.csv';
        if (file_exists($filename)) {
            unlink($filename);
        }
        $query = 'DELETE FROM transaction WHERE tstatus=9 AND origv=1 AND destv=1'; // normally 8 make it 6 for test purposes
        mysql_query($query) or die(mysql_error());
    } else {
        $numpage = $cfg['nofflicks'];
        $loginuid = 0;
    }

    // default query (overwritten below if filter posted)
    $query = "SELECT SQL_CALC_FOUND_ROWS $cols FROM ((movies_d LEFT JOIN movies_u on movies_d.id=movies_u.id) LEFT JOIN logins ON movies_u.insertedby=logins.user_id) LEFT JOIN buddies ON logins.user_id=buddies.uid ";

    // iff filter has been submitted, use it
    if($_SERVER['REQUEST_METHOD'] == 'POST'){
        // form has been posted, page, filter and sortby[] values are present!

        // WHERE clause
        if(strlen($_POST['filter'])>0){
            // where clause was submitted
            // check if it is a select and not malicious SQL
            if(substr($_POST['filter'],0,38) != 'SELECT SQL_CALC_FOUND_ROWS _COLS_ FROM')
                die('don\'t try that.');
            $query = str_replace('_COLS_',$cols,$_POST['filter']);
        }
        // ORDER BY clause
        $sortsize = sizeof($_POST['sortby']);
        for($i=0; $i<$sortsize; $i++){
            $sortarray[$i] = $_POST['sortby'][$i];
            if($sortarray[$i]=='') break;
        }
        // fill rest of sort array with default values
        for($j=0; $j<$sortsize-$i; $j++){
            if(!isset($cfg['defaultsort'][$j])) break;
            $sortarray[$i] = $cfg['defaultsort'][$j];
            $i++;
        }
        $sortsize = sizeof($sortarray);
        $query .= ' ORDER BY '.implode($sortarray,',');
    } else {
        // default query
        $sortarray = $cfg['defaultsort'];
        $sortsize = sizeof($cfg['defaultsort']);
        $sortby = implode($sortarray,',');
        $query .= " ORDER BY $sortby ";
        $_POST['filtertitle'] = 'all movies';
        $_POST['filter'] = '';
        $_POST['genres'] = '';
    }
    // LIMIT clause
    if(!isset($_POST['page']) || $_POST['page'] == '')
        $_POST['page'] = '0';
    $query .= ' LIMIT '.$_POST['page'].','.$numpage;

    if ($_SESSION['access'] >= 2) {
        $mywhere = ' WHERE acclevel<>0 AND (pri=0 OR ((pri=1) AND ('.$loginuid.'<>0)) OR ((pri=2) AND (buid='.$loginuid.') AND ('.$loginuid.'<>0)) OR insertedby='.$loginuid.') ';
    } else {
        $mywhere = ' WHERE acclevel<>0 AND (pri=0 OR insertedby='.$loginuid.') ';
    }
    if(strlen($_POST['filter'])<=0) {
        if (strpos($query,"WHERE")) {
            $query = str_replace(" WHERE ",$mywhere,$query);
        } else {
            $query = str_replace(" ORDER BY ",$mywhere." ORDER BY ",$query);
        }
    }
    $_SESSION['myquery'] = $query;
    $result = mysql_query($query) or die(mysql_error());
    $rowresult = mysql_query('SELECT FOUND_ROWS()') or die(mysql_error());
    $row = mysql_fetch_row($rowresult);
    $rowcount = $row[0];
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
    <head>
        <meta http-equiv="content-type" content="text/html;charset=iso-8859-1"/>
        <title><?= $cfg['pagetitle'] ?></title>
        <link rel="stylesheet" type="text/css" href="config/flicks.css"/>
        <link rel="shortcut icon" href="favicon.ico"/>
        <link rel="bookmark icon" href="favicon.ico"/>
        <!-- another ugly hack because microsoft thinks standards are not for them -->
        <!--[if IE]>
            <style>
            #footer{
                position:absolute;
                left:0px;
                bottom:expression(body.scrollBottom + 'px');
            }

            body{
                height: 100%;
                overflow:hidden;
            }

            #indexmain{
                height: 100%;
                overflow: auto;
            }

            #navbox{
                margin-bottom:200px;
            }

            /* some other ie specific stuff */
            body{
                scrollbar-3dlight-color: white;
                scrollbar-arrow-color: red; scrollbar-darkshadow-color: black;
                scrollbar-face-color: white; scrollbar-highlight-color: silver;
                scrollbar-shadow-color: white; scrollbar-track-color: white;
            }
            </style>
        <![endif]-->

        <script type="text/javascript" language="JavaScript">
        <!--
            search = new Image();        search.src = 'pics/search.gif';
            search_a = new Image();     search_a.src = 'pics/search_a.gif';

            pr = new Image();            pr.src = 'pics/print.gif';
            pr_a = new Image();         pr_a.src = 'pics/print_a.gif';

            add = new Image();        add.src = 'pics/add.gif';
            add_a = new Image();         add_a.src = 'pics/add_a.gif';

            buddies = new Image();        buddies.src = 'pics/buddies.gif';
            buddies_a = new Image();     buddies_a.src = 'pics/buddies_a.gif';

            newusers = new Image();        newusers.src = 'pics/newusers.gif';
            newusers_a = new Image();     newusers_a.src = 'pics/newusers_a.gif';

            users = new Image();        users.src = 'pics/users.gif';
            users_a = new Image();         users_a.src = 'pics/users_a.gif';

            info = new Image();        info.src = 'pics/info.gif';
            info_a = new Image();         info_a.src = 'pics/info_a.gif';

            login = new Image();        login.src = 'pics/<?= ($loggedin?'logout.gif':'login.gif')?>';
            login_a = new Image();         login_a.src = 'pics/<?= ($loggedin?'logout_a.gif':'login_a.gif')?>';

            up = new Image();            up.src = 'pics/up.gif';
            up_g = new Image();         up_g.src = 'pics/up_g.gif';

            down = new Image();        down.src = 'pics/down.gif';
            down_g = new Image();         down_g.src = 'pics/down_g.gif';

            trans = new Image();        trans.src = 'pics/trans.gif';
            trans_a = new Image();         trans_a.src = 'pics/trans_a.gif';

            comms = new Image();        comms.src = 'pics/comms.gif';
            comms_a = new Image();         comms_a.src = 'pics/comms_a.gif';

            windowargs = 'location=no,menubar=no,status=no,titlebar=no,toolbar=no,directories=no';

            function swap(imgID,imgObjName) {
                if(imgID != '')
                    document.images[imgID].src = eval(imgObjName + ".src");
                document.images['<?= $sortarray[0]?>'.replace(' ','_')].src = '<?= strpos($sortarray[0],'DESC')>0?'pics/down.gif':'pics/up.gif'?>';
            }
            function tfilter(f,lin){
                //sets the filter to title=f,genre=... and submits filterform.
                var allgenres=true;
                var genrenull=true;
                var query='SELECT SQL_CALC_FOUND_ROWS _COLS_ FROM ((movies_d LEFT JOIN movies_u on movies_d.id=movies_u.id) LEFT JOIN logins ON movies_u.insertedby=logins.user_id) LEFT JOIN buddies ON logins.user_id=buddies.uid'+lin+'AND ';
                document.filterform.genres.value = '';

                gquery='';
                for(i=0;;i++){
                    if(!(cur=document.getElementById('genres_'+i)))
                        break;
                    if(cur.checked){
                        document.filterform.genres.value += ','+cur.value;
                        genrenull=false;
                        if(gquery != '')
                            gquery += ' OR ';
                        gquery += ' FIND_IN_SET(\''+cur.value+'\',genre) ';
                    } else
                        allgenres = false;
                }

                if(allgenres){
                    document.filterform.genres.value = '';
                } else if(genrenull){
                    document.filterform.genres.value = '&lt;none&gt;';
                    query += '( ISNULL(genre) )';
                } else
                    query += '('+gquery+')';

                if(f=='' && allgenres) query += '1';
                if(f!='' && !allgenres) query += ' AND ';

                rExp = /\'/gi;
                f = f.replace(rExp,'\\\'');
                if(f=='#'){
                    document.filterform['filter'].value = query+'name REGEXP \'^[^a-zA-Z]\'';
                    document.filterform.filtertitle.value = 'movies #';
                }
                else if(f.length == 1){
                    document.filterform['filter'].value = query+'name like \''+f+'%\'';
                    document.filterform.filtertitle.value = 'movies '+f.toLowerCase();
                } else if(f!=''){
                    document.filterform['filter'].value = query+'MATCH(movies_d.name,aka) AGAINST(\''+f+'\' IN BOOLEAN MODE)';
                    document.filterform.filtertitle.value = 'matches for '+f.toLowerCase();
                } else {
                    document.filterform['filter'].value = query;
                    document.filterform.filtertitle.value = 'all movies';
                }

                document.filterform.page.value = '0';
                //alert(document.filterform['filter'].value); //debug
                document.filterform.submit();
            }

            function showOptions(f,lin){
                var optionBox = document.getElementById('optionBox');
                var theBox = document.getElementById('navbox');
                if(f){
                    // show search options
                    optionBox.style.visibility = 'visible';
                    //document.getElementById('navbox').borderBottomStyle = 'hidden';
                    document.getElementById('navbrowse').innerHTML='<a onclick="showOptions(false,\''+lin+'\')">hide genres</a>';
                    theBox.style.height = '85px';
                    window.scrollBy(0,65);
                } else {
                    // no genre restrictions must be made
                    checkGenres(true);
                    if(document.filterform.genres.value != ''){
                        // genre restrictions apply, remove
                        document.filterform.genres.value = '';
                        tfilter('',lin);
                    }
                    // hide search options
                    optionBox.style.visibility = 'hidden';
                    document.getElementById('navbrowse').innerHTML='<a onclick="showOptions(true,\''+lin+'\')">browse genres...</a>';
                    theBox.style.height = '19px';
                }
            }

            function checkGenres(val){
                for(i=0;;i++){
                    if(!(cur=document.getElementById('genres_'+i)))
                        break;
                    else
                        cur.checked = val;
                }
            }
            function browseGenre(name,lin){
                for(i=0;;i++){
                    if(!(cur=document.getElementById('genres_'+i)))
                        break;
                    if(cur.value == name)
                        cur.checked = true;
                    else
                        cur.checked = false;
                }
                tfilter('',lin);
            }

            function sortby(s){
                var theBlank = s.indexOf('_');
                // dont sort after same column twice! check if this column already present
                for(i=0; i<<?= $sortsize-1 ?>;i++)
                    if(document.filterform['sortby['+i+']'].value.substring(0,theBlank) == s.substring(0,theBlank))
                        break;
                for(i;i>0;i-=1)
                    document.filterform['sortby['+i+']'].value = document.filterform['sortby['+(i-1)+']'].value;
                document.filterform['sortby[0]'].value = s.replace('_',' ');;
                document.filterform.submit();
            }
            function showall(){
                //resets filter values but not sortby, sends filterform.
                document.filterform.genres.value = '';
                document.filterform['filter'].value = '';
                document.filterform.filtertitle.value = 'all movies';
                document.filterform.page.value = '0';
                document.filterform.submit();
            }
            function setpage(p){
                document.filterform.page.value = p;
                document.filterform.submit();
            }

            function submitenter(e,lin){
                var keycode;
                if (window.event) keycode = window.event.keyCode;
                else if (e) keycode = e.which;
                else return true;
                if (keycode == 13){
                    tfilter(document.getElementById('title').value,lin);
                }else return true;
            }
        -->
        </script>

    </head>
    <body onload="swap('',''); if(document.filterform.genres.value!='') showOptions(true,'<?= $mywhere; ?>'); else showOptions(false,'<?= $mywhere; ?>');">
        <form name="filterform" action="index.php" method="post">
            <!-- specifies filter criteria for flicks, e.g. title like a% AND year = 1999 OR director like ... -->
            <!-- this is set with javascript. i hate javascript. you can't take seriously a language that allows 4 different ways to access array elements(all of which just might work, if you're lucky). but then again it can be very useful...-->
            <input type="hidden" name="page" value="<?= isset($_POST['page'])?$_POST['page']:'0' ?>"/>
            <input type="hidden" name="filtertitle" value="<?= isset($_POST['filtertitle'])?$_POST['filtertitle']:'all movies'?>"/>
            <!-- any valid WHERE clause here. director=..., actor=..., writer=... will be replaced with the correct joins -->
            <input type="hidden" name="filter" value="<?= $_POST['filter'] ?>"/>
<? for($i=0; $i<$sortsize; $i++) {?>
            <input type="hidden" name="sortby[<?= $i ?>]" value="<?= $sortarray[$i] ?>"/>
<? } ?>
            <input type="hidden" name="genres" value="<?= $_POST['genres'] ?>"/>
            <input type="hidden" name="login" value="<?= $loggedin?'1':'0' ?>"/>
            <!--indicates whether a login-check is done on page load. this is for performance reasons solely, since creating/destroying a session means writing/deleting a file each time! -->
        </form>
        <div id="mainheader">
            <div class="buttonsl">
                <? if ($loggedin) { ?>
                    <img name="search" src="pics/search.gif" alt="search movie" onmouseover="swap('search','search_a')" onmouseout="swap('search','search')" onclick="window.open('find.php','','width=500,height=220,resizable=no,'+windowargs);"/>
                    <? if ($cfg['htmldoc'] == 1) { ?>
                        <img name="pr" src="pics/print.gif" alt="print movie list" onmouseover="swap('pr','pr_a')" onmouseout="swap('pr','pr')" onclick="window.open('print/index.php','','width=500,height=220,resizable=no,'+windowargs);"/>
                    <? } else {?>
                        <img name="pr" src="pics/print.gif" alt="download movie list" onmouseover="swap('pr','pr_a')" onmouseout="swap('pr','pr')" onclick="window.open('members/update.php?action=expcsv','','width=250,height=140,resizable=no,'+windowargs);"/>
                    <? } ?>
                    <img name="add" src="pics/add.gif" alt="add movie" onmouseover="swap('add','add_a')" onmouseout="swap('add','add')" onclick="window.open('members/add.php','','width=250,height=140,resizable=no,'+windowargs);"/>
                <? } ?>
            </div>
            <div class="buttonsr">
                <? If ($loggedin) { ?>
                    <? if ((get_user_trans_status(1, $_SESSION['uid'], 0) >= 1) || (get_user_trans_status(2, $_SESSION['uid'], 0) >= 1)) { ?>
                        <img src="pics/new.gif" alt="new transactions" onclick="window.open('members/transactions.php','','width=500,height=500,resizable=no,'+windowargs);"/>
                    <? } else {?>
                        <? if ((get_user_trans_status(1, $_SESSION['uid'], -1) >= 1) || (get_user_trans_status(2, $_SESSION['uid'], -1) >= 1)) { ?>
                            <img name="trans" src="pics/trans.gif" alt="transaction log" onmouseover="swap('trans','trans_a')" onmouseout="swap('trans','trans')" onclick="window.open('members/transactions.php','','width=500,height=500,resizable=no,'+windowargs);"/>
                        <? } ?>
                    <? } ?>
                <? } ?>
                <? if (($loggedin) && ($_SESSION['access'] >= 3)) { ?><img name="buddies" src="pics/buddies.gif" alt="add a buddy" onmouseover="swap('buddies','buddies_a')" onmouseout="swap('buddies','buddies')" onclick="window.open('members/newbuddie.php','','width=250,height=600,resizable=no,'+windowargs);"/><? } ?>
                <? if ($loggedin) { ?>
                    <img name="users" src="pics/users.gif" alt="user info" onmouseover="swap('users','users_a')" onmouseout="swap('users','users')" onclick="window.open('members/users.php','','width=375,height=500,resizable=no,'+windowargs);"/>
                    <? if ($_SESSION['access'] >= 3) { ?>
                        <img name="comms" src="pics/comms.gif" alt="comms panel" onmouseover="swap('comms','comms_a')" onmouseout="swap('comms','comms')" onclick="window.open('members/comms.php','','width=300,height=250,resizable=no,'+windowargs);"/>
                    <? } ?>
                <? } ?>
                <? if ((!$loggedin) && ($cfg['autonewacct'] == 1)) { ?>
                    <img name="newusers" src="pics/newusers.gif" alt="create account" onmouseover="swap('newusers','newusers_a')" onmouseout="swap('newusers','newusers')" onclick="window.open('members/newusers.php','','width=250,height=450,resizable=no,'+windowargs);"/>
                <? } ?>
                <? if ($cfg['offline'] == 0) { ?>
                    <img id="login" src="pics/<?=($loggedin?'logout.gif':'login.gif')?>" alt="<?=($loggedin?'log out':'log in')?>" onmouseover="swap('login','login_a')" onmouseout="swap('login','login')" onclick="window.open('<?=($loggedin?'login.php?action=logout':'login.php')?>','','width=250,height=140,resizable=no,'+windowargs);"/>
                <? } ?>
                <img name="info" src="pics/info.gif" alt="info/about php4flicks" onmouseover="swap('info','info_a')" onmouseout="swap('info','info')" onclick="window.open('info.php','','height=600,width=350,resizable=no,'+windowargs);"/>
            </div>
            <span class="welcome">
                <? if ($cfg['offline'] == 0) { ?>
                    <?= $loggedin?'welcome back, '.$_SESSION['user'].'! '.$nummembers.' members and growing!':'' ?>
                <? } else { ?>
                    <b><u>PLEASE DO NOT ATTEMPT TO LOG IN - MAINTENANCE MODE IS ENGAGED!!!</b></u>
                <? } ?>
            </span>
        </div>
<?
// style="height: [ound((($numpage * 19) + 120),0);] px; overflow:auto;"
?>
        <div id="indexmain">
            <table id="maintable">
                <thead>
                <tr>
                    <th colspan="7"><?= stripslashes($_POST['filtertitle']);?> [<? if ($rowcount == 0) echo 'no matches'; else{ echo $_POST['page']+1; echo '..'; echo $_POST['page']+min($numpage,$rowcount-$_POST['page']); echo ' of '; echo $rowcount;} echo ']'?><?= show_pages($rowcount, $numpage, (integer)$_POST['page']); ?></th>
                </tr></thead>
                <tbody>
                    <tr class="rowtitle">
                        <td style="width: 40px">&nbsp;<br/><img name="nr_ASC" alt="^" src="pics/up_g.gif" onclick="sortby('nr_ASC')" onmouseover="swap('nr_ASC','up')" onmouseout="swap('nr_ASC','up_g')"/><img name="nr_DESC" alt="v" src="pics/down_g.gif" onclick="sortby('nr_DESC')" onmouseover="swap('nr_DESC','down')" onmouseout="swap('nr_DESC','down_g')"/></td>
                        <td>title<br/><img name="name_ASC" alt="^" src="pics/up_g.gif" onclick="sortby('name_ASC')" onmouseover="swap('name_ASC','up')" onmouseout="swap('name_ASC','up_g')"/><img name="name_DESC" alt="v" src="pics/down_g.gif" onclick="sortby('name_DESC')" onmouseover="swap('name_DESC','down')" onmouseout="swap('name_DESC','down_g')"/></td>
                        <td style="width: 160px">director<br/></td>
                        <td style="width: 60px">year<br/><img name="year_ASC" alt="^" src="pics/up_g.gif" onclick="sortby('year_ASC')" onmouseover="swap('year_ASC','up');" onmouseout="swap('year_ASC','up_g')"/><img name="year_DESC" alt="v" src="pics/down_g.gif" onclick="sortby('year_DESC')" onmouseover="swap('year_DESC','down')" onmouseout="swap('year_DESC','down_g')"/></td>
                        <td style="width: 60px">added by<br/><img name="user_ASC" alt="^" src="pics/up_g.gif" onclick="sortby('user_ASC')" onmouseover="swap('user_ASC','up');" onmouseout="swap('user_ASC','up_g');"/><img name="user_DESC" alt="v" src="pics/down_g.gif" onclick="sortby('user_DESC')" onmouseover="swap('user_DESC','down')" onmouseout="swap('user_DESC','down_g')"/></td>
                        <td style="width: 60px">medium<br/><img name="medium_ASC" alt="^" src="pics/up_g.gif" onclick="sortby('medium_ASC')" onmouseover="swap('medium_ASC','up');" onmouseout="swap('medium_ASC','up_g');"/><img name="medium_DESC" alt="v" src="pics/down_g.gif" onclick="sortby('medium_DESC')" onmouseover="swap('medium_DESC','down')" onmouseout="swap('medium_DESC','down_g')"/></td>
                        <td style="width: 28px"/>
                    </tr>
<?
    $brow = true;
    while($row = mysql_fetch_array($result)) {
        $bld = ''; $bld1 = ''; $img = '';
        $rankchk = '|'.$row['fid'].'|';
        $rqst = $row['rqsted'];
        if (strpos($mrankings,$rankchk) >= 1) {
            $bld = '<b>';$bld1 = '</b>';
            if ($rqst >= 1)
                $bld1 = ' ('.$rqst.')'.$bld1;
        } else {
            if ($rqst >= 1)
                $bld1 = ' ('.$rqst.')';
        }
        $directors = ''; directorsearch($directors,$row['id']);
        $namelen = strlen($row['user']);
        $namelen += 120;
        $msgicons = '';
        if ($row['AIM'] <> '') $msgicons .= '<img width=20 height=20 src=&quot;/pics/aim.gif&quot; alt=&quot;AIM&quot;>&nbsp;';
        if ($row['Yahoo'] <> '') $msgicons .= '<img width=20 height=20 src=&quot;/pics/yahoo.gif&quot; alt=&quot;Yahoo&quot;>&nbsp;';
        if ($row['ICQ'] <> '') $msgicons .= '<img width=20 height=20 src=&quot;/pics/icq.gif&quot; alt=&quot;ICQ&quot;>&nbsp;';
        if ($row['MSN'] <> '') $msgicons .= '<img width=20 height=20 src=&quot;/pics/msn.gif&quot; alt=&quot;MSN&quot;>&nbsp;';
?>
        <tr class="row<?= $brow?'0':'1'?>">
            <td><?= $row['nr']?></td>
<?
            if ($loggedin) {
                if ($_SESSION['disppics'] == 1) {
?>
                    <td><a style="cursor: pointer;" onclick="window.open('view.php?fid=<?= $row['fid']?>','','height=600,width=350,resizable=no,'+windowargs);"  onmouseover="this.T_WIDTH=97;return escape('<img src=&quot;imgget.php?for=<?= $row['fid'] ?>&quot; alt=&quot;<?= $row['fid'] ?>&quot; width=&quot;97&quot; height=&quot;150&quot; border=&quot;0&quot;')"><?= $bld.$row['name'].$bld1 ?></a></td>
<?
                } else {
?>
                    <td><a style="cursor: pointer;" onclick="window.open('view.php?fid=<?= $row['fid']?>','','height=600,width=350,resizable=no,'+windowargs);"><?= $bld.$row['name'].$bld1 ?></a></td>
<?
                }
            } else {
?>
                <td><?= $bld.$row['name'].$bld1 ?></td>
<?
            }
?>
            <td><?= $directors?></td>
            <td><?= $row['year']?></td>
            <td>
<?
                if ($loggedin) {
                    if ($row['insertedby'] <> $_SESSION['uid']) {
?>
                        <a href="nindex.php?u=<?= $row['insertedby'] ?>" onmouseover="this.T_WIDTH=<?= $namelen; ?>;return escape('<b><?= $row['user']; ?>\'s Info (<?= ($row['source_cnt'] + $row['destin_cnt']) ?>)</b><br><br><img src=&quot;/pics/rating_<?= $row['source_rating']; ?>.gif&quot; alt=&quot;source rating&quot;><br><img src=&quot;/pics/rating_<?= $row['destination_rating']; ?>.gif&quot; alt=&quot;destination rating&quot;><br><?= $msgicons; ?>')"><?= $row['user']?></a>
<?
                    } else {
?>
                        <a href="#" onmouseover="this.T_WIDTH=<?= $namelen; ?>;return escape('<b><?= $row['user']; ?>\'s Info (<?= ($row['source_cnt'] + $row['destin_cnt']) ?>)</b><br><br><img src=&quot;/pics/rating_<?= $row['source_rating']; ?>.gif&quot; alt=&quot;source rating&quot;><br><img src=&quot;/pics/rating_<?= $row['destination_rating']; ?>.gif&quot; alt=&quot;destination rating&quot;><br><?= $msgicons; ?>')"><?= $row['user']?></a>
<?
                    }
                } else {
?>
                    <a href="nindex.php?u=<?= $row['insertedby'] ?>"><?= $row['user']?></a>
<?
                }
?>
            </td>
            <td><?= $row['medium']?></td>
            <td><? if ($loggedin) { ?><a href="http://www.imdb.com/title/tt<?= $row['id']?>/" target="_blank"><img alt="imdblogo" src="pics/imdb.gif"/></a><? } ?></td>
        </tr>
<?
        $brow = !$brow;
    }
?>
                </tbody>
            </table>
            <div id="navbox">
                <span class="navbuttonsl"><a <? if($_POST['page'] != '0') echo 'onclick="setpage(0)"' ?>><img alt="&lt;" src="pics/left_.gif"/></a><a <? if($_POST['page']!='0') {echo 'onclick="setpage('; echo((integer)$_POST['page'])-$numpage; echo ')"'; }?>><img alt="&lt;" src="pics/left.gif"/></a></span><a href="#" onclick="showall();">all</a><? for($i=97; $i<123; $i++) echo '<a href="#" onclick="tfilter(\''.chr($i).'\',\''.$mywhere.'\');">'.chr($i).'</a>'; ?><a href="#" onclick="tfilter('#','<?= $mywhere; ?>');">&#35;</a><span class="navbuttonsr"><a <? $tmp = ((integer)$_POST['page'])+$numpage; if($rowcount > $tmp) echo "onclick=\"setpage($tmp)\""?>><img alt="&gt;" src="pics/right.gif"/></a><a <? if($rowcount > $tmp) {$end = --$rowcount - (($rowcount) % $numpage); echo "onclick=\"setpage($end)\"";} ?>><img alt="&gt;" src="pics/right_.gif"/></a></span><span id="navsearch">search:<input title="search in titles. usage:  [+|-]word {[+|-]word}  e.g.: american +beauty -pie" style="cursor:help;" type="text" class="navinput" id="title" onkeydown="submitenter(event,'<?= $mywhere; ?>');"/><a href="#" onclick="tfilter(document.getElementById('title').value,'<?= $mywhere; ?>');">go!</a></span><span id="navbrowse"><a onclick="showOptions(true,'<?= $mywhere; ?>');">browse genres...</a></span>
                <div id="optionBox">
                    Select Genres for search: (<a onclick="checkGenres(true);">check all</a>&nbsp;/&nbsp;<a onclick="checkGenres(false);">uncheck all</a>)
                    <table>
<?
                $sgenre = explode(',',$_POST['genres']);
                $i=0;
                foreach($cfg['genre'] as $m){
                    if($i%11 == 0)
                        echo '<tr>';
                    echo '<td><input type="checkbox" id="genres_'.$i.'" value="'.$m.'" '.(in_array($m,$sgenre)?'checked="checked"':'').'/>'.$m.'</td>';
                    $i++;
                    if($i%11 == 0)
                        echo '</tr>';
                }
                for($j=0; $j<11-$i%11; $j++)
                    echo '<td/>';
?>
                    </tr></table>
                </div>
            </div>
        </div>
        <div id="footer">
            <span class="copy">php4flicks <?= $cfg['version'] ?></span>
        </div>
        <script language="JavaScript" type="text/javascript" src="wz_tooltip.js"></script>
    </body>

</html>
<?
    // this would be unnecessary if mysql supported views:(
    function directorsearch(&$out, $movieid){
        $res = mysql_query("SELECT people.name FROM directs,people WHERE directs.movie_id = $movieid AND directs.people_id = people.id;") or die(mysql_error());
        while($row = mysql_fetch_row($res))
            ($out ==''?$out .= $row[0] : $out .= ', '.$row[0]);
        return;
    }
?>




INDEX vil jeg gætte på...

og du har oprettet tabellerne og ellers fulgt installationsvejledningen ?

Ja så vidt muligt, men vil lige gennemgå tabellerne igen. Der er rigtig mange at oprette og rigtig mange at tjekke igennem.. Så fejl kan jo nemt opstå

CREATE TABLE transaction (
  transactid smallint(3) unsigned NOT NULL auto_increment,
  originator_id smallint(3) unsigned NOT NULL default '0',
  destination_id smallint(3) unsigned NOT NULL default '0',
  movie_id mediumint(3) unsigned NOT NULL default '0',
  tstatus tinyint(3) unsigned NOT NULL default '0',
  origv tinyint(3) unsigned NOT NULL default '0',
  destv tinyint(3) unsigned NOT NULL default '0',
  date datetime default NULL,
  orig_rated tinyint(3) unsigned default '0',
  dest_rated tinyint(3) unsigned default '0',
  UNIQUE KEY transactid (transactid,originator_id,movie_id),
  KEY transactid_2 (transactid)
) TYPE=MyISAM;


I denne kommer PHPmyAdmin med en note om  UNIQUE og INDEX nøgler burde ikke begge være sat for kolonne `transactid`

Det er næppe alvorligt.

To spørgsmål mere: Hvilken version af Mysql kører du ?

OG : hvilket nok er den værste:

Hvordan har du det med magic_quotes ? skal være off

1.
Kører via. Danhost, og det er version 4.1

Magic_quotes er nok slået til så. Hvordan slår jeg det fra?

Nemmest er det jo at rette det i php.ini - men det har du sikkert ikke lov til.

Du skulle kunne klare det ved at lave en .htaccess fil med indholdet

php_flag magic_quotes_gpc off

jeg laver bare en fil der hedder .htaccess med php_flag magic_quotes_gpc off ? Hvor skal jeg lægge den så, for der ligger en del .htaccess rundt omkring i forskellige mapper...

samme sted som du har lagt ovenstående index.php.

Har du en .htaccess fil i den mappe i forvejen, kan du jo bare sætte linien ind i den fil.

Okay mange tak, det fandt jeg så ud af nu. Bare at lægge den i mappen... Nu får jeg så ny fejl

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@domain.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.


Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Så må lige kiggge på hvad jeg så har lavet af fejl ;)

FAQ'en på http://php4flicks.sourceforge.net/ nævner at hvis du får underlige SQL fejl- er det nok på grund af maqic quotes -

hmm, jeg er vist ved at løbe tør for ideer

Hov, det er vel "bare" en 404 Not found - som din host ikke er så glad for at informere om.

Du har uploaded ALT ?

Ja, har lige prøvet igen at gennemgå det. Kan slet ikke finde noget der mangler...

$cfg['htmldoc_path'] = 'c:/programme/apache2/htdocs/movies/print';  // the data directory for htmldoc

er det ikke:
$cfg['htmldoc_path'] = 'c:/programmer/apache2/htdocs/movies/print';  // the data directory for htmldoc

eller:
$cfg['htmldoc_path'] = 'c:/program/apache2/htdocs/movies/print';  // the data directory for htmldoc

altså program

Hm. Bare jeg laver et dokument og kalder det test.html kan den ikke finde det...

Det ved jeg ikke, nu ligger det jo ikke hos mig men hos Danhost... Men kan lige prøve at ændre

Øhh, er det overhovedet en windows platform ?

Har danhost ikke kun php på Unix platform -( og asp på Windows)

jo præcis.. Du siger ikke jeg har fundet et forkert script?;):$

Nej, Det fremgår at det skulle være muligt at installere det på *nix.
Men helt generelt, er der jo mange konfigurationsparamtre i config.php

De skal selvfølgelig bare sættes "rigtigt".

Bare godt at vide hvad den så skal ændres til

Det var mærkeligt.. Nu fjernede jeg .htaccess nu kan jeg se det dokument jeg lagde uafhængigt af de andre, men i samme mappe. Og det virker nu ser det ud til :S

- Må hellere bede om svar så jeg kan dele point ud. Det er der vist fortjent

Underligt, det virker ikke i IE 7, men det virker i Firefox..

Må jeg se svar ? ;)

Ok