mysql

YodaOfCamarilla

how can I insert something into every row of a mysql table.
Ive tried:

$sql="insert into mytable (column2) values(\"a\") where column1!=\"null\"";

but it doesnt seem to work.

LordShryku

May just be your syntax. I know Oracle is picky like that. Try
$sql="insert into mytable (column2) values('a') where column1 is not null";

YodaOfCamarilla

just tried that and it doesnt work either 🙁

LordShryku

Are you getting an error message?

YodaOfCamarilla

$rs=mysql_query($sql,$conn) or die("Err:Que17");

i recieve the or die message

LordShryku

Add this on the end and get the actual mysql error message

$rs=mysql_query($sql,$conn) or die("Err:Que17" . mysql_errno() . ": " . mysql_error());

YodaOfCamarilla

Err:Que171064:You have an error in your SQL syntax near 'where column1!="null"' at line 1

LordShryku

ok, and what query are you using right now?

YodaOfCamarilla

im not sure what you mean

LordShryku

This error is saying you have a problem with the syntax of your SQL query near WHERE....

What is the sql query you are using?

YodaOfCamarilla

the 1 at the start of this thread

LordShryku

Try using single quotes instead

$sql="insert into mytable (column2) values('a') where column1 != null;

YodaOfCamarilla

is "where" a valid action when inserting data, I have only presumed it is as that is what you put when recieving data.

LordShryku

Yes, it is. It's the conditional statement for inserting. It's having trouble with what's before the where statement.

Teen0724

No it is not, don't use WHERE statment for an INSERT. if you want to change the value of a column at the end of every page then use

UPDATE <table> SET item='Item',item2='item2' WHERE column='condition'

An insert Statment CAN NOT be used with a WHERE conditon, since it creates another row, why would it need to determine where to insert it? It like having a WHILE 1 at the end.

Use update statment instead.

LordShryku

didn't finish...

or it's having trouble with column1!="null"

You just need to debug your query. Most databases don't like double quote charaters, so I would start by replacing those. The also changing != NULL to IS NOT NULL. See what error messages you get by debugging and running it.

YodaOfCamarilla

thx for all the help guys, its sorted through the update function. I guess what Ive learnt from this is don't assume stuff in php 😛