First retrieve data from database using following command $select = mysq

i want to store retrieved data from database into an array
list with limit.And display the data from that array
list.have any answer for this?

Question Posted / guest

2 Answers
9751 Views
I also Faced
E-Mail Answers

Answer Posted / guest

First retrieve data from database using following command

$select = mysql_query("SELECT * FROM table limit number") or
die(mysql_error);

then store retrieve data in array using following command

while($row = mysql_fetch_array($select))
{
$rname[] = $row['name'];
}

display values of array

foreach($rname as $val)
{
echo $val;
}

Is This Answer Correct ?

15 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What backslash character will match whitespace?

1066

What websites use php?

974

How many ways to include array elements in double-quoted strings using php?

1051

Explain some of the php array functions?

1073

Is php a mvc?

942

What are the advantages of stored procedures, triggers, indexes in php?

1037

Is array empty php?

914

What are default session time and path?

1123

What are the benefits of using php?

1007

Explain what are psrs?

951

What are traits?

1278

What is htaccess? Why do we use this and where?

989

Does exist in php?

982

What are headers in php?

960

How to swap two variables without using 3rd temp variable.

916