Check if a row exists using old mysql API

Question

I just want to check and see if a row exists where the  lectureName shows  If a row does exist with the  lectureName somewhere in it  I want the function to return  quot assigned quot  if not then it should return  quot available quot   Here s what I have  I m fairly sure its a mess  Please help  function checkLectureStatus  lectureName      con   connectvar     mysql select db  quot mydatabase quot    con     result   mysql query  quot SELECT   FROM preditors assigned WHERE lecture name   lectureName  quot      while  row   mysql fetch array  result             if    row  lectureName      lectureName                  mysql close  con            return  quot Available quot                else                mysql close  con           return  quot Assigned quot            When I do this everything return available  even when it should return assigned

User · Answer

function checkLectureStatus  lectureName      global  con     lectureName   mysql real escape string  lectureName      sql    SELECT 1 FROM preditors assigned WHERE lecture name   lectureName       result   mysql query  sql  or trigger error mysql error        sql     if  mysql fetch row  result         return  Assigned         return  Available       however you have to use some abstraction library for the database access  the code would become   function checkLectureStatus  lectureName       res   db  getOne  SELECT 1 FROM preditors assigned WHERE lecture name     lectureName     if  res        return  Assigned         return  Available

User · Answer

result   mysql query  select if exists  SELECT   FROM  preditors assigned WHERE lecture name   lectureName    Assigned    Available

User · Answer

Easiest way to check if a row exists    lectureName   mysql real escape string  lectureName       SECURITY   result   mysql query  SELECT 1 FROM preditors assigned WHERE lecture name   lectureName  LIMIT 1    if  mysql fetch row  result         return  Assigned     else       return  Available       No need to mess with arrays and field names

User · Answer

If you just want to compare only one row with  lactureName then use following  function checkLectureStatus  lectureName      con   connectvar     mysql select db  mydatabase    con     result   mysql query  SELECT   FROM preditors assigned WHERE lecture name   lectureName       if mysql num rows  result   gt  0               mysql close  con            return  Assigned         else             mysql close  con           return  Available

User · Answer

Use mysql num rows    to check if rows are available or not   result   mysql query  SELECT   FROM preditors assigned WHERE lecture name   lectureName  LIMIT 1     num rows   mysql num rows  result    if   num rows  gt  0         do something   else        do something else

User · Answer

This ought to do the trick  just limit the result to 1 row  if a row comes back the  lectureName is Assigned  otherwise it s Available   function checkLectureStatus  lectureName         con   connectvar        mysql select db  mydatabase    con        result   mysql query           SELECT   FROM preditors assigned WHERE lecture name   lectureName  LIMIT 1         if mysql fetch array  result      false          return  Assigned       return  Available

[php] Check if a row exists using old mysql_* API

Examples related to php

Examples related to mysql