Selecting parts of an ID

[MitchEvans]

I need to select certain parts of my ID's.
They are stored like this:

//ID//
A10-0
A10-1
A124-0
A124-1
A124-2
A28-0

Now I just need to select the parts shown below:

//ID//
A10
A124
A28

So somehow I need to snip the text off after or before the "-"
How can I do this please?

[ClarkF1]

Use explode()

[MitchEvans]

And how would I do this?

If my select statement was "Select id from table;"

[lozza1978]

MitchEvans wrote:

I need to select certain parts of my ID's.
They are stored like this:

//ID//
A10-0
A10-1
A124-0
A124-1
A124-2
A28-0

Now I just need to select the parts shown below:

//ID//
A10
A124
A28

So somehow I need to snip the text off after or before the "-"
How can I do this please?

As ClarkF1 mentioned, you use explode with the dielimiter "-".
explode("-",$variable_to_spilt);

HTH

[MitchEvans]

Any ideas how I would apply this to a simple query, such as:

"SELECT id FROM table;"

[Installer]

Or strtok()

$arr = array('A10-0', 'A10-1', 'A124-0', 'A124-1', 'A124-2', 'A28-0');
$new_arr = array();
foreach ($arr as $id) {
    $prefix = strtok($id, '-');
    if (!in_array($prefix, $new_arr)) {
        $new_arr[] = $prefix;
    }
}

[ClarkF1]

MitchEvans wrote:

Any ideas how I would apply this to a simple query, such as:

"SELECT id FROM table;"

You just get the id from the database as you normally would and then use the explode function of it.

The first element of the resultant array is what you are after.

If you are grabbing all the id numbers, just use explode on them and add the first element of the resultant array to a new array

[MitchEvans]

How would I apply this to the following (the grpid is the one that needs snipping/exploding):

$typesSQL = "(SELECT grptype, grpid FROM user_tasks WHERE custid = '$username' AND buildid = '$buildingid') ORDER BY grpid";
	$typesResults = mysql_query ($typesSQL);

	while ($typesRow = mysql_fetch_assoc ($typesResults)){
    $test = $typesRow["grpid"];
	$types[$test] = $typesRow["grptype"];

$testSQL = "(SELECT fvalue FROM user_tasks WHERE grptype = '$types[$test]' AND grpid = '$test' AND custid = '$username' AND buildid = '$buildingid' AND areaqty = 'Area' AND catname='Hard Floor Care') ORDER BY grpid";	
$testResults = mysql_query ($testSQL);
$testRow = mysql_fetch_array ($testResults);

		$assoc1[$test] = $testRow["fvalue"];	

$test1SQL = "(SELECT fvalue FROM user_tasks WHERE grptype = '$types[$test]' AND grpid = '$test' AND custid = '$username' AND buildid = '$buildingid' AND areaqty = 'Area' AND catname='Carpet Care') ORDER BY grpid";	
$test1Results = mysql_query ($test1SQL);
$test1Row = mysql_fetch_array ($test1Results);

		$assoc[$test] = $test1Row["fvalue"]+$assoc1[$test];		

}

[ClarkF1]

I don't understand why you don't try what we are telling you to do

$explode = explode("-",$typesRow['grpid']);
$test = $explode[0];

It couldn't have been easier

[lozza1978]

ok d00d.

You query the server with..

"SELECT id FROM table;"

Then you use mysql_fetch_array() to grab all the results into an array(), this array now contains all your ID'S
example code...

$sql = "SELECT id FROM table;";
$query = mysql_query($sql);

while($row =  mysql_fetch_array($query));
{
echo $row['ID'];//depends on the name of the row in mysql

}

the script above will output all your IDS as you have stored them in SQL.

lets move on..
example code!

$sql = "SELECT id FROM table;";
$query = mysql_query($sql);

while($row =  mysql_fetch_array($query));
{
echo explode("-", $row['ID']);//depends on the name of the row in mysql

}

now it will display all your id's in the correct format you require... trust me try it, it will work!

let us know how you get on

hth

lozz

[bradgrafelman]

lozza1978 wrote:

trust me try it, it will work!

Actually, it won't, but you're close:

$sql = "SELECT id FROM table;"; 
$query = mysql_query($sql); 

while($row =  mysql_fetch_array($query)); 
{ 
$explode = explode("-", $row['ID']);//depends on the name of the row in mysql 
echo $explode[0];
} 

[MitchEvans]

My grpid's in the select statement now don't match as they've been exploded, any ideas how to resolve this?

[lozza1978]

bradgrafelman wrote:

Actually, it won't, but you're close:

Damm, That will teach not to post code before i tried it... doh.