PHP-mysql

[autocolismo]

How do i retrive the data that each field contains?
Can anyone help me?
thanks!!!

<?php

$fields = mysql_list_fields($db, $table);
$columns = mysql_num_fields($fields);
echo "<table width='100%' border='2'>";

for ($i = 0; $i < $columns; $i++) {
$valor = mysql_field_name($fields, $i);
echo "<td><b> $valor</a></b></td>";
}

echo "</tr></table>";
?>

[[deleted]]

Well, you could start by reading the manual to see which functions there are for working with mysql.

[amansabharwal]

why don't you refer manual it is very clearly mention that

this shows that you have not read manual at all.

any way still i will show you

<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("could not connect");
    mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf ("ID: %s  Name: %s", $row[0], $row[1]);  
}

mysql_free_result($result);
?>


Example 3. mysql_fetch_array with MYSQL_ASSOC

<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("could not connect");
    mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    printf ("ID: %s  Name: %s", $row["id"], $row["name"]);
}

mysql_free_result($result);
?>


Example 4. mysql_fetch_array with MYSQL_BOTH

<?php
    mysql_connect("localhost", "mysql_user", "mysql_password") or
        die("could not connect");
    mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    printf ("ID: %s  Name: %s", $row[0], $row["name"]);
}

mysql_free_result($result);
?>