如何从表中选择数据并使其成为字符串？

Question

I am trying to use a database where the email can have multiple entries, but i would like to prevent duplicate entries. Currently i have:

    <?php
    "SELECT Notes, itemName from UserItems where email = '$email'";
    if("itemName" == $name && "Notes" == $desc) {
        echo "duplicate";
    }
    ?>

But itemName and Notes need to become strings for my if statement to work

My insert function is lower in my code but ill post it

    $insert = ("insert into UserItems (itemName, ItemNumber, email, Price, Notes) Value (\"$name\", \"$ItemNumber\", \"$email\", \"$price\", \"$desc\")");

Answer 1

Am I missing something here? I held off answering cause I thought this would be too obvious and my post would waste time -

<?php
// add actual db connection info here
$email = '[e-mail]';
$name = 'John';
$desc = 'Some Description';
$row = mysql_fetch_array(mysql_query("SELECT Notes, itemName from UserItems where email = '$email'"));
if($row['itemName'] == $name && $row['Notes'] == $desc) {
    echo "duplicate";
}
?>

You never actually run a query or fetch the results. Or define the variables you're comparing against. Are they $_POST, $_GET, results of the last row or something?