ok, so i need to insert something to my mysql database. I have seperately tested the connection, and it's good. It's just something wrong with my code. Look at it.
<?php
include("db.php");
$link2=mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
if(!$link2){ echo "could not connect.";}
$myusername="test";
$mypassword="test";
$sql="insert into `members` (email) VALUES ('asdf@asdf.com') WHERE username='$myusername' and password='$mypassword' ";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
if($result)
{
echo "successful.";
}
?>
It's not some internal problem with the WHERE function, because it works fine when i use it with other things..
this is very simple, but it simply wont work... help is greatly appreciated!!!!
~kodiak