Jump to content

[SOLVED] value and field help in mySQL


berry05

Recommended Posts

 
<?php 

include("dbconfig.php"); //replace with your db connection file 

$query = mysql_query("SELECT * FROM tbl_name");   //replace tbl_name with your tbl 

while($getinfo = mysql_fetch_array($query)){ 

   if($getinfo['rowhere'] == 0){ 

       echo "row here equals 0" ; 
    } 

   if($getinfo['rowhere'] == 1){ 

     echo "row here equals 1"; 

} 
} 

?> 

 

I think this is what you want, my php isn't "great" but im learning and like to try and help people out. If there is any errors i apologize =)

 

Link to comment
Share on other sites

if ($field == 0) {
   echo 'Some Text'; //need single
}elseif ($field == 1) {
    echo 'Do something else!'; //and another!
}

 

;)

 

lol why post the same thing as premiso. ;)

 

I didn't, take a look at the comments  ;)

Link to comment
Share on other sites

my version....

<?php


<?php 

include("dbconfig.php"); //replace with your db connection file 

$query = mysql_query("SELECT * FROM tbl_name");   //replace tbl_name with your tbl 

while($getinfo = mysql_fetch_assoc($query)){ 

switch($getinfo['rowhere']) {

   case '0':

  $x="Some Text";
  
  break;

  case '1': 

    $x='Do something else!';
    
    break;
}
  }
  
  echo $x;
?>

Link to comment
Share on other sites

Why is everyone connecting to a database?  He only wanted an if elseif statement...  Use premiso's, or rather use my updated version of premiso's.

 

MySQL is in the title....but here is my version!

<?php 
$result = mysql_query("SELECT field FROM tbl_name WHERE field = 1");   //replace tbl_name with your tbl 

if (mysql_num_rows($result) == 0) {
    echo 'Do this here';
}else {
    echo 'Do this other thing here!';
}
?>

 

=)

Link to comment
Share on other sites

Hey phpsenei,

 

I was wondering about this line that you put in your code

 

 
($row['field'] == 0) ? 0 : $row['field'];

 

could you explain the " ? 0 : " part or give me a link to read up on it?

 

Its a shortened if/else statement. If the field is equal to 0 set it to 0 else set it to $row['field'];

Link to comment
Share on other sites

Hey phpsenei,

 

I was wondering about this line that you put in your code

 

 
($row['field'] == 0) ? 0 : $row['field'];

 

could you explain the " ? 0 : " part or give me a link to read up on it?

 

Hey friend, glad to help.

 

It is another conditional operator called ternary, prevents the whole curly bracelet hassle

 

http://ca.php.net/manual/en/language.operators.comparison.php#language.operators.comparison.ternary

Link to comment
Share on other sites

It's called a ternary operator.  TRUE('?') ELSE(':').

 

$field = ($row['field'] == 0) ? 0 : $row['field'];

 

Is the same exact thing as:

 

if($row['field'] == 0) {
  $field = 0;
} 
else {
   $field = $row['field'];
}

 

 

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.