Adding A Boolean To My Column Type

[tomyknoker]

I need to add a column in my database, which will be called 'MemberPackSent' basically I want to send out a pack to members, just wondering would I make this a Boolean? Do I need to specify the 'Length' or is a Boolean simply always 1 or 0?

[mburt]

Boolean can be 1 or 0, but you can make it "true" or "false" as well. I know in PHP true and false boolean tags are read as 1 and 0 anyways, if you try to echo them.
As long as you don't get too confused, 1 and 0 are fine.

[tomyknoker]

Ahhhhh ok is there a way in php that if it was a '1' value I could convert it to 'Yes'?

[mburt]

if ($value == 1) {
  $value = "Yes";
  } else {
  $value = "No";
  }

[Twey]

$value = $value ? "Yes" : "No";

[mburt]

Huh?
Shouldn't:

$value = $value ? : "Yes" : "No";

Be

$value = $value ? "Yes" : "No";

[Twey]

Yes, sorry, typo. Corrected.

[realmetrics.com]

Hi tomy,

Yes, sure you can assign the value using simple “if” condition before updating database.

Here is the basic code to do this..

<?php
$con = @mysql_connect(“Ip Address”, “username”, “password”) or die(mysql_error());

$db = @mysql_select_db(“emp”, $con) or die(mysql_error());

$packets = true;
If ($packets = true)
{
$Val = 1;
}
Else
{
$val = 0;
}

?>

After converting the value you can simply insert it into the database using SQL statements.

[Twey]

Some versions of MySQL will accept "true" and "false" as keywords and convert them automatically.

$con = @mysql_connect(“Ip Address”, “username”, “password”) or die(mysql_error());

Watch the "smart quotes" -- that won't even parse as PHP.

[mburt]

Off the topic of connecting, but mysql_query allows it:

SELECT * FROM blah WHERE test=“foo”

so in PHP, you could do

mysql_query('SELECT * FROM blah WHERE test=“foo”');