I was wondering if you guys can help me with this! I'm trying to display data on the items_Deltails.php page from classifieds1.php page using $_GET. I'm able display all data from items table without any problem, however when i try to display the field pix from the images table it comes up with this message "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\web\htdocs\Item_Details.php on line 35".

I've two different tables one clled items (itemID, categoryID, item_Description, itemName, price, contactNAme, phone and email) and the other one called images (itemID, categoryID and pix).
I'm sure the there is something from with the mysql command "SELECT * FROM" in item_Details.php

Here is the code for classifieds1.php

<?php
echo "<h1>List of all items</h1>";
//database info in misc.inc
include("misc.inc");
$table = "items";
$db = 0;
$db = mysql_connect($db_host . ":" . $db_port, $db_user, $db_pwd);
if ($db == 0) {die("Cannot connect, Error <b>" . mysql_errno() . "</b>: " . mysql_error());};

mysql_query("USE " . $db_db);
if (mysql_errno() != 0) {die("Cannot USE database, Error <b>" . mysql_errno() . "</b>: " . mysql_error());};

$query1 = "SELECT * FROM items WHERE categoryID='3'";
$result = mysql_query($query1);
//let's get the number of rows in our result so we can use it in a for loop
$numofrows = mysql_num_rows($result);

echo"<table id=mytable cellspacing=0 summary=Items from almacen database>
<caption>Books, CDs and DVDs: </caption>";
echo "<TR bgcolor=\"lightblue\"><TH>Item Name</TH><TH>Price</TH><TH>Posted On</TH></TR>\n"; 
for($i = 0; $i < $numofrows; $i++) {
$row = mysql_fetch_array($result); //get a row from our result set
$id=$row['itemID'];
if($i % 2) { //this means if there is a remainder
echo "<TR bgcolor=\"#F5FAFA\">\n";
} else { //if there isn't a remainder we will do the else
echo "<TR bgcolor=\"#FFFFFF\">\n";
} 
echo "<TD><a href='http://localhost/item_Details.php?itemID=$id' target = '_blank'>{$row['itemName']}</a></TD>
<TD>&pound;".number_format ($row['price'],2)."</TD><TD>".$row['submitDate']."</TD>\n";
echo "</TR>\n";
} 	
echo "</table><br/>";
  
?>

And here is the code for items_Details

<?php
//database info in misc.inc
include("misc.inc");
//Get item ID
$id = $_GET["itemID"];
$db = 0;
//Connect to database
$db = mysql_connect($db_host . ":" . $db_port, $db_user, $db_pwd);
if ($db == 0) {die("Cannot connect, Error <b>" . mysql_errno() . "</b>: " . mysql_error());};

mysql_query("USE " . $db_db);
if (mysql_errno() != 0) {die("Cannot USE database, Error <b>" . mysql_errno() . "</b>: " . mysql_error());};
//fetch data from database
$query1 = "SELECT * FROM images, items WHERE itemID=$id";
$result = mysql_query($query1);
while ($row = mysql_fetch_array ($result))
{
echo"<table>";
echo"<tr>";
echo"<td colspan='2'>
  <h2 style='font-size: large;'> ".$row['itemName']."</h2><br />
    <span id=''></span>
 <br>
<img border='0' align='right' src='../images/{$row['pix']} alt='item Image' style='margin-left: 5px;'> '<br />
  <br>
   <div>     
         <b>Price: </b>&pound;" .number_format ($row['price'],2). "<br />
         <b>Posted On: </b>" .$row['submitDate']. "<br />\n
         </div><br>
<b>Description: </b><p>" .$row['item_Description']. "<p><br />
 <div ;='' style=clear: both;>
  <h4 style='font-size: medium;'>Contact details:</h4>
<b>Name: </b>" .$row['contactName']. "<br />
<b>E-mail: </b>".$row['email']." <br /><br />  
</div></td>\n";
echo"</tr>\n";
}
echo "</table><br/>";
?>

Thank you very much.

line 14

$query1 = "SELECT * FROM images, items WHERE itemID=$id";

is incorrect.

use this sql

SELECT item.itemID, item.categoryID, item.item_Description, item.itemname, item.price, item.contactNAme, ite.phone, item.email, images.itemID, images.pix
FROM item
FULL JOIN images
ON item.itemID=images.itemID
ORDER BY item.itemID

this will join both tables together.
You don't need to write it like this, but this way you can delete the ones you don't want to select.

EDIT: you still need to add your WHERE statement to this

Hope this helps :)

or first try:
$query1 = "SELECT * FROM images WHERE itemID='$id'";

Don't forget your single quotes ;)

echo "SELECT * FROM images, items WHERE itemID=$id"; exit;

echo select query and see out output .

i think problem is selecting two tables. try like this

$query1 = "SELECT * FROM images, items WHERE (images.itemID=$id && items.itemID=$id)"; exit;

Excellent. it works like this:
$query1 = "SELECT * FROM images, items WHERE (images.itemID=$id && items.itemID=$id)";
without the exit;

Thank you very much you both guys!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.