string concatenation

[lc21]

This syntax throws an error, I am not sure how to concatenate the string. Is there a method of fixing this?

Thank you

 

$dbs = "SELECT roll, acNumber FROM excelDS WHERE rollAmount ='". $_SESSION ["rollAmount"]."'"AND $_SESSION["roll"] = '10000'";

[teng84]

try

$dbs = "SELECT roll, acNumber FROM excelDS WHERE rollAmount ='". $_SESSION ["rollAmount"]."' AND ".$_SESSION["roll"]." = '10000'";

 

[lc21]

That code then produces this,

 

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 '= 10000' at line 1

[lc21]

hmmmm that one could have been logic,  how would this one be fixed?

 

$excel = "SELECT rollN, tyU FROM excel WHERE roll ='". $_SESSION ["roll"]."' AND " rollExcel =".$_SESSION["rollExcel"].";

[pocobueno1388]

hmmmm that one could have been logic,  how would this one be fixed?

 

$excel = "SELECT rollN, tyU FROM excel WHERE roll ='". $_SESSION ["roll"]."' AND " rollExcel =".$_SESSION["rollExcel"].";

 

$excel = "SELECT rollN, tyU FROM excel WHERE roll ='". $_SESSION ["roll"]."' AND rollExcel = ".$_SESSION["rollExcel"]."";

[lc21]

Still get the same error...bad times.

 

It seems to be a problem with the $rollExcel as it has been set to = 1. Should that cause a problem?

[mihail]

$roll = $_SESSION ['roll"'];

$rollExcel = $_SESSION['rollExcel'];

$excel = "SELECT rollN, tyU FROM excel WHERE roll = '$roll' AND rollExcel = '$rollExcel'";

[marcus]

$excel = "SELECT `rollN`,`tyU` FROM `excel` WHERE `roll`='$_SESSION[roll]' AND `rollExcel` ='$_SESSION[rollExcel]'";

[MadTechie]

my 2cents

 

<?php
$dbs = "SELECT roll, acNumber FROM excelDS WHERE rollAmount ='{$_SESSION['rollAmount']}' AND {$_SESSION['roll']} = '10000'";
?>

 

or to concatenation

 

<?php
$dbs = "SELECT roll, acNumber FROM excelDS WHERE rollAmount ='".$_SESSION['rollAmount']."' AND ".$_SESSION['roll']." = '10000'";
?>

 

Try them.. and let us know:)

[MadTechie]

also

 

Still get the same error...bad times.

 

It seems to be a problem with the $rollExcel as it has been set to = 1. Should that cause a problem?

 

$rollExcel should be a field name!!

 

BUT it should be

$roll = $_SESSION ["roll"];

NOT

$roll = $_SESSION ['roll"'];

 

fix that problem...