MySQL query

junemo · June 10th, 2004, 08:12 PM

I find the solution.

Thanks all.

happygv · June 10th, 2004, 08:15 PM

If you dont mind could you post here about the solution you found to solve that?

Cheers!

_________________________
-Vijay G

Strive for Perfection

junemo · June 10th, 2004, 09:12 PM

<?php
$db_name = "prod";
//create connection
$conn = mysql_connect("localhost", "phpuser","") or die (mysql_error());

//select dbase
$db = mysql_select_db($db_name, $conn) or die (mysql_error());

//Formulate and execute the query
$sql = "UPDATE product SET
    prod_id= '$_POST[prod_id]',
    b_type= '$_POST[b_type]',
    descp= '$_POST[descp]',
    cust_id= '$_POST[cust_id]',
    person= '$_POST[person]',
    mod= '$_POST[mod]'
    WHERE prod_id= '$_POST[prod_id]'";

$result = mysql_query($sql, $conn) or die(mysql_error());
mysql_close($conn);
?>
<html>
.......

<?php
//Display all updated record
//query
$sql = "SELECT * FROM product WHERE prod_id = '$prod_id'";
$result = mysql_query($sql, $connection) or die (mysql_error());

//function
    function check(&$var)
    {
        return (isset($var))? $var :'';
    }
//refer my previous post
?>
......
</html>

It can use single QUOTEs because data type set as VARCHAR (prod_id). Isn't?
I use function check(&$var) to assign the values of $_POST variables.(Thanks Rich)

Thanks for help.

happygv · June 10th, 2004, 09:20 PM

Yes, you can always you single QUOTEs around it when its type is varchar.

I actually wanted to know what you were missing so that the database was not updated, but still you were saying the UPDATE worked fine.

Is that you were missing this part earlier? as I was able to see only part of you code in all you previous post.

Code:

$sql = "SELECT * FROM product WHERE prod_id = '$prod_id'";

Cheers!

_________________________
-Vijay G

Strive for Perfection

junemo · June 10th, 2004, 10:11 PM

Before I say UPDATE worked fine because I had test on mysql.exe, it can function. But at html form, must use $_POST to pass the value, isn't?
Then, I not using the POST passed the new value to dbase(UPDATE query)at my previous post.
UPDATE value can view on page may be because I use POST (//function)to retrieval the data from html form.

$sql = "SELECT * FROM product WHERE prod_id = '$prod_id'";
This query for me make sure I retrieving data from dbase not from previous page.

Thanks. :-)