sittinDuck
asked on
Slash between values question
Hello experts!
I have 10 columns in my database called table_nightclub_1, table_nightclub_2, table_nightclub_3, table_nightclub_4 and so on. Datatype = enum('Y', 'N', '').
Y if the table is booked - N if not.
How can I echo '1 / 2 / 3' if table 1, 2 and 3 are booked? And only '1' if table 1 is booked? '8 / 9' if table 8 and 9 are booked.
I can't find a smart way to make a slash between the values:-/ Hope someone can help me!
Thanks in advance!
I have 10 columns in my database called table_nightclub_1, table_nightclub_2, table_nightclub_3, table_nightclub_4 and so on. Datatype = enum('Y', 'N', '').
Y if the table is booked - N if not.
How can I echo '1 / 2 / 3' if table 1, 2 and 3 are booked? And only '1' if table 1 is booked? '8 / 9' if table 8 and 9 are booked.
I can't find a smart way to make a slash between the values:-/ Hope someone can help me!
Thanks in advance!
Another option would be to do it in SQL ...
SELECT
CASE WHEN table_nightclub_1 = 'Y' THEN '1 / ' ELSE '' END +
CASE WHEN table_nightclub_2 = 'Y' THEN '2 / ' ELSE '' END +
CASE WHEN table_nightclub_3 = 'Y' THEN '3 / ' ELSE '' END +
CASE WHEN table_nightclub_4 = 'Y' THEN '4 / ' ELSE '' END +
CASE WHEN table_nightclub_5 = 'Y' THEN '5 / ' ELSE '' END +
CASE WHEN table_nightclub_6 = 'Y' THEN '6 / ' ELSE '' END +
CASE WHEN table_nightclub_7 = 'Y' THEN '7 / ' ELSE '' END +
CASE WHEN table_nightclub_8 = 'Y' THEN '8 / ' ELSE '' END +
CASE WHEN table_nightclub_9 = 'Y' THEN '9 / ' ELSE '' END +
CASE WHEN table_nightclub_10 = 'Y' THEN '10' ELSE '' END
AS Booked
FROM
table
and in PHP
$Booked = trim($data['Booked'], ' /');
sort of thing.
SELECT
CASE WHEN table_nightclub_1 = 'Y' THEN '1 / ' ELSE '' END +
CASE WHEN table_nightclub_2 = 'Y' THEN '2 / ' ELSE '' END +
CASE WHEN table_nightclub_3 = 'Y' THEN '3 / ' ELSE '' END +
CASE WHEN table_nightclub_4 = 'Y' THEN '4 / ' ELSE '' END +
CASE WHEN table_nightclub_5 = 'Y' THEN '5 / ' ELSE '' END +
CASE WHEN table_nightclub_6 = 'Y' THEN '6 / ' ELSE '' END +
CASE WHEN table_nightclub_7 = 'Y' THEN '7 / ' ELSE '' END +
CASE WHEN table_nightclub_8 = 'Y' THEN '8 / ' ELSE '' END +
CASE WHEN table_nightclub_9 = 'Y' THEN '9 / ' ELSE '' END +
CASE WHEN table_nightclub_10 = 'Y' THEN '10' ELSE '' END
AS Booked
FROM
table
and in PHP
$Booked = trim($data['Booked'], ' /');
sort of thing.
ASKER
There was an error with the first solution
Parse error: syntax error, unexpected T_FUNCTION, expecting ')' in /home/tabelreservation.dk/ wwwroot/te st.php on line 23
Parse error: syntax error, unexpected T_FUNCTION, expecting ')' in /home/tabelreservation.dk/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANK you :-)
Just what I needed!
Just what I needed!
Open in new window