Truncating variable name to specific length

[Gary_Kambic]

Hello,

I am receiving a variable from a program which can be any one of the following:

$client_id_rolling_1
$client_id_rolling_2
$client_id_rolling_3
.
.
.
$client_id_rolling_12

As indicated in the following query, I don't know which variable the program will send as the user is selecting from list. I need convert one of the above to a generic variable named $client_id_rolling so I can search the table for that id.

Any thoughts?

Thanks,

Gary

$query = "SELECT * FROM clients WHERE id = '$client_id_rolling'";

[zhabala]

Could you show us the form, where the user selects the variable ? There is probably error in field name, it could be so called array.

Zdenek

[Gary_Kambic]

Program searches and sends $client_id_rolling_? as part of a Post:

while ($row = mysql_fetch_assoc($result)) {
$client_id = $row["id"];
$client_agent_id = $row["agent_id"];
if ($client_agent_id == $agent_id_login) {
$client_match = "true";
++$client_counter;
$client_id_rolling = "client_id_rolling_" . "$client_counter";
$client_first_name = $row["client_first_name"];
$client_last_name = $row["client_last_name"];
$client_address_1 = $row["client_address_1"];
$client_address_2 = $row["client_address_2"];
$client_city = $row["client_city"];
$client_state = $row["client_state"];
$client_zip_code = $row["client_zip_code"];
$client_email_address = $row["client_email_address"];
$client_display .= "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"760\" height=\"190\">

---

<form action=\"agent_contact_client_7621297_specific_651132347765348.php\" method=\"POST\">
<input type=\"hidden\" name=\"agentemailaddress\" value=\"$agentemailaddress\">
<input type=\"hidden\" name=\"agentpassword\" value=\"$agentpassword\">
<input type=\"hidden\" name=\"login_status\" value=\"$agent_login\">
<input type=\"hidden\" name=\"agency_name\" value=\"$agency_name\">

<input type=\"hidden\" name=\"agent_first_name\" value=\"$agent_first_name\">
<input type=\"hidden\" name=\"agent_last_name\" value=\"$agent_last_name\">
<input type=\"hidden\" name=\"$client_id_rolling\" value=\"$client_id\">

<input name=\"email_client\" type=\"submit\" value=\" E-Mail Client \">
</form>

[zhabala]

I do not see a sense, why it is done this way. Why you need different variable name, when there is only one variable with this meaning ?

Zdenek

[weekender]

if you had to do it this way, do it like this

//loop through all GET vars
foreach($_GET AS $key=>$val){
    //if the name of the var includes "client_id_rolling_"
    if(strstr($key, "client_id_rolling_")){
        //set the variable
        $client_id_rolling = $val;
    }
}

[Gary_Kambic]

Weekender, thanks for the script it worked great.

I know it seems strange the way I have the code written but I have my reasons for doing it this way and you got me over the hump, thanks, Gary.

[weekender]

no problemo Gary. It's a pain, but sometimes you just gotta do stuff the hard way i guess!