To edit a value (field), you don’t use "select", but "update"!
ie
$sql = "update `tablename` set `fieldname` = ‘".$newvalue. "’ where `otherfield`= ‘".$value."’" limit 1";
View the page and source at:
http://nlmphotography.net/MAIN/news/news.php
[CODE]<?php
header("Content-type: text/xml");
$host = "xxxx";
$user = "xxxx";
$pass = "xxxx";
$database = "xxxx";
$linkID = mysql_connect($host, $user, $pass) or die("Could not connect to host.");
mysql_select_db($database, $linkID) or die("Could not find database.");
$query = "SELECT DISTINCT year_id, date FROM news ORDER BY year_id";
$resultID = mysql_query($query, $linkID) or die("Data not found.");
$xml_output = "<?xml [...]
ok ,I have problems with my inner thighs , there is some skin discolouration on my inner thighs ,where two legs join,,at the sides of my private part, and it is some kind of wet over there,because of this skin over there ,get peeled and some times ,i can see red flesh .and it [...]
I have a table of records that contains duplicate account numbers. The table is sorted so that the rows are grouped by account number. I need to select just the first row for each unique account number. Using DISTINCT doesn’t work because I need the whole row and each row is a little different except [...]
hi, i was wondering how to create a myspace group train where the owners pictures are side by side and where i could click on each image so it would take me to their profile. thanks.
go to myspace groups and create you group upload some pictures witch allows you to change there psoition.
I bought this Sony DSC-W80 camera and it take s the sony memory stick duo or the sony memory stick duo pro card. Can you just insert this into the Toshiba A215-S5825 laptop to transfer pictures? I know it has media ports I just don’t know if this is one of them. [...]
How does a database work in a large retail store, per store, such as Home Depot for example? For example is there a central database for a specific store that has all the products (just the products) that are currently availible on the shelf in the store? (Talking about specific stores, rather than an overall [...]
I don’t want everything on the page, just certain data. How do I write the query to specify?
I don’t know how to specify the certain data in a web query. What you could do is query the whole page on a separate sheet and then reference the cells that you want on your original sheet.
Example:
If [...]
These items will be different each time the excell form is filled in. I am just starting to use MVB and am at a loss with the code. I can build the macro but do not know how to get the words to past into excell. Thanks for your help
=A1&" "&B1&" "&C1&" [...]
I need to retrieve Country name and total value of all sales that I have made to that country during 2007 where the total values of sales to that country is under $5,000. Result set should have just one row per country name.
I have a Orders table, OrderDetails (from Northwind db)
I keep getting errors from [...]
