2. PHPRunner General questions
  3. Extract info from 1 table to another base on certain field
This topic is locked

Extract info from 1 table to another base on certain field

 		6/19/2008 9:33:32 PM
PHPRunner General questions
lukey author

Hi,
I have 2 TABLES - IPDATA & OUI
the IPDATA table has 3 fields
IP Address

MAC address
for the OUI i have 2 fields
OUI

MANUFACTURER
as we know the mac address first 6 char is for the manufacturer
how do i list the manufacturer field (pull data from OUI table based on the first 6 char in the MAC field ) in phprunner list view
J
 		Jane 6/20/2008

Hi,
where do you want to pull in and show information from OUI table: on the list page in the other column, on the view page?
lukey author 7/12/2008

Hi,

where do you want to pull in and show information from OUI table: on the list page in the other column, on the view page?


on the list page
J
 		Jane 7/14/2008

Here are some tips:

  1. join two tables on the Edit SQL query tab.
  2. to cut six symbols only use substr() MySQL functions:

    http://dev.mysql.com/doc/refman/5.0/en/str...function_substr