Home
Featured Product
How To
FAQ
Industry Links
Contact Us
Samples
Return Policy
Privacy Statement
|
Products
select * from tbl_lines where parent_no = 1 Order By name asc
#getlines.name#
select *
from tbl_lines
where parent_no = #getlines.lines_ID#
ORDER BY Name
select * FROM tbl_lines
WHERE parent_no=#getsublines.parent_copy##getsublines.lines_ID#
•
#getsublines.parent_copy##getsublines.lines_ID#">#getsublines.name#
select *
from tbl_lines
where parent_no = #current_id#
ORDER BY Name
• #getsublines2.parent_copy##getsublines2.lines_ID# " >#getsublines2.name#
Select *
from tbl_copyprods
where Newline = #getsublines2.lines_ID#
Select distinct name, line, imagefilename1
from tbl_products
where line = #getsublines2.lines_ID# OR (line = #getcopies.mainline# AND name LIKE "#getcopies.name#")
Group By Name
Select *
from tbl_copyprods
where Newline = #getsublines2.lines_ID# AND Name LIKE '#getproducts.name#'
- #getproducts.name#
Select *
from tbl_copyprods
where Newline = #current_id#
Select distinct name, line, imagefilename1
from tbl_products
where line = #current_id# OR (line = #getcopies.mainline# AND name LIKE "#getcopies.name#")
Group By Name
Select *
from tbl_copyprods
where Newline = #current_id# AND Name LIKE '#getproducts.name#'
- #getproducts.name#
|
