Order number variable

[mehnihma]

Hi

Can you maybe tell me how to put order number in pdf?

 

I have tried many variables and did not get how to get order number php variable?

 

 

Thanks

[brian!]

if it existed, I think logically it would be $ordernum - but I don't think the order number is passed to the invoice as a variable... therefore, you will have to query the database to obtain the value yourself...

 

# Obtain Order Number from database
$query = mysql_query("SELECT ordernum FROM tblorders WHERE invoiceid = $invoicenum");
$result = mysql_fetch_array($query);
$ordernum = $result["ordernum"];    

then you just use $ordernum in your output wherever you want to show the order number.

[mehnihma]

Hi

Thanks

I got it working like this:

 

$query = mysql_query("SELECT ordernum FROM tblorders WHERE userid = $userid");

$result1 = mysql_fetch_array($query);

$ordernum1 = $result1["ordernum"];

 

In your example I just got blank string not sure why

[brian!]

In your example I just got blank string not sure why

i'm not sure your code will work if you use it with a client that has more than one order - it might just take the first order number it comes across for that client and might not be the correct order number for that invoice... my code will use the correct value if it exists.

 

I tested my code before posting and it worked - but remember that not all invoices will have an order number associated with them - e.g, I don't think any renewal invoices would have an order number...

Edited May 2, 2014 by brian!