Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given i

[markymark]

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\New\cartnisya.php on line 15

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\New\cartnisya.php on line 74

CODE

$db = mysql_connect("localhost", "root","");

mysql_select_db("vinnex",$db);

mysql_query("Delete From temptransaction",$db);

//mysql_query("Delete From temporderdetails",$db);

$Username = $_POST['Username'];

$Password = $_POST['Password'];

$result = mysql_query("Select TransNo From transaction", $db);

$myrow = mysql_fetch_array($result);

if ($myrow=='')

{

$TransNo='1000';

$q = mysql_query("Select Username, Lastname, Firstname From customer where Username=$Username, Lastname=$Lastname, Firstname=$Firstname ");

$myrow1 = mysql_fetch_array($q);

$Username = $myrow1['Username'];

$Firstname = $myrow1['Firstname'];

$Lastname = $myrow1['Lastname'];

$name = $Firstname. " ".$Lastname;

$sql1 = " INSERT INTO temptransaction (TransNo, Username, Firstname, Date)

  VALUES ('$TransNo', '$Username', '$Firstname', '$Date')";

$result = mysql_query($sql1) or die(mysql_error());

}

else

{

$sql = mysql_query("Select max(TransNo) maxTransNo From transaction", $db);

$myrow1 = mysql_fetch_array($sql);

$orderno = $myrow1['maxTransNo']+1;

$sql = mysql_query("Select Username, Lastname, Firstname From customer where Username=$Username, Lastname=$Lastname, Firstname=$Firstname");

$myrow1 = mysql_fetch_array($sql);

$Username = $myrow1['Username'];

$Firstname = $myrow1['Firstname'];

$Lastname = $myrow1['Lastname'];

$Date = date('m/d/y');

$sql1 = " INSERT INTO temptransaction (TransNo, Username, Firstname, Date)

  VALUES ('$TransNo', '$Username', '$Firstname', '$Date')";

$result = mysql_query($sql1) or die(mysql_error());

}

 

please help masters im just newbie in php.

[Pikachu2000]

Your query is failing and returning a boolean FALSE to mysql_fetch_array(). All string data should be in single quotes in the query strings. i.e. WHERE username = '$username' , etcetera.

[coupe-r]

Shouldn't the query also read:

 

Select Username, Lastname, Firstname From customer where Username='".$Username."' AND Lastname='".$Lastname."' AND Firstname='".$Firstname."'

 

You are missing the AND as well as quotes.