I'm using a
SELECT * FROM "" WHERE "" = "" query and I'm not sure what I'm doing wrong with it. I'm trying to select an item based on its PO which is a completely unique identifier to one row in the table. Here's my process in doing so:
$jobnumber = $_GET['jref']; $query = "SELECT * FROM `po_10152796` WHERE `po` = " .$jobnumber; $results = mysqli_query($conn,$query) or die(mysqli_error($conn)); $rowitem = mysqli_fetch_array($results); $jobname = $rowitem['Job Name']; $phone = $rowitem['phone'];
Things i know are correct:
- The "jobnumber" is retrieved correctly and matches up with an element in the table
- The table is named "po_10152796" and there is a column named "po"