Jump to content

Archived

This topic is now archived and is closed to further replies.

elie

how to retrieve values stored from database (mysql)

Recommended Posts

i have stored arrayed fields into the database... i want to create a new page where i can call and retrieve these values stored from the database? please help...

[code]
<?php
include("config.php");

$field_a = $_POST['field_a'];
$field_b = $_POST['field_b'];
$field_c = $_POST['field_c'];
$field_d = $_POST['field_d'];
$field_e = $_POST['field_e'];
$field_f = $_POST['field_f'];
$num = $_POST['num'];
foreach($field_a as $key => $val)
{
$sql="INSERT INTO sample (field_a, field_b, field_c, field_d, field_e, field_f, code) VALUES

('".$val."','".$field_b[$key]."','".$field_c[$key]."','".$field_d[$key]."','".$field_e[$key]."','".$field_f[$key]."','$code')";
mysql_query($sql) or die(mysql_error());
}

?>
[/code]

Share this post


Link to post
Share on other sites
[code]$query = "SELECT * FROM sample";
$result = mysql_query($query) or die(mysql_error());
if($result && mysql_num_rows($result) > 0)
{
     while($row = mysql_fetch_array($result))
     {
          extract($row);
          echo "$field_a<br />";
          echo "$field_b<br />";
          // etc
     }
}[/code]

Share this post


Link to post
Share on other sites
thanks for the help ober!! [img src=\"style_emoticons/[#EMO_DIR#]/wink.gif\" style=\"vertical-align:middle\" emoid=\":wink:\" border=\"0\" alt=\"wink.gif\" /]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.