[Resolved] Invalid Resource

loureiro

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /nfs/home/london7/public_html/remax-us/firepay.php

  // select all info for pending customer
  $sqlCustomer = "SELECT * FROM PendCustomer WHERE clientID = \"".$_POST["clientID"]."\"";
  if($pendCustomerQuery = mysql_query($sqlCustomer) && $errorCheck)
  {
    //user exists-- error is on this line
    list($_SESSION['clientIDPend'],$_SESSION['companyIDPend'],$_SESSION['firstPend'],$_SESSION['middlePend'],$_SESSION['lastPend'],$_SESSION['titlePend'],$_SESSION['mobilePend'],$_SESSION['emailPend'],$_SESSION['photoPend'],$_SESSION['personalPend'],$_SESSION['programPend'],$_SESSION['passwordPend'],$_SESSION['productPend'],$_SESSION['versionPend'],$_SESSION['trialLengthPend'],$_SESSION['expiryDatePend'],$_SESSION['subDirectoryPend'],$_SESSION['primaryPend'],$_SESSION['statusPend'],$_SESSION['linkPend'],$_SESSION['userNotesPend'],$_SESSION['paidPend'],$_SESSION['datePend']) = mysql_fetch_row($pendCustomerQuery);

the error is on the long line...the mysql_fetch_row

can anyone help?

swr

The argument is "not a valid MySQL result resource" because the query failed. You're trying to get results from a query that failed.

Move the mysql_query call out of the if, and add "or die(mysql_error())" like this:

$pendCustomerQuery = mysql_query($sqlCustomer) or die(mysql_error());

Always call mysql_query() like that, or you won't know why it failed.

Looking at the query, I'd bet it's because you're using double quotes. SQL uses single-quotes around strings. Like this:

$sqlCustomer = "SELECT * FROM PendCustomer WHERE clientID = '".$_POST["clientID"]."'";

loureiro

actually that piece of code worked before i made some very minor changes. i echoed out the query and ran it manually and it returned the results i was looking for. i just thought it was weird which is why i posted a message in here. i will try using single quotes to see if that makes a difference. thanks for the post

loureiro

i figured out what the problem was! it was in the logic of the if statement. There needed to be brackets around the assignment statement. it wasnt processing the statement in the correct order. here is the new process statement compared to the old:

NEW

if(($pendCustomerQuery = mysql_query($sqlCustomer, $dbh)) && $errorCheck)

OLD

if($pendCustomerQuery = mysql_query($sqlCustomer) && $errorCheck)