Check if a row exists using old mysql_* API

by

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.

More Related Contents:

  1. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  2. timestamp within a form [closed]
  3. how to select only one value sql
  4. Save the data into a database and return another value from database using PHP
  5. Math Symbol From Mysql To HTML? [closed]
  6. Create the timestamp of an hour ago [duplicate]
  7. How to store repeating dates keeping in mind Daylight Savings Time
  8. Using a .php file to generate a MySQL dump
  9. JSON encode MySQL results
  10. Insert Blobs in MySql databases with php
  11. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [duplicate]
  12. PDO with INSERT INTO through prepared statements [closed]
  13. How do I execute PHP that is stored in a MySQL database?
  14. Error while sending QUERY packet
  15. How to sort rows of HTML table that are called from MySQL
  16. PDO fetch one column from table into 1-dimensional array
  17. php file upload, how to restrict file upload type
  18. PHP: Calling MySQL Stored Procedure with Both INPUT AND OUTPUT Parameters (NOT “INOUT”)
  19. Get all child, grandchild etc nodes under parent using php with mysql query results
  20. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  21. Laravel Migration table already exists, but I want to add new not the older
  22. Saving images in database mysql
  23. convert date string to mysql datetime field
  24. Set PDO to throw exceptions by default [duplicate]
  25. I cannot use mysql_* functions after upgrading PHP
  26. Get number of rows matched by UPDATE query with PHP mysqli
  27. Sort by date (newest)
  28. mysql count occurrences of special character in a field
  29. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  30. Join subquery with doctrine 2 DBAL

Leave a Comment