Welcome Guest, Not a member yet? Register   Sign In
Select query with else
#1

Hello,
I have a few questions and hope you can help me there.
In my old version I made such a query.

PHP Code:
           $sql "SELECT
                        tb_kunde_id
                    FROM
                        db_kunde
                    WHERE
                        tb_kunde_vorname = :vorname
                            AND
                                tb_kunde_nachname = :nachname
                            AND
                                tb_kunde_land = :land"
;
 
           $select $db->prepare($sql);
 
           $select->bindParam(':vorname'$tb_kunde_vorname);
 
           $select->bindParam(':nachname'$tb_kunde_nachname);
 
           $select->execute();
 
           if($select->rowCount() < 1)
 
               {
 
                   $client_data['tb_kunde_vorname'] = $tb_kunde_vorname;
 
                   $client_data['tb_kunde_nachname'] = $tb_kunde_nachname;
 
                   $add_client $db->insert("db_kunde",$client_data) OR die("Error: ".$db->error()."</br> Zeile ".__LINE__);
 
                   $id_kunde $db->lastInsertId();
 
               }
 
           else
                
{
 
                   $results $select->fetch(PDO::FETCH_NUM);
 
                   $id_kunde $results[0];
 
               

Now I wonder how I need to query this in ELSE?
Reply


Messages In This Thread
Select query with else - by Germanikus - 09-16-2017, 02:24 PM
RE: Select query with else - by Wouter60 - 09-17-2017, 04:12 AM
RE: Select query with else - by Germanikus - 09-17-2017, 12:36 PM



Theme © iAndrew 2016 - Forum software by © MyBB