How-to ???

[Anon]

Hi !!!

I'm trying to extract data from mysql db thus:

#Solicitando dados da Tabela.
$result = mysql_query("select * from $tabela");
while($row = mysql_fetch_array($result)) {
#Assign rows to variables.
$ID = $row["ID"];
$Categoria = $row["Categoria"];
$Nome = $row["Nome"];
$Texto = $row["Texto"];
$Imagem = $row["Imagem"];
}

I have multiple data in db, then what can I do to list all rows using this unique variables($ID,$Categoria,$nome,$Texto,$Imagem) in other page ???

Any ideas???

Regards,

marcoBR

[Anon]

Hi, you may use like this :

#Solicitando dados da Tabela.
$result = mysql_query("select * from $tabela");
$i=0;
while($row = mysql_fetch_array($result)) {
#Assign rows to variables.
$ID[$i] = $row["ID"];
$Categoria[$i] = $row["Categoria"];
$Nome[$i] = $row["Nome"];
$Texto[$i] = $row["Texto"];
$Imagem[$i] = $row["Imagem"];
$i++;
}

From source above, it tells that you can use array with its index as row counter, so $ID[0] means ID of record #1

Try it and good luck..🙂