[Warning: mysqli_real_escape_string()]

Two words - variable scope.

 

$link is not defined within your function. You need to pass it as a parameter when you call the function.

 

Have you considered indenting your code to make it easier to read?

[getting a soccer table]

See this similar problem

[Planning Stage - Filling in Blank Data]

When I need to extract chart data covering a range of dates I find it easier to create a temporary table containing all the dates that I need to show on the chart. I use a DatePeriod object to create the range of dates EG

mysql> select * from tempdate;
+---------+
| month   |
+---------+
| 2016-01 |
| 2016-02 |
| 2016-03 |
| 2016-04 |
| 2016-05 |
| 2016-06 |
| 2016-07 |
| 2016-08 |
| 2016-09 |
| 2016-10 |
| 2016-11 |
| 2016-12 |
+---------+

So if I have a revenue table like yours ...

mysql> select * from revenue;
+---------+---------+
| month   | revenue |
+---------+---------+
| 2016-05 |      20 |
| 2016-08 |      10 |
| 2016-11 |      50 |
+---------+---------+

... I can fill in the gaps with

SELECT t.month
  , IFNULL(r.revenue, 0) as revenue
FROM tempdate t 
LEFT JOIN revenue r USING (month);

+---------+---------+
| month   | revenue |
+---------+---------+
| 2016-01 |       0 |
| 2016-02 |       0 |
| 2016-03 |       0 |
| 2016-04 |       0 |
| 2016-05 |      20 |
| 2016-06 |       0 |
| 2016-07 |       0 |
| 2016-08 |      10 |
| 2016-09 |       0 |
| 2016-10 |       0 |
| 2016-11 |      50 |
| 2016-12 |       0 |
+---------+---------+

[Getting data from between two strings]

use

 

• a foreach() loop
• or print_r()

[help with PHP outputing to JSON]

Simpler:

$outp = $result->fetch_all(MYSQLI_ASSOC);

echo json_encode($outp);

[Send a reminder based on chosen date]

Locking - OP has opened separate thread.

[Checking if a checkbox is checked inside a foreach loop]

 

if(isset($opp_played['$key']))

 

You have the variable inside single quotes - remove them. (The value it is looking for is the literal string $-k-e-y instead of the variable's value)

[JS Open Hours]

I'd separate the time check from the day check

if it is a work day
    if it is work hour
        we are open
    else
        we are closed
    endif
else
    we are closed
endif

[select between rate range at set time.]

So for it to work as it did with a separate time column, are the time elements the same in the two datetime columns?

 

When comparing a date with a datetime column you need to use only the date portion of the datetime.

 

So if my opening assumption is true

SELECT id
, schedule_start
, schedule_end
WHERE
    UTC_DATE() BETWEEN DATE(schedule_start) AND DATE(schedule_end)
        AND EXTRACT(HOUR_MINUTE FROM UTC_TIME()) = EXTRACT(HOUR_MINUTE FROM schedule_start)

 

[MSSQL Statement]

Note

The PDO_SQLSRV extension is only compatible with PHP running on Windows. For Linux, see ODBC and » Microsoft's SQL Server ODBC Driver for Linux.

[summing two dates]

No one that understands the sanity in adding two dates.

[Foreach error]

Foreach () takes an array and loops through it.

 

You have the array, $dpts, from which you created the comma-delimited string $departmento.

[Call to undefined function]

Use code tags ( <> button in toolbar) when posting code. lol

[$_REQUEST error when empty.]

You are getting an error on $_REQUEST['step']

 

So perhaps that is is the one you should be checking with isset() ?

[$_REQUEST error when empty.]

If you can't remember the manual is there to jog your memory

[Populate array from another array]

Change

'options'      => array_values($category_str)

to

'options'      => $category_str;

[Reverse Date Select List]

for ($i=$y+1; $i >= $y-11; $i--)

[seperating an array at a certain index]

There are several things in this job that can lead to insanity. One of them is accepting free-form text as input. It only takes a small spelling mistake (like your "strops" above) and the whole thing collapses like a house of cards.

[Show single listing from Search - PHP SQL]

It could be they have an ancient version of PHP that doesn't support [..] array definition syntax.

 

To verify try

array( 'id' => $_GET['id'])

instead of

[  'id' => $_GET['id']  ]

[Show single listing from Search - PHP SQL]

Rerunning #3, #4, #5 is a definite no-no. You could end up with completely different set of ids. That was, as previously stated, a one-off exercise.

 

1. How do you create the csv at present?
2. How many test_db records do you typically add at a time?
3. How often do you have new whiskies?

[Myphpadmin - DD MM YYYY ?]

This is the part that is confusing me. How do i echo it out as DDMMYY

 

 

 

You could try reading thara's post again and use the function he gave you.

 

edit - alternatively you can do it in PHP

$dtobj = new DateTime($row['date']);
echo $dtobj->format('d/m/Y');               //--> 23/01/2017, for example

[Show single listing from Search - PHP SQL]

 

I was hoping to show the avg price , last price / date sold

That is what that query was designed to do - just the latest record with price and date plus the average price.

 

When you list all the results for a whisky, what do you want to show?

[How to check if two columns match from joined tables?]

Sorry, I forgot to change it to INNER JOIN in that last version of the query.

[How to check if two columns match from joined tables?]

There is a "Donate to me" link underneath my avatar on the left. Thanks.

[Show single listing from Search - PHP SQL]

url_img and whsky_id are not in the fields selected in the query.