Intimidat0r

Okay, I'm not very good with databases in php (this is my first php serious application thing). if i have this:

[PHP]$sqlstring = mysql_query("SELECT * FROM someRandomTable WHERE id=1");[/PHP]

obviously we're assuming there's only one entry where the id is 1. my question is, how can i then do something like assign, say, $someOtherColumnValue (or whatever var) to a different column's value in the row where the id is 1?

__________________
Children in the dark cause accidents, and accidents in the dark cause children.

http://www.ronincoders.org

skuinders

You use an update SQL query...

__________________
"A stupid man's report of what a clever man says can never be accurate, because he unconciously translates what he hears into something he can understand."
- B. Russell

http://web.bryant.edu/~srk2

Intimidat0r

then how would i assign the value of a column in that row to a variable?

__________________
Children in the dark cause accidents, and accidents in the dark cause children.

http://www.ronincoders.org

magic_e

you could use a loop to go through each result and return just the value you want

[PHP]
$res = mysql_query("SELECT * FROM someRandomTable WHERE id=1",);

while ($row = mysql_fetch_array($res, MYSQL_ASSOC)) {

$VAR_NAME_HERE = $row['ROW_NAME_HERE'];
$VAR2_NAME_HERE = $row['ROW2_NAME_HERE'];
$VAR3_NAME_HERE = $row['ROW3_NAME_HERE'];

}[/PHP]

how it helps

magic e

Lich

for help on sql and php check out www.spoono.com/php

jcmnetmedia

I dont want to sound like a jerk, but this is pretty basic, and the only reason I say that is because I think you'd benefit by going through the basic php/mysql tutorials available on the web before getting started. I think this is what you are looking for, is an update query, with variables inserted into it:

[php]
$sql = "UPDATE `users` SET `name` = '$name', `email` = '$email' WHERE `id` = $id LIMIT 1";
[/php]

This will update your tables with the values provided in the variable. The clause "LIMIT 1" is not even neccessary, but I use it as a safety precaution, just to keep it from updating multiple rows in some freak instance.

Edit: Spoono does have a good tutorial here that will get you rolling in the right direction.

__________________
Jeremy Morgan,
Check out my SEO Blog.
Simplicity is the ultimate sophistication!

Lich

Also, get a good SQL book and learn how to use it. Once you get the SQL command line, the php stuff makes alot more sense