how to update record with 2 tables?

i have 2 tables,
1. account
-id,
-accounttypeid,
-name

2. accounttype
-accounttypeid,
-type.

i can add record by join the table,
but if i need update record, it cant,
can some 1 help me?
how to update?
thz

Expand|Select|Wrap|Line Numbers

 <html><head></head>

<body>

<?php

$jenis =$_POST['accounttypeid'];
 
$connect =mysql_connect("localhost","root","") or die (mysql_error());

$select = mysql_select_db("phplogin") or die (mysql_error());

   $q = mysql_query("select * from accounttype");

        while ($row = mysql_fetch_assoc($q)) 

        {

                $jenis .= "<option value = $row[accounttypeid]>$row[type]";

        }

        ?>

        <?
 
if (isset ($_POST['submit'])) {
 
   $name = $_POST['name'];

   $sid = $_POST['accounttypeid'];

   $ID=$_GET['ID'];
 
      $updatelink="Update account set name='$name', accounttypeid ='$sid'";

      mysql_query($updatelink) or die(mysql_error());

      print "Link updated.";
 
} else

{
 
   $ID=$_GET['ID']; //gets the id from URL

   $sql="SELECT account.id, account.name, accounttype.type from account, accounttype where account.accounttypeid = accounttype.accounttypeid and account.id='$ID'";

   $result=mysql_query($sql) or die("Could not get button"); 

   $row=mysql_fetch_array($result);
 
   ?>

   <form method="post" action="lista.php" >

   <table><tr><td><input type="hidden" name="ID" value="$ID"></td></tr><tr><td>Name: </td> <td><input name="name" type="text" id="name" value="<? echo $row['name']; ?>"></td></tr>

   <tr><td>

     Accounttype: </td> <td><select name="accounttypeid"><?php print ($jenis); ?>

</select></td></tr>

   <tr><td colspan="2"> <input type='submit' name="submit"  value='submit'></td></tr>

   </table></form>
 
<? }

?>

<form method="post" action="viewa.php">

<table><tr><td>

<input type="submit" name="view" value="View">

</td></tr></table></form>
 
<form method="post" action="a6.php">

<table>

<tr><td>

<input type="submit" name="back" value="Back">

</td></tr></table></form>

</body></html>

Sep 14 '09 #1

Subscribe Post Reply

2008

ryachza

I gather you are asking for assistance creating an UPDATE query across multiple tables?

Expand|Select|Wrap|Line Numbers

 UPDATE tableName t1 JOIN tableName t2 ON t1.field = t2.field SET t1.field = 'value', t2.field = 'value', etc. WHERE t1.field = 'value' AND t2.field = 'value';
 

Sep 15 '09 #2

Similar topics

Select .. for update question

by: jayson_13 | last post by:

Hi, I need to implement a counter and i face problem of locking so hope that u guys can help me. I try to do test like this : 1st connection SELECT * FROM nextkey WHERE tblname = 'PLCN'...

MySQL Database

common UPDATE syntax for SqlServer and Oracle

by: Jan van Veldhuizen | last post by:

The UPDATE table FROM syntax is not supported by Oracle. I am looking for a syntax that is understood by both Oracle and SqlServer. Example: Table1: id name city ...

Microsoft SQL Server

Bulk Insert / Update / Delete

by: Philip Boonzaaier | last post by:

I want to be able to generate SQL statements that will go through a list of data, effectively row by row, enquire on the database if this exists in the selected table- If it exists, then the colums...

PostgreSQL Database

Update to child table fails

by: PAUL | last post by:

Hello, I have 2 tables with a relationship set up in the dataset with vb ..net. I add a new record to the parent table then edit an existing child record to have the new parent ID. However when I...

Visual Basic .NET

Deadlock. Referential Integrity checks select for update?

by: Grant McLean | last post by:

Hi First a simple question ... I have a table "access_log" that has foreign keys "app_id" and "app_user_id" that reference the "application_type" and "app_user" tables. When I insert into...

PostgreSQL Database

Add and update data to multiple tables

by: jpr | last post by:

Hello, I know that this is not the rule but need some help. My datbase has three tables: MASTER TEMPLATES FORMS I have a form which is based on a table named MASTER. I have a primary key...

Microsoft Access / VBA

doing a update

by: Roy | last post by:

Hi Access gurus, I have a A2K application.The data in the database is updated daily by a excel download.I have a master n related tables keyed in by a OrderID.I have a problem in updating data.If...

Microsoft Access / VBA

Update problem ADO vbnet 2005

by: Scotty | last post by:

I like to have a good insert, update and delete code The code below sometimes workl ok sometimes doesnt work, what i am doing wrong?? Sub SaveAny() Dim command_builder As New...

Visual Basic .NET

dataAdapter.Update / SQL PasswordHash NULL problem

by: BobLewiston | last post by:

Some of you may have seen my earlier thread “PasswordHash NULL problem”. I’ve started a new thread because investigation has shown that the problem is actually quite different than I previously...

Microsoft SQL Server

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA