database sql help needed

wittanthony

I need help coding a few sql statements in php. I made a statement to insert data into a database but its not working.

Heres the statement I made.

$query = mysql_query("Insert Into messages ('to', 'from', 'date', 'message', 'subject', 'type') VALUES ('$to', '$username', '$curdate', '$message', '$subject', '$type') ", $db);

Can some body tell me what I did wrong and post here what the correct statement should be for both statements I posted here?

The other statement I made is suppost to count how many messages a user has in the database for them. Theres 2 statements I need help on.

$result = mysql_query("SELECT count(*) FROM messages WHERE to = '$username' OR to = 'Everybody' ",$db)

$result = mysql_query("SELECT count(*) FROM messages WHERE to = '$username' OR to = 'Everybody' AND type = 'New' ",$db);

Any help will be gladly appreciated. Thanks for you help in advance.

viper21634

Well at first glance, you need to set a var call it $sql, then give it the value of your sql string, then you can do this

mysql_query($sql,$db);

wittanthony

Thanks for you help, but I know that the sql statements are the problem. I am connecting to the database and the database is open before the statements are called. I just keeping getting an error after the sql statements are runned and the data isn't being pulled in. I think the problem is because I got more than 1 field after the WHERE and that its not coded right. I'll try your way if I can figure out why the sql statements are not working right first. All my other sql statements are coded the same way and they work fine. Its just these I'm having a problem with not getting to work right.