trouble figuring out variable name...

[lmayer4]

Afternoon,

I have a form field:

<select name="rowdata[<?PHP echo $cnt; ?>][ORFacility]">

I want to use that variable to update a table this is the query:

$setFacilityID = "update tblTrailersOnRoad
set ORFacilityID = tblLocation.FacilityID
from tblTrailersOnRoad, tblLocation
where tblTrailersOnRoad.ORFacility = tblLocation.Facility
AND ORDate = '$ORDate'";

mssql_query($setFacilityID);

Everything else works except this so I'm guessing I just can't get the name right.

Any thoughts would be greatly appreciated.

Thanks so much

Laura

[Roger_Ramjet]

echo the query before you run it to see what you are submitting, probably a simple syntax error. But I can't actaully follow your code myself. Sure select has a name, but it will return the valus of the option selected. Where are the options in your code and how do you fill them?

[lmayer4]

Thanks,

I've attached the file so you can see what I'm doing.

Laura

[tsinka]

Hi,

the code looks some kind of familiar to me ...

You have urldecode($POST['ORDate']). I think that's the problem because ORDate is part of $rowdata. So in this case try $arr['ORDate'] instead of $POST['ORDate']. One thing I noticed is that you concat all the INSERT queries and execute the mssql query after the foreach loop has finished. Does that work ?

Thomas

[lmayer4]

You mean after all the hacking I've done you still recognize your own code? Who would have thunk 🙂

I'll give the $arr thing a shot. I knew I was referencing it wrong.

Yes the inserts work perfect it's just the field name that was giving me fits.

Laura

[lmayer4]

Alright it's official. Your a genius! Worked like a charm.

Thanks you Thomas. I think you're up to a years subscription to Starbucks 🙂

Thanks again.

Laura