By jono_howlett on

Hello all,

(I previously posted this in the "how do I" forum but got no responses)

I'm using Drupal as an aplication framwork to become the new front
end to a database. It works really well for what I have wanted to do so far
but I'm having problems passing variables to the php scripts in the nodes.
eg: I have a bit of php in the body of a node (set to php):

$db = mssql_connect("xxxxxxxx","hubble","xxxxxxxx") or die("Unable to connect to server");
mssql_select_db("excell");
$cust_id = $_POST['cust_id'];
$result = mssql_query("select * from customers where id = $cust_id;");
$num_rows = mssql_num_rows($result);
while ($myrow = mssql_fetch_row($result)){
       $id = $myrow[0];
       $company = $myrow[3];
       $addr1 = $myrow[4];
       $addr2 = $myrow[5];
       $addr3 = $myrow[6];
       $city = $myrow[7];
       $postcode = $myrow[10];
       $tel = $myrow[11];
       $fax = $myrow[12];
       $notes = $myrow[13];
       print ("<p><b>Customer Id:</b> $id - <b>company name:</b> $company - <b>Tel:</b> $tel - Notes: $notes'</p><p>Address: $addr1,<br>$addr2,<br>$Addr3,<br>$city,<br>$postcode,</p><hr>");
   }

and linking to it thus:

http://www.excellhelpdesk.com/intranet//?q=node/39/cust_id=220

However cust_id remains empty. Whats the easiest way around this? How to I pass
the variables in? Im sure this is a no brainer to all the php +drupal experts :-)

Any help greatly appreciated!

thanks

jono