SQL error

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Jobao
Forum Newbie
Posts: 1
Joined: Thu Sep 08, 2005 8:49 am

SQL error

Post by Jobao »

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

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\">&nbsp;</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\">&nbsp;</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>"); 
} 
?>
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

you likely have a syntax error or logic error in your query try things like this

Code: Select all

$formation = mysql_query('your query here') or die(mysql_error());
Post Reply