Code: Select all
<?php
mysql_select_db($database_somedatabase, $somedatabase);
$query_findPeople_rs = "SELECT firstname, age FROM people WHERE state = 'texas' ORDER BY firstname ASC";
$findPeople_rs = mysql_query($query_findPeople_rs, $thesilentcritic) or die(mysql_error());
$row_findPeople_rs = mysql_fetch_assoc($findPeople_rs);
$totalRows_findPeople_rs = mysql_num_rows($findPeople_rs);
?>Adam 32
Bob 28
Dave 29
Jim 43
Jim 26
Mike 30
Phil 54
Steve 22
Steve 36
i check the number of rows by:
Code: Select all
<?php
$counter = mysql_num_rows($findPeople);
?>Now my question is, how would i store the first name of the person in the 9th row (Steve) as the variable $name
Code: Select all
<?php
$name = ?
?>