INSERT VALUES into empty column

Question

 $querychange = 
  mysql_query("UPDATE table SET clounm='$newvale' WHERE email='$email'")

but put $newvalue into the nearest empty cell

How is the specific table row specified? For the null check, you can use where yourColumn is null. — stb
– stb, Commented Jul 27, 2012 at 13:42
user1557whatever, if your table design resembles excel sheet - then your table design is wrong. use table (x int, y int, value int) and transform to excel-like-table on demand... — Kuba Wyrostek
– Kuba Wyrostek, Commented Jul 27, 2012 at 13:49

bryan.blackbee · Accepted Answer · 2012-07-27 13:50:55Z

1

Consider the following code:

UPDATE `table_name` SET `col_name` = `col_value` WHERE `record_name` = 'ID'

for example

UPDATE `student` SET `marks` = 50 WHERE `name` = 'Jack'

This will set all records with name Jack to 50 marks.

answered Jul 27, 2012 at 13:50

bryan.blackbee

1,9645 gold badges32 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

yes but in the code there is a session variable which =$email so only that row can be changed

Dru · Accepted Answer · 2012-07-27 14:09:18Z

0

Is this what your looking for

UPDATE table SET clounm='$newvale' WHERE email IS NULL LIMIT 1

answered Jul 27, 2012 at 14:09

Dru

5564 silver badges21 bronze badges

that sounds like what I'm looking for I'll try it out, TVM for the post.