Re: [PHP-DB] Getting Results

2011-01-20 Thread Karl DeSaulniers
Hi Robbyka, ."USERS." and ."VIP." are constant variables used to hide the actual names of the tables for security reasons. Those variables will have content. Not sure what you mean by "semi locon like => from ".users";" The user names are set up to be unique. No two user names can be identi

Re: [PHP-DB] Getting Results

2011-01-20 Thread Karl DeSaulniers
Thanks Robbyka, The username would be what your referring to with the .idvip So.. "select username, userlevel,email, timestamp from ".USERS.", ".VIP." where ".VIP.".username=".USERS.".username; yes? Karl On Jan 20, 2011, at 7:24 PM, Robbyka Gheo wrote: i think its wrong, try this script?

Re: [PHP-DB] getting results from INSERT

2001-10-26 Thread Bruno Gimenes Pereti
I think you want this. $sql = "INSERT INTO table (cod, nome, email) VALUES ('', '$nome', '$email')"; $result = mysql_query($sql); $cod = mysql_insert_id(); The $cod is the primery key. Hope it helps. Bruno Gimenes Pereti. - Original Message - From: "Matt Stewart" <[EMAIL PROTECTED]> To