Document in your code that the order is significant -- so you don't screw up on a year or so and re-order it more pretty. Been there. Done that. On Fri, March 30, 2007 7:00 pm, Jake McHenry wrote: > Ok, this is working good, except for one problem... I have variable > $pay_rate and $pay_rate_bap ... It finds $pay_rate first and then it > never > finds $pay_rate_bap because it changes it to say.. 21_bap... Anyone > know of > anything else that may work? I have been messing around with eval, and > I > havn't gotten it to work even once yet... Always comes back with error > at > line 5 of eval'd.... And line 5 of the paragraph is a blank line... > Line 4 > is plain text... Not even a variable until line 12... > > I guess next I will play around with preg_replace, but I'm thinking I > will > have the same problem as I did with str_replace... As long as the > variable > names have any kind of similar names.... Correct? I can resolve this I > suppose, but the data is already in place and trying to work around > it... > > Thanks, > Jake > > > >> -----Original Message----- >> From: Jim Lucas [mailto:lists@xxxxxxxxx] >> Sent: Friday, March 30, 2007 7:32 PM >> To: Jake McHenry >> Cc: php-general@xxxxxxxxxxxxx >> Subject: Re: Parsing database variables >> >> Jake McHenry wrote: >> > Hi everyone, >> > >> > I have been searching and trying to do this for the past >> hour without >> > success yet.... >> > >> > >> > >> > I have a database table with this in it: >> > >> > >> > <p>$name<p> >> > Period Ending Date: $ppe<p> >> > Etc....... >> > >> > >> > And in my script, these variables exist and have values. Is >> there a way for >> > me to get the output from mysql_query to use the current >> script variables in >> > place of the same variable name within the database output? >> > >> > >> > >> > Thanks, >> > Jake >> > >> >> If I read the manual correct about how to setup the input >> values for str_replace() >> you should be able to do the following. >> >> This is completely untested, since I have now system like >> yours. But here is goes... >> >> >> #setup the entries that you want to find. >> $find[] = '$name'; >> $find[] = '$ppe'; >> >> #setup the values to be replaced. >> #Mind you to keep the indexes the in sync with $find... >> $replace[] = $name; >> $replace[] = $ppe; >> >> echo '<pre>'; >> >> while ( $row = mysql_fetch_assoc($resultHandle) ) { >> >> $row = str_replace($find, $replace, $row); >> >> // do something with $row. Display it maybe... >> >> var_dump($row); >> >> } >> >> echo '</pre>'; >> >> Basically replace $find[0] with $replace[0] in any of the >> values of the return $row then replace the >> previous $row values with the newly modified values... >> Then go to the next index of $find[1] and >> $replace[1] and do the same thing until you are out of indexes. >> >> But this is a much better way of doing this than using >> eval(). eval is an evil little function! >> >> >> >> -- >> Enjoy, >> >> Jim Lucas >> >> Different eyes see different things. Different hearts beat on >> different strings. But there are times >> for you and me when all such things agree. >> >> - Rush >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> -- >> No virus found in this incoming message. >> Checked by AVG Free Edition. >> Version: 7.5.446 / Virus Database: 268.18.23/740 - Release >> Date: 3/30/2007 1:15 PM >> >> > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.446 / Virus Database: 268.18.23/740 - Release Date: > 3/30/2007 > 1:15 PM > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Some people have a "gift" link here. Know what I want? I want you to buy a CD from some indie artist. http://cdbaby.com/browse/from/lynch Yeah, I get a buck. So? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
