sql query, editing?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have this code below, it fetches data on a mysql database. I was hoping
you could give me a code hint on where could, my goal is to display this
data on a browser which i did already and be able to edit it via a form.

edit? -> table1=value -> table2=value

I dont know where to start. please help me, i hope i can display all the
data and have a button for editing and catch which one to edit.


## code ##
$result = mysql_query("select
product_code,title,language,issue,category,cost from iip_t_cp where issue =
$issue and category = '$category' and language = '$language' and depleted =
'$depleted'", $connect);
$num_rows = mysql_num_rows($result);

function display($result)
  {
    echo "<h1>pricelist records</h1>\n";
    echo "<br>";
    echo "\n<table cellspacing=3 cellpadding=3 border=1>\n<tr>\n" .
         "\n<th>product
code</th><th>title</th><th>language</th><th>issue</th><th>category</th><th>c
ost</th>" .
         "\n</tr>";

      while ($row = @ mysql_fetch_row($result))
        {
          echo "\n<tr>";
          foreach($row as $data)
          echo "\n\t<td> $data </td>";
          echo "\n</tr>";
        }

    echo "\n</table>";
}
display($result);
## code ##




-- -
Louie Miranda
http://www.axishift.com

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux