Help with a Loop

[ex1]

hey! my first post here! here goes...

here is the code;

$count = "4";
$db_result = mysql_query("SELECT offer FROM offers"); 
if ($row = mysql_fetch_array($db_result)) { 
do { 
$query = "SELECT * FROM requests WHERE offer = $row['offer']";  */ this is line 22 /*
$result = mysql_query($query);
$count++ 
} while($row = mysql_fetch_array($result)); 
};

here is the error;

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /var/www/users/semple/readerOffers/totals.php on line 22

here are the tables;

offers

id | offer

1 offer 1

2 offer 2

3 offer 3

requests

id | offer | date
1 offer 2 111111
2 offer 2 111111
3 offer 1 111111
4 offer 3 111111

explanation;

i am trying to make a loop that will loop through all the offers. then using 'offer' from the offers table select all the entries in the request table that relate to that specific offer.

ie;

$query4 = SELECT * from requests WHERE offer = "offer 1";
$result4 = mysql_query($query4);

$query5 = SELECT * from requests WHERE offer = "offer 2";
$result5 = mysql_query($query5);

$query6 = SELECT * from requests WHERE offer = "offer 3";
$result6 = mysql_query($query6);

ill then use mysql_numrows to find the total number of requests for each offer.

so... where am i going wrong?

thanks!

david*

[ex1]

$count = "4";
    $db_result = mysql_query("SELECT offer FROM offers"); 
    if ($row = mysql_fetch_array($db_result)) { 
    do { 
    $query = "SELECT * FROM brouchurerequest WHERE offer =". $row['offer']. ""; 
    $result99 = mysql_query($query);
    $getit = mysql_num_rows($result99);
    print $row['offer']; 
    } while($row = mysql_fetch_array($db_result)); 
    };
?>

this is the update and the select statement works.
i can out put all the offers to the screen.

but the mysql_num_rows aint working. i get this;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/users/semple/readerOffers/totals.php on line 24

line 24 is the mysql_num_rows.

david*

[tsinka]

Try to change it to

$count = "4"; 
    $db_result = mysql_query("SELECT offer FROM offers");  

    if ($row = mysql_fetch_array($db_result)) {  

    do {  

    $query = "SELECT * FROM brouchurerequest WHERE offer ='".$row['offer']. "'";  

    $result99 = mysql_query($query) or die ("Error: ".mysql_error()); 
    $getit = mysql_num_rows($result99); 
    print $row['offer'];  

    } while($row = mysql_fetch_array($db_result));  

    }; 

the ' are only neccessary if offer is not numeric. The use of mysql_error will show you if there is something wrong with the query.

[ex1]

using that update u supplied i get error,

Error: You have an error in your SQL syntax near 'Republic 17/07' at line 1

now im more confused?

david*

[ex1]

just did some further error checking - the select statment is not working.

any ideas people?

david*

[tsinka]

Did you use the single quotes in the select statement ?

What does your SQL statement look like if you print it out ?

[ex1]

sorted it out people!

stupid mistakes ruin a full script!

so her it is...

	$db_result = mysql_query("SELECT offer FROM offers"); 
	if ($row = mysql_fetch_array($db_result)) { 
	do { 
	$query = "SELECT * FROM request WHERE offer ='". $row['offer']. "'"; 
	$result99 = mysql_query($query);

if ($result99){
	print "select has worked";
	} 

$getit = mysql_num_rows($result99);
print $row['offer']; 
print ": "$getit;
} while($row = mysql_fetch_array($db_result)); 
};

david*

[ex1]

see if i want to pull out the contents of another column in the array can i do it in the same way i have done it already.

is i wanted to pull out both the date and the offer columns can i do...

print $row['offer'];
print $row['date'];

david*