mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...

mideastgirl

What does this error mean?

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/m/i/d/mideasthonors/html/student_session_proposal_success.php on line 109
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

This is the code, but I am not seeing what they are talking about:

Expand|Select|Wrap|Line Numbers

 
   <?

include("admin-dbcon.php");

$ID=$_GET['sessionproposalID'];

$sessionsql=mysql_query("SELECT primary_contact, primary_email, primary_institution, presenter_2, presenter_2 email, presenter_2 institution,

presenter_3, presenter_3 email, presenter_3 institution, presenter_4, presenter_4 email, presenter_4 institution, abstract_title, abstract_description,

session_length, session_category, av_equipment, MONTHNAME(dtAdded) as month, YEAR(dtAdded) as year, DAYOFMONTH(dtAdded) as day FROM student_session_proposals WHERE ID=$ID");

$row=mysql_fetch_array($sessionsql) or die(mysql_error());

echo "<b>Thank You!</b><br/>";

echo "Your prpopsal has been received. Below is your confirmation information.</p>";

echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"600\" border=\"0\">";

echo "<tr>";

echo "<td valign=\"top\"><p><b>";

echo $row["primary_contact"];

echo "&nbsp;";

echo $row["primary_email"];

echo "&nbsp;";

echo $row["primary_institution"];

echo "&nbsp;";

echo $row["presenter_2"];

echo "&nbsp;";

echo $row["presenter_2 email"];

echo "&nbsp;";

echo $row["presenter_2 institution"];

echo "&nbsp;";

echo $row["presenter_3"];

echo "&nbsp;";

echo $row["presenter_3 email"];

echo "&nbsp;";

echo $row["presenter_3 institution"];

echo "&nbsp;";

echo $row["presenter_4"];

echo "&nbsp;";

echo $row["presenter_4 institution"];

echo "&nbsp;";

echo $row["abstract_title"];

echo "&nbsp;";

echo $row["abstract_description"];

echo "&nbsp;";

echo $row["session_length"];

echo "&nbsp;";

echo $row["session_category"];

echo "&nbsp;";

echo $row["av_equipment"];

echo "&nbsp;";

echo "</b>";

echo "<br/>";
 
mysql_free_result($sessionsql);

ob_end_flush();

  ?>

Dormilich

try this:

Expand|Select|Wrap|Line Numbers

$sessionsql=mysql_query(…) or die(mysql_error());

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...

re: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about