|
|
|
|
آخر إعلان
";
include("include/dbconnect.php");
$sql="SELECT `ofr_no`,
`ofr_number`,
`ofr_date`,
`close_date`,
`ofr_title`
FROM `offers`
where `ofr_date` =
(
select max(`ofr_date`)
FROM `offers`
)
and
`ofr_number` =
(
select max(`ofr_number`)
FROM `offers`
)
";
$result = @mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
$row = mysql_fetch_array($result);
$ofr_number = $row[ofr_number]==null?'No value':$row[ofr_number];
$ofr_date = $row[ofr_date]==null?'No value':$row[ofr_date];
$close_date = $row[close_date]==null?'No value':$row[close_date];
$ofr_title = $row[ofr_title]==null?'No value':$row[ofr_title];
$id=$row[ofr_no];
$add_underscore = " - " ;
$add_space = " ";
$ofr_str = $last_ofr_no.$add_space.$ofr_number.$add_underscore.$last_ofr_title.$add_space.$ofr_title.$add_underscore.$last_ofr_date.$add_space.$ofr_date.$add_underscore.$last_ofr_close_date.$add_space.$close_date;
echo "
$ofr_str
";
echo "";
?>
|
|
|
|
";
include("include/dbconnect.php");
$sql="SELECT `ofr_no`,
`ofr_number`,
`ofr_date`,
`close_date`,
`ofr_title`
FROM `offers`
order by `ofr_date` desc";
$result = @mysql_query($sql);
if (!$result) {
die('Invalid query: ' . mysql_error());
}
$num = mysql_num_rows($result);
while ($row = mysql_fetch_array($result)) {
$ofr_number = $row[ofr_number]==null?'No value':$row[ofr_number];
$ofr_date = $row[ofr_date]==null?'No value':$row[ofr_date];
$close_date = $row[close_date]==null?'No value':$row[close_date];
$ofr_title = $row[ofr_title]==null?'No value':$row[ofr_title];
$id=$row[ofr_no];
echo "
| $ad_ofr_no |
$ofr_number |
| $ad_ofr_date |
$ofr_date |
| $ad_close_date |
$close_date |
| $ad_ofr_title |
$ofr_title |
- - - - - - - - - - - - - - - - - - - - - - -
";
} // end while
echo "";
?>
|
|
|
|
|
|
