Error

[nuju_sj]

I usually get the following when trying to connect:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/raazz053/public_html/Product_Details.php on line 186
====================================================================

<?
$sql=mysql_query("Select Title from tblMain where Id=$a_row[McatId]");
$amyrow=mysql_fetch_array($sql); ---error line 186
?>

Help!!

[codyrockx]

try this,

 $sql=mysql_query("Select Title from tblMain where Id = '$a_row[McatId]'"); 

[EspenA]

Hi nuju_sj,

Have you tried to add the mysql_error() function after mysql_query?

$sql=mysql_query("Select `Title` FROM `tblMain` WHERE `Id` = '$a_row[McatId]'") or die(mysql_error()); 

[Cam]

It's easier to find errors if you lay your code out properly and make up some nice SQL error handler function

  function mysql_die() {
      global $sql;
  
      echo '<b>Oops, an error has occurred and here\'s why:</b><br />
         <blockquote>' . mysql_error() . '</blockquote><br /><br />
          <b>Offending SQL:</b><br />
          <pre>' . $sql . '</pre>';
      return true;
  }
  
  $sql = "select
              title
          from tblmain
          where
              id = '{$a_row['McatId']}'" ;
  
  $rs = mysql_query($sql) or mysql_die(); 

[EspenA]

It's easier to find errors if you lay your code out properly and make up some nice SQL error handler function

Nice function Personally, I prefer this method:

function SQLError($query, $file, $line, $mysql_error) {
  echo "<table cellspacing=\"1\"><tr><th colspan=\"4\">SQL Error - Details</th></tr>
  <tr><td><strong>SQL Query:</strong></td><td>$query</td></tr>
  <tr><td><strong>File:</strong></td><td>$file</td></tr>
  <tr><td><strong>Line:</strong></td><td>$line</td></tr>
  <tr><td><strong>MySQL said:</strong></td><td>$mysql_error</td></tr>
  </table>";

  echo "</body>
  </html>";

  exit;
} // end function 

And then:

$query = "SELECT count(*) AS `count` FROM `categories`";
$result = mysql_query($query);

if (!$result) {
  SQLError($query, __FILE__, __LINE__, mysql_error());
} // end if 

[Cam]

Yeah, I just wrote that function for that post. My won DB object has a much more in-depth error handler