[thelist] php array

[deboute benjamin]

 >Right now, I would do it like this:
 ><?php
 >
 >$db = mysql_connect("localhost", "root", "pass");
 >mysql_select_db("cvdb",$db);
 >
 >// Kindla isiku C(urriculum)V(itae)
 >if ($id) {
 >    $result = mysql_query("SELECT * FROM ie_cv_main WHERE id=$id",$db);
 >    $myrow = mysql_fetch_array($result);
 >    printf("Nimi: %s %s\n<br>", $myrow["first"], $myrow["last"]);
 >    printf("E-mail: %s\n<br>", $myrow["email"]);
 >
 >   $result2=mysql_query("SELECT * FROM ie_cv_edu WHERE id=$id",$db);
 >    $myrow2 = mysql_fetch_array($result);
 >    printf("More data: %s %s\n<br>", $myrow["first"], $myrow["last"]);
 >    printf("E-mail: %s\n<br>", $myrow["email"]);
 >
 >}
 >
 >and so on. Now, how can I make it simpler?
 >Note: Some of the columns in different tables have the same name.

if($id) {
    $query="SELECT CONCAT('Nimi: ', ie_cv_main.firstname, ' ',
ie_cv_main.lastname) AS main_name, CONCAT('Email: ', ie_cv_main.email) AS
main_email, CONCAT('More data: ', ie_cv_edu.firstname, ' ',
ie_cv_edu.lastname) AS edu_name, CONCAT('Email: ', ie_cv_edu.email) AS
edu_email FROM ie_cv_main LEFT JOIN ie_cv_edu ON ie_cv_edu.id=ie_cv_main.id
WHERE ie_cv_main.id=$id";
    $result=mysql_query($query, $db);
    $myrow=mysql_fetch_array($result);
    print
$myrow["main_name"].'\n<br>'.$myrow["main_mail"].'\n<br>'.$myrow["edu_name"].'\n<br>'.$myrow["edu_mail"];
}


should work
on mysql.
think indexing your fields for the left join.


BTW, i received your mail in a strange fashion...
have you put a from, a subject ?
did you post this through software or webware ?




ben.