Code: Select all
$result = mysql_query("SELECT * FROM `logs_admin` WHERE 'date' LIKE '".$_GET['date']."' ORDER BY `id` DESC"); $result = mysql_query("SELECT * FROM `logs_admin` WHERE '".$_GET['date']."' LIKE 'date' ORDER BY `id` DESC");padekok arnui tai jis man padejo su LIKEpsychical wrote:Arba aš ne taip supratau arba neveikia. (čia du skirtingi)Code: Select all
$result = mysql_query("SELECT * FROM `logs_admin` WHERE 'date' LIKE '".$_GET['date']."' ORDER BY `id` DESC"); $result = mysql_query("SELECT * FROM `logs_admin` WHERE '".$_GET['date']."' LIKE 'date' ORDER BY `id` DESC");
-- 2013 Bal 09 18:43 --
Ačiū už bandymą padėti išeitį radau http://www.w3schools.com/sql/sql_like.asp
Code: Select all
<?php$date_match = str_replace("-", "", $_GET['date']);$result = mysql_query("SELECT * FROM `logs_admin` WHERE EXTRACT(YEAR_MONTH FROM date) = '".$date_match."'");?>