wildarp
Новичок
Вывод ближайших дат к датам запроса
Привет всем.
Необходимо вывести даты c.date_ariv и date_left as lefta ближайшие к запросу
c.date_ariv <= '$data[data_b]' AND c.date_left >= '$data[data_a]'
но к сожалению ничего не получается значения остаются пустыми
((
$res = mysql_query("SELECT f.id AS number, f.pass AS pass,
f.id_dist, f.tip_id, f.total_room AS total_room,
f.total_place, f.lev_id, f.city_id,
f.price AS price, f.owner_id AS owner_num, f.sea,
f.conder, b.id AS owner_b, b.nick AS own_nick,
d.id, d.name AS tip_name, e.id_lev,
e.name AS level_name, z.name AS city_name, g.id, g.name AS dvor_name,
c.date_ariv as ariv, c.date_left as lefta ,
n.value AS minut FROM `common` AS f
LEFT JOIN owner b ON ( b.id = f.owner_id )
LEFT JOIN tip d ON (d.id = f.tip_id)
LEFT JOIN distance n ON ( n.dis_id = f.id_dist )
LEFT JOIN level e ON (e.id_lev = f.lev_id)
LEFT JOIN dvor g ON (g.id = f.dvor_id)
LEFT JOIN city z ON (z.id = f.city_id)
LEFT JOIN clients c ON (c.apart_id = f.id)
AND c.date_ariv <= '$data[data_b]' AND c.date_left >= '$data[data_a]'
WHERE f.id > '1' $sql GROUP BY f.id HAVING COUNT( c.apart_id ) = '$busy'
ORDER by f.price LIMIT " . $begin . ", " . $cfg[onpage]) or die(mysql_error());
Спасибо.
Невнятно описал сори
Даты выводятся если $busy = 1
а если $busy = 0 то даты не выводтся
а мне нужно чтоб они выводились в любом случае
конкретный запрос выглядет так который выводит даты
SELECT f.id AS number, f.pass AS pass,
f.id_dist, f.tip_id, f.total_room AS total_room,
f.total_place, f.lev_id, f.city_id, f.price AS price,
f.owner_id AS owner_num, f.sea, f.conder,
b.id AS owner_b, b.nick AS own_nick, d.id,
d.name AS tip_name, e.id_lev, e.name AS level_name,
z.name AS city_name, g.id, g.name AS dvor_name,
c.date_ariv as ariv, c.date_left as lefta,
n.value AS minut FROM `common` AS f
LEFT JOIN owner b ON ( b.id = f.owner_id )
LEFT JOIN tip d ON (d.id = f.tip_id)
LEFT JOIN distance n ON ( n.dis_id = f.id_dist )
LEFT JOIN level e ON (e.id_lev = f.lev_id)
LEFT JOIN dvor g ON (g.id = f.dvor_id)
LEFT JOIN city z ON (z.id = f.city_id)
LEFT JOIN clients c ON (c.apart_id = f.id)
AND c.date_ariv <= '2008-06-30' AND c.date_left >= '2008-06-07'
WHERE f.id > '1' and f.city_id='2' GROUP BY f.id HAVING COUNT( c.apart_id ) = '1'
Привет всем.
Необходимо вывести даты c.date_ariv и date_left as lefta ближайшие к запросу
c.date_ariv <= '$data[data_b]' AND c.date_left >= '$data[data_a]'
но к сожалению ничего не получается значения остаются пустыми
(($res = mysql_query("SELECT f.id AS number, f.pass AS pass,
f.id_dist, f.tip_id, f.total_room AS total_room,
f.total_place, f.lev_id, f.city_id,
f.price AS price, f.owner_id AS owner_num, f.sea,
f.conder, b.id AS owner_b, b.nick AS own_nick,
d.id, d.name AS tip_name, e.id_lev,
e.name AS level_name, z.name AS city_name, g.id, g.name AS dvor_name,
c.date_ariv as ariv, c.date_left as lefta ,
n.value AS minut FROM `common` AS f
LEFT JOIN owner b ON ( b.id = f.owner_id )
LEFT JOIN tip d ON (d.id = f.tip_id)
LEFT JOIN distance n ON ( n.dis_id = f.id_dist )
LEFT JOIN level e ON (e.id_lev = f.lev_id)
LEFT JOIN dvor g ON (g.id = f.dvor_id)
LEFT JOIN city z ON (z.id = f.city_id)
LEFT JOIN clients c ON (c.apart_id = f.id)
AND c.date_ariv <= '$data[data_b]' AND c.date_left >= '$data[data_a]'
WHERE f.id > '1' $sql GROUP BY f.id HAVING COUNT( c.apart_id ) = '$busy'
ORDER by f.price LIMIT " . $begin . ", " . $cfg[onpage]) or die(mysql_error());
Спасибо.
Невнятно описал сори
Даты выводятся если $busy = 1
а если $busy = 0 то даты не выводтся
а мне нужно чтоб они выводились в любом случае
конкретный запрос выглядет так который выводит даты
SELECT f.id AS number, f.pass AS pass,
f.id_dist, f.tip_id, f.total_room AS total_room,
f.total_place, f.lev_id, f.city_id, f.price AS price,
f.owner_id AS owner_num, f.sea, f.conder,
b.id AS owner_b, b.nick AS own_nick, d.id,
d.name AS tip_name, e.id_lev, e.name AS level_name,
z.name AS city_name, g.id, g.name AS dvor_name,
c.date_ariv as ariv, c.date_left as lefta,
n.value AS minut FROM `common` AS f
LEFT JOIN owner b ON ( b.id = f.owner_id )
LEFT JOIN tip d ON (d.id = f.tip_id)
LEFT JOIN distance n ON ( n.dis_id = f.id_dist )
LEFT JOIN level e ON (e.id_lev = f.lev_id)
LEFT JOIN dvor g ON (g.id = f.dvor_id)
LEFT JOIN city z ON (z.id = f.city_id)
LEFT JOIN clients c ON (c.apart_id = f.id)
AND c.date_ariv <= '2008-06-30' AND c.date_left >= '2008-06-07'
WHERE f.id > '1' and f.city_id='2' GROUP BY f.id HAVING COUNT( c.apart_id ) = '1'