[RESOLVED] [ask] how to implement substring function in this case?

coolbear91

hi guys,
I have some code snippet:

    $rs = mssql_query("[SQL SELECT STATEMENT]");
    $rx = mssql_fetch_array($rs);
    echo $rx['ne'];

which generated the output below:

ABCD5
ABCD6
ABCD8
ABC24,BC0
ABC25,BC0

I want to replace the comma found in output with other character (-) by using substring function,
but I still get messed up about how to implement this way.
as I'm still new in using PHP.
so, can u guys help me?

thx b4.

big_nerd

coolbear91,

A couple of things.

Unless you are using a while() statement, just using $rx = mssql_fetch_array($rs); will only get the first result.

what you've posted really isn't enough to try to help you, but I'll give it my best shot.

Possibility 1:

    $rs = mssql_query("[SQL SELECT STATEMENT]");
    while ($rx = mssql_fetch_assoc($rs)) {
        $ne = str_replace(',','-',$rx['ne']);
        echo $ne; 
    }

    $rs = mssql_query("[SQL SELECT STATEMENT]");
    $rx = mssql_fetch_array($rs);
    $ne = str_replace(',','-',$rx['ne']);
    echo $ne;

Either way, I hope I've pointed you in the right direction..

laserlight

Use [man]str_replace/man.

sneakyimp

Also, when you run queries on a database (or when you connect, etc.) you should check the query result for an error -- otherwise your script may fail unpredictably.

coolbear91

@: thx.. I will then first run the query on sql server to check whether it returns the result finely or not

@: thx 4 your advice, bro

@big.nerd: thx 4 your explanation..
FYI,
I had run the query in SQL and returns 12 rows as below:

MSJ24,BC0
MSJ24,BC1
MSJ24,BC2
MSJ24,BC3
MSJ24,BC4
MSJ24,BC5
MSJ24,BC6
MSJ24,BC7
MSJ24,BC8
MSJ24,BC9
MSJ24,CP1
MSJ24,CP2

I had tried using

while ($rx = mssql_fetch_assoc($rs))

and it returns some output as above..
but it couldn't stop looping.
how can I fix this?

JVassie

coolbear91;10974025 wrote:
@: thx.. I will then first run the query on sql server to check whether it returns the result finely or not

@: thx 4 your advice, bro

@big.nerd: thx 4 your explanation..
FYI,
I had run the query in SQL and returns 12 rows as below:

MSJ24,BC0
MSJ24,BC1
MSJ24,BC2
MSJ24,BC3
MSJ24,BC4
MSJ24,BC5
MSJ24,BC6
MSJ24,BC7
MSJ24,BC8
MSJ24,BC9
MSJ24,CP1
MSJ24,CP2

I had tried using
while ($rx = mssql_fetch_assoc($rs))
and it returns some output as above..
but it couldn't stop looping.
how can I fix this?

Well we're assuming you were trying to run a PHP script. Are you typing the code into phpmyadmin or similar?

coolbear91

JVassie;10974038 wrote:
Well we're assuming you were trying to run a PHP script. Are you typing the code into phpmyadmin or similar?

no I didn't used phpmyadmin..

well, I just trying to display the output by using popup:

echo "
<script>
alert('$ne');
</script>
";

then it shows a never ending loop popup message.

but now I just thought, it's ok..
as I just wanna see the output, so it's not the main idea I have to solve.
🙂