print every row in column using PHP

Anon

Hi,

If I the query:

select user, info,info_found, type_info from table_name

in my php file, It gets all the data from database but it just prints on record.

How I can print all the rows for these columns at a time on the screen.

I'm using the PHP and mysql

Anon

try the following code snippet

while($row=mysql_fetch_row($sql))
{
echo "$row[0]","<br>";

}

//where sql is the executed select statement

Anon

Thanks, It is working now.

But I can not get it in the tabular form, please let me know if there is a way to do that.

Anon

put it in a table:

$result=mysql_query("SELECT blah blah");
printf("<table>\n");
while ($array=mysql_fetch_array($result))
{
printf(" <tr>\n");
for ($i=0;$i<count($array);$i++)
{
printf(" <td>%s</td>\n", $array[$i]);
}
printf(" </tr>\n");
}
printf("</table>");

Anon

Thankyou Very much

Anon

Hi, how can I get all the data from mysql database using the php, and once I have all the data then how I can select columns which one I want, and count, average the row or a column.

Please help me with this Thank you.
Mannu

Anon

Hi, how can I get all the data from mysql database using the php, and once I have all the data then how can I select columns which one I want and get count, and average of the row or a column.

Please help me with this Thank you.
Mannu

Anon

I am not able to understand ur question properly. Can u explain me clearly as to what u want exactly with a example.

Anon

Hi,
My question was:

How can I get all the data from mysql database using the php, only with one statement
I'm using this query:

select * from data_table;

It'll give me the data from the table

Once I have all the data. Now for the first time I need to count the rows with multiple columns selected in table data_table.

For the second time or next table I need the columns to get the average in table data_table.

For the next time I wanted to select the rest of the columns in table data_table.

Please help me with this Thank you.

mannu