Return Formatted page with data from 1 record

Trying to get something to work that I assume should be easy but I can’t figure out how to get it to work.

I am trying to create a Work Order page from my job database. All of the info is contained in one row in my database. The webpage that will call the page will be something like "http://www.aaa.com/show_workorder.php?jobnumber=[jobnumber] (the bracketted job number will be the actual job number).

I tried to create the databinding to grab the data --> Select * from jobs where jobnumber = {{jobnumber}}. I can’t seem to get this to work from the server. If I change the query to "Select * from jobs where jobnumber = 12345, I am able to browse to the resulting data fine.

{“jobinfo”:[{“jobID”:“12345”,“jobnumber”:“2828623”,“PO_Number”:“55555”,“coname”:“SomeCo”,“bill_Address”:“123 Street”,“bill_City”:“SomeCity”,“bill_State”:“CA”,“bill_Zip”:“90000”,“phone”:“310-555-1275”,“Time_In”:null,“Date_In”:null,“Job_Title”:“Some bcards",“email”:"tim@aol.com”,“Quantity”:null,“JobType”:“Offset Printing”,“Notes”:null,“BinderyNotes”:null,“PressNotes”:null}]}

For setting up the php file, I basically just want to put something like this:

Job Number: {{returns job number}}
Job Title: {{returns job title}}
etc.

I looked at the docs and saw how to create a table with multiple values but I can seem to just display single variables. Sorry if this is basic but I haven’t quite figured out wapplers way of doing it.

Thanks for you help.

Tom Komin