a real strange one here?



Hi All

I have been chasing my tail on this for the last hour and have
now give up and am asking for help here

below is a bit of code, if $sate = 'details' then it runs the code,
it displays 3 buttons to run some JavaScript then runs one
of two MySQL select statements depending on what $type is
set to.

If $type is not set to 'brand' then is runs the second select statement
and all works fine.

If $type is set to 'brand' it runs the first select statement, and displays
the
correct info but the buttons to control the JavaScript now don't work???

I have been over this a 1000 times, and can't see any reason why this
would not work?

Anybody got any idea?

Brian







if ($state=='details') {
print "<p align=\"center\" ><input type=\"button\" name=\"backbtn\"
value=\"&lt;&lt; Back\" OnClick=\"JavaScript:history.back()\">
<input type=\"button\" name=\"printbtn\"
value=\"Printable version\" OnClick=\"JavaScript:Print('$orderno')\">
<input type=\"button\" name=\"exportbtn\"
value=\"Export to CSV\" OnClick=\"JavaScript:MakeZip('$orderno')\">

</p>";

if ($type == 'brand') {
$query = "SELECT * FROM $customer WHERE (lcase(orderno) =
lcase('$orderno')) AND (lcase(brand) = lcase(\"$access\"))";
} else {
$query = "SELECT * FROM $customer WHERE lcase(orderno) =
lcase('$orderno')";
}
$result = mysql_query($query,$db);
......................etc


.


Quantcast