Hi,
I have a page to view the product detail(view_pro.php), at the same time I also want to view the customer detail(cust_id)at that page.
The problem is, it only can view the product detail. :(
So, what or how can retrieval data direct from dbase?

SELECT * FROM customer WHERE cust_id = "$_POST[cust_id]";
it return empty value.
Isn't $_POST only function to pass the value from HTML form?
If I write in this, result still same - not value.
SELECT * FROM customer WHERE cust_id = '$cust_id';

Thanks in advance.

You should change that as

"SELECT * FROM customer WHERE cust_id =" . $_POST[cust_id];

Cheers!

_________________________
-Vijay G
Strive for Perfection

I get error msg:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Thanks in advance

Try:

$query = "SELECT * FROM customer WHERE cust_id='".$_POST['cust_id']."'";

Snib

<><

Can you post the code here, that gives you that error?

_________________________
-Vijay G
Strive for Perfection

Hi, it still not return any value.
Attach code:
$query = "SELECT * FROM customer WHERE cust_id='".$_POST['cust_id']."'";

$result = mysql_query($query) or die (mysql_error());


//function

    function check(&$var)
    {
        return (isset($var))? $var :'';
    }

    echo" <br>\n".
        " ".check($_POST['cust_id'])."\n".
        " </b>\n".
        " - The customer detail is shown below.\n".
        " <p> </p>\n".
        " <table width='70%' border='1'>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Customer Name:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['cust_name'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Address 1:\n".
        " </td>\n".
        " <td>\n";
?>
     <textarea name='add1' cols='70' rows='5' id='add1' ><? echo "".check($_POST['add1'])."\n"; ?> </textarea>
<?php
    echo" </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Address 1:\n".
        " </td>\n".
        " <td>\n";
?>
    <textarea name='add2' cols='70' rows='5' id='add2' ><? echo "".check($_POST['add2'])."\n"; ?> </textarea>

<?php
    echo" </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Country:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['country'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Postal Code:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['postal'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Phone No.:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['phone'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Fax No.:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['fax'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>E-mail:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['email'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Contact First Name:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['cf_name'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Contact Last Name:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['cl_name'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Position:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['position'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Last Person:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['cust_person'])."\n".
        " </td>\n".
        " </tr>\n".
        " <tr>\n".
        " <td>\n".
        " <b>Last Modified:\n".
        " </td>\n".
        " <td>\n".
        " ".check($_POST['cust_mod'])."\n".
        " </td>\n".
        " </tr>\n".
        " </table>\n";
?>

Thanks in advance.

Is this page published somewhere?

Are all the $_POST variables set for sure?

Add this to the query just in case: LIMIT 1

So that it looks as follows:

$query = "SELECT * FROM customer WHERE cust_id='".$_POST['cust_id']."' LIMIT 1";

Let me know,

Snib

<><

I suspect your $_POST['cust_id'] doesn't contain any data. Please check that.

_________________________
-Vijay G
Strive for Perfection

Sorry,it still same.

Isn't $POST is use to pass the value from a form?

May be you right, $_POST['cust_id'] doesn't contain any data.

Sorry, I doesn't say my word so clear.
First, user must insert the prod_id to view the product detail (view.php). Next page(view_pro.php)will display the selected product detail. At the same page,I want it can view the customer detail who order the product.

My problem is, it only can view the product detail.
So, want should I write the query to view the data?

Thanks in advance.

Does your form look something like this?

<form method=POST action="view.php">

Snib

<><