Help Please!!

russmc

I need a little help with a simple code that would do this,

The user submits a form supplying their order id it is passed to form.php as $order_id

I have a table named orders_products that contains their orders_id and the products_id that they ordered.

Then I have a table named products_description that contains a field named products_lister_url that contains a url to a page for the product they ordered and the products_id

right now form.php validates the orderer by email_address and orders_id I need it to ,based on the order id to get the products_id from the first table store it in a variable and using that variable get the products_lister_url based on that variable and put it into a variable so that it can be called on in html body via a php call.

does that make any sense, here is what got so far

<?php

include('includes/application_top.php');

#################Get Products_id to assign page redirect after validation##############################

$sql = mysql_query("select products_id From orders_products WHERE orders_id = '$order_id'");
$result = mysql_query($sql);

$sql2 = mysql_query("select products_lister_url FROM products_description WHERE products_id = '$result'");
$result2 = mysql_query($sql2);

#################Get oder id and lister email address for validation #################################
$result = mysql_query("select orders_id, customers_email_address From orders WHERE orders_id = '$order_id' AND customers_email_address = '$lister_email'");
$number = mysql_num_rows($result);
if($number) {
echo "Thank You! You Are Whom You Say You Are!!<br>Please Continue";
}
else {
echo "your info is incorrect";
}

?>
<HTML>
<HEAD>
<TITLE>Test this script.</TITLE>
</HEAD>
<BODY>
<br><br><?php echo $result2; ?>
</BODY>
</HTML>

jabba_29

You have an error in your code, that might be causing a few problems:

#################Get oder id and lister email address for validation #################################
$result = mysql_query("select orders_id, customers_email_address From orders 
WHERE orders_id = '$order_id' AND customers_email_address = '$lister_email'");
$number = mysql_num_rows($result);

It should read something like:

#################Get oder id and lister email address for validation #################################
$sql3 = mysql_query("select orders_id, customers_email_address From orders 

WHERE orders_id = '$order_id' AND customers_email_address = '$lister_email'");
$result3 = mysql_query($sql3); 
$number = mysql_num_rows($result3);

It is also useful to echo out errors so you can see where you are going wrong:

	
$result2 = mysql_query($query2, $connection) 
or die ("<p class=\"warning\">Error in query: $query2. " . mysql_error(). "</p>");

The above code should be on the same line, it is just broken for legibility.

Also depending on what version of PHP you have, to would be better to query on your variable like:

WHERE orders_id = '".$HTTP_POST_VARS[$order_id]."'

Jamie

russmc

Thank you for your reply,

But the part of code you referenced isworking its the above code that does not work for what I need in the explanation of what I am trying to do.

I am trying to get this working.

The user submits a form supplying their order id it is passed to form.php as $order_id

I have a table named orders_products that contains their orders_id and the products_id that they ordered.

Then I have a table named products_description that contains a field named products_lister_url that contains a url to a page for the product they ordered and the products_id

Thank you in advance!

russmc

What I mean is the code you referencd works to validate the user when they enter there email and order id against what is in the database

I added the above queries in hope of extracting the products id from a table called orders_products place that in a variable

then based on the products id pull a URL from a table called products_description stoerd in product_lister_url based on the products_id variable

and place that url into the html tags with php as a variable??

Thanks again