Sql And Php

moda1919

Hi, I am a very beginner programmer.. I want a useful script describing exactly how to connect to DB and select from 2 tables and creat a table using php with the info from the selected items of the 2 tables in the DB thanks

LordShryku

Okay....so....what have you done? Have you looked anything up? Written any code? Do you have these two tables already? Do you have the sql statement you want to execute?

You have to do the work. We'll just help with your specific questions.

moda1919

Well, I am sorry for non-specifying ....

Yes I already have the to tables located on a site so I begin with
<? php
$server = "rdbms.strato.de";
$username = "xxxxxxx";
$password = "xxxxxxx";
$connection = mysql_connect($server, $benutzer, $kennwort);
mysql_select_db("DB85691", $connection);
$sql = "Select FROM moda_hours.id, moda_hours.name, moda_hours.dob, moda_persons.id, moda_persons.con, moda_persons.sallery FROM moda_hours INNER JOIN moda_persons ON moda_hours.ID = moda_persons.ID"
$result = mysql_query ($sql, $connection);
<table border = 2>
<tr>
bla bla bla
</tr>
</table>
mysql_free_result($result);
mysql_close($connection);
?>
so i want to know the bla bla bla to put the selected info from $sql into one table... I want help to write the code of looping that finally the selected (moda_hours.id , moda_hours.name ... and from the second table) all put in this table

thanks for help