Quick question about reading and modifying a record.

[kjspear]

Hello everyone!

I have a quick question. Can MySql do both retrive records and modify the values in them at the same time? For example, the code below reads records one at a time on the screen.

$db=mysql_connect("mycomputer","yourname","&quot
or die("Could not connect : " . mysql_error());
mysql_pconnect();
mysql_select_db("mytable&quot or die("Could not select database"


$query = ("SELECT * FROM myimagexx where ID=$count"

$result = mysql_query($query) or die("Query failed : " . mysql_error());
$num_rows = mysql_num_rows($result);

if ($v5=5){;
$sql = "INSERT INTO `myimagexx` (`v5`) VALUES ('" . $v5. "')";
}



echo "$num_rows Rows\n";

while ($row= mysql_fetch_array($result))

//I used the sessions command increment the page visit by //one for the $count varible. It works fine for retriving records one at a time on screen. What I really want to do is not add records but to modify one. So lets say, 'v5' was 1 it was changed to 2.

Please let me know if you need more information.

Thanks
KJ

 

[sleipnir214]

I'm not sure what it is you're trying to do, but MySQL cannot select and modify a record at the same time. I doubt you can do this with any SQL-based datbase server.



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[kjspear]

O.K. I was afraid of that. I'm going to try something else. I'll let you know the results.

Thanks
KJ