Re: mysql row position

2002-06-14 Thread Zac Hillier
= mysql_insert_id(); } #-- check to see that each word has an index value if($indx[$key]) { #--create value list for update into lookup table $vlst .= "($compID," . $indx[$key] . "," . $scr[$key] . "), "; } else { echo 'no index set for keyword, word = &

mysql row position

2002-06-14 Thread Zac Hillier
Hi I'm looking for a php function that will return the position of the pointer in a mysql recordset. I found mysql_data_seek, but this appears to only move the pointer, I need to get the equivalent row number for the pointer position before moving it, then return to the same position. Can anyon

large data design for mysql

2002-05-31 Thread Zac Hillier
Hi, Within MySql if you have a large amount of data of the same format and also know that there are distinct groups within this data which you need to run many comprehensive searches against; is it better to have a well indexed large table or many small tables / databases for each distinct group

VB3 and mysql

2001-06-06 Thread Hillier
To whom it may affect Jonas Norrman pass this question on to you Is VB3 compatiable for mysql * Visual Basic Thanks Brett Hillier