). Zajímají mě ted jen 2 sloupce ID,DATE. Dotaz:

$result = $db->sql_query("SELECT id, date FROM ".$table." ORDER BY date DESC LIMIT 1");
$drow = $db->sql_fetchrow($result);
$date = $drow['date'];
$id = $drow['id'];




$result = $db->sql_query("SELECT id, date FROM ".$table." ORDER BY date DESC LIMIT 1");
while ($row = $db->sql_fetchrow($result)) {


$bwvypis_id = intval($row['id']);
$bwvypis_date = $row['date'];


}
$db->sql_freeresult($result);




`id` int(11) NOT NULL auto_increment









CREATE TABLE `pf_bcpp_history` (
`id` int(12) NOT NULL auto_increment,
`isin` varchar(12) collate latin2_czech_cs NOT NULL,
`namecp` varchar(18) collate latin2_czech_cs NOT NULL,
`bic` varchar(8) collate latin2_czech_cs NOT NULL,
`date` date NOT NULL,
`finishrate` decimal(13,2) NOT NULL,
`modify` decimal(7,2) NOT NULL,
`lastrate` decimal(13,2) NOT NULL,
`minperyear` decimal(13,2) NOT NULL,
`maxperyear` decimal(13,2) NOT NULL,
`manycp` int(11) NOT NULL,
`capacity` decimal(17,2) NOT NULL,
`lasttrade` date NOT NULL,
`group` int(1) NOT NULL,
`dimension` smallint(1) NOT NULL,
`market` varchar(1) collate latin2_czech_cs NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=616 ;


Obsah fóra BLASSENweb » Rady a porady - ostatní
|
|