automatically checking a checkbox

anfetienne

hi, i've written a javascript code to automatically check a checkbox if a value is true. I am trying to incorporate this into php/mysql, so when a certain cell within a db value/length is greater than 0 the checkbox is ticked.

the code i have for this is below but php doesn't accept the coding. how can i write this so that if the length of the fields are greater than 0 it will run the javascript code? or can the same thing be done with php?

Expand|Select|Wrap|Line Numbers

 
$paySQL = "SELECT payment01,payment02 FROM savedTemps WHERE tempID = '{$random_digit}'";

$payRES = mysql_query( $paySQL ) or die( mysql_error );
 
if ( mysql_fetch_lengths( $payRES ) > 0 )

{
 
<script>

//accesses the button called "test"

document.example.test.checked=true

</script>
 
}

Markus

Something like this:

Expand|Select|Wrap|Line Numbers

 
$sql = "SELECT `col1`, `col2` FROM `tbl`";

$res = mysql_result($sql);

// $len is an array of the fields returned by the query ($sql), that is, 'col1' and 'col2'

$len = mysql_fetch_lengths($res);
 
// if 'col1' has a length > 1

if($len[0] > 1) {

    // code

}
 
// if 'col2' has a length > 1

if($len[1] > 1) {

    // code

}

You'll have to adapt your code to use the method above.

Mark.

anfetienne

thanks markus ill test this now and post my results

Markus

Quote:

Originally Posted by anfetienne

thanks markus ill test this now and post my results

Okay.

Mark.

anfetienne

ok this is how i've adapted my coding to get this to work but mysql_fetch_lengths is coming up as an error

here is the error message

Expand|Select|Wrap|Line Numbers

 
$psql = "SELECT * FROM savedTemps WHERE tempID = '{$random_digit}'";

$pres = mysql_query( $psql ) or die( mysql_error );
 
if ( mysql_num_rows( $pres ) > 0 ){
 
$prow = mysql_fetch_array( $pres );
 
// if 'col1' has a length > 1

if( mysql_fetch_lengths ( $prow['payment01'] ) > 1) {

include("payment01a.php");

}

else{

include("payment01b.php");

}

// if 'col2' has a length > 1

if( mysql_fetch_lengths ( $prow['payment02'] ) > 1) {

include("payment02a.php");

}

else{

include("payment02b.php");

}

}

Markus

I don't see an error message? ;)

anfetienne

Warning: mysql_fetch_lengths(): supplied argument is not a valid MySQL result resource in /home/theau10/public_html/resources/templateEdit.php on line 273

Warning: mysql_fetch_lengths(): supplied argument is not a valid MySQL result resource in /home/theau10/public_html/resources/templateEdit.php on line 282

Markus

As I showed previously, mysql_fetch_lengths() expects a resource returned by mysql_query().

Expand|Select|Wrap|Line Numbers

 
$sql = "SELECT * FROM `tbl`;";

$res = mysql_query($sql);
 
// This

$lengths = mysql_fetch_lengths($res);
 
// Not this:

$arr = mysql_fetch_array($res);

$lengths = mysql_fetch_lengths($arr['col1']);

anfetienne

i've solved my problem, here is my final code....thanks for the suggestion markus!

Expand|Select|Wrap|Line Numbers

 
<?

mysql_connect($hostname,$username,$password);

@mysql_select_db($database) or die( "Unable to select database");
 
$paysql = "SELECT * FROM savedTemps WHERE tempID = '{$random_digit}'";

$payres = mysql_query( $paysql ) or die( mysql_error );
 
if ( mysql_num_rows( $payres ) > 0 ){
 
$result1 = mysql_query("SELECT payment01, payment02 FROM savedTemps WHERE tempID = '{$random_digit}'");

if (!$result1) {

    echo 'Could not run query: ' . mysql_error();
 
}

$payResults = mysql_fetch_assoc($result1);

$lengths = mysql_fetch_lengths($result1);
 
// if 'col1' has a length > 1

    if( $lengths[0] > 1) {

        echo '<script type="text/javascript">';

        echo 'document.form1.payment01.checked=true';

        echo '</script>';
 
        echo '<script type="text/javascript">';

        echo 'document.form1.payment02.checked=true';

        echo '</script>';

    }
 
    else{

        echo '<script type="text/javascript">';

        echo 'document.form1.payment01.checked=false';

        echo '</script>';
 
        echo '<script type="text/javascript">';

        echo 'document.form1.payment02.checked=false';

        echo '</script>';

    }

}

mysql_close();

?>

automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

re: automatically checking a checkbox

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about