Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by dodgeitorelse3

  1. Have you tried putting this code into a php file and running it to see what you have?


    // Show all information, defaults to INFO_ALL


    in your web browser use edit/find in page and search for mysqlnd. That would be for firefox browser. Chrome browser would be search/find

  2. changing your code from php short tag to <?php  and then adding error reporting and display errors as such displays

    	ini_set('display_errors', '1');


    Warning: require_once(/var/www/vhosts/worldwide-gaming.com/httpdocs/squirrelcart/pre_common.php): failed to open stream: No such file or directory in /var/www/html/ProdFeedGen.php on line 6

    Fatal error: require_once(): Failed opening required '/var/www/vhosts/worldwide-gaming.com/httpdocs/squirrelcart/pre_common.php' (include_path='.:/usr/share/pear:/usr/share/php') in /var/www/html/ProdFeedGen.php on line 6

    and does not print code to screen.

    These errors show for me due to the fact I am not using a full url to get to your require once file.

  3. We know no more now than we did when you posted the 3 files. We already understood that is the file with the error. Please provide all 4 files using the actual file names and without any sensitive information that is in them. I have a suspicion you have not followed the majority of the advice you have already been given. There is obviously a mistake (or many) that is causing the error. It will be very hard for you to solve the error if you are going to pick and choose what advice is given.

  4. instead of saying first file, second file and third file use the actual file name. I am curious if your form is actually posting to second file (denetim.php)  and which file is your redirect (header("Location:sayfam.php")). The clearer you are determines the quickest path to your answer.

  5. Using sort will sort numbers. so I if enter 12345 into input box results will be 12345. If I do same thing again then result will be the same. Without using sort, the numbers will be returned in different orders each time using same input of 12345.

    However entering more than 5 digits, lets say 1 through 9, then it will return 2 sets of numbers. the first set with 5 numbers and the second set with the remaining 4 numbers. So depending on what you are expecting for results depends on the code you use.

  6. <?php
        if (!empty($from) && !empty($to)) {
       <div class="card">
          <div class="card-datatable table-responsive card-body">
              <div class="col-md-12" >
                  <table class="table dataTable" id="myTable2">
                      <tbody class="tbody">
                          <?= $tdata ?>

    I think that is what you need



  7. @Barand I marked your  reply as a solution. There were actually 2 solutions, the first was the SQL tutorials in your signature and the second was your post about 

    19 hours ago, Barand said:

    Better to use fetch assoc() to get arrays with just the column names as keys

    Thank you very much.

    This post also turned into a database normalization issue and I am still working on that.

  8. The query has Original_Name. I changed to fetch_assoc and now do not have the duplicate field values. Now I have to work on the normalization. Using design for database I currently have fails when I try to join all the tables. Thank you for that fix Barand. I tried to send sql files in message but I get the error too big. There are 1929 entries and file size of mapnames table is biggest weighing in at 600 kb. second biggest is 223 kb and the last five sql files are 100 kb or less.


  9. Is it possible to run a query to get data from multiple tables where they have only 1 common field name?

    Below are images of the field names for each table as well as the web and database server info.

    If possible which join would I use?

    I can get 2 tables to return data using

    SELECT id, size, Original_Name, resource, disabled, tickmark, image, type, creator, modder, beta, final, modded, classification, sf, tod, weather, es2
    					INNER JOIN mapnames_tooltips USING (id)
    					ORDER BY id Asc"

    however this gives me double entries in array.


        [0] => Array
                [0] => 1
                [id] => 1
                [1] => 11441673
                [size] => 11441673
                [2] => Border.aao
                [Original_Name] => Border.aao
                [3] => 2_8_5_default, abr, blannick, chevy, crypt, ffat, kool, rapidfire, vanoke, spectrum
                [resource] => 2_8_5_default, abr, blannick, chevy, crypt, ffat, kool, rapidfire, vanoke, spectrum
                [4] => 0
                [disabled] => 0
                [5] => 1
                [tickmark] => 1
                [6] => ../../gsreaders/lgsl/lgsl_files/maps/aarmy/armygame/border.jpg
                [image] => ../../gsreaders/lgsl/lgsl_files/maps/aarmy/armygame/border.jpg
                [7] => PVP
                [type] => PVP
                [8] => Richard Starr
                [creator] => Richard Starr
                [9] => 
                [modder] => 
                [10] => N
                [beta] => N
                [11] => Y
                [final] => Y
                [12] => N
                [modded] => N
                [13] => LAND
                [classification] => LAND
                [14] => N
                [sf] => N
                [15] => DAY
                [tod] => DAY
                [16] => HAZY
                [weather] => HAZY
                [17] => N
                [es2] => N
                [18] => 0
                [slots] => 0
        [1] => Array
                [0] => 2
                [id] => 2

    This gives me double entries though.

    Any advice would be greatly appreciated.


    web server.png

    db server.png








  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.