[Sparky222B]

I've been googling and I'm stumped.

PHP Code:

query = mysql_query("SELECT Title FROM offers WHERE country LIKE '$ucountryid' ORDER BY offerid DESC");

while($Title = mysql_fetch_row($query))
{
     $URL = mysql_query("SELECT URL FROM offers WHERE Title='$Title'");
     $Description = mysql_query("SELECT Description FROM offers WHERE Title='$Title'");
     $price = mysql_query("SELECT price FROM offers WHERE Title='$Title'");
     echo "<a href='".$URL."'>".$Title."</a> - ".$Description." (".$price.")<br>";
}; 

This seems to return:

Code:

Array - Resource id #32 (Resource id #33)
Array - Resource id #35 (Resource id #36)

What is going on here? Why doesn't it return the SINGLE matching result to those queries?

[robertark]

$Title is going to be an array more than likely. Try this:

PHP Code:

while($Title = mysql_fetch_row($query))
{
/*
     $URL = mysql_query("SELECT URL FROM offers WHERE Title='$Title'");
     $Description = mysql_query("SELECT Description FROM offers WHERE Title='$Title'");
     $price = mysql_query("SELECT price FROM offers WHERE Title='$Title'");
     echo "<a href='".$URL."'>".$Title."</a> - ".$Description." (".$price.")<br>";
*/
  print_r($Title);
} 

You should probably call an element out of $Title, such as $Title['element1'], $Title['element2'], etc.

To clarify things, look in your table (whatever the table is being queried with $query above) and see what columns there are. Each column will be the actual 'element' - Sorry if I'm confusing you heh

[Sparky222B]

That fixes the titles being echoed ($Title[0], etc), but the URL and other mysql_query lines still return Resource #s.

PHP Code:

while($Title = mysql_fetch_row($query))
{
    $Title2=$Title[0];
     $URL = mysql_query("SELECT URL FROM offers WHERE Title='$Title2'");
     $Description = mysql_query("SELECT Description FROM offers WHERE Title='$Title2'");
     $price = mysql_query("SELECT price FROM offers WHERE Title='$Title2'");
     echo "<a href='".$URL."'>".$Title2."</a> - ".$Description." (".$price.")<br>";
}; 

Code:

Ringtone Download - Resource id #32 (Resource id #33)
Test Offer - Resource id #35 (Resource id #36)

Sorry if I'm confusing you heh

HAO I USE ARAYS? Seriously, come on.

[robertark]

PHP Code:

print_r($Description);
print_r($price); 

Print your results and see what they are, if that fails, try var_dump();

[Sparky222B]

Yeah, it occured to me - they dump as

Code:

 resource(34) of type (mysql result) NULL

[robertark]

Without knowing your MySQL table setup, it's a pain to figure out where the problem may be coming from. Your PHP is right, however, go through your MySQL tables and confirm that each column you're calling (Description, Price, etc) actually exists and is non-null.

[robertark]

What is your $query (in the while loop) - Show me that first, please

[Sparky222B]

They all exist and are non-null. Query is

PHP Code:

$query = mysql_query("SELECT Title FROM offers WHERE country LIKE '$ucountryid' ORDER BY offerid DESC"); 

Nico: No SQL error is given; the query executes successfully, just doesn't return right.

Table creation structure:

CREATE TABLE `offers` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` varchar(255) NOT NULL DEFAULT '',
  `Title` varchar(255) NOT NULL DEFAULT '',
  `URL` varchar(255) NOT NULL DEFAULT '',
  `Country` varchar(200) NOT NULL DEFAULT '',
  `Description` varchar(255) NOT NULL DEFAULT '',
  `price` varchar(255) NOT NULL DEFAULT '',
  `offerid` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ; 

[End User]

Originally Posted by Sparky222B

HAO I USE ARAYS? Seriously, come on.

Here is how you use arrays:

http://us2.php.net/array

[robertark]

Originally Posted by Sparky222B

They all exist and are non-null. Query is

Code:

$query = mysql_query("SELECT Title FROM offers WHERE country LIKE '$ucountryid' ORDER BY offerid DESC");

Nico: No SQL error is given; the query executes successfully, just doesn't return right.

Table creation structure:

Code:

CREATE TABLE `offers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` varchar(255) NOT NULL default '',
  `Title` varchar(255) NOT NULL default '',
  `URL` varchar(255) NOT NULL default '',
  `Country` varchar(200) NOT NULL default '',
  `Description` varchar(255) NOT NULL default '',
  `price` varchar(255) NOT NULL default '',
  `offerid` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;

Try this:

PHP Code:

$query = mysql_query("SELECT * FROM offers WHERE country LIKE '$ucountryid' ORDER BY offerid DESC") or die(mysql_error());
while($row = mysql_fetch_assoc($query)) {
  print_r($row);
} 

Then from there, you could do something like:

PHP Code:

$query = mysql_query("SELECT * FROM offers WHERE country LIKE '$ucountryid' ORDER BY offerid DESC") or die(mysql_error());
while($row = mysql_fetch_assoc($query)) {
  $date = $row['date'];
  $Title = $row['Title'];
  $URL = $row['URL'];
  $Country = $row['Country'];
  $Description = $row['Description'];
  $price = $row['price'];
  $offerId = $row['offerid'];

  # Echo accordingly...
} 

Is this what you're trying to do?