SQL error
Posted: Thu Sep 08, 2005 8:52 am
Hi,
I would like to know why, when I execute this script, I only get the first row of the table wheras I should get more rows and I also get this error message and the
"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\manager\manager_val.php on line 58*"
Take note that this message error refers to this command:
$val = mysql_fetch_array($formation)
And that:
$formation = mysql_query("SELECT * FROM skill_objectif,skill,mapping,formation WHERE Skill_user_id='$employe_id' AND Skill_objectif_skill_cible=Skill_id AND Skill_id=Mapping_skill_id AND Mapping_formation_id=Formation_id");
Maybe I should select data on my database by another way??
I appreciate any help
thx
Jobao
I would like to know why, when I execute this script, I only get the first row of the table wheras I should get more rows and I also get this error message and the
"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\manager\manager_val.php on line 58*"
Take note that this message error refers to this command:
$val = mysql_fetch_array($formation)
And that:
$formation = mysql_query("SELECT * FROM skill_objectif,skill,mapping,formation WHERE Skill_user_id='$employe_id' AND Skill_objectif_skill_cible=Skill_id AND Skill_id=Mapping_skill_id AND Mapping_formation_id=Formation_id");
Maybe I should select data on my database by another way??
I appreciate any help
thx
Jobao
Code: Select all
<?
print("<table width=\"85%\" align=center style=\"border: 1px solid #000000\" bordercolor=\"#000000\" cellSpacing=0 cellPadding=0>
<tr>
<td colspan=\"3\" bgcolor=\"#869BB0\" width=\"25%\" align=\"center\" style=\"border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">Skill</td>
<td width=\"30%\" align=\"center\" style=\"padding-left: 4px; padding-right: 4px; border-right-style: solid; border-right-width: 1px;\" rowspan=\"2\" bgcolor=\"869BB0\">Libéllé de la Formation</td>
<td width=\"10%\" align=\"center\" style=\"padding-left: 4px; padding-right: 4px; border-right-style: solid; border-right-width: 1px;\" rowspan=\"2\" bgcolor=\"869BB0\">Type de Formation</td>
<td width=\"10%\" align=\"center\" style=\"padding-left: 4px; padding-right: 4px; border-right-style: solid; border-right-width: 1px;\" rowspan=\"2\" bgcolor=\"869BB0\">Nb de Jours</td>
<td width=\"10%\" align=\"center\" style=\"padding-left: 4px; padding-right: 4px; border-right-style: solid; border-right-width: 1px;\" rowspan=\"2\" bgcolor=\"869BB0\">Coût</td>
<td width=\"10%\" align=\"center\" bgcolor=\"869BB0\"> </td>
</tr>
<tr>
<td width=\"10%\" bgcolor=\"869BB0\" align=\"center\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">Domaine</td>
<td bgcolor=\"869BB0\" width=\"10%\" align=\"center\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">Sous Domaine</td>
<td bgcolor=\"869BB0\" width=\"5%\" align=\"center\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">Niveau</td>
<td bgcolor=\"869BB0\" align=\"center\"> </td>
</tr>");
$formation = mysql_query("SELECT * FROM skill_objectif,skill,mapping,formation WHERE Skill_user_id='$employe_id' AND Skill_objectif_skill_cible=Skill_id AND Skill_id=Mapping_skill_id AND Mapping_formation_id=Formation_id");
while ($val = mysql_fetch_array($formation)){
$domaine = $val["Skill_domaine"];
$sous_domaine = $val["Skill_sous_domaine"];
$niveau = $val["Skill_niveau"];
$formation = $val["Formation_description"];
$type = $val["Formation_for_exp"];
$duree = $val["Formation_nb_jours"];
$cost = $val["Formation_cost"];
$mapping_id = $val["Mapping_id"];
print("<tr>
<td bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$domaine</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$sous_domaine</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$niveau</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$formation</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$type</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$duree</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; border-right-style: solid; border-right-width: 1px; padding-left: 4px; padding-right: 4px\">$cost €</td>
<td align=\"center\" bgcolor=\"#FFFFFF\" style=\"border-top-style: solid; border-top-width: 1px; padding-left: 4px; padding-right: 4px\">
<form method=\"POST\" action=\"\">
<p align=\"left\" style=\"margin-top: 0; margin-bottom: 0\"><input type=\"radio\" value=\"Réalisée\" name=\"maj\">Réalisée</p>
<p align=\"left\" style=\"margin-top: 0; margin-bottom: 0\"><input type=\"radio\" value=\"Non Réalisée\" name=\"maj\">A faire</p>
<p align=\"left\" style=\"margin-top: 0; margin-bottom: 0\"><input type=\"radio\" value=\"Autre\" name=\"maj\">Autre</p>
</td></tr></table>");
}
?>