[PHP] RE: [PHP-DB] implode()

2002-11-25 Thread Beau Lebens
implode accepts an *array* as input, not a string. you would need to change your $sqlUpdate to be an array, and each statement look something like; if($textfield12 != '') { $sqlUpdate[] = textfield12='$textfield12'; } of course it would probably be easier to just do something like this;

[PHP] RE: [PHP-DB] displaying flash from db

2002-10-21 Thread Beau Lebens
*** APOLOGIES FOR CROSS POSTING *** I haven't done this directly, but I imagine the process would be similar to working with images, and the same restrictions/rules of thumb would apply regarding storing them in the db versus storing them on the filesystem, i.e. store the flash files in the

[PHP] RE: [PHP-DB] Session data not being deleted on browser close.

2002-07-08 Thread Beau Lebens
have you closed all browser windows? eg. if you open your browser, then spawn a new window (ctrl-n or similar) then do something with one of them which creates session vars, then close that window, then open a new one again, the session has probably remained active because the first window was

[PHP] RE: [PHP-DB] Random Selecting from mySQL

2002-03-13 Thread Beau Lebens
could you perhaps do the select on the first page, then store the results in a session (array) and just load different indexed portions of the resultset each page? only problem there is that you wouldn't get any refreshed results while browsing those pages - but i don't know if this matters for

[PHP] RE: [PHP-DB] Connecting from PHP to MySQL on another Server

2002-01-17 Thread Beau Lebens
// 1. What is the difference between working with PHP and MySQL // on a local // server and working with PHP and MySQL when MySQL is on a // remote server? none - just specify different hostname in connection call (perhaps IP more reliable) // 2. What is the protocol used to connect to MySQL

[PHP] RE: [PHP-DB] How can this be done?

2001-04-27 Thread Beau Lebens
you need to use the addslashes() command which will escape the quote mark for you, so something like $query=insert into trivia (trivia) values (' . addslashes($line) . '); however, you will find that on a machine which is configured with magic_quotes_gpc turned on, you will end up with