Hvala.
Probao sam UPPER/UCASE ali ne radi tj. nista mi ne pokaze kao da nista ne odgovaram tim kriterijama. Ako npr. koristim UPPER('city') onda mi samo izbaci gradove koji su ispisani velikim.
Tek sam poceo da ucim PHP/MySQL pa sam mozda negdje drugo gresku uradio ... evo pogledaj code, pa mozda nesto drugo primjetis ...
btw. city = u_address
Code:
<?php
require 'db_connect.php';
if ($logged_in == 0) {
echo 'Access Forbidden!';
} else {
// 1 - expired
// 0 - not expired
// ##### Take ads that expires today and are not set as expired #####
$query="SELECT * FROM classified WHERE ex_date=CURDATE() AND expired='0'";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
// ##### Now set as expired #####
$setexpire="UPDATE classified SET expired='1' WHERE id='$id'";
$update=mysql_query($setexpire);
$i++;
}
// ##### Old ads are set as expired #####
// ##### Now display approved and not expired ads #####
$query="SELECT * FROM classified WHERE approved='1' AND expired='0'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
// VARIABLES/////////////////////////
//$ex_in = 60; //default: expire in 60days
//$ex_date = date ("Y-m-d", mktime(0, 0, 0, date("m"), date("d")+$ex_in, date("Y")));
/////////////////////////////////////
if ($num == 0) { echo "<center><b>NO CLASSIFIED YET</b></center>"; }
else {
echo "<center><b>ALL CLASSIFIEDS<br></b>You have a total of $num classifieds</center>";
$i=0;
while ($i < $num) {
echo "<br>";
$u_headline=mysql_result($result,$i,"u_headline");
$u_content=mysql_result($result,$i,"u_content");
$u_address=mysql_result($result,$i,"u_address");
$ex_date=mysql_result($result,$i,"ex_date");
echo "$u_address<br><b>$u_headline</b><br>$u_content<br><font size=1>expire: $ex_date</font><br><br><br>";
$i++;
}
}
}
?>
DDSD!