michael624

Does the word text in --> WHERE length(text)>0 <-- need quotes or '$'? Is this a variable or a constant? Or a row name?

the data is in 2byte format for special characters. notepad reads one byte characters, unless you file-saveas and click encding type as utf8. Have you tried putting it into excel and seeing what happens? I think when you save the csv file as UTF8 the headers in the file will be recoognized by excel then it will work.

that many tables is a lot. Maybe your table is not normalized. 125 tables is too much for even a bank. But you should check your settings limits. you should increase your limits of open connections and cache size limit.

NO NO NO! STOP RIGHT THERE! In a database if you are holding percents keep it as an integer or real. Not as a varchar, although php will convert it for you. BUT never store the percent sign, it goes against ALL database rules! store the percents as numbers and add a % sign when you are outputting the text. Then your original query with >= will work. Although if you cant or dont want to make an import script, you can trim and convert I dont remember the exact syntax but this should be somewhat it: toint(substr(successPct,0,2)) what it does is take the first two letter and convert them to numbers letters:'12%' to int 12

when you create id each have to be unique so there are few ways to do this. You can hash(sha1, md5) the current time and thats the id, hashes look crazy and have no order. But they are lony like 30 characters. Or be simple and just put in the datetime using you own "secret way" like today is 06-03-09 4:40 so the id could be 3060440 and just add like 123456 to it and then you get 423896. Now tell me what date that represents? Since it invloves date and time it will always be different and it will be wierd because time changes. use seconds and then its super cyptic!

I am creating a database that involves users and a UID. I have a 'user_id' so to relate to other tables in joins. Also I have a 'uid' so each user has a unique ID for outside database tracking. I have partners that tell me when my user visits their site by the URL like this: www.sample.com/visit.php?uid=432jh65j They then send an a message to me saying user '432jh65j' has visited their site. I wanted to know if I should have a seperate 'uid' and 'user_id', the uid is for outside tracking and the user_id is for joins. Is this ok?