substr value changes when submit to mysql

[cyberlei]

Hello Guys,

Just wondering how I can make the substr value changes when submit into mysql.

something like:
someone typed A123456 on a blank field and submit into mysql. the Value will only display 123456 in mysql

Thanks a lot

[nomad]

Hello Guys,

Just wondering how I can make the substr value changes when submit into mysql.

something like:
someone typed A123456 on a blank field and submit into mysql. the Value will only display 123456 in mysql

Thanks a lot

take a look at the substr() function

nomad

[ronverdonk]

Hello Guys,

Just wondering how I can make the substr value changes when submit into mysql.

something like:
someone typed A123456 on a blank field and submit into mysql. the Value will only display 123456 in mysql

Thanks a lot

Most probable cause would be a mistake in offset value of the the substr() function. Starts at 0 (zero) and not 1 (one).

Ronald

[cyberlei]

Most probable cause would be a mistake in offset value of the the substr() function. Starts at 0 (zero) and not 1 (one).

Ronald

something like?

<?php
substr=ltrim($sn,"A")
?>

[ronverdonk]

something like?

<?php
substr=ltrim($sn,"A")
?>

That is not the SUBSTR() function, that is the LTRIM() function.
See the PHP documentation for a full description HERE

Ronald

[nomad]

take a look at the substr() function

nomad

for some reason some of my code was not posted.

you could do this
$test = "phpcoder";
echo substr($test, 3) ; //prints "coder"

nomad

[cyberlei]

Issue Resolved, Here is the code

$Text = ltrim($Text, 'A');

[ronverdonk]

Anything that helps you out.

Ronald