No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
 | I'm brand new to SQL queries, hoping someone can help me set up this query. I'm using [URL="http://www.phplist.com"]phpList [/URL]to manage my mailing list. All user defined attributes appear to be stored in a table called phplist_user_user_attribute. The structure of this table is:[INDENT][U]Field[/U], [U]Type[/U] attributeid, int(11) userid, int(11) value, varchar(255) [/INDENT]attributeid …  |
| | why does [code]$sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "68104"'; $query = mysql_query($sql);[/code] find 23 records, but [code]$testvalue="68104"; $sql = 'SELECT userid FROM `phplist_user_user_attribute` WHERE `attributeid`= 7 AND `value` LIKE "$testvalue"'; $query = mysql_query($sql);[/code] finds none? Shouldn't they be the same? Can I not use … |
| | I have a barcode scanner (UF-101 PS/2 keyboard wedge). Was working fine one day, the next it won't read anything. (Shines the LED light on the barcodes, but won't "read" them). So I bought a new scanner (POSX Xi200, also a PS/2 keyboard wedge), but it doesn't work either. Tried … |