ok, thanx, "skipping records with php" was what i was thinking of as an other way of solving this problem, if i can't find the easy solution here with mysql.
hi sleipnir214
ok, I got the meaning of the LIMIT function. BUT i still can't get it rigth for my specific SELECT-statement.
If I have this SELECT:
SELECT *
FROM `t_test`
WHERE T_REGION_ID = 1 AND DATE_CREATED
LIKE "2003-01-01%"
ORDER BY DATE_CREATED DESC , VALID_FROM ASC
LIMIT 4...
thanx for the hint, sleipnir214, I did already check the documentation, and I know (believe) that I need to use the LIMIT function, but I still can't figure it out...
I have a table which looks like this:
CREATE TABLE `t_test` (
`T_REGION_ID` int(16) NOT NULL default '0',
`VALID_FROM` varchar(5) NOT NULL default '',
`TXT1` varchar(50) NOT NULL default '',
`DATE_CREATED` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;
in the db there...
hi mwolf00
thanx a lot for your script!
i had to change the "select - one" to "select" and the fieldname in the alert needs the ".name", but now it works. thanx a lot, you really did help!
<script>
function checkSelects(){
allSelects =...
Hi experts!
I need help for the following problem:
I have a form with several "rows" of dynamically created dropdown-boxes:
<form name="form" action="something.php" method="post" onSubmit="return chkFormular();">
<select...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.