Re: Modifying a database

cptn_future

Hi all...

I got this MYSql data base file that contains some values. Does anyone know the code to compare a certain value to the code, and of the value matches do something to the value inside the database, other wise continue. I tried the code below but it didnt work.

<?php
$name = $POST["name"];
$age = $POST["age"];
$prov = $_POST["provence"];

mysql_connect ("localhost") or
die ("could not connect to Database");
mysql_select_db("biz") or
die("could not find database");

$query = "insert into inof(name,age,prov) values ('$name','$age','$prov')";
mysql_query($query) or
die(mysql_error());

$result = mysql_query("select from inof") or
die (mysql_error());
while($row=mysql_fetch_array($result)){
//**********************************
// This is where I want to compare the vlaue
/////////////////////////////////////////////////////////
if ($row['age']=="41"){
$row['name']="someName";

	echo "\n";
echo $row['name'],"\t",$row['age']. "<br>\n";
}

}

?>

thorpe

try changing this;

if ($row['age']=="41") {

to;

 if ($row['age']==41) {

cptn_future

Hi there Thorpe

First, I'd like to thank you for taking the time in answering my thread.

The problem is that 'age' is actualy a text column, hence I used "41".
or let me ask you another question in this regard. What if instead of 'age', I had, say:
$row['FirstName']=="Jon";

in other words, im checking to see if the First Name was jon, how would go about this??

Best regards

laserlight

Does anyone know the code to compare a certain value to the code, and of the value matches do something to the value inside the database

You need to UPDATE the DB table and SET the value as required for that to happen.
What you're doing here is changing the $row['name'] variable in PHP, which of course doesnt affect the database.

cptn_future

Hi there Laserlight..

Thanx for taking the time to answer ma question. Im realy a newbie at PHP. Im actualy more knowledgeable in ASP than PHP, so I need all the help I can get.

Hence, I was wondering whats the code to update that database, if you dont mind sharing with me??

THanx