php and mysql

[agenthobbs]

Ok i am having a problem displaying a table on my website. I created a table using phpmyadmin with 3 columns and 3 rows. I am curious how to accomplish this by storing the data in an array and using for loops to display the table, because my brother showed me a while back how to do it this way, but every example I can find shows a different way. Any help would be much appreciated.

[b1randon]

Ok i am having a problem displaying a table on my website. I created a table using phpmyadmin with 3 columns and 3 rows. I am curious how to accomplish this by storing the data in an array and using for loops to display the table, because my brother showed me a while back how to do it this way, but every example I can find shows a different way. Any help would be much appreciated.

[PHP]
<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT field1,field2,field3 FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("Field1: %s Field2: %s, Field3: %s", $row[0], $row[1], $row[2]);
}

mysql_free_result($result);
?>
[/PHP]

[treecool]

table name " users "

----------------------------------------------------
| name      |  age                |            location |
----------------------------------------------------
| TreeCool | 21                  |           Bandung |
| Lina        | 20                  |          Jakarta    |
 

if this is the table of databases

we can display using " while "

<?php
$query=mysql_query("select * from users");
while($rows=mysql_fetch_array($query))
{
         echo "$row[name] - $row[age] - $row[[location]";
}
?>
 

then you can modified as your need..

[cassbiz]

You can try this

<?
$username="username";
$password="password";
$database="your_database";
 
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM tablename";
$result=mysql_query($query);
 
$num=mysql_numrows($result);
 
mysql_close();
 
 
?>
 
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th>Value1</th>
<th>Value2</th>
<th>Value3</th>
 
</tr>
 
<?
$i=0;
while ($i < $num) {
 
$field1=mysql_result($result,$i,"field1");
$field2=mysql_result($result,$i,"field2");
$field3=mysql_result($result,$i,"field3");
 
?>
 
<tr>
<td><? echo $field1; ?></td>
<td><? echo $field2; ?></td>
<td><? echo $field3; ?></td>
</tr>
 
<?
$i++;
}
 
echo "</table>";
?>