To return the total amount of records in a table, just do:
$query = 'SELECT COUNT(*) FROM tblName';
$result = mysql_query($query);
$total_records = mysql_result($result, 0);
Or, for short,
$total_records = mysql_result(mysql_query($query), 0);
To step through the records, just do a normal SELECT query:
$query = 'SELECT stuff FROM tblName ';
$query .= "WHERE intStuff=$stuff ORDER BY stuff";
$result = mysql_query($query);
if ($row = mysql_fetch_row($result)) {
do {
while ($row = mysql_fetch_row($result));
}
else {
// stuff for if there are no records.
}
Does this answer your question? If not, please be more specific as to what
I missed :)
-Mike
At 12:17 PM 8/22/2001 +0200, you wrote:
>Hey there. I realize this is a forum for php-windows users,but knowing
>that most of you guys run a mysql db as backend i have a question for
>you..
>
>I know there is a way to return the amount of records in the db by using
>the mysql_num_rows($resultid). My problem is that it only returns the
>total number of records from my query
>
>I have seen that there is a function called mysql_data_seel(par,par),
>but i am not sure how it works.
>
>My problem is the following>
>i want to do a print out of each record in the db , but the HTML code
>(to be exact the positioning of the HTML table should be different
>depending on the number of record printed out.
>
>To illustrate this is more or less what i want >
>
>i want to print out record 1 in one style , then i want to next record
>to be printed out in a different way. Is there a way to do a check on
>which number of record is printed out.
>I realize i cannot use the id simply because if i do a printout of total
>4 records and i want to use a record with id = 100 e.g then it won't do
>me any good.
>
>Basically is there a way for me to check the number of record is printed
>out on a page. If i want to print out 4 records then the first row
>should be 1..Regardless of the ID stored in the db.
>
>I hope you understand me .if now i would be happy to reply with a more
>detailed instruction on my problem.
>
>in ODBC db i know one can use the rs.next object and method, but is
>there an equivalent to this in MYSQL..
>
>Thanks everyone
>
>Lars Eirik
>
>
>
>--
>PHP Windows Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
-=- Mike Flynn - Burlington, VT -=-
[EMAIL PROTECTED] http://www.mikeflynn.net/ * Give blood *
The modern conservative is engaged in one of man's oldest
exercises in moral philosophy; that is, the search for a
superior moral justification for selfishness.
-- James K. Galbraith
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
