Jump to content
  • Announcements

    • boen_robot

      Guidelines and Netiquette   03/28/2017

      Posting Problems:   Having problems posting your topic? Read through this: To join, you agree to our terms and conditions and fill out and submit a registration form. An activation email will be sent to your email adress, so you'll need to verify your account. After that the account has to be validated by one of the moderators. This will mean that it can take up to a day to be activated. A couple of things to remember to ensure approval: Don't use an email address in one of those $2 four character .com domains eg. xyds.com. These will be deleted and the domain added to the banned list. Don't use an email address that is within a domain with a bad reputation for spam. A Google search is run on every email address and email domain. Don't sign up with an email address that doesn't exist, doesn't work or requires the sender to answer a quiz before their email can get to you. Put your country and or state and city in the signup form. Blank forms will go to the botton of the "to do" list. And make sure that your email address and your country match, saying you're from Alabama and using a .ru email address is not going to get you activated. After a membership is activated the first few posts will be monitored. Posting spam or unapproved topics described in the agreement results in an immediate ban. The email provider and the IP addresses associated with the account will be banned and all posts will be deleted. These strict measures have been deemed necessary to hinder spam. Sorry for any inconvenience this causes, but it's not liable to change. If, after reading this, you still can't post and don't understand why, contact one of the Moderators listed here.   Topic Guidelines   Including the following information can expedite an accurate response from board members: Must be a Specific Problem or Question related to web design and development Include Code in Question (wrap with   for small blocks of code and for longer blocks   ) Include Code Author Include Extra Notes/Modifications/Attempts Include web link to page/file when possible Content Guidelines   You may not post, upload, link to, or email any Content that contains, promotes, gives instruction about, or provides prohibited Content. Prohibited Content includes any Content that breaks any local, state, county, national or international law. Prohibited Content also includes: No direct or indirect advertising or websites, forums, products, services No hijacking of posts (do not post your question in someone elses) Content that infringes upon any rights [ex. MP3s and ROMs] (including, but not limited to, copyrights and trademarks) Abusive, threatening, defamatory, racist, or obscene Viruses or any other harmful computer software False Information or libel Spam, chain letters, or Pyramid schemes Gambling or Illicit drugs Terrorism Hacking or cheating for internet/online games Warez, Roms, CD-Keys, Cracks, Passwords, or Serial Numbers Pornography, nudity, or sexual material of any kind Excessive profanity Invasive of privacy or impersonation of any person/entity Hacking materials or information Posting Tips   There are more BBcodes than there are buttons for on the reply menu. To get the full list, click "BB Code Help" underneath the clickable smilie face menu. Use   for small snippets of code Use   for lengthy snippets of code Use   if your snippet is HTML (optional) Use   if your snippet is SQL (optional) Rules of Conduct   Be nice. There's no need for calling someone stupid if they ask an 'easy' question. Keep your avatars and signatures absolutely child friendly. We have a younger audience on this forum. Keep your language appropriate for the same reason above. Do not PM moderators for help on the forum. Post on the topic, or create a new one.   Spam:   Recently, as you have all without doubt noticed, we have had lots of spam and advertisement on the forum. Therefore, we'd like to alert you as to what to do when you have found any of the aforementioned annoying messages: it. Immediately. Give a clear reason, please, if the advertising is not evident. DO NOT POST! Report, let the post stay as is, and we will get to it, meanwhile if you continue to post as normal in the other threads, it won't be on the top so long. Refrain from PMing the member. This won't help at all, as they are most likely spambots anyway. Thank you.       Images in signatures:   After thinking of users on dial-up, we have decided to enforce the following rules regarding signatures. Please pay heed to them. Respecting these rules is respecting the members on this forum with dial-up. Signature rules: No animated images AT ALL. No matter the amount of animation. Maximum image widthxheight: 300x150 Maximum image (file) size: 15kb Use calm colors. Do not use highly contrasting images in your signature, as this can get really annoying when seeing several posts from one member in the same thread. The same prohibited content goes for images as for posts. Lastly, use common sense. No lengthy signatures please. Save us some scrolling. Thank you.       Links in signatures:   Please understand that w3schools.com only exists because of voluntary work and is barely supported by the advertising littered throughout the tutorials and the forum. So, please, stop advertising other sites. DO not post links that drive traffic away from the w3schools domain - especially to a site that offers similar if not identical information. Please help support the site by keeping individuals on it. Thank you. Here are some guidelines as to what you can put in your signature: w3schools links --> allowed w3.org links --> allowed browser links --> allowed html editor links --> allowed personal sites --> allowed tutorial sites competing with w3schools --> NOT allowed sites completely irrelevant to webprogramming and this forum --> NOT allowed   Thanks for understanding, and for taking the time to read this. ~W3Schools Modstaff~
Sign in to follow this  
rootKID

advance search SQL Query and PHP - trouble making it work

Recommended Posts

Hello W3S!

So i have some problems again, hoping you can help me clear it out. I am currently trying to make a search page where a user can search for profiles with different profiles information such as tattoos, height, etc. And i have some difficulties making it work, hoping you can spot some sort of errors that i cannot.

Please note that it's been a while since i've been making a fully working searcher with php and sql, so sorry for the messed up code, if so hehe :P

Okay. So i have 6 files, follows as such:

1. index.php (being the main file) - (LOCATION: ROOT/FILE_HERE.php),

2. PAGE_searchprofiles.php (being where the search coding begins AND output is coming) - (LOCATION: ROOT/include/files/www-files/FILE_HERE.php),

3. functions.pagination.class.php (being my pagination class, used on file PAGE_searchprofiles.php) - (LOCATION: ROOT/FILE_HERE.php),

4. functions.php (my php functions into 1 file) - location is root

5. index.search_patterns_setup.php (being used on file PAGE_searchprofiles.php, being where i use if/else statements to compile a proper sql) - location root

6. index.no_search_show_cards_profiles.php (being used on file PAGE_searchprofiles.php, showing ALL profiles if no search has been done so far.) - location root

-------------------------------------------

okay, those are file names and locations.

the idea is that when there is a search, the searched profiles should be shown, else, show all files. I got that part working perfectly, but now comes the actual search query where i get a little lost (i think). And please take note that this is a search query from a past coder, doing this for a company and this coder has done some terrible coding... i think... i have a hard time seeing what he has done and not. At some places he has done a quite good job, but the search part, not so much.

So, i will share the code below here for ALL files, and after that coding, i will write about the problem at hand again.

--------------------------------------

index.php

<?php
ob_start();
session_start();
define("DEFINED_FILE:DEFINES_1", TRUE);
require_once("include/files/www-files/random_uncategorized_useful_files/defines.php"); // Defines
require_once("include/files/www-files/random_uncategorized_useful_files/report_methods.php"); // Reportings
require_once("database/connection.php");
DB_open_main_connection(); // $dblink
?>
<!DOCTYPE html>
<html lang="da">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <title>Release 1 - Version 1</title>
    
    <!-- Bootstrap V.4.0.0 CSS files -->
    <link rel="stylesheet" href="include/css/bootstrap.min.css" />
    
    <!-- My Custom CSS Files -->
    <link rel="stylesheet" href="include/css/global_custom_css_design.css" />
    <link rel="stylesheet" href="include/css/5.css" />
    <link rel="stylesheet" href="include/css/navigation_menu_5.css" />
    
    <!-- other css files -->
    <link rel="stylesheet" href="include/css/fontawesome-all.min.css">
    
    <!-- Jquery (necessary for Bootstrap's JavaScript plugins) and Bootstrap V.4.0.0 JS Script files -->
    <script src="include/js/jquery-3.2.1.js"></script>
    <script src="include/js/bootstrap.min.js"></script>
    <script src="include/js/bootstrap.bundle.js"></script>
    <script src="include/js/5.js"></script>
</head>
<body>
    
    <?php
    # Require Navigation Menu
    require_once("include/files/www-files/nav-menu.php");
    
    # Including PAGE_signup1.php
    include_once("include/files/www-files/PAGE_searchprofiles.php");
    ?>
    
    <div class="mt-3"></div>
    <?php
    # Require Footer
    require_once("include/files/www-files/footer.php");
    
    // close connection
    $dblink->close(); // MAIN Connection
    ?>
    
</body>
</html>

PAGE_searchprofiles.php

<?php
require_once("functions.php");

////////////////////////////////////////////////////////////////////////////////////////////////////
// Notes
////////////////////////////////////////////////////////////////////////////////////////////////////

//------------------------------------------------------------------------------------------------
// comma separeret DB output for ALLE checkboxes (Tatovering & Kategori - vi bruger explode!)
//------------------------------------------------------------------------------------------------

/*
I DB (users_info) laver jeg en "text" for både kategori og tatovering checkboxes da jeg skal bruge string til comma (sådan forstår jeg det!).

Jeg indsætter komma sepereret tal, og bruger php funktionen explode til at sepererer tallene.
Jeg bruger senere tallene til at "selecte" ud fra ID hos diverse tabeller, senere hen vise diverse som er blevet vist/valgt/osv.
*/

////////////////////////////////////////////////////////////////////////////////////////////////////
// Lists
////////////////////////////////////////////////////////////////////////////////////////////////////

//------------------------------------------------------------------------------------------------
// FORM - names
//------------------------------------------------------------------------------------------------

// my notes: maybe add "multiple" to the select? Style it to be a normale dropdown... look into alternatives!

// FORMNAME_SogProfilBar_Keywords (Søg Profil Bar)
// FORMNAME_MinAlder (Alder :: Minimum)
// FORMNAME_MaxAlder (Alder :: Maximum)
// FORMNAME_Landsdel (Landsdel "SelectOption")
// FORMNAME_Kon (Køn "SelectOption")
// FORMNAME_MinHojde (Højde :: Minimum)
// FORMNAME_MaxHojde (Højde :: Maximum)
// FORMNAME_Etnicitet (Etnicitet "SelectOption")
// FORMNAME_Sprog (Sprog "SelectOption")
// FORMNAME_MinVaegt (Vægt :: Minimum)
// FORMNAME_MaxVaegt (Vægt :: Maximum)
// FORMNAME_Tatoveringer (Tatoveringer "SelectOption")
// FORMNAME_Kategorier (Kategorier "SelectOption")

// FORMNAME_submit_search (Søg "Submit Button")

//------------------------------------------------------------------------------------------------
// Queries - already being used
//------------------------------------------------------------------------------------------------

// $query_1 (selecting all data from DB-Table users_info)

// $query_2 (Landsdel -> SelectOption)
// $query_3 (Køn -> SelectOption)
// $query_4 (Etnicitet -> SelectOption)
// $query_5 (Sprog -> SelectOption)
// $query_6 (Tatoveringer -> SelectOption)
// $query_7 (Kategori -> SelectOption)

// $query_100 (outputting all cards/profiles to the "profiles" area)

//------------------------------------------------------------------------------------------------
// Queries
//------------------------------------------------------------------------------------------------

$query_1 = "SELECT * FROM users_info";
$result_1 = mysqli_query($dblink, $query_1) or die ( mysqli_error($dblink) );
$row_1 = mysqli_fetch_array($result_1);
?>

<div class="container-fluid">
    <div class="row">
        <div class="col-md-12">
            <br />
            <h1 class="text-muted text-center">Søg Profiler</h1>
        </div>
    </div>
</div>

<div class="container">
    <form method="post" action="index.php">
        <div class="row mb-3">
            <!-- Søg Profil Bar -->
            <div class="input-group">
                <input type="text" class="form-control" placeholder="Søg Profil" name="FORMNAME_SogProfilBar_Keywords">
                <div class="input-group-append">
                    <button type="submit" class="btn btn-outline-secondary" name="FORMNAME_submit_search">Søg</button>
                    <button type="button" class="btn btn-outline-secondary JQUERY_ACTION_expand_search">Udvid Søgning</button>
                </div>
            </div>
        </div><!-- //.row -->
        <div class="row">
            <div class="container">
                <div class="row">
                    <!-- Min.Alder -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Min.Alder</span>
                                <span class="input-group-text">ÅR</span>
                            </div>
                            <input type="number" class="form-control" placeholder="Min.Alder" min="0" name="FORMNAME_MinAlder">
                        </div>
                    </div>
                    <!-- Max.Alder -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Max.Alder</span>
                                <span class="input-group-text">ÅR</span>
                            </div>
                            <input type="number" class="form-control" placeholder="Max.Alder" min="0" name="FORMNAME_MaxAlder">
                        </div>
                    </div>
                    <!-- Landsdel -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <label class="input-group-text" for="inputGroupSelect_LANDSDEL">Landsdel</label>
                            </div>
                            <select class="custom-select" id="inputGroupSelect_LANDSDEL" name="FORMNAME_Landsdel">
                                <option selected disabled hidden>Landsdel</option>
                                <?php
                                $query_2 = "SELECT * FROM users_info_landsdel";
                                $result_2 = mysqli_query($dblink, $query_2) or die ( mysqli_error($dblink) );
                                while( $row_2 = mysqli_fetch_array($result_2) ) {
                                    $selected = ($row_2['usersinfoLandsdel_id'] == $row_1['usersinfo_FK_usersinfoLandsdel_id']) ? 'selected="selected"' : '';
                                    echo '<option value="'.$row_2['usersinfoLandsdel_id'].'" '.$selected.'>'.$row_2['usersinfoLandsdel_name'].'</option>';
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                    <!-- Køn -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <label class="input-group-text" for="inputGroupSelect_KØN">Køn</label>
                            </div>
                            <select class="custom-select" id="inputGroupSelect_KØN" name="FORMNAME_Kon">
                                <option selected disabled hidden>Køn</option>
                                <?php
                                $query_3 = "SELECT * FROM users_gender";
                                $result_3 = mysqli_query($dblink, $query_3) or die ( mysqli_error($dblink) );
                                while( $row_3 = mysqli_fetch_array($result_3) ) {
                                    $selected = ($row_3['usersGender_id'] == $row_1['users_FK_usersGender_id']) ? 'selected="selected"' : '';
                                    echo '<option value="'.$row_3['usersGender_id'].'" '.$selected.'>'.$row_3['usersGender_name'].'</option>';
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                </div><!-- //.row -->
            </div><!-- //.container -->
        </div><!-- //.row -->
        <div class="row" style="display: none;">
            <div class="container mt-3 mb-3">
                <div class="row mb-3">
                    <div class="col-md-3">
                        &nbsp;
                    </div>
                    <div class="col-md-3">
                        &nbsp;
                    </div>
                    <div class="col-md-3">
                        &nbsp;
                    </div>
                    <div class="col-md-3">
                        <button type="button" class="btn JQUERY_ACTION_minimize_search">Minimer Søgning</button>
                    </div>
                </div><!-- //.row -->
                <div class="row mb-3">
                    <!-- Min.Højde -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Min.Højde</span>
                                <span class="input-group-text">CM</span>
                            </div>
                            <input type="number" class="form-control" placeholder="Min.Højde" min="0" name="FORMNAME_MinHojde">
                        </div>
                    </div>
                    <!-- Max.Højde -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Max.Højde</span>
                                <span class="input-group-text">CM</span>
                            </div>
                            <input type="number" class="form-control" placeholder="Max.Højde" min="0" name="FORMNAME_MaxHojde">
                        </div>
                    </div>
                    <!-- Etnicitet -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <label class="input-group-text" for="inputGroupSelect_ETNICITET">Etnicitet</label>
                            </div>
                            <select class="custom-select" id="inputGroupSelect_ETNICITET" name="FORMNAME_Etnicitet">
                                <option selected disabled hidden>Etnicitet</option>
                                <?php
                                $query_4 = "SELECT * FROM users_gender";
                                $result_4 = mysqli_query($dblink, $query_4) or die ( mysqli_error($dblink) );
                                while( $row_4 = mysqli_fetch_array($result_4) ) {
                                    $selected = ($row_4['usersinfoEtnicitet_id'] == $row_1['usersinfo_FK_usersinfoEtnicitet_id']) ? 'selected="selected"' : '';
                                    echo '<option value="'.$row_4['usersinfoEtnicitet_id'].'" '.$selected.'>'.$row_4['usersinfoEtnicitet_name'].'</option>';
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                    <!-- Sprog -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <label class="input-group-text" for="inputGroupSelect_SPROG">Sprog</label>
                            </div>
                            <select class="custom-select" id="inputGroupSelect_SPROG" name="FORMNAME_Sprog">
                                <option selected disabled hidden>Sprog</option>
                                <?php
                                $query_5 = "SELECT * FROM users_info_sprog";
                                $result_5 = mysqli_query($dblink, $query_5) or die ( mysqli_error($dblink) );
                                while( $row_5 = mysqli_fetch_array($result_5) ) {
                                    $selected = ($row_5['usersinfoSprog_id'] == $row_1['usersinfo_FK_usersinfoSprog_id']) ? 'selected="selected"' : '';
                                    echo '<option value="'.$row_5['usersinfoSprog_id'].'" '.$selected.'>'.$row_5['usersinfoSprog_name'].'</option>';
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                </div><!-- //.row -->
                <div class="row">
                    <!-- Min.Vægt -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Min.Vægt</span>
                                <span class="input-group-text">KG</span>
                            </div>
                            <input type="number" class="form-control" placeholder="Min.Vægt" min="0" name="FORMNAME_MinVaegt">
                        </div>
                    </div>
                    <!-- Max.Vægt -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <span class="input-group-text">Max.Vægt</span>
                                <span class="input-group-text">KG</span>
                            </div>
                            <input type="number" class="form-control" placeholder="Max.Vægt" min="0" name="FORMNAME_MaxVaegt">
                        </div>
                    </div>
                    <!-- Tatoveringer -->
                    <div class="col-md-3">
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <label class="input-group-text" for="inputGroupSelect_TATOVERINGER">Tatoveringer</label>
                            </div>
                            <select class="custom-select" id="inputGroupSelect_TATOVERINGER" name="FORMNAME_Tatoveringer">
                                <option selected disabled hidden>Tatoveringer</option>
                                <?php
                                $query_6 = "SELECT * FROM users_info_tatoveringer";
                                $result_6 = mysqli_query($dblink, $query_6) or die ( mysqli_error($dblink) );
                                while( $row_6 = mysqli_fetch_array($result_6) ) {
                                    $selected = ($row_6['usersinfoTatoveringer_id'] == $row_1['usersinfo_FK_usersinfoTatoveringer_id']) ? 'selected="selected"' : '';
                                    echo '<option value="'.$row_6['usersinfoTatoveringer_id'].'" '.$selected.'>'.$row_6['usersinfoTatoveringer_name'].'</option>';
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                    <!-- Kategorier -->
                    <div class="col-md-3">
                        <?php
                        //include_once("include/files/www-files/form_parts/searchprofiles_multiselect/multiselect_kategori.php");
                        ?>
                        <div class="input-group">
                            <div class="input-group-prepend">
                                <label class="input-group-text" for="inputGroupSelect_KATEGORI">Kategorier</label>
                            </div>
                            <select class="custom-select" id="inputGroupSelect_KATEGORI" name="FORMNAME_Kategorier">
                                <option selected disabled hidden>Kategorier</option>
                                <?php
                                $query_7 = "SELECT * FROM users_info_kategorier";
                                $result_7 = mysqli_query($dblink, $query_7) or die ( mysqli_error($dblink) );
                                while( $row_7 = mysqli_fetch_array($result_7) ) {
                                    $selected = ($row_7['usersinfoKategorier_id'] == $row_1['usersinfo_FK_usersinfoKategorier_id']) ? 'selected="selected"' : '';
                                    echo '<option value="'.$row_7['usersinfoKategorier_id'].'" '.$selected.'>'.$row_7['usersinfoKategorier_name'].'</option>';
                                }
                                ?>
                            </select>
                        </div>
                    </div>
                </div><!-- //.row -->
            </div><!-- //.container -->
        </div><!-- //.row (udvidet søgning) -->
    </form>
</div>
<div class="mt-3"></div>














































<div class="container">
    <?php
    if( isset($_POST['FORMNAME_submit_search']) ) {
        
        //include_once("functions.pagination.class.php"); // include pagination
        
        $qur = "";
        
        @$SearchKeywords = mysqli_real_escape_string($dblink, $_POST['FORMNAME_SogProfilBar_Keywords']); // Search Bar Profil Keywords
        @$MinAlder = mysqli_real_escape_string($dblink, $_POST['FORMNAME_MinAlder']); // Minimum Alder
        @$MaxAlder = mysqli_real_escape_string($dblink, $_POST['FORMNAME_MaxAlder']); // Maximum Alder
        @$Landsdel = mysqli_real_escape_string($dblink, $_POST['FORMNAME_Landsdel']); // Landsdel
        @$Kon = mysqli_real_escape_string($dblink, $_POST['FORMNAME_Kon']); // Køn
        @$MinHojde = mysqli_real_escape_string($dblink, $_POST['FORMNAME_MinHojde']); // Minimum Højde
        @$MaxHojde = mysqli_real_escape_string($dblink, $_POST['FORMNAME_MaxHojde']); // Maximum Højde
        @$Etnicitet = mysqli_real_escape_string($dblink, $_POST['FORMNAME_Etnicitet']); // Etnicitet
        @$Sprog = mysqli_real_escape_string($dblink, $_POST['FORMNAME_Sprog']); // Sprog
        @$MinVaegt = mysqli_real_escape_string($dblink, $_POST['FORMNAME_MinVaegt']); // Minimum Vægt
        @$MaxVaegt = mysqli_real_escape_string($dblink, $_POST['FORMNAME_MaxVaegt']); // Maximum Vægt
        @$Tatoveringer = mysqli_real_escape_string($dblink, $_POST['FORMNAME_Tatoveringer']); // Tatoveringer
        @$Kategorier = mysqli_real_escape_string($dblink, $_POST['FORMNAME_Kategorier']); // Kategorier
        
        // Søgning af ALT starter her.
        $query = "SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'";
        $result = mysqli_query($dblink, $query) or die(mysqli_error($dblink));
        $query = htmlentities("
        SELECT DISTINCT
            users_id,
            users_fornavn,
            users_mellemnavn,
            users_efternavn,
            users_email,
            users_city,
            users_zipcode,
            users_birthday_date,
            users_address,
            users_tlf_telefon,
            users_tlf_mobil,
            
            usersinfo_profilesearch_viewable,
            usersinfo_hojde_cm,
            usersinfo_vaegt_kg,
            usersinfo_ErfaringKvalifikationer,
            usersinfo_beskaeftigelse,
            usersinfo_FK_usersinfoHairColor_id,
            usersinfo_FK_usersinfoEyeColor_id,
            usersinfo_FK_usersinfoBukseBredde_id,
            usersinfo_FK_usersinfoBukseLaengde_id,
            usersinfo_FK_usersinfoBluseStorrelse_id,
            usersinfo_FK_usersinfoSkoStorrelse_id,
            usersinfo_FK_usersinfoLandsdel_id,
            usersinfo_FK_usersinfoEtnicitet_id,
            usersinfo_FK_usersinfoTatoveringer_id,
            usersinfo_FK_usersinfoKategorier_id,
            usersinfo_FK_usersinfoSprog_id,
            
            usersGender_id,
            usersGender_name,
            
            usersinfoLandsdel_id,
            usersinfoLandsdel_name,
            
            usersinfoEtnicitet_id,
            usersinfoEtnicitet_name,
            
            usersinfoTatoveringer_id,
            usersinfoTatoveringer_name,
            
            usersinfoSprog_id,
            usersinfoSprog_name,
            
            usersinfoKategorier_id,
            usersinfoKategorier_name
        FROM
            users
        
        INNER JOIN users_info ON users.users_id = users_info.usersinfo_FK_users_id
        
        INNER JOIN users_gender ON users.users_FK_usersGender_id = users_gender.usersGender_id
        INNER JOIN users_info_landsdel ON users_info.usersinfo_FK_usersinfoLandsdel_id = users_info_landsdel.usersinfoLandsdel_id
        INNER JOIN users_info_etnicitet ON users_info.usersinfo_FK_usersinfoEtnicitet_id = users_info_etnicitet.usersinfoEtnicitet_id
        INNER JOIN users_info_tatoveringer ON users_info.usersinfo_FK_usersinfoTatoveringer_id = users_info_tatoveringer.usersinfoTatoveringer_id
        INNER JOIN users_info_sprog ON users_info.usersinfo_FK_usersinfoSprog_id = users_info_sprog.usersinfoSprog_id
        INNER JOIN users_info_kategorier ON users_info.usersinfo_FK_usersinfoKategorier_id = users_info_kategorier.usersinfoKategorier_id
        ");
        
        // Search patterns - needs editing! from old-original to my version so it fits!
        include_once("index.search_patterns_setup.php");
        
        // fortsætter herunder
        $query .= " GROUP BY users_id, usersinfo_FK_users_id";
        $result = mysqli_query($dblink, $query) or die(mysqli_error($dblink));
        
        // hvis der ikke er EN række i udtrækket, vises en fejlbesked (??? på search eller ???)
        //$searchCount=mysqli_num_rows($result); // Behøver jeg denne del (???)
        
        //  OG START PÅ "<?PHP ?\>" - HTML KOMMER HER IFØLGE TIDLIGERE KODE! (tror jeg skipper den del!)
        
        if( mysqli_num_rows($result) > 0 ) {
            while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
                echo '<p>her er jeg!</p>'; // indsæt søge resultater her!
            }
        } else {
            $row = '<p>Der var desværre ingen resultater på din søgning. Prøv igen.</p>';
            echo '<h3>'.$row.'</h3>';
            die();
        }
    } else {
        //include_once("functions.pagination.class.php"); // include pagination
        include_once("index.no_search_show_cards_profiles.php");
    }
    ?>
</div>















































<script>
    $('.JQUERY_ACTION_expand_search').on('click', function () {
        $(this).parent().parent().parent().next().next().show(1000);
    });
    $('.JQUERY_ACTION_minimize_search').on('click', function () {
        $(this).parent().parent().parent().parent().hide(1000);
    });
</script>

functions.pagination.class.php

<?php
class pagination {
    /*
    Properties array
    @var array
    @access private
    */
    private $_properties = array();
    /*
    Default configurations
    @var array
    @access public
    */
    public $_defaults = array(
    'page' => 1,
    'perPage' => 10
    );
    /*
    Constructor
    
    @param array $array   Array of results to be paginated
    @param int   $curPage The current page interger that should used
    @param int   $perPage The amount of items that should be show per page
    @return void
    @access public
    */
    public function __construct($array, $curPage = null, $perPage = null) {
        $this->array   = $array;
        $this->curPage = ($curPage == null ? $this->defaults['page']    : $curPage);
        $this->perPage = ($perPage == null ? $this->defaults['perPage'] : $perPage);
    }
    /*
    Global setter
    
    Utilises the properties array
    
    @param string $name  The name of the property to set
    @param string $value The value that the property is assigned
    @return void
    @access public
    */
    public function __set($name, $value) {
        $this->_properties[$name] = $value;
    }
    /*
    Global getter
    
    Takes a param from the properties array if it exists
    
    @param string $name The name of the property to get
    @return mixed Either the property from the internal
    properties array or false if isn't set
    @access public
    */
    public function __get($name) {
        if (array_key_exists($name, $this->_properties)) {
            return $this->_properties[$name];
        }
        return false;
    }
    /*
    Set the show first and last configuration
    
    This will enable the "<< first" and "last >>" style
    links
    
    @param boolean $showFirstAndLast True to show, false to hide.
    @return void
    @access public
    */
    public function setShowFirstAndLast($showFirstAndLast) {
        $this->_showFirstAndLast = $showFirstAndLast;
    }
    /*
    Set the main seperator character
    
    By default this will implode an empty string
    
    @param string $mainSeperator The seperator between the page numbers
    @return void
    @access public
    */
    public function setMainSeperator($mainSeperator) {
        $this->mainSeperator = $mainSeperator;
    }
    /*
    Get the result portion from the provided array
    
    @return array Reduced array with correct calculated offset
    @access public
    */
    public function getResults() {
        // Assign the page variable
        if (empty($this->curPage) !== false) {
            $this->page = $this->curPage; // using the get method
        } else {
            $this->page = 1; // if we don't have a page number then assume we are on the first page
        }
        // Take the length of the array
        $this->length = count($this->array);
        // Get the number of pages
        $this->pages = ceil($this->length / $this->perPage);
        // Calculate the starting point
        $this->start = ceil(($this->page - 1) * $this->perPage);
        // return the portion of results
        return array_slice($this->array, $this->start, $this->perPage);
    }
    /*
    Get the html links for the generated page offset
    
    @param array $params A list of parameters (probably get/post) to
    pass around with each request
    @return mixed  Return description (if any)...
    @access public
    */
    public function getLinks($params = array()) {
        // Initiate the links array
        $plinks = array();
        $links = array();
        $slinks = array();
        // Concatenate the get variables to add to the page numbering string
        $queryUrl = '';
        if (!empty($params) === true ) {
            unset($params['page']);
            $queryUrl = '&amp;'.http_build_query($params);
        }
        // If we have more then one pages
        if (($this->pages) > 1) {
            // Assign the 'previous page' link into the array if we are not on the first page
            if ($this->page != 1) {
                if ($this->_showFirstAndLast) {
                    $plinks[] = ' <a href="?page=1'.$queryUrl.'">&laquo;&laquo; First </a> ';
                }
                $plinks[] = ' <a href="?page='.($this->page - 1).$queryUrl.'">&laquo; Prev</a> ';
            }
            // Assign all the page numbers & links to the array
            for ($j = 1; $j < ($this->pages + 1); $j++) {
                if ($this->page == $j) {
                    $links[] = ' <a class="selected">'.$j.'</a> '; // If we are on the same page as the current item
                } else {
                    $links[] = ' <a href="?page='.$j.$queryUrl.'">'.$j.'</a> '; // add the link to the array
                }
            }
            // Assign the 'next page' if we are not on the last page
            if ($this->page < $this->pages) {
                $slinks[] = ' <a href="?page='.($this->page + 1).$queryUrl.'"> Next &raquo; </a> ';
                if ($this->_showFirstAndLast) {
                    $slinks[] = ' <a href="?page='.($this->pages).$queryUrl.'"> Last &raquo;&raquo; </a> ';
                }
            }
            // Push the array into a string using any some glue
            return implode(' ', $plinks).implode($this->mainSeperator, $links).implode(' ', $slinks);
        }
        return;
    }
}

functions.php

<?php
// clause CHECK AND function //
function clauseCHECK_AND () {
    global $clause;
    if( isset($clause) ) {
        $clause = " AND ";
        //echo "CLAUSE ER WHERE:";
    } else {
        $clause = " WHERE ";
    }
}

// clause CHECK OR function //
function clauseCHECK_OR () {
    global $clause;
    if( isset($clause) ) {
        $clause = " OR ";
        //echo "CLAUSE ER WHERE:";
    } else {
        $clause = " WHERE ";
    }
}
?>

index.no_search_show_cards_profiles.php

<div class="container">
    <div class="card-columns">
        <?php
        $query_100 = "SELECT * FROM users ORDER BY users_id DESC";
        $result_100 = mysqli_query($dblink, $query_100) or die(mysqli_error($dblink));
        if( mysqli_num_rows($result_100) > 0 ) {
            if( mysqli_num_rows($result_100) > 0 ) {
                while( $row_100 = mysqli_fetch_array($result_100) ) {
                    $user_id = $row_100['users_id'];
                    $user_fornavn = $row_100['users_fornavn'];
                    
                    $dateOfBirth = $row_100['users_birthday_date']; // output: Y-m-d (Year-Month-Day)
                    $today = date("Y-m-d"); // current date today
                    $diff = date_diff(date_create($dateOfBirth), date_create($today)); // difference between the two dates
                    ?>
                        <div class="card">
                            <a href="#" title="Profil">
                                <img class="card-img-top img-responsive img-rounded" src="https://dummyimage.com/250x330/000/fff.jpg" alt="Billede">
                            </a>
                            <div class="card-body">
                                <h5 class="card-title"><b><?php echo $user_fornavn.',&nbsp;'.$diff->format('%y'); ?></b></h5>
                                <p class="card-text">#<?php echo $user_id; ?></p>
                            </div><!-- //.card-body -->
                        </div><!-- //.card -->
                    <?php
                }
            }
        } else {
            echo 'Intet at vise lige nu.';
        }
        ?>
    </div>
</div>

index.search_patterns_setup.php

<?php
/////////////////////////// ALDER ///////////////////////////

// ORIGINAL
/*
if( $minAlder > 0 ) {
    $time = new DateTime('now');
    $newtime = $time->modify('-'.$minAlder.' year')->format('Y-m-d');
    //echo $newtime;
    echo clauseCHECK();
    $query .=  $clause." user_dob <= '$newtime' ";
    //$clause   .= " OR ";//Change  to OR after 1st WHERE
}
if( $maxAlder > 0 ) {
    echo clauseCHECK();
    $time = new DateTime('now');
    $newtime = $time->modify('-'.$maxAlder.' year')->format('Y-m-d');
    //echo $newtime;
    $query .= $clause." user_dob >= '$newtime' ";
    //$clause .= " OR ";//Change  to OR after 1st WHERE
}
*/

// MY VERSION

if( $MinAlder > 0 ) {
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    // dob = Date Of Birth
    $time = new DateTime('now');
    $newtime = $time->modify('-'.$MinAlder.' year')->format('Y-m-d');
    $query .= $clause." users_birthday_date <= '$newtime' ";
}
if( $MaxAlder > 0 ) {
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    // dob = Date Of Birth
    $time = new DateTime('now');
    $newtime = $time->modify('-'.$MaxAlder.' year')->format('Y-m-d');
    $query .= $clause." users_birthday_date >= '$newtime' ";
}

/////////////////////////// KØN ///////////////////////////

// ORIGINAL
/*
if( !empty($reg_koen) ) {
    echo clauseCHECK();
    $query .= $clause." user_koen = '$reg_koen' ";
    //$clause .= " OR ";//Change  to OR after 1st WHERE
}
*/

// MY VERSION

if( !empty($Kon) ) {
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause." usersGender_id = '$Kon' ";
}

/////////////////////////// LANDSDEL ///////////////////////////

// ORIGINAL
/*
if( !empty($reg_Landsdel) ) {
    echo clauseCHECK();
    $query .= $clause." user_landsdel = '$reg_Landsdel' ";
    //$clause .= " OR ";//Change  to OR after 1st WHERE
}
*/

// MY VERSION

if( !empty($Landsdel) ) {
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause." usersinfoLandsdel_id = '$Landsdel' ";
}

/////////////////////////// ETNICITET ///////////////////////////

// ORIGINAL
/*
if( !empty($reg_etnic) ) {
    echo clauseCHECK();
    $query .= $clause." user_etnicitet = '$reg_etnic' ";
    //$clause .= " OR ";//Change  to OR after 1st WHERE
}
*/

// MY VERSION

if( !empty($Etnicitet) ) {
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause." usersinfoEtnicitet_id = '$Etnicitet' ";
}

































/////////////////////////// TATOVERINGER ///////////////////////////

// ORIGINAL
/*
if( !empty($_POST['check_listTat']) ) {
    // Loop to store and display values of individual checked checkbox.
    foreach($_POST['check_listTat'] as $c) {
        if( !empty($c) ) {
            echo clauseCHECKor();
            $qur = "userPers_fk_tat_id";
            $query .= $clause."".$qur." LIKE '%{$c}%'";
            //$clause   = " OR ";//Change  to OR after 1st WHERE
        }
    }
}
*/

// MY VERSION

if( !empty($Tatoveringer) ) {
    // når jeg skifter til checkboxes, bruger jeg clauseCHECK_OR()! Som den bruges i de originale! Tjek for eksempler!
    
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause." usersinfoTatoveringer_id = '$Tatoveringer' ";
}

/////////////////////////// SPROG ///////////////////////////

// ORIGINAL
/*
if( !empty($_POST['check_listSprog']) ) {
    // Loop to store and display values of individual checked checkbox.
    foreach($_POST['check_listSprog'] as $c) {
        if( !empty($c) ) {
            echo clauseCHECKor();
            $qur = "userPers_fk_sprog_id";
            $query .= $clause."".$qur." LIKE '%{$c}%'";
            $clause = " OR "; //Change to OR after 1st WHERE
        }
    }
    //echo $query;//Remove after testing
}
*/

// MY VERSION

if( !empty($Sprog) ) {
    // når jeg skifter til checkboxes, bruger jeg clauseCHECK_OR()! Som den bruges i de originale! Tjek for eksempler!
    
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause." usersinfoSprog_id = '$Sprog' ";
}

/////////////////////////// KATEGORIER ///////////////////////////

// ORIGINAL
/*
if( !empty($_POST['check_listKat']) ) {
    // Loop to store and display values of individual checked checkbox.
    // Loop to store and display values of individual checked checkbox.
    foreach($_POST['check_listKat'] as $c) {
        if( !empty($c) ) {
            echo clauseCHECKor();
            $qur = "userPers_fk_kat_id";
            $query .= $clause."".$qur." LIKE '%{$c}%'";
            $clause = " OR ";//Change  to OR after 1st WHERE
        }
    }
}
*/

// MY VERSION

if( !empty($Kategorier) ) {
    // når jeg skifter til checkboxes, bruger jeg clauseCHECK_OR()! Som den bruges i de originale! Tjek for eksempler!
    
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause." usersinfoKategorier_id = '$Kategorier' ";
}

/////////////////////////// VÆGT ///////////////////////////

// ORIGINAL
/*
if( $reg_vaegt_min>0 && $reg_vaegt_max<1 ) {
    $reg_vaegt_max="999";
}
if( $reg_vaegt_max>0 && $reg_vaegt_min<1 ) {
    $reg_vaegt_min="1";
}
if( $reg_vaegt_min>0 || $reg_vaegt_min>0 ) {
    echo clauseCHECK();
    //echo "<br><hr><br>HER er vægt.<br><br>";
    $query .= $clause."user_vaegt BETWEEN $reg_vaegt_min AND $reg_vaegt_max  ";
    $clause = " OR ";
}
*/

// MY VERSION

if( $MinVaegt>0 && $MaxVaegt<1 ) {
    $reg_vaegt_max="999";
}
if( $MaxVaegt>0 && $MinVaegt<1 ) {
    $reg_vaegt_min="1";
}
if( $MinVaegt>0 || $MinVaegt>0 ) {
    // når jeg skifter til checkboxes, bruger jeg clauseCHECK_OR()! Som den bruges i de originale! Tjek for eksempler!
    
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause."userinfo_vaegt_kg BETWEEN $MinVaegt AND $MaxVaegt  ";
    $clause = " OR ";
}

/////////////////////////// HØJDE ///////////////////////////

// ORIGINAL
/*
if( $reg_hoejde_min>0 && $reg_hoejde_max<1 ) {
    $reg_hoejde_max="999";
}
if( $reg_hoejde_max>0 && $reg_hoejde_min<1 ) {
    $reg_hoejde_min="1";
}
if( $reg_hoejde_min>0 || $reg_hoejde_min>0 ) {
    echo clauseCHECK();
    //echo "<br><hr><br>HER er vægt.<br><br>";
    $query .= $clause."user_hoejde BETWEEN $reg_hoejde_min AND $reg_hoejde_max ";
    $clause = " OR ";
}
*/

// MY VERSION

if( $MinHojde>0 && $MaxHojde<1 ) {
    $reg_hoejde_max="999";
}
if( $MaxHojde>0 && $MinHojde<1 ) {
    $reg_hoejde_min="1";
}
if( $MinHojde>0 || $MinHojde>0 ) {
    // når jeg skifter til checkboxes, bruger jeg clauseCHECK_OR()! Som den bruges i de originale! Tjek for eksempler!
    
    //echo clauseCHECK_AND();
    echo "<p>".clauseCHECK_AND()."</p>";
    
    $query .= $clause."usersinfo_hojde_cm BETWEEN $MinHojde AND $MaxHojde ";
    $clause = " OR ";
}

/////////////////////////// KEYWORDS ///////////////////////////

// ORIGINAL
/*
//if keyword set, goes here
if( !$keyword=="" ) {
    echo clauseCHECK();//Initial clause
    $c=" user_unikID LIKE '%$keyword%' OR user_fornavn LIKE '%$keyword%' OR user_efternavn LIKE '%$keyword%' OR user_faerdigheder LIKE '%$keyword%' OR user_etnicitet LIKE '%$keyword%' OR user_haarfarve LIKE '%$keyword%' OR user_haartype LIKE '%$keyword%'  OR user_ojenfarve LIKE '%$keyword%'  ";
    
    $query .= $clause." $c";
}
*/

// MY VERSION

//if keyword set, goes here
if( !$SearchKeywords=="" ) {
    //echo clauseCHECK_AND(); // Initial clause
    echo "<p>".clauseCHECK_AND()."</p>"; // Initial clause
    
    // unikID = old wwww-files :: ROOT/call/reg_sessioncall.php :: line ~290+ (cirka)
    
    // search query
    /*
    $c = "
    user_unikID LIKE '%$SearchKeywords%'
    OR
    users_fornavn LIKE '%$SearchKeywords%'
    OR
    users_mellemnavn LIKE '%$SearchKeywords%'
    OR
    users_efternavn LIKE '%$SearchKeywords%'
    
    
    OR
    users_faerdigheder LIKE '%$SearchKeywords%'
    OR
    user_etnicitet LIKE '%$SearchKeywords%'
    OR
    user_haarfarve LIKE '%$SearchKeywords%'
    OR
    user_haartype LIKE '%$SearchKeywords%'
    OR
    user_ojenfarve LIKE '%$SearchKeywords%'
    ";
    */
    $c = "
    user_unikID LIKE '%$SearchKeywords%'
    OR
    users_fornavn LIKE '%$SearchKeywords%'
    OR
    users_mellemnavn LIKE '%$SearchKeywords%'
    OR
    users_efternavn LIKE '%$SearchKeywords%'
    ";
    
    $query .= $clause." $c";
}

?>

-----------------------------------------------------------------

Okay, as you might have guessed, the code is a little long. (yay).

Okay, so i have "tried" to clean up the past coding the best i could, BUT, here is where i get lost a bit. In the main query on PAGE_searchprofiles.php - am i supposed to make a lot of inner joins? I did that one myself, but wonna make sure BECAUSE! I have a LOT of tables and rows in the DB.

I have a main table, users, where basic info is like firstname, etc. Then i have another called users_info, having a lot of integers with 1ns and zeros... those numbers are supposed to go to another table, for each table with Foreign Keys (FK), containing names, etc of forms and so on. I thought it would be better this way for the select at the time, and it was, but also worse for the search query because i have no idea if i am doing that part correct.

Also with the file (index.search_patterns_setup.php) - not sure if i do the if/else's correct, since i just reused the old coders parameters and just changed the variables and queries to my database and variable names so they would look perfectly, and they do, only not sure if it's working or not :/

Mostly because whenever i make a search, nothing comes out, no errors either, just no rows. Not sure if i pinpoint the whole thing at different ways with id's etc with inner joins at the main query and the parameters if/else's statements.

This is my current DB (query a little bit, but if you can check it out, go for it, just remember, it is in Danish some of it and some in English... combined the 2 languages for some text hehe):

-- phpMyAdmin SQL Dump
-- version 4.7.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Mar 10, 2018 at 10:35 AM
-- Server version: 5.7.18
-- PHP Version: 7.1.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `u1d4zzx`
--

-- --------------------------------------------------------

--
-- Table structure for table `carousel1`
--

CREATE TABLE `carousel1` (
  `carousel1_id` int(11) NOT NULL,
  `carousel1_img_url` text NOT NULL,
  `carousel1_title` text NOT NULL,
  `carousel1_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `carousel1`
--

INSERT INTO `carousel1` (`carousel1_id`, `carousel1_img_url`, `carousel1_title`, `carousel1_description`) VALUES
(1, '1.PNG', 'No Title 1', 'No Description 1'),
(2, '2.jpg', 'No Title 2', 'No Description 2'),
(3, '3.jpg', 'No Title 3', 'No Description 3'),
(4, '4.jpeg', 'No Title 4', 'No Description 4');

-- --------------------------------------------------------

--
-- Table structure for table `page_work1_videos`
--

CREATE TABLE `page_work1_videos` (
  `pw1videos_id` int(11) NOT NULL,
  `pw1videos_link` text NOT NULL,
  `pw1videos_director` text NOT NULL,
  `pw1videos_title` text NOT NULL,
  `pw1videos_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `page_work1_videos`
--

INSERT INTO `page_work1_videos` (`pw1videos_id`, `pw1videos_link`, `pw1videos_director`, `pw1videos_title`, `pw1videos_text`) VALUES
(6, 'DxiOVmuZyw4', 'Simon Bonde', 'Tuborg Classic', 'All Cast'),
(7, 'BDhC7DU0yYE', ' ', 'Hi-Fi Klubben', 'Extras'),
(8, 'nN1GLigSw40', 'Jannik Vestmar', 'Krifa', 'All Cast'),
(9, 'wBC1WWO9AUc', 'Stevan Treshow', 'Oddset', 'All Cast'),
(10, 'FH5cw-n00T8', 'Stevan Treshow', 'Oddset', 'All Cast'),
(11, 'L7D1G8vgkEQ', 'Stevan Treshow', 'Oddset', 'All Cast'),
(12, '_kASjW_aPbQ', 'Nadia Marquard', 'Emelie Sandé Wonder', 'Cast & Extras'),
(14, '0rbA2qBDn8A', ' ', 'Ikano Bank', 'Cast '),
(15, 'NYndyqp1gDU', ' ', 'Just Eat', 'All Cast'),
(16, 't9diF_GKImA', ' ', 'Just Eat', 'All Cast'),
(17, 'zvK8WL43kdY', 'Jonas Elmer', 'Betsafe', 'Cast '),
(18, '0bPWGoTRFc0', 'Michael Langhoff', 'Øresundsbroen', 'Extras'),
(19, 'MBcU7VCh_MM', 'Michael Langhoff', 'Øresundsbroen', 'Extras'),
(20, '_m_KUK6QFS0', 'Michael Langhoff', 'Øresundsbroen', 'Extras'),
(21, 'p7QrsVAEwIU', 'Michael Langhoff', 'Øresundsbroen', 'Extras'),
(23, 'hmdlCmLrD8A', 'Simon Bonde & Michael Spooner', 'Ladbrokes', 'Cast & Extras'),
(29, 'TjHSXd0CcNI', 'Fredrik Callinggard', 'Ofir', 'All Cast'),
(30, 'CfAyPqhbeCM', 'Mats Stenberg', 'Casino.dk', 'Ekstra'),
(31, 'Aml0d-e6czg', 'Michael Langhoff', 'DayDose', 'Extras'),
(32, '5AdMpkKrlDE', '', 'Unibet ', 'Extras'),
(33, 'jY-PZ4tMwXU', '', 'Unibet', 'Extras'),
(38, '7Cd3UbueGzM', 'Fredrik Callinggard', 'Ofir', 'All Cast'),
(42, 'R3JqzsNuer8', 'Gaute Hesthagen ', 'Telenor', 'All Cast'),
(46, 'mmHpWlTZEk4', 'Gaute Hesthagen ', 'Telenor', 'All Cast'),
(47, 'W3p0yzLc_js', 'Gaute Hesthagen ', 'Telenor', 'All Cast'),
(49, '8IIGUBV-jqo', '  ', 'Mobilepay', 'All Cast'),
(50, 'MQ_uMGxRvH8', '', 'Bygma', 'Extras');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `users_id` int(11) NOT NULL,
  `users_ActiveState` int(11) NOT NULL DEFAULT '0',
  `users_fornavn` varchar(255) NOT NULL,
  `users_mellemnavn` varchar(255) NOT NULL,
  `users_efternavn` varchar(255) NOT NULL,
  `users_email` text NOT NULL,
  `users_password` text NOT NULL,
  `users_FK_usersGender_id` int(11) NOT NULL DEFAULT '0',
  `users_city` varchar(255) NOT NULL,
  `users_zipcode` int(11) NOT NULL,
  `users_birthday_date` date DEFAULT NULL,
  `users_address` text NOT NULL,
  `users_tlf_telefon` int(11) NOT NULL DEFAULT '0',
  `users_tlf_mobil` int(11) NOT NULL DEFAULT '0',
  `users_FK_usersSubscription_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`users_id`, `users_ActiveState`, `users_fornavn`, `users_mellemnavn`, `users_efternavn`, `users_email`, `users_password`, `users_FK_usersGender_id`, `users_city`, `users_zipcode`, `users_birthday_date`, `users_address`, `users_tlf_telefon`, `users_tlf_mobil`, `users_FK_usersSubscription_id`) VALUES
(2, 1, 'd', 'd', 'd', 'd@yahoo.co.uk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 2, 'FREDERIKSBERG C', 1851, '1992-11-08', 'Nyvej 16, 2TV', 44444444, 44444444, 3),
(3, 0, 'dwjioj', 'odj', 'woidjo', 'derp@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 2, 'd C', 1851, '1992-11-08', 'diwjdo, 2TV', 44444444, 44444444, 2),
(4, 0, 'Danie', ' ', 'Pedersen', 'd@yahoo.com', '4c65f054573c27e35eefcdd5d6b31091516827fa', 2, 'd C', 1851, '1992-11-08', ' ', 44444444, 44444444, 1),
(5, 0, 'Uglen', ' ', 'Elsker', 'demo1@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 1, 'd C', 6666, '1992-11-08', ' ', 44444444, 44444444, 1),
(6, 0, 'Ugleerne', ' ', 'Elskerne', 'demo2@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 1, 'd C', 6666, '1992-11-08', ' ', 44444444, 44444444, 1),
(7, 0, 'derpy', ' ', 'derp', 'demo3@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 1, 'd C', 2000, '1992-11-08', ' ', 44444444, 51444379, 3),
(8, 0, 'wdwe', '', 'dwad', 'demo4@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 1, 'd C', 5151, '2018-12-31', '', 51444379, 44444444, 1),
(9, 0, 'wdwe', '', 'dwad', 'demo5@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 1, 'd C', 5151, '2018-12-31', '', 44444444, 51444379, 1),
(10, 0, 'Karsten', '', 'Larsen', 'demo7@yahoo.dk', '4c65f054573c27e35eefcdd5d6b31091516827fa', 2, 'd C', 1851, '1992-11-08', '', 51444379, 44444444, 1);

-- --------------------------------------------------------

--
-- Table structure for table `users_files`
--

CREATE TABLE `users_files` (
  `usersFiles_id` int(11) NOT NULL,
  `usersFiles_FK_users_id` int(11) NOT NULL DEFAULT '0',
  `usersFiles_avatar_1` text NOT NULL,
  `usersFiles_image_1` text NOT NULL,
  `usersFiles_image_2` text NOT NULL,
  `usersFiles_image_3` text NOT NULL,
  `usersFiles_image_4` text NOT NULL,
  `usersFiles_image_5` text NOT NULL,
  `usersFiles_image_6` text NOT NULL,
  `usersFiles_image_7` text NOT NULL,
  `usersFiles_image_8` text NOT NULL,
  `usersFiles_image_9` text NOT NULL,
  `usersFiles_image_10` text NOT NULL,
  `usersFiles_video_1` text NOT NULL,
  `usersFiles_video_2` text NOT NULL,
  `usersFiles_video_3` text NOT NULL,
  `usersFiles_video_4` text NOT NULL,
  `usersFiles_video_5` text NOT NULL,
  `usersFiles_video_6` text NOT NULL,
  `usersFiles_video_7` text NOT NULL,
  `usersFiles_video_8` text NOT NULL,
  `usersFiles_video_9` text NOT NULL,
  `usersFiles_video_10` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_files`
--

INSERT INTO `users_files` (`usersFiles_id`, `usersFiles_FK_users_id`, `usersFiles_avatar_1`, `usersFiles_image_1`, `usersFiles_image_2`, `usersFiles_image_3`, `usersFiles_image_4`, `usersFiles_image_5`, `usersFiles_image_6`, `usersFiles_image_7`, `usersFiles_image_8`, `usersFiles_image_9`, `usersFiles_image_10`, `usersFiles_video_1`, `usersFiles_video_2`, `usersFiles_video_3`, `usersFiles_video_4`, `usersFiles_video_5`, `usersFiles_video_6`, `usersFiles_video_7`, `usersFiles_video_8`, `usersFiles_video_9`, `usersFiles_video_10`) VALUES
(1, 2, '9e711fd22a826bf711a2f748692cf781.jpg', '', '', '', '', '', '', '', '', '', '16b72540e572da3f3ab5753e6034ab2d--rubber-catsuit-fetish-fashion.jpg', '', '', '', '', '', '', '', 'C3322_B_1.jpg', '', ''),
(2, 10, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `users_gender`
--

CREATE TABLE `users_gender` (
  `usersGender_id` int(11) NOT NULL,
  `usersGender_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_gender`
--

INSERT INTO `users_gender` (`usersGender_id`, `usersGender_name`) VALUES
(1, 'Andet'),
(2, 'Mand'),
(3, 'Kvinde');

-- --------------------------------------------------------

--
-- Table structure for table `users_info`
--

CREATE TABLE `users_info` (
  `usersinfo_id` int(11) NOT NULL,
  `usersinfo_FK_users_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_hojde_cm` int(11) NOT NULL DEFAULT '0',
  `usersinfo_vaegt_kg` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoHairColor_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoEyeColor_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoBukseBredde_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoBukseLaengde_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoBluseStorrelse_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoSkoStorrelse_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_ErfaringKvalifikationer` text NOT NULL,
  `usersinfo_beskaeftigelse` text NOT NULL,
  `usersinfo_profilesearch_viewable` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoTatoveringer_id` varchar(255) NOT NULL,
  `usersinfo_FK_usersinfoKategorier_id` varchar(255) NOT NULL,
  `usersinfo_FK_usersinfoSprog_id` varchar(255) NOT NULL,
  `usersinfo_FK_usersinfoLandsdel_id` int(11) NOT NULL DEFAULT '0',
  `usersinfo_FK_usersinfoEtnicitet_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info`
--

INSERT INTO `users_info` (`usersinfo_id`, `usersinfo_FK_users_id`, `usersinfo_hojde_cm`, `usersinfo_vaegt_kg`, `usersinfo_FK_usersinfoHairColor_id`, `usersinfo_FK_usersinfoEyeColor_id`, `usersinfo_FK_usersinfoBukseBredde_id`, `usersinfo_FK_usersinfoBukseLaengde_id`, `usersinfo_FK_usersinfoBluseStorrelse_id`, `usersinfo_FK_usersinfoSkoStorrelse_id`, `usersinfo_ErfaringKvalifikationer`, `usersinfo_beskaeftigelse`, `usersinfo_profilesearch_viewable`, `usersinfo_FK_usersinfoTatoveringer_id`, `usersinfo_FK_usersinfoKategorier_id`, `usersinfo_FK_usersinfoSprog_id`, `usersinfo_FK_usersinfoLandsdel_id`, `usersinfo_FK_usersinfoEtnicitet_id`) VALUES
(1, 2, 176, 130, 4, 1, 14, 21, 6, 29, '                                                                                                                                                                                                                                                                                                                                                                Info tekst mangler.                                                                                                                                                                                                                                                                                                                    ', '                                                                                                                                                                                                                                                                                                                                                                Info tekst mangler.                                                                                                                                                                                                                                                                                                                    ', 0, '', '', '', 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `users_info_bluse_storrelse`
--

CREATE TABLE `users_info_bluse_storrelse` (
  `usersinfoBluseStorrelse_id` int(11) NOT NULL,
  `usersinfoBluseStorrelse_storrelse` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_bluse_storrelse`
--

INSERT INTO `users_info_bluse_storrelse` (`usersinfoBluseStorrelse_id`, `usersinfoBluseStorrelse_storrelse`) VALUES
(1, 'X-Small'),
(2, 'Small'),
(3, 'Medium'),
(4, 'Large'),
(5, 'X-Large'),
(6, 'XX-Large'),
(7, 'XXX-Large');

-- --------------------------------------------------------

--
-- Table structure for table `users_info_bukse_bredde`
--

CREATE TABLE `users_info_bukse_bredde` (
  `usersinfoBukseBredde_id` int(11) NOT NULL,
  `usersinfoBukseBredde_bredde` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_bukse_bredde`
--

INSERT INTO `users_info_bukse_bredde` (`usersinfoBukseBredde_id`, `usersinfoBukseBredde_bredde`) VALUES
(1, 24),
(2, 25),
(3, 26),
(4, 27),
(5, 28),
(6, 29),
(7, 30),
(8, 31),
(9, 32),
(10, 33),
(11, 34),
(12, 35),
(13, 36),
(14, 37),
(15, 38),
(16, 39),
(17, 40),
(18, 41),
(19, 42),
(20, 43),
(21, 44),
(22, 45);

-- --------------------------------------------------------

--
-- Table structure for table `users_info_bukse_laengde`
--

CREATE TABLE `users_info_bukse_laengde` (
  `usersinfoBukseLaengde_id` int(11) NOT NULL,
  `usersinfoBukseLaengde_laengde` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_bukse_laengde`
--

INSERT INTO `users_info_bukse_laengde` (`usersinfoBukseLaengde_id`, `usersinfoBukseLaengde_laengde`) VALUES
(1, 24),
(2, 25),
(3, 26),
(4, 27),
(5, 28),
(6, 29),
(7, 30),
(8, 31),
(9, 32),
(10, 33),
(11, 34),
(12, 35),
(13, 36),
(14, 37),
(15, 38),
(16, 39),
(17, 40),
(18, 41),
(19, 42),
(20, 43),
(21, 44),
(22, 45),
(23, 46),
(24, 47),
(25, 48);

-- --------------------------------------------------------

--
-- Table structure for table `users_info_etnicitet`
--

CREATE TABLE `users_info_etnicitet` (
  `usersinfoEtnicitet_id` int(11) NOT NULL,
  `usersinfoEtnicitet_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `users_info_eye_color`
--

CREATE TABLE `users_info_eye_color` (
  `usersinfoEyeColor_id` int(11) NOT NULL,
  `usersinfoEyeColor_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_eye_color`
--

INSERT INTO `users_info_eye_color` (`usersinfoEyeColor_id`, `usersinfoEyeColor_name`) VALUES
(1, 'Blå'),
(2, 'Grønne'),
(3, 'Brune'),
(4, 'Grå');

-- --------------------------------------------------------

--
-- Table structure for table `users_info_hair_color`
--

CREATE TABLE `users_info_hair_color` (
  `usersinfoHairColor_id` int(11) NOT NULL,
  `usersinfoHairColor_color` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_hair_color`
--

INSERT INTO `users_info_hair_color` (`usersinfoHairColor_id`, `usersinfoHairColor_color`) VALUES
(1, 'Hvidt'),
(2, 'Platinblond'),
(3, 'Lysblond'),
(4, 'Mellemblond'),
(5, 'Mørkeblond'),
(6, 'Rødblond'),
(7, 'Rød'),
(8, 'Lysebrunt'),
(9, 'Brunt'),
(10, 'Mørkebrunt'),
(11, 'Sort'),
(12, 'Gråt'),
(13, 'Grå stænk'),
(14, 'Anden');

-- --------------------------------------------------------

--
-- Table structure for table `users_info_kategorier`
--

CREATE TABLE `users_info_kategorier` (
  `usersinfoKategorier_id` int(11) NOT NULL,
  `usersinfoKategorier_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_kategorier`
--

INSERT INTO `users_info_kategorier` (`usersinfoKategorier_id`, `usersinfoKategorier_name`) VALUES
(1, 'Uddannet skuespiller'),
(2, 'Autodidakt skuespiller'),
(3, 'Ingen erfaring (indenfor film, reklamer, TV)'),
(4, 'Statist'),
(5, 'Sanger'),
(6, 'Danser'),
(7, 'Tvilling'),
(8, 'Mor til børn'),
(9, 'Far til børn');

-- --------------------------------------------------------

--
-- Table structure for table `users_info_landsdel`
--

CREATE TABLE `users_info_landsdel` (
  `usersinfoLandsdel_id` int(11) NOT NULL,
  `usersinfoLandsdel_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_landsdel`
--

INSERT INTO `users_info_landsdel` (`usersinfoLandsdel_id`, `usersinfoLandsdel_name`) VALUES
(1, 'Sjælland'),
(2, 'Jylland'),
(3, 'Odense'),
(4, 'Bornholm');

-- --------------------------------------------------------

--
-- Table structure for table `users_info_sko_storrelse`
--

CREATE TABLE `users_info_sko_storrelse` (
  `usersinfoSkoStorrelse_id` int(11) NOT NULL,
  `usersinfoSkoStorrelse_storrelse` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_sko_storrelse`
--

INSERT INTO `users_info_sko_storrelse` (`usersinfoSkoStorrelse_id`, `usersinfoSkoStorrelse_storrelse`) VALUES
(1, 17),
(2, 18),
(3, 19),
(4, 20),
(5, 21),
(6, 22),
(7, 23),
(8, 24),
(9, 25),
(10, 26),
(11, 27),
(12, 28),
(13, 29),
(14, 30),
(15, 31),
(16, 32),
(17, 33),
(18, 34),
(19, 35),
(20, 36),
(21, 37),
(22, 38),
(23, 39),
(24, 40),
(25, 41),
(26, 42),
(27, 43),
(28, 44),
(29, 45),
(30, 46),
(31, 47),
(32, 48),
(33, 49),
(34, 50);

-- --------------------------------------------------------

--
-- Table structure for table `users_info_sprog`
--

CREATE TABLE `users_info_sprog` (
  `usersinfoSprog_id` int(11) NOT NULL,
  `usersinfoSprog_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_info_sprog`
--

INSERT INTO `users_info_sprog` (`usersinfoSprog_id`, `usersinfoSprog_name`) VALUES
(1, 'Dansk'),
(2, 'Engelsk (US)'),
(3, 'Engelsk (UK)'),
(4, 'Norsk'),
(5, 'Svensk'),
(6, 'Tysk'),
(7, 'Fransk');

-- --------------------------------------------------------

--
-- Table structure for table `users_info_tatoveringer`
--

CREATE TABLE `users_info_tatoveringer` (
  `usersinfoTatoveringer_id` int(11) NOT NULL,
  `usersinfoTatoveringer_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `users_subscription`
--

CREATE TABLE `users_subscription` (
  `usersSubscription_id` int(11) NOT NULL,
  `usersSubscription_name` varchar(255) NOT NULL,
  `usersSubscription_months` int(11) NOT NULL DEFAULT '0',
  `usersSubscription_price` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_subscription`
--

INSERT INTO `users_subscription` (`usersSubscription_id`, `usersSubscription_name`, `usersSubscription_months`, `usersSubscription_price`) VALUES
(1, '1 MDR 35,-', 1, 35),
(2, '6 MDR 198,-', 6, 198),
(3, '12 MDR 349,-', 12, 349);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `carousel1`
--
ALTER TABLE `carousel1`
  ADD PRIMARY KEY (`carousel1_id`);

--
-- Indexes for table `page_work1_videos`
--
ALTER TABLE `page_work1_videos`
  ADD PRIMARY KEY (`pw1videos_id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`users_id`);

--
-- Indexes for table `users_files`
--
ALTER TABLE `users_files`
  ADD PRIMARY KEY (`usersFiles_id`);

--
-- Indexes for table `users_gender`
--
ALTER TABLE `users_gender`
  ADD PRIMARY KEY (`usersGender_id`);

--
-- Indexes for table `users_info`
--
ALTER TABLE `users_info`
  ADD PRIMARY KEY (`usersinfo_id`);

--
-- Indexes for table `users_info_bluse_storrelse`
--
ALTER TABLE `users_info_bluse_storrelse`
  ADD PRIMARY KEY (`usersinfoBluseStorrelse_id`);

--
-- Indexes for table `users_info_bukse_bredde`
--
ALTER TABLE `users_info_bukse_bredde`
  ADD PRIMARY KEY (`usersinfoBukseBredde_id`);

--
-- Indexes for table `users_info_bukse_laengde`
--
ALTER TABLE `users_info_bukse_laengde`
  ADD PRIMARY KEY (`usersinfoBukseLaengde_id`);

--
-- Indexes for table `users_info_etnicitet`
--
ALTER TABLE `users_info_etnicitet`
  ADD PRIMARY KEY (`usersinfoEtnicitet_id`);

--
-- Indexes for table `users_info_eye_color`
--
ALTER TABLE `users_info_eye_color`
  ADD PRIMARY KEY (`usersinfoEyeColor_id`);

--
-- Indexes for table `users_info_hair_color`
--
ALTER TABLE `users_info_hair_color`
  ADD PRIMARY KEY (`usersinfoHairColor_id`);

--
-- Indexes for table `users_info_kategorier`
--
ALTER TABLE `users_info_kategorier`
  ADD PRIMARY KEY (`usersinfoKategorier_id`);

--
-- Indexes for table `users_info_landsdel`
--
ALTER TABLE `users_info_landsdel`
  ADD PRIMARY KEY (`usersinfoLandsdel_id`);

--
-- Indexes for table `users_info_sko_storrelse`
--
ALTER TABLE `users_info_sko_storrelse`
  ADD PRIMARY KEY (`usersinfoSkoStorrelse_id`);

--
-- Indexes for table `users_info_sprog`
--
ALTER TABLE `users_info_sprog`
  ADD PRIMARY KEY (`usersinfoSprog_id`);

--
-- Indexes for table `users_info_tatoveringer`
--
ALTER TABLE `users_info_tatoveringer`
  ADD PRIMARY KEY (`usersinfoTatoveringer_id`);

--
-- Indexes for table `users_subscription`
--
ALTER TABLE `users_subscription`
  ADD PRIMARY KEY (`usersSubscription_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `carousel1`
--
ALTER TABLE `carousel1`
  MODIFY `carousel1_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `page_work1_videos`
--
ALTER TABLE `page_work1_videos`
  MODIFY `pw1videos_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `users_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT for table `users_files`
--
ALTER TABLE `users_files`
  MODIFY `usersFiles_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `users_gender`
--
ALTER TABLE `users_gender`
  MODIFY `usersGender_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `users_info`
--
ALTER TABLE `users_info`
  MODIFY `usersinfo_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `users_info_bluse_storrelse`
--
ALTER TABLE `users_info_bluse_storrelse`
  MODIFY `usersinfoBluseStorrelse_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `users_info_bukse_bredde`
--
ALTER TABLE `users_info_bukse_bredde`
  MODIFY `usersinfoBukseBredde_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT for table `users_info_bukse_laengde`
--
ALTER TABLE `users_info_bukse_laengde`
  MODIFY `usersinfoBukseLaengde_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT for table `users_info_etnicitet`
--
ALTER TABLE `users_info_etnicitet`
  MODIFY `usersinfoEtnicitet_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users_info_eye_color`
--
ALTER TABLE `users_info_eye_color`
  MODIFY `usersinfoEyeColor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `users_info_hair_color`
--
ALTER TABLE `users_info_hair_color`
  MODIFY `usersinfoHairColor_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `users_info_kategorier`
--
ALTER TABLE `users_info_kategorier`
  MODIFY `usersinfoKategorier_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `users_info_landsdel`
--
ALTER TABLE `users_info_landsdel`
  MODIFY `usersinfoLandsdel_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `users_info_sko_storrelse`
--
ALTER TABLE `users_info_sko_storrelse`
  MODIFY `usersinfoSkoStorrelse_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
--
-- AUTO_INCREMENT for table `users_info_sprog`
--
ALTER TABLE `users_info_sprog`
  MODIFY `usersinfoSprog_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `users_info_tatoveringer`
--
ALTER TABLE `users_info_tatoveringer`
  MODIFY `usersinfoTatoveringer_id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `users_subscription`
--
ALTER TABLE `users_subscription`
  MODIFY `usersSubscription_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

please note with this SQL, i have removed some names pre-made :P

But that is my SQL never the less. Hoping you can help.

And it is to my believes that it is with the queries my problems are, mainly, unsure about the if/else's statements, they look good to my eye, it is mostly the SQL i am not the best at making when it comes to searchers.

Hope you can help, as always, thanks, and sorry if i left any info out. Please ask if you need more information! :)

Thanks again! :)

Share this post


Link to post
Share on other sites

You're going to need to narrow down what you want people to look at it, there's no way I have the time to read through that much code to find an if statement that you're referring to.  Find the relevant parts of the code only, too much information is no better than not enough information.

Share this post


Link to post
Share on other sites

ohh sorry, i just thought to be... well... as much info as needed so you guys would not need anything :P

I think i have come up with a new way, i posted a new topic about it in the SQL section. Only problem i have now is that i cannot output anything... but will keep that info in mind next time :P..

Will write again if i need the help :D

Thanks! :D

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×