Walker33

HA! That was it. Perfect. Thanks so much for the advice!

hmm. Yes that should work, but it didn't. I echoed that, and I got: S01,S02,S03,S04,R01,R02 ,S05 So what I'm noticing is that there is an additional space after R02. Maybe that's the issue somehow, that additional space in my $licen variable?

Hi. When updating my row with two variables, the order ' ".$reso.",".$licen." ' works perfectly fine. But when I flip them to ' ".$licen.",".$reso." ' it only updates the $licen variable and ignores the $reso. $licen is a string consisting of, say, S01,S02,S03,R01,R02,R03 . $reso returns a single variable, in this case S04. So I want the row to update to S01,S02,S03,R01,R02,R03,S04 (S04 at the end). But I can only manage to get it to update to S04,S01,S02,S03,R01,R02,R03 (S04 at the beginning). Any ideas? <?php $que = pg_query("SELECT sublicenses FROM sublicenses WHERE license = '$striplic'"); $getarr = pg_fetch_assoc($que); $licen = $getarr['sublicenses']; $string="$licen"; $domain3=strrchr($string,"S"); $string2=split(",",$domain3); $res = $string2['0']; $number = (int) $res[2]; $new_number = $number+1; $reso = substr_replace($res, $new_number, 2); $intosubs2 = pg_query ("UPDATE sublicenses SET sublicenses = ' ".$reso.",".$licen." ' WHERE license = '$striplic' "); ?> So code above works fine. Don't understand why I can't flip the $reso $licen over to $licen $reso. Would really appreciate any help. Thanks!

Quick thought: Actually, I would say that it's quite a bit of help that non-tech people think anything is possible (not in an hour, and not without $$$$). I started my company with an idea and no tech knowledge (which I still lack, quite obviously) and thousands of people currently benefit from the idea and the product. I hired brilliant developers to implement it, but I had some pretty fantastical expectations to start. But I think that's what keeps the big minds (like all of you) rockin' and rollin'. Great practical minds need great dreamer ideas. How many superstar guitarists play fairly simple songs for a living but don't write any of their own? First, Asimov or Heinlen (or whoever) has to propose the theory in a fictional sense, and then a whole team of people brighter than them, like NASA, make the theory a reality. I think the world needs both, the dreamers and the do-ers. Where would the Beatles have been without Brian Epstein? Where would Brian Epstein have been without the Beatles? Anyway, that's just my two cents. I think it's symbiotic. Again, all of you are a great help to me in the stuff I'm trying to accomplish on my own (trying to cut some costs in these tough times). You really have no idea how much I appreciate your patience and good advice. Thanks again!

(whoops) a nightmare. And yes, we already ran into the field length issue in the past. Fixed by our actual developers. Anyway, thanks again.

Ha! Believe me, the main difficulty is my inexperience with the database, php, you name it! I'm trying to read and study as much as I can, but yes, I'm extremely green to all of this. Yes, you are right about the ap, all sorts of hooks and such. A universal update would be required, and with our customers, that is ALWAYS

Again, I agree. Additional problem is that the software we sell looks to that existing column for validity, so changes to the actual app would be required, as well.....but in time, yes, you're most likely right, better to switch it up. Hey, I really appreciate all your tips and suggestions! Gotta run, but I'll give these suggestions a shot tomorrow. As always, this group is great. Thanks!

And yes, you're right, PFMaBiSmAd, separate rows would simplify a lot of things. I didn't build it. On the other hand, some accounts have as many as 60 subs, so that might get messy, too. But I agree with you overall.

Before update, it can contain, for example, R01,R02,R03,S01,S02,S03,A01,A02,A03,A04 After update: S04 What I want is: R01,R01,R02,R03,S01,S02,S03,A01,A02,A03,A04,S04

Problem is there is already a bunch of data in the row, and I need to keep that in there. I just need to add the new data from the $res2 variable. Using UPDATE eliminates existing data and replaces it with $res2 instead of just adding the $res2 data.

I apologize in advance if this is a ridiculously simple question, but I can NOT find the answer anywhere and everywhere. I'm attempting to use update to add additional data to a row, but I don't want to change the data in there. Obviously, update eliminates what's there and inserts the new data. <?php $striplic = substr($isolate,0,9); echo "$striplic<br><br>" ; if($no_station=='addon_stn_1'){ if ($stn1_type =='scopist'){ $que = pg_query("SELECT sublicenses FROM sublicenses WHERE license = '$striplic'"); $getarr = pg_fetch_assoc($que); $licen = $getarr['sublicenses']; $string="$licen"; $domain3=strrchr($string,"S"); $string2=split(",",$domain3); print_r ($string2); $res = $string2['0']; echo "<br><br>$res"; $number = (int) $res[2]; $new_number = $number+1; $res2 = substr_replace($res, $new_number, 2); echo "<br><br>$res2"; //Adding sub for new scopist $intosubs2 = pg_query ("UPDATE sublicenses SET sublicenses = '$res2' WHERE license = '$striplic' "); echo "<br><br>should be a new one in subs"; exit; ?> As always, any help is greatly appreciated!

That's the ticket! This time I tested all dup numbers, 11, 22, 33, etc. Perfect. Thanks again, your help is greatly appreciated.

Spoke a second too soon. If my result is R11, your script returns R22 instead of R12.

Beautiful! Works like a champ. Thank you very much. I'm pretty new to this, so I wasn't aware of the str_replace function. Really appreciate your help!

And yes, it will always be a three-digit variable, one letter, two numbers.

Hmm. Put it in just as you wrote it, but not getting a return for the echo.

I have a column that contains a string, for example, R01,R02,R03,R04,S01,S02,S03,A01,A02. I need to isolate the last R or S or A, which my code does, but then I need to add one to that final variable. ++ just repeats it. Is there a simple way to do this then to split up $result ? <?php $query6 = pg_query("SELECT sublicenses FROM sublicenses WHERE license = '3RF6EWOT2'"); $getarray = pg_fetch_assoc($query6); $license6 = $getarray['sublicenses']; echo "$license6 <br><br>"; $string="$license6"; $domain3=strrchr($string,"S"); echo "$domain3<br><br>"; if (!$domain3){echo "no licenses<br><br>";} $string2=split(",",$domain3); print_r ($string2); $result = $string2['0']; echo "<br><br>$result"; $addstn = $result++; echo "<br><br>$addstn"; ?> So my $result returns what I want, S03. But my $addstn also returns S03. I need a final return of S04, in this instance. Thanks a lot for any tips!

Cool! Thanks. I think I need to read up on it to understand more, but yes, that's getting me where I want to be. Thanks!

Okay, that's getting me there, but I guess I'm not fully understanding something. I used <?php foreach($string2 as $key=>$value){ if(substr($value, 0, 1) != "S") unset($string2[$key]); echo $key; ?> and my echo pumps out the numerical count of the entire array, along with the S values. How do I isolate the S values in an echo?

I have a row with values R01,R02,R03,S01,S02,S03,A01,A02,A03. I can get them, split them, and pick out a specific value. But I need to use a wildcard to pick out all the "S" group, for example. <?php $query6 = pg_query("SELECT sublicenses FROM sublicenses WHERE license = '3RF6EWOT2'"); $getarray = pg_fetch_assoc($query6); $license6 = $getarray['sublicenses']; echo "$license6 <br><br>"; $string="$license6"; $string2=split(",",$string); print_r ($string2); // Here's where I need to remove the elements who's values contain R or A, but % and * aren't working in whatever form I use. Can remove R01, R02, A01, etc., if I predetermine that, as below. $arr = array_diff($string2, array("R01", "R01", "A01")); print_r($arr); //but can't get rid of all R's and A's ?> Always appreciate any help offered. Thanks!

I have a column with multiple values in each row, for instance R01,R02,R03,S01,S02,S03,A01,A02,A03 . I'm trying to grab the highest S value. But it's reading it as a single value, beginning with R. SELECT max (sublicenses) FROM sublicenses where license = '3RF6EWOT2' AND sublicenses like 'R%'; returns entire row SELECT max (sublicenses) FROM sublicenses where license = '3RF6EWOT2' AND sublicenses like 'S%'; returns empty, as it should, I think, because it's reading it all as a single value, beginning with the first R. Can anyone point me in the right direction how to query this to return a max value of R03 or S03? Any help is greatly appreciated.

Still not getting any output for $license6 . Wasn't sure how to use Ken's substring. I know there's at least one value, because when I make license = 'value' , it spits it out. <?php $query5 = ("SELECT License_Num FROM demo_details WHERE ((RFirstName like '%$FName1%' AND RLastName like '%$LName1%') OR (REmail = '$billing_email') OR (SFirstName like '%$FName1%' AND SLastName like '%$LName1%') OR (SEmail = '$billing_email'))"); $result5 = mysql_query($query5) or die(mysql_error()); $myString=""; while($row5 = mysql_fetch_array($result5)){ $myString.="'".$row5['License_Num']."',"; echo $row5['License_Num']; echo "<br />"; //check trial license table to see that they're still in there $query6 = pg_query("SELECT license FROM triallics WHERE license IN (".$myString.")"); $getarray = pg_fetch_assoc($query6); $license6 = $getarray['license']; echo $license6 ; } ?>

I'm getting an array, and I want to use use each result in a subsequent query, but I'm not sure how to name the returned array to place it in the second query. So I'm trying to get license to equal all the results echoed in $row5['License_Num'] and echo whatever the second query returns. Stumped. <?php <? if ($result["r_approved"] == "APPROVED") // transaction processed successfully // check demo table if Initiator is reporter to see if they have a demo license: { $query5 = ("SELECT License_Num FROM demo_details WHERE ((RFirstName like '%$FName1%' AND RLastName like '%$LName1%') OR (REmail = '$billing_email') OR (SFirstName like '%$FName1%' AND SLastName like '%$LName1%') OR (SEmail = '$billing_email'))"); $result5 = mysql_query($query5) or die(mysql_error()); while($row5 = mysql_fetch_array($result5)){ echo $row5['License_Num']; echo "<br />"; //check trial license table to see if any results from 1st query exist $query6 = ("SELECT license FROM triallics WHERE license = '???'"); $result6 = pg_query ($query6); $row6 = pg_fetch_array ($result6); echo $row6['license']; } echo "you have some rows"; } ?> As always, any help is GREATLY appreciated!

Okay...I think I'm all backwards and need to start fresh....

yeah, I guess I am. I guess I don't understand, either, obviously. Should I be checking that license5 and creating a license6 on the pg_query to check?