[thelist] mysql help

der wert derwert at hotmail.com
Mon Oct 2 00:06:15 CDT 2006


first I would recommend you adding an index field and make it uniq and have 
it auto_increment
now say you have an entry in the table that looks like this

index	= 1
category= misc
url	= http://example.com
title	= example
target	= _blank


if you wanted to change title to example2 you would do the below query

UPDATE `info` SET `title` = 'example2' WHERE `index` = 1 LIMIT 1 ;

_________________________________________________________________
The next generation of Search—say hello!  
http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&FORM=WLMTAG




More information about the thelist mailing list