Stuff!
Posted: Tue Apr 30, 2002 5:49 am
yes yes i know its a lame question,, so just help me and prove me to be so.
ok here's my situation...
i'm creating an invoicing system ,, i have a table for invoices and a table for the services applicable
..i also have a form to generate a invoices ..it lists all the services dynamically with an array from the services table and gives each one its own checkbox with a name like name=sid_array[] and a value=$sid ..
this is all fine so far.
..when submitted to the generation page which will do all the work(totals and costs for services) i do something like this
if ($sid_array)
{
$stypes = implode($sid_array, "|");
}
(which gives me the service id's in this form 1|2|3..etc)(this is the form i need the services id's in for storage in a single field in case your wondering)
now wut i need to do is be able to take each seperate $sid (in either the $sid _array or $stype) and do a lookup with mysql on the services table and list the the matching records/services..
i'm having some hell of a time doing this.. anyone have any ideas?
ok here's my situation...
i'm creating an invoicing system ,, i have a table for invoices and a table for the services applicable
..i also have a form to generate a invoices ..it lists all the services dynamically with an array from the services table and gives each one its own checkbox with a name like name=sid_array[] and a value=$sid ..
this is all fine so far.
..when submitted to the generation page which will do all the work(totals and costs for services) i do something like this
if ($sid_array)
{
$stypes = implode($sid_array, "|");
}
(which gives me the service id's in this form 1|2|3..etc)(this is the form i need the services id's in for storage in a single field in case your wondering)
now wut i need to do is be able to take each seperate $sid (in either the $sid _array or $stype) and do a lookup with mysql on the services table and list the the matching records/services..
i'm having some hell of a time doing this.. anyone have any ideas?