|
|
Posted by J.O. Aho on 02/01/06 19:30
Mike wrote:
> Thanks but how do I get this to work...
>
> I thought of a way to do it but I need to access each line of the array
>
> by number. I think this is called the master element index position.
>
>
> I thought the following would work but it dosn't...
>
>
> $row = mysql_fetch_array($result, MYSQL_BOTH)
> echo $row[1]['id'];
> echo $row[1]['f_name'];
> echo $row[1]['l_name'];
mysql_fetch_array() does only fetch one line at the time, putting each column
in it's own cell.
$row = mysql_fetch_array($result, MYSQL_BOTH)
echo $row['id'];
echo $row['f_name'];
echo $row['l_name'];
If you want to display all in the table
while($row = mysql_fetch_array($result)) {
echo $row['id'];
echo $row['f_name'];
echo $row['l_name'];
}
If you want to limit the number of lines, you need to include LIMIT in the query.
$result = mysql_query("SELECT id, f_name, l_name FROM personal where
l_name ='$_POST[l_name]' LIMIT $startpoint,$numberofrows");
Keep in mind first row has the value 0.
//Aho
Navigation:
[Reply to this message]
|