[thelist] php array
deboute benjamin
deboute at fr.clara.net
Mon Oct 9 03:15:07 CDT 2000
>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.
More information about the thelist
mailing list