[PHP-DB] Re: Closing curly brackets?

No public ridicule, although it doesn't work. >From what I understand $query = "SELECT id, name, image, quantity, type FROM is an array so if I were to use mysql_fetch_row($ret) it is only returning 1 row. where as mysql_fetch_array($ret) is returning the whole array. However I could be wrong t

[PHP-DB] Re: Advice for dataupload

Hey, if the databases contain the same data, why don't you just have them use one database. Just set up MySQL with a user on the internet server that the intranet system uses to connect to it with.. Do it over SSL and it would be secure then. Wouldn't that be somewhat simpler and less time consumi

[PHP-DB] Re: Closing curly brackets?

Maybe change mysql_fetch_array($ret) to mysql_fetch_row($ret)? Not sure but I've used that before to do what appears to be similar while loops.. Wouldn't the data still get retrieved in array form with that? If I'm wrong, feel free to publicly ridicule me.. Later, Bob Weaver "Jennifer Downey"

[PHP-DB] Closing curly brackets?

Hi everyone, I originally posted this in general by mistake. I have a question about this code. The way it sits now it always shows the last record in the database table. In other words if the user has 6 items, like: item id 1 item id 2 item id 5 item id 6 item id 7 item id 8 it will only show

[PHP-DB] Re: [PHP] Re: arguments against php / mysql?

Sun Microsystems makes a package called ChiliSoft that allows Unix servers to run ASP. I have done a minimal amount of checking into this, but the majority opinion is that this is a bad idea. http://www.chilisoft.com There is also an app called ASP2PHP that converts ASP code to PHP. I have to th

[PHP-DB] Re: LOBS with CURSOR_SHARING=FORCE gives core dump

John! Thanks for the update. Did you find any work-around for this issue? Thanks, Prince. "John Lim" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hmm, I have also been having similar problems with LOBs. However it might > not > be cursor_sharing=force, bec

RE: [PHP-DB] Any way to do this with a minimum of queries?

Ok, if I understood correctly you have two tables one just logs IP addresses and usernames and another having user information, correct? If thats the case, just alter your users table to add an IP column (and user name column as well if needed) and use INSERT INTO ... SELECT ... syntax to populat

[PHP-DB] Any way to do this with a minimum of queries?

I log IP addresses on my site, along with the persons username. Right now, they are logged in a seperate table, but I would like to store them in my users table now. I can't start my ip logging again, since the list of ips is also used for a hit counter. What is a good way (if there is one) to

Re: [PHP-DB] Using include file

I pasted your code into a file testinclude.php (changing only the server name), then wrote another file test.php: It parses okay for me. How are you doing the include? -Steve On Friday, April 12, 2002, at 03:02 PM, Alex Francis wrote: > I get a parse error on line 2. The code is as follows

RE: [PHP-DB] Saving DB Resuts to a file

Hi Chris, This is probably due to a permissions problem on your newsletter subdirectory. Go to the server and change the newsletter subdirectory's permissions to be 777 (leaving it that way could be a security hazard, depending on if you have important information stored in that directory or not,

Re: [PHP-DB] Saving DB Resuts to a file

Hi there, I entered the code in as you described below, and it LOOKS on the screen as thought it is doing it, but when I look at the server there is no output file, can you see anything obvious that I am doing wrong? Thanks for your help. Chris $connection = mysql_connect("localhost","xx",

Re: [PHP-DB] Using include file

I get a parse error on line 2. The code is as follows: As I said, when I paste the code into each file I don't have a problem. -- Alex Francis Cameron Design 35, Drumillan Hill Greenock PA16 0XD Tel 01475 798106 [EMAIL PROTECTED] http://www.camerondesign.co.uk This message is sent in confiden

[PHP-DB] Saving DB Resuts to a file

Hi there everyone, I have a newsletter which works wonderfully, sends to everyone in the DB fine with error checking etc .. My problem is my client now wants to be able to easily save the email addresses from the DB into a text file - so my question is, how can this be done? Connecting t

Re: [PHP-DB] Using include file

Just a guess: Are you doing the include from a function? If so, make sure you explicitly mark your global vars. Otherwise, what's the error message? -Steve On Friday, April 12, 2002, at 12:28 PM, Alex Francis wrote: > I have one site which I am having problems connecting to my database. > I

[PHP-DB] Using include file

I have one site which I am having problems connecting to my database. If I create my connections in an "include" config file I get an error on the server connection. When I cut and paste the code exactly as it is into each file I have no problems. I have a local server set up in my office which I

[PHP-DB] Re: Stopping and restarting Oracle

Just try to run it in the background. I have been using it even such way: exec("$command >csa.log 2>&1 &"); >exec("sudo /etc/rc.d/init.d/dbora stop"); > > Everything works EXCEPT I cannot get it to return from the 'dbora start' > command. The PHP script just sits there and won't budge. I've

[PHP-DB] Re: [PHP] is it possible to scann subdirectories?

write recursive function that uses PHP's functions for directory reading. function read_rec($dir_name){ open_the_dir_name while (read_from_the_dir){ if (name_type=dir){ read_rec($name); }else{ // the file is file not dir // make your check here

Re: [PHP-DB] converting

update some table set some_field='X' where ((some_field IS NULL) OR (some_field!="")); HTH Andrey - Original Message - From: "Natividad Castro" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 12, 2002 2:47 PM Subject: [PHP-DB] converting > Hi to all, > I'm having a lot

[PHP-DB] converting

Hi to all, I'm having a lot of problems doing something that for some of you might be simple. I'm selecting fields from a table that can have an 'A', 'B' or 'C' as their value e.g. FIELDNAME_1 = 'A' FIELDNAME_1 = 'B' FIELDNAME_1 = 'C' FIELDNAME_2 = 'A' AND SO ON what I'm trying to d

Re: [PHP-DB] SID

On Friday 12 April 2002 17:18, [EMAIL PROTECTED] wrote: > Hi list, > > Wonder if someone could assist me in Enabling Trans SIDs. > > I know how to use them, but just dont know the telnet command to enable > them. > > If someone could tell me exactly what I need to do in order to have them > enable

[PHP-DB] Stopping and restarting Oracle

Can anyone help. this is driving me insane. I am trying to write a script that allows users to configure their Oracle server (change tnsnames.ora, listener.ora, update some synomyms to allow them to connect to a remote Oracle server, etc). I'm using exec() and sudo on Linux to allow the Apache

Re: [PHP-DB] Checkbox ?

if you read about cookies in manual, you can see that you have (must) set a cookie before you send any output to browser... so if you send output before "if(isset $aa)" you will have an error. to avoid this look @ "LXII. Output Control Functions" Dave Carrera a écrit : > Hi all > > I have a ch

Re: [PHP-DB] Advice for dataupload

"Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet news:[EMAIL PROTECTED]... > On Monday 08 April 2002 19:15, Michael Andersson wrote: > > > What happens to a blob field with lets say a image when dumping a mysql > > table to a file? > > I don't use BLOB fields. You try it and let me know ;-)

[PHP-DB] SID

Hi list, Wonder if someone could assist me in Enabling Trans SIDs. I know how to use them, but just dont know the telnet command to enable them. If someone could tell me exactly what I need to do in order to have them enabled it would be much appreciated. Many thanks Barry Zimmerman www.bzdp

[PHP-DB] Checkbox ?

Hi all I have a checkbox field in a form and want to set a cookie to the values below. Using the code below it always returns "NO" errr why? http://davecarrera.freelancers.net http://www.davecarrera.com