[RESOLVED] Displaying MySQL data into a custom table

darkangel2001lv

hey guy new to php and am trying to pull data from table in mysql db i want you get just the cells name from the table where say the id is 12-106
below and display them into my own table.

i think i have the first part to query db but i am stumped on how to get the data to display where i want it to. What would be the best way to do this?

 <?php require_once('mysql connection file'); 

$results = mysql_query('SELECT item_code, description, allergy_statement, useable_units, region_availability, order_lead_time, ingredients FROM products WHERE id <= 12-106'); 

?>

Where i want the data to be displayed

<h1>Product Details </h1>
<h3>description to display here</h3>
<h5>item_code to display here </h5>
<h3>Ingredients:</h3>
<table width="420" border="0">
  <tr>
    <td class="ingreg">want "ingredients" cell in database to display here </td>
  </tr>
</table>
<h4>Allergy Statement:</h4>
<table width="420" border="0">
  <tr>
    <td class="ingreg">want "allergy_statement" cell in database to display here </td>
  </tr>
</table>
<h4>Useable Units Per Package:</h4>
<table width="420" border="0">
  <tr>
    <td class="ingreg">want "useable_units" cell in database to display here </td>
  </tr>
</table>
<h4>Region Availability:
</h4>
<table width="420" border="0">
  <tr>
    <td class="ingreg">want "region_availability" cell in database to display here </td>
  </tr>
</table>
<h4>Order Lead Time:</h4>
<table width="420" border="0">
  <tr>
    <td class="ingreg">want "order_lead_time" cell in database to display here </td>
  </tr>
</table>

darkangel2001lv

ok been messing with this issue for a few hours now and this is what i have come up with. However am missing the final part that will display each field name in the correct place

 
<link href="includes/pd.css" rel="stylesheet" type="text/css" media="all" />




<?php require_once('my connection file'); 

$results = mysql_query('SELECT item_code, description, allergy_statement, useable_units, region_availability, order_lead_time, ingredients FROM products WHERE id <= 12-106'); 
$get_info = mysql_fetch_row($result);         # line 8 
?>

Part of page where i want to display the results

<title>Product Details 12-100</title>
<body><div align="center">
  <table width="889" border="0">
    <tr>
      <td width="231"><p><img src="images/12-100.jpg" width="231" height="547"></p>
      <p><iframe src='includes/product-disclaimer.php' frameborder='0'
width='100%' height='150' ></iframe></td>
      <td width="715" align="center" valign="top">&nbsp;
        <h1>Product Details</h1>
        <h3><?php foreach ($get_info as $item_code) ?></h3>     # line 21 ( want to display here)
        <table width="420" border="0">
            <td class="ingreg">&nbsp;</td>
        </table>

but i get these errosr:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/84/8829884/html/products/12-100-2.php on line 8

Warning: Invalid argument supplied for foreach() in /home/content/84/8829884/html/products/12-100-2.php on line 21

i know i am missing something can some one help?

bradgrafelman

See the link in my signature to learn how to debug failing MySQL queries, but I can tell you right now one thing that looks suspicious is this:

WHERE id <= 12-106

since the '12-106' part is going to evaluate to -94, so you're telling MySQL to SELECT rows where the 'id' value is less than or equal to -94.

EDIT: Also note that your error message doesn't correspond with the code snippet you showed us; the former references a call to 'mysql_num_rows', while the latter instead shows a call to 'mysql_fetch_row'.

darkangel2001lv

ok updated code to the following however can't still can't get it to display where i want it to.

<link href="includes/pd.css" rel="stylesheet" type="text/css" media="all" />



<?php require_once('my connection file'); 

$query = "SELECT item_code, description, allergy_statement, useable_units, region_availability, order_lead_time, ingredients " . 
 "FROM products  " .
 "WHERE item_code= 12-100  " .
$resuts = mysql_query($query) 
			or die(mysql_error());
while ($row = mysql_fetch_array($resuts)) {
	extract ($row);

?>

where i need the data to display


<title>Product Details 12-100</title>
<body>
<p>&nbsp;</p>
<div align="center">
  <table width="889" border="0">
    <tr>
      <td width="231"><p><img src="images/12-100.jpg" width="231" height="547"></p>
      <p><iframe src='includes/product-disclaimer.php' frameborder='0'
width='100%' height='150' ></iframe></td>
      <td width="715" align="center" valign="top">&nbsp;
        <h1>Product Details</h1>
        <h3> <?php echo $description; ?> </h3>
        <table width="420" border="0">
            <td class="ingreg">&nbsp;</td>
        </table>

How i tell the script to display the data in my table. I can't figure it out.....

bradgrafelman

For one, the code you posted above has a parse error:

$query = "SELECT item_code, description, allergy_statement, useable_units, region_availability, order_lead_time, ingredients " .
"FROM products  " . 
"WHERE item_code= 12-100  " .

(the extra period at the end and a missing semicolon).

Second, that query still doesn't make any sense... you're basically telling MySQL to check this:

WHERE item_code = -88

Third, note that if you're only expecting at most 1 result to be returned from the DB, then it doesn't make much sense to use a while() loop at all - just retrieve the single row (if there is one).

Derokorian

if the item code is LITERALLY 12-100 and you're not doing a range (IE item codes between 12 and 100) then you need to enclose it in quotes in the query (or you get the -88 bg mentions) if you are trying to get items with code between 12 and 100 then you need to tell myself that:

$code = '12-100';
list($start,$end) = explode('=',$code);
$query = "SELECT item_code, description, allergy_statement, useable_units, region_availability, order_lead_time, ingredients " . 
"FROM products  " . 
"WHERE item_code BETWEEN $start AND $end ";

darkangel2001lv

thanks Derokorian, bradgrafelman

I want to get the fields
item_code
description
allergy_statement
useable_units
region_availability
order_lead_time
ingredients

for item_code 12-100 LITERALLY 12-100, no range, but like i said before i am really new to php and mysql. I have 1187 items that when a user clicks a link in search results it takes them to the product details page for that item code All that data is in my database just can't figure out how to get it out of the database. Is this even the right script to achieve that result.

Have edited the code to fix parse error but still not working nor do i know how AFTER i get the data from the database how to display it in the stops show in first post.

<?php require_once('my connection file'); 

$query = "SELECT item_code, description, allergy_statement, useable_units, region_availability, order_lead_time, ingredients " . 
 "FROM products  " .
 "WHERE item_code = '12-100' ";
$resuts = mysql_query($query) 
			or die(mysql_error());
while ($row = mysql_fetch_array($resuts)) {
	extract ($row);
}
?>

Display here

<title>Product Details 12-100</title>
<body>
<p>&nbsp;</p>
<div align="center">
  <table width="889" border="0">
    <tr>
      <td width="231"><p><img src="images/12-100.jpg" width="231" height="547"></p>
      <p><iframe src='includes/product-disclaimer.php' frameborder='0'
width='100%' height='150' ></iframe></td>
      <td width="715" align="center" valign="top">&nbsp;
        <h1>Product Details</h1>
        <h3>DISPLAY  DESCRIPTION HERE</h3>
        <table width="420" border="0">
            <td class="ingreg">&nbsp;</td>
        </table>
        <h5>Item Number</h5>
        <table width="420" border="0">
          <tr>
            <td class="ingreg">DISPLAY ITEM_CODE HERE</td>
          </tr>
        </table>
        <h3>Ingredients:</h3>
        <table width="420" border="0">
          <tr>
            <td class="ingreg">DISPLAY INGREDIENTS HERE</td>
          </tr>
        </table>

darkangel2001lv

will not let me edit but forgot to post that i am getting the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/84/8829884/html/products/12-100-2.php on line 10

line 10 is the following

$data= mysql_fetch_array($result);

this script is about to get tossed cus i am fed up with it it has been over a week i have been trying to get this working in the hopes that i wouldn't have to make 1100 product details sheets. I have search this forum and searched google for hours and find nothing that fits with what i am trying to do. I have a deadline to meet and i have wasted a week on a script that doesn't work. Guess i will be creating these pages one by one.

bradgrafelman

Since the error message doesn't seem to correlate with any code you've posted thus far, can you show us what your code looks like now?

Also, were you planning on generalizing the code out to work for all products? I note the file is called '12-100-2.php', but it seems like you could instead use a sinlge 'product.php' file and instead pass in which product you want via the query string.