[PHP-DB] Converting Databases

Hi, I am pretty much new to the field of php/mysql programming, however a future project of mine may involve the importing of a large database of products. I am expecting this database to be in MS Access form and am looking for solutions in advanced. Now the question, are there any methods for

Re: [PHP-DB] Converting Databases

Simple solution, if you only have one or two tables: dump them in comma delimited format and then use the LOAD command from the MySQL shell frontend. Alternative: use the MySQL ODBC component and export from access to that (it works like a charm if you use the latest version). Either way should

RE: [PHP-DB] php session

I'm having a little trouble getting sessions to work properly with php. I have put session_start(); on all pages before any data is printed. The session will start on the first loading of the page but after a link is clicked the session seems to die i have no idea why. for the links on the

RE: [PHP-DB] php session

On Mon, 2002-12-02 at 02:43, John W. Holmes wrote: No, it shouldn't. So, the links are correct on one page, and they disappear on the second page? Is there a reason you're passing the SID in the URL and not using cookies? Hmmm, found this in the manual. Maybe it applies? --- The

[PHP-DB] Assign a variable with another variables value

Hi folks, I probably need a little help the next couble of days, but well here is the first question. How can i assign a variable with the value of another variable ?? Example: $foo = BAR; $newBAR = some string; The BAR is supposed to be taken from the value of $foo. THANKS A LOT!!!

RE: [PHP-DB] Assign a variable with another variables value

// Example: $foo = BAR; ${'new' . $foo} = some string; // this should do it i think, in this case creating a var called $newBAR HTH Beau // -Original Message- // From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]] // Sent: Monday, 2 December 2002 10:30 AM // To: [EMAIL PROTECTED] //

Re: [PHP-DB] Assign a variable with another variables value

$foo = BAR; $varname = new$foo; $$varname = some string; Martin Allan Jensen wrote: Hi folks, I probably need a little help the next couble of days, but well here is the first question. How can i assign a variable with the value of another variable ?? Example: $foo = BAR; $newBAR = some

RE: [PHP-DB] Re: PHP4.22/OCI8/Netscape 3.63 tnsnames problem...

[ ORACLE_SID=blah, OciLogon ( user, pw, ); -] If you are really using that third, empty parameter, omit it. The manual says: | If the optional third parameter is not specified, PHP uses the | environment variables ORACLE_SID (Oracle instance) or TWO_TASK | (tnsnames.ora) to

[PHP-DB] Making field concat of autoincrement column and other values?

I'm trying to make a field in my database table a concat of an autoincrement value and some other values. I'm trying: insert into table set val1='val1',val2='val2',concatfield=concat('whatever',id,'whatever'), but it doesn't work. Is there another way, or will I have to update the row

Re: [PHP-DB] Making field concat of autoincrement column and othervalues?

I could concat when selecting, but it will be used in the where clause (it is neccesary to do it like this, I'm also md5ing it but forgot to mention that), and I'm guessing it would be bad for the server to have to concat and md5 in the where clause. John W. Holmes wrote: I'm trying to make a

RE: [PHP-DB] Making field concat of autoincrement column and other values?

I could concat when selecting, but it will be used in the where clause (it is neccesary to do it like this, I'm also md5ing it but forgot to mention that), and I'm guessing it would be bad for the server to have to concat and md5 in the where clause. Yeah, I guess so. This all begs the

Re: [PHP-DB] Making field concat of autoincrement column and othervalues?

I'm trying to make a customised session system (I could use PHP's built-in one, but I need a lot more control than it offers). I could use the autoincremented id in a cookie, but it would be easy for a hacker to change the cookie to gain access to others' data. John W. Holmes wrote: I could

RE: [PHP-DB] Making field concat of autoincrement column and other values?

So now the hacker has to guess 'whatever' and 'whatever', right? Why not just use uniqid() and md5() to create a truly random unique id, so there's no chance of guessing right... ---John Holmes... -Original Message- From: Leif K-Brooks [mailto:[EMAIL PROTECTED]] Sent: Sunday, December

[PHP-DB] some data output formatting and grouping question...

I just have a fucking mental block; I cannot at all conceive the necessary syntax to or even the theoretical algorithm that I need, to do the following: Consider the following table: U | X | Y --|---|-- me|001|0a me|002|0a me|003|0a me|002|0b me|003|0b me|004|0b ..|...|.. then the code says: