populating

[Anon]

Hi, i've got a mysql database and i'm trying to populate a table the problem is i need different info from different tables into different columns. The first column populates fine listing the info in the correct place, now what i need to do is place the other data in the other columns but making sure that the data matches the first column, e.g.

Name Age Description
John 22 Male

The name info is from one database and the age, description is from another. So if there was a list of 10 peoples names with no other info, as you input the info and recall the page you might only have the info filled in for people nos 1 & 3 leaving 2 blank. This sounds really complicated to me and i'm having a hell of a time trying to get it sorted. It has to stay in different table due to the nature of the site.

Any help would be great thanks.

[Anon]

It sounds like you are looking for the query to be used to pull the information. If that is the case, something like this may work for your query...

SELECT t1.name as name, t2.age as age, t2.gender as gender
FROM table1 as t1, table2 as t2
WHERE t1.id = t2.id

This way, you can pull all of the information from the one query.

If thats not the case, what db are you using? What does the code look like now?

[Anon]

Can you work with one person at a time. You can have the person enter their name on one form and create a user id then you can use a second form to fill out other info such as age, description.

Use:
<form action="update_database" method="post">
<input type="hidden" name="userid" value="use output code here from a page query">

this form will then input the user id into your 2nd table.

does this help?

terry

[Anon]

I think he's talking about populating a HTML table from data pulled out of the database. Right??

Use the method Chad gave, assuming you have an ID linking the two databases. If not then you're screwed. Just becuase you put data into the database, it doens't mean it stays in that order. The database can return it in any order, that's why you use SQL to make sure you know how it's being returned...

---John Holmes...

[Anon]

Yep it's linked via a text field, each database has the item name in it, and yep it's for a html table. Hope this helps

[Anon]

What field is the same in the two tables, linking them together? Do you use the name or an ID number?

Can you give an example of what the two tables look like exactly?

--JH

[Anon]

It's linked by text.

Lambitem database

servicetypeno, name, idno

workdetail database

servicetype, lambitem, staff, hours, cost, datecomp, custno, idno, aircraftreg, indivhours

name and lambitem are the same.

don't know if this is right, i've only been using php for about 3 weeks. Heres some of the code.

<table border="1">
  <tr>
    <td bgcolor="#AAAAAA"><font face=arial size=2><b>Lams Items</b></td><td bgcolor="#AAAAAA"><font face=arial size=2><b>Staff</b></td><td bgcolor="#AAAAAA"><font face=arial size=2><b>Total hours</b></td><td bgcolor="#AAAAAA"><font face=arial size=2><b>Cost per item (UK £)</b></td><td bgcolor="#AAAAAA"><font face=arial size=2><b>Date Completed</b></td><td></td></tr>

<?

$db = mysql_connect ("localhost", "root", "orange");
mysql_select_db ("camco", $db);
$query = "SELECT FROM lambitems WHERE servicetypeno = '$row[3]' ORDER BY name";
$query2 = "SELECT FROM workdetail WHERE custno = '$row[6]' ORDER BY lambitem";
$query3 = "SELECT * FROM jobdetail WHERE jobno = '$row[6]' ORDER BY jobno";
$res = mysql_query ($query, $db);
$res2 = mysql_query ($query2, $db);
$res3 = mysql_query ($query3, $db);

for ($i = 0; $i < mysql_num_rows ($res); $i++) {
$row = mysql_fetch_row ($res);
$row2 = mysql_fetch_row ($res2);
$row3 = mysql_fetch_row ($res3);
echo '<tr><td><form action="work_carried_out_save.php" method=GET>';
printf ("<input type=\"text\" name=\"lambs\" font face=\"arial\" value=\"%s\"></td>\n", $row[1], $row[1]);
printf ("<td><input type=\"hidden\" name=\"jobid\" value=\"$row3[6]\">\n");
printf ("<input type=\"text\" name=\"hours\" size=\"15\" value=\"$row2[2]\"></td>\n");
printf ("<td><input type=\"text\" name=\"hours\" size=\"8\" value=\"$row2[3]\"></td>\n");
printf ("<td><input type=\"text\" name=\"cost\" size=\"15\" value=\"$row2[4]\"></td>\n");
printf ("<td><input type=\"text\" name=\"donedate\" size=\"15\" value=\"$row2[5]\"></td>\n");
echo '<td><input type="submit" value="ok"></td></tr></form>';
}

mysql_free_result ($res);
mysql_free_result ($res2);
mysql_free_result ($res3);
mysql_close ($db);

?>

</table>

hope that helps, thanks