How should I structure code?

[DeepakJ]

Ok so I want to create an update in this table

 

productid invoicenum

xxx        yyy

xxy        yyz

 

But I want to change the productid from ""(initially entered before in teh script) to the actual key with this table.

There can be multiple invoice num in this table. How can I make a SQL instruction that will only update the FIRST "" string available. UPDATE productid SET productid='$productid' WHERE invoicenum=$invoicenum changes all the null strings at the particular invoice num.

 

Help would be greatly appreciated.

[severndigital]

quick answer (not sure if it is the best though)

 

add a time stamp to the entry and update based off that.

 

i can elaborate more if you want to go that way.

 

chris

[fenway]

I don't know why you're trying to accomplish this task, so it's hard to suggest alternatives.

[Iceman512]

Hi DeepakJ,

 

I hope I'm understanding you rightly... how about something like this:

<?php
UPDATE productid SET productid='$productid' WHERE invoicenum = '' LIMIT 1
?>

 

or

 

<?php
UPDATE productid SET productid='$productid' WHERE invoicenum != '' LIMIT 1
?>

 

Does that make any sense or help at all?

Iceman