Databases
StackOverflow2013
Postsdbo
POWhy can I query with an int but not a string here? PHP MySQL Datatypes
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy can I query with an int but not a string here? PHP MySQL Datatypes
    primarykey
    data
    text
    <p>I am working on an Asset Database problem. I receive <code>$id</code> from <code>$_GET["id"];</code> I then query the database and display the results.</p> <p>This works if my id is an integer like "93650" but if it has other characters like "wci1001", it displays this MySQL error:</p> <p>Unknown column 'text' in 'where clause'</p> <p>All fields in tables are of type: <code>VARCHAR(50)</code></p> <p>What would I need to do to be able to use this query to search by id that includes other characters?</p> <p>Thank you.</p> <pre><code>&lt;?php &lt;?php /* * ASSET DB FUNCTIONS SCRIPT * */ # connect to database function ConnectDB(){ mysql_connect("localhost", "asset_db", "asset_db") or die(mysql_error()); mysql_select_db("asset_db") or die(mysql_error()); } # find asset type returns $type function GetAssetType($id){ $sql = "SELECT asset.type From asset WHERE asset.id = $id"; $result = mysql_query($sql) or die(mysql_error()); $row = mysql_fetch_assoc($result); $type = $row['type']; return $type; } # query server returns $result (sql query array) function QueryServer($id){ $sql = " SELECT asset.id ,asset.company ,asset.location ,asset.purchaseDate ,asset.purchaseOrder ,asset.value ,asset.type ,asset.notes ,server.manufacturer ,server.model ,server.serialNumber ,server.esc ,server.warranty ,server.user ,server.prevUser ,server.cpu ,server.memory ,server.hardDrive FROM asset LEFT JOIN server ON server.id = asset.id WHERE asset.id = $id "; $result = mysql_query($sql); return $result; } # get server data returns $serverArray function GetServerData($result){ while($row = mysql_fetch_assoc($result)) { $id = $row['id']; $company = $row['company']; $location = $row['location']; $purchaseDate = $row['purchaseDate']; $purchaseOrder = $row['purchaseOrder']; $value = $row['value']; $type = $row['type']; $notes = $row['notes']; $manufacturer = $row['manufacturer']; $model = $row['model']; $serialNumber = $row['serialNumber']; $esc = $row['esc']; $warranty = $row['warranty']; $user = $row['user']; $prevUser = $row['prevUser']; $cpu = $row['cpu']; $memory = $row['memory']; $hardDrive = $row['hardDrive']; $serverArray = array($id, $company, $location, $purchaseDate, $purchaseOrder, $value, $type, $notes, $manufacturer, $model, $serialNumber, $esc, $warranty, $user, $prevUser, $cpu, $memory, $hardDrive); } return $serverArray; } # print server table function PrintServerTable($serverArray){ $id = $serverArray[0]; $company = $serverArray[1]; $location = $serverArray[2]; $purchaseDate = $serverArray[3]; $purchaseOrder = $serverArray[4]; $value = $serverArray[5]; $type = $serverArray[6]; $notes = $serverArray[7]; $manufacturer = $serverArray[8]; $model = $serverArray[9]; $serialNumber = $serverArray[10]; $esc = $serverArray[11]; $warranty = $serverArray[12]; $user = $serverArray[13]; $prevUser = $serverArray[14]; $cpu = $serverArray[15]; $memory = $serverArray[16]; $hardDrive = $serverArray[17]; echo "&lt;table width=\"100%\" border=\"0\"&gt;&lt;tr&gt;&lt;td style=\"vertical-align:top\"&gt;&lt;table width=\"100%\" border=\"0\"&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;h2&gt;General Info&lt;/h2&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Asset ID:&lt;/td&gt;&lt;td&gt;"; echo $id; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Company:&lt;/td&gt;&lt;td&gt;"; echo $company; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Location:&lt;/td&gt;&lt;td&gt;"; echo $location; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Purchase Date:&lt;/td&gt;&lt;td&gt;"; echo $purchaseDate; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Purchase Order #:&lt;/td&gt;&lt;td&gt;"; echo $purchaseOrder; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Value:&lt;/td&gt;&lt;td&gt;"; echo $value; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Type:&lt;/td&gt;&lt;td&gt;"; echo $type; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Notes:&lt;/td&gt;&lt;td&gt;"; echo $notes; echo "&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/td&gt;&lt;td style=\"vertical-align:top\"&gt;&lt;table width=\"100%\" border=\"0\"&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;h2&gt;Server Info&lt;/h2&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Manufacturer:&lt;/td&gt;&lt;td&gt;"; echo $manufacturer; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Model:&lt;/td&gt;&lt;td&gt;"; echo $model; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Serial Number:&lt;/td&gt;&lt;td&gt;"; echo $serialNumber; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;ESC:&lt;/td&gt;&lt;td&gt;"; echo $esc; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Warranty:&lt;/td&gt;&lt;td&gt;"; echo $warranty; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;h2&gt;User Info&lt;/h2&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;User:&lt;/td&gt;&lt;td&gt;"; echo $user; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Previous User:&lt;/td&gt;&lt;td&gt;"; echo $prevUser; echo "&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/td&gt;&lt;td style=\"vertical-align:top\"&gt;&lt;table width=\"100%\" border=\"0\"&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;h2&gt;Specs&lt;/h2&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;CPU:&lt;/td&gt;&lt;td&gt;"; echo $cpu; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;Memory:&lt;/td&gt;&lt;td&gt;"; echo $memory; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr id=\"hightlight\"&gt;&lt;td&gt;Hard Drive:&lt;/td&gt;&lt;td&gt;"; echo $hardDrive; echo "&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&amp;nbsp;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;h2&gt;Options&lt;/h2&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;a href=\"#\"&gt;Edit Asset&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=\"2\"&gt;&lt;a href=\"#\"&gt;Delete Asset&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"; } ?&gt; </code></pre> <p>__</p> <pre><code>/* * View Asset * */ # include functions script include "functions.php"; $id = $_GET["id"]; if (empty($id)):$id="000"; endif; ConnectDB(); $type = GetAssetType($id); ?&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"&gt; &lt;html xmlns="http://www.w3.org/1999/xhtml"&gt; &lt;head&gt; &lt;meta http-equiv="Content-Type" content="text/html; charset=utf-8" /&gt; &lt;link rel="stylesheet" type="text/css" href="style.css" /&gt; &lt;title&gt;Wagman IT Asset&lt;/title&gt; &lt;/head&gt; &lt;body&gt; &lt;div id="page"&gt; &lt;div id="header"&gt; &lt;img src="images/logo.png" /&gt; &lt;/div&gt; &lt;/div&gt; &lt;div id="content"&gt; &lt;div id="container"&gt; &lt;div id="main"&gt; &lt;div id="menu"&gt; &lt;ul&gt; &lt;table width="100%" border="0"&gt; &lt;tr&gt; &lt;td width="15%"&gt;&lt;/td&gt; &lt;td width="30%%"&gt;&lt;li&gt;&lt;a href="index.php"&gt;Search Assets&lt;/a&gt;&lt;/li&gt;&lt;/td&gt; &lt;td width="30%"&gt;&lt;li&gt;&lt;a href="addAsset.php"&gt;Add Asset&lt;/a&gt;&lt;/li&gt;&lt;/td&gt; &lt;td width="25%"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/ul&gt; &lt;/div&gt; &lt;div id="text"&gt; &lt;ul&gt; &lt;li&gt; &lt;h1&gt;View Asset&lt;/h1&gt; &lt;/li&gt; &lt;/ul&gt; &lt;?php if (empty($type)):echo "&lt;ul&gt;&lt;li&gt;&lt;h2&gt;Asset ID does not match any database entries.&lt;/h2&gt;&lt;/li&gt;&lt;/ul&gt;"; else: switch ($type){ case "Server": $result = QueryServer($id); $ServerArray = GetServerData($result); PrintServerTable($ServerArray); break; case "Desktop"; break; case "Laptop"; break; } endif; ?&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;div class="clear"&gt;&lt;/div&gt; &lt;div id="footer" align="center"&gt; &lt;p&gt;&amp;nbsp;&lt;/p&gt; &lt;/div&gt; &lt;/div&gt; &lt;div id="tagline"&gt; Wagman Construction - Bridging Generations since 1902 &lt;/div&gt; &lt;/body&gt; &lt;/html&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USOMG Ponies
    1. USCT.
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COI realize this is wide open for SQL Injection but this is just for my own learning so I first am simply trying to get things to work.
      singulars
      1. POWhy can I query with an int but not a string here? PHP MySQL Datatypes
      1. USCT.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload