Cannot Retrieve Data from Database: PHP

[Vicky Moore]

Hello All.

I need some help with retrieving some data from my PHP server. I expect some data to be shown, but I see none. I followed a couple Youtube tutorials - they all said the same thing. When I tried it it, I did not get the desired result.

Here is the code that I used:
<?php // Make connection to the Database define('DB_NAME', 'product'); define('DB_USER', 'root'); define('DB_PASSWORD', ''); define('DB_HOST', 'localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) {  die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if(!$db_selected){  die('Cannot use ' . DB_NAME . ': ' . mysql_error()); } //Get SQL Results. $requested_product = $_POST["product"]; // coming from a form $sql = "SELECT * FROM products WHERE PRODUCT_NAME = $requested_product "; $records = mysql_query($sql); ?> <form>   <table width="600" border="1" cellpadding="1" cellspacing="1">         <tr>           <th>Product Name</th>           <th>Product Notes</th>           <th>Shop URL</th>           <th>Shop Name</th>           <th>Product Location</th>         </tr>         <?php          //Add stuff to the page.          while($product=mysql_fetch_array($records, MYSQL_ASSOC)){            echo "<tr>";            echo "<td>".$product['PRODUCT_NAME']."</td>";            echo "<td>".$product['PRODUCT_NOTES']."</td>";            echo "<td>".$product['SHOP_URL']."</td>";            echo "<td>".$product['SHOP_NAME']."</td>";            echo "<td>".$product['PRODUCT_LOCATION']."</td>";            echo "</tr>";          }          ?>   </table> </form>


Here is the text of the PHP My Admin screen(to show that I have some data):

Full texts
ID
PRODUCT_NAME
PRODUCT_NOTES
SHOP_URL
SHOP_NAME
PRODUCT_LOCATION

2
Hi
Hi
HI
HI
Hi

.

This is what I get when I run it, and $_POST['product']= Hi.


Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\product\getdata.php on line 41
Product Name Product Notes Shop URL Shop Name Product Location


All help would be greatly appreciated.

[K. Tsang]

Try displaying your sql. The parameter may not be what you expect causing the sql to not return a resource for the mysql_fetch_array function.

Remember to put quotes in sql.

[Vicky Moore]

Thank you. I just would like to know which SQL you are talking about.

[K. Tsang]

Vicky Moore wrote:Thank you. I just would like to know which SQL you are talking about.

Line 23 of your original posting.

Say your variable $requested_product = "ABC"

When you display that is it showing :
SELECT * FROM products WHERE PRODUCT_NAME =  ABC ;
or
SELECT * FROM products WHERE PRODUCT_NAME = 'ABC' ; <- with quote