Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Replace that wont work on the fly

11:18 am on May 9, 2013 (gmt 0)

New User

5+ Year Member

joined:Feb 20, 2011
posts: 15
votes: 0


I am using Playton phpmyedit for my data files and I cannot get a simple replace to work on the screen output\
I am trying to get a blank/NULL instead of a '0'

the code for one numeric entry is as follows..

$opts['fdd']['build_no'] = array(
'default' => '',
'help|ACP' => 'Limit 8 characters',
'input' => '',
'maxlen' => 8,
'name' => 'Build #',
'options' => 'ACPVDFL',
'select' => 'T',
'size' => 8,
'sqlw' => 'TRIM("$val_as")',
'sort' => true

I have tried replacing the SQLW line with

'sqlw' => 'IF($val_qas = 0, NULL, $val_qas)',

But it does not work
7:30 pm on May 9, 2013 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member lucy24 is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month

joined:Apr 9, 2011
votes: 491

Obvious first question: What is the prior history of
? Have you tried explicitly converting it to a string?

Or $val_qas as the case may be (assuming a typo in the post).