[SOLVED] Can some one help debug this?

[ballhogjoni]

if (($_SESSION['IPAddress']) == ($ip)) {

$result = mysql_query("SELECT * FROM address WHERE IPAddress=$_SESSION['IPAddress']");

if( mysql_num_rows($result) == 1 ) {

$sql = "SELECT FIRSTNAME, LASTNAME, STREET1, STREET2, CITYNAME, STATEORPROVINCE, POSTALCODE, COUNTRY, PHONE, PAYER, IPAddress FROM address WHERE IPAddress='$_SESSION['IPAddress']'";

$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);

[kenrbnsn]

And the problem is?

 

Ken

[ballhogjoni]

sorry bout that.

 

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/realfina/public_html/ec/checkout/functions.php on line 323

[MadTechie]

$sql = "SELECT FIRSTNAME, LASTNAME, STREET1, STREET2, CITYNAME, STATEORPROVINCE, POSTALCODE, COUNTRY, PHONE, PAYER, IPAddress FROM address WHERE IPAddress='{$_SESSION['IPAddress']}'";

 

&&

 

"SELECT * FROM address WHERE IPAddress={$_SESSION['IPAddress']}"

[kenrbnsn]

You need to put "{ }" around the array references in the query strings:

<?php
if (($_SESSION['IPAddress']) == ($ip)) {
   $result = mysql_query("SELECT * FROM address WHERE IPAddress='{$_SESSION['IPAddress']}'");
   if( mysql_num_rows($result) == 1 ) {
   $sql = "SELECT FIRSTNAME, LASTNAME, STREET1, STREET2, CITYNAME, STATEORPROVINCE, POSTALCODE, COUNTRY, PHONE, PAYER, IPAddress FROM address WHERE IPAddress='{$_SESSION['IPAddress']}'";
   $result = mysql_query($sql);
   $row = mysql_fetch_assoc($result);
?>

 

or use concatenation:

<?php
if (($_SESSION['IPAddress']) == ($ip)) {
   $result = mysql_query("SELECT * FROM address WHERE IPAddress='" . $_SESSION['IPAddress'] ."'");
   if( mysql_num_rows($result) == 1 ) {
   $sql = "SELECT FIRSTNAME, LASTNAME, STREET1, STREET2, CITYNAME, STATEORPROVINCE, POSTALCODE, COUNTRY, PHONE, PAYER, IPAddress FROM address WHERE IPAddress='" . $_SESSION['IPAddress'] . "'";
   $result = mysql_query($sql);
   $row = mysql_fetch_assoc($result);
?>

 

Ken