[PHP-DB] Re: [EMAIL PROTECTED] php crashes with msyql

Noah Silverman wrote: Hello, I have a mission critical problem that I cant seem to solve. Can anyone help?? I'll even offer $100 paypal if someone gives me the answer to solve this issue. You don't enable zts so I seriously doubt your php is threadsafe; you configure httpd without speci

[PHP-DB] More problems with a script. How to I get to a next entry

HI All, I have this script. (See below) it was designed to allow my case managers to look at a list of the case noted they have generated on a specific client. It allows the case manager to select the client and then it shows them the case note. Only problem is that it only shows them one case

[PHP-DB] Showing the next entry

Hi All, I have developed a script that allows me to select a students name from the client table and display the call information from the case_note table, but the report only shows the first available case_note for an individual. I want this script to display all entries for the specific client

RE: [PHP-DB] problems with a script. .

Martin; I have taken your advice and read both of the articles, but unfortunately I have not been able to find what needs to be changed. As I mentioned, I am very new at this. Could you possibly look at the script and point me in the right direction? Keep the faith John Wireless Neighbor

[PHP-DB] problems with a script

Hi everyone, I have a question. I have built a script on my desktop that works fine, but when I upload it to the server, it does not post the data to the database. I checked the my server and the isp server. I am running php 5.+ but my isp is only running php 4.3.9 does this mean I have to cha

[PHP-DB] Getting information on ICQ

I understand that there is a support group for newbie's on ICQ. Can anyone direct me as to how I can get on that list. thanks John

[PHP-DB] Looking for help.

I need help. I am building a database for a collaborative non-profit organization. Originally it was scheduled to be done in MS Access, which I know fairly well. but the problem is they want it hosted on a freeDBS server and they do not have the ability to use an access database, nor are they wi

[PHP-DB] Problems with a script

Add an Entry "; if ($_GET[master_id] != "") { //connect to database $conn = mysql_connect("localhost", "root", "becky") or die(mysql_error()); mysql_select_db("testDB",$conn) or die(mysql_error()); //get first, last names for display/tests validity $

RE: [PHP-DB] Sorting multidimensional arrays from mysql

I need your help. I have a script that allows me to select a specific user from a mysql database and then allow me to show the data on a specific client. I would like to put this information into a for that I have created instead of just displaying them on the screen. Any Suggestions. Keeping t

RE: [PHP-DB] Re: log in script kicks me out

I have done that, and there are no differences. Thank you for the advice. -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: log in script kicks me out >"Irm Jr" <

RE: [PHP-DB] Re: log in script kicks me out

Upon reading your suggestion, I tested the same script on a new server using PHP 5 and don't seem to have this problem. Might there be an installation problem? Or something with php itself? -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 12

[PHP-DB] RE: log in script kicks me out

ms, and no solutions. -Original Message- Sent: Tuesday, August 17, 2004 7:08 AM Irm Jr wrote: > Each page checks for a particular session variable, if it isn't set to > a particular value, the intruder is kicked out to the login form and > asked to log in. > > Th

RE: [PHP-DB] Warning message -- session side-effect

I just came across this yesterday in fact. If you look in your php.ini file, you will see the following ; PHP 4.2 and less have an undocumented feature/bug that allows you to ; to initialize a session variable in the global scope, albeit register_globals ; is disabled. PHP 4.3 and later will wa

RE: [PHP-DB] php mysql dates

)447-4310 -Original Message- From: Justin Patrin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 28, 2004 3:44 PM To: Irm Jr Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:39:01 -0700, Irm Jr <[EMAIL PROTECTED]> wrote: > Sure I understand Y-

RE: [PHP-DB] php mysql dates

Sure I understand Y-m-d. But won't the database cry because the Month is in text format? (January, february)? Thanks again. Subject: Re: [PHP-DB] php mysql dates On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr <[EMAIL PROTECTED]> wrote: > > Hi all, currently I have a form

[PHP-DB] php mysql dates

Hi all, currently I have a form which prompts for the user to choose a date. The dropdown lists are stored into variables: $month//e.g. January, February, ... $day //e.g 1 - 31 $year //e.g. 2004 (four digits) then combined into $articleDate How can I manipulat

[PHP-DB] SQLite

. The configure statement I used to compile PHP is below. Thank you in advance for any advice you can provide! JR ./configure --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --include dir=/usr/include --libdir=/usr/lib --libex

Re: [PHP-DB] MySQL Query not working via PHP

I would say try single quotes instead of double quotes ... let me know if that works ... Regards, Matt. - Original Message - From: "Sean Smitz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 4:32 PM Subject: [PHP-DB] MySQL Query not working via PHP > I have

Re: [PHP-DB] Confused

uclear over this question. Next time, I'll go elsewhere since some one got P.O.'d about my posting twice. Sparky -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --- Michael Cupp, Jr. 937/626-2310 [EMAIL PROTECTED] -- PHP Databa

[PHP-DB] PHP Issue

I'm trying to 'run' a php pgoram by loading it into my browser, but instead of running, it only displays it to me - how can I fix this?

RE: [PHP-DB] access mysql db with DW

Part of the problem is $insertGoTo = "booking_details.php?email=".HTTP_POST_VARS["email"].""; should be $insertGoTo = "booking_details.php?email="$HTTP_POST_VARS["email"].""; -Original Message- From: Terry L. Ensley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 08, 2003 7:53 PM To

RE: [PHP-DB] access mysql db with DW

Part of the problem is $insertGoTo = "booking_details.php?email=".HTTP_POST_VARS["email"].""; should be $insertGoTo = "booking_details.php?email="$HTTP_POST_VARS["email"].""; -Original Message- From: Terry L. Ensley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 08, 2003 7:53 PM To

[PHP-DB] Outgoing mail problem.

Friends, I have a RedHat 7.3. I am having problems to send email. I know, I must config the php.ini. What are the configurations, that i need to setup? My php.ini has an smtp entry, but no sendmail or qmail is running on the local machine. Do I have to have one running? I wish I did not have to

[PHP-DB] Database Connections

I have a general question concerning databases in php. More specifically, what is the general consensus on maintaining a connection. Some of this is more than likely my ignorance. My connection stuff goes something like this ... $db = mysql_connect("localhost", "stuff", "pw") or die("Could Not

[PHP-DB] mysql problem

Hello all! I am new to php and I am trying to update a mySQL table using php v4.2.3 for Windows. I am using the command: mysql_query("insert into tblquotehits (qoption,referer,browser,remoteaddr,dt) values ($quotetype,$referer,$browser,$remoteaddress,$currentdtstring)",$db); I have read the doc

[PHP-DB] Upgrading PHP

Hi-- I'm currently running 4.0.4pl1 on RedHat 7.0 and I want to upgrade to PHP 4.2.2is there anything special I have to do BEFORE or AFTER the install? Or is it just a straight re-install of PHP on top of the current Version? THANKS! Julio Cuz, Jr. [EMAIL PROTECTED] Inform

[PHP-DB] PHP + PostgreSQL

Hi, I am trying to configure a webserver running iplanet and php to connect to a postgresql server. My setup is the following: Web server: Solaris 2.6, iplanet 4.1, PHP 4.1 DB server: Linux 2.2.20 (debian woody), PostgreSQL 7.2.1. I have built PHP under Solaris with the configuration: ./config

[PHP-DB] Check Boxes

Hi-- Does anyone have any suggestions, SAMPLES, or ideas on how to STORE, RETRIEVE, AND PROCESS values for "Check Boxes" w/PHP & Postgresql? Thanks! Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscrib

[PHP-DB] Variables

//But so far, it only processes the value of $count alone, and it ignores $c //The line below should read like this: $c1 = $artist[0], next line: $c2 = $artist[1], etc. $c . $count+1 = $artist[$count]; } Help!!! Julio Cuz, Jr. Riversid

Re: [PHP-DB] Weird Windows SQL

To: "Michael K. Dolan Jr." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, April 24, 2002 7:55 PM Subject: RE: [PHP-DB] Weird Windows SQL > have you set up permissions for the user you are connecting as? > see GRANT in the MySql manual. The test bit is a def

[PHP-DB] Weird Windows SQL

Hi, I just installed MySQL on Windows XP. The winmysqladmin GUI only allows me to create databases that start with "test". So, I can create a database called "testmydata" but I cannot create a database named "mydata". This is driving me nuts. Any ideas? Thanks, Mike

[PHP-DB] dynamic sql

Rich, thanks. I got the dynamic sql to work (i had a syntax problem), now my problem is what's the most efficient way to loop it through all the form fields that are passed to the processor? This is my current sql statement which handles 1 field: $sql_update = "UPDATE md_users SET ".$formName."

[PHP-DB] dynamic sql

Is it possible to do a sort of dynamic sql. For instance, if I have a form with a bunch of field/data variables and I send them to a php processor, can I just create a loop to have it update all the fields without having to specify each field. In scratch code, I guess I'm looking for something

[PHP-DB] WebMail

Hi, I'm looking for a good web based email client (preferably easy to setup and done in PHP of course). We have a sendmail server that works great. I'm not sure how the webmail systems work though. Can I use a different Apache server or do I have to setup the PHP webmail on the actual mail serv

Re: [PHP-DB] Error in non existing line

//www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] SELECT statement

names and '"$find" is what the user entered when searching for a record. At 03:39 PM 4/4/2001 -0700, you wrote: >At 03:24 PM 4/4/2001 -0700, Julio Cuz, Jr. wrote: >>Every time I run the following code, I get this error if I use a NUMBER >>for the 'Email'

[PHP-DB] SELECT statement

"SELECT * FROM \"Remodel\" WHERE \"WO\" LIKE $find"; break; case "Email": $sql = "SELECT * FROM \"Remodel\" WHERE \"Email\" LIKE $find"; break; } -- Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] Validating forms

Hi-- I have a form that cannot have a specific field blank, so I would like to add a message box saying "fill out the x field," is there a way to do this WITHOUT having to refresh the page? Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing

[PHP-DB] Refresh

Hi-- I don't know if this is something PHP can solve, or if my database engine (Postgresql 7.03) needs to do something. Every time a user adds a new request, a new ID is generated, but SOMETIMES, when the same user adds several requests, one after another, the browser does NOT refresh and it

[PHP-DB] Error

Hi-- When I run the following code: if($myrow = pg_fetch_array($result,0)) { echo "ok..."; } else { die(include("../sqlerror.inc")); } I get this error message: "Warning: Unable to jump to row 0 on PostgreSQL result index 2 in /html/rccd/remodel/display.php on line 27" Please help

[PHP-DB] Money to double format?

Hi-- I have about 10 fields (in PGSQL) that have the MONEY format, when I edit a form they display as "$0.00" (for example), but when I do some math using those fields, PHP treats them as "$0.00" and NOT as 0.0, I've tried to use SETTYPE ($field, double), but all numbers get reset to 1. Any i

[PHP-DB] Evaluting T/F (3)

esult = pg_exec($db, $sql); $myrow = pg_fetch_array($result,0) or die(include("../sqlerror.inc")); ----- Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubsc

[PHP-DB] Evaluating T/F (2)

ID=$id"; $result = pg_exec($db, $sql) or die(include("../sqlerror.inc")); $myrow = pg_fetch_array($result,0) or die(include("../sqlerror.inc")); ----- Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] Evaluating T/F.

/sqlerror.inc")); $myrow = pg_fetch_array($result,0) or die(include("../sqlerror.inc")); ----- Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscr

[PHP-DB] CLEAR screen command

Hi-- Is there a CLEAR SCREEN command in PHP? Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail

[PHP-DB] Variables

there, including field 4 this time. Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL

[PHP-DB] Redirect command?

Hi-- I've been looking for a "redirect" command (basically redirect from page a to page b if something happens)... Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

[PHP-DB] SELECT problem (2)

" line to pass the value of "$campus" to the new loaded page. Help! Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] SELECT problem

Hi-- What's wrong with this line of code? echo(""); Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] delete a row by a column of type date

i have a mysql field called expired of type date in a table that holds the date that the record needs to be expired. what php code would i need to delete all records that if the date in the expire column for each row was older than current date. -- PHP Database Mailing List (http://www.php.n

[PHP-DB] Drop-down menu selection

t;); ?> $building: "); $cmlist = @pg_exec($db, "SELECT * FROM building_$campus") or die(include("../sqlerror.inc")); $i = 0; $x = pg_numrows($cmlist); while ($i < $x): $clist = pg_fetch_array($cmlist,$i); echo "".$clist["Building"].""; $i++; endwhile; echo(""); ?> = Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED]

[PHP-DB] delete records by a column with date

there is a column in a mysql database called expires that has type date and i was wondering what php code would be needed to delete all records that have dates that have expired something like delete from expires where curdate > expires; something like that. -- PHP Database Mailing List (ht

[PHP-DB] Lowercase problem

ercase, as well as field names...I had to transfer everything to lowercase to get it working. Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTEC

[PHP-DB] Freetds/ODBC/Openlinks?

Hi-- Bottom line: What's the most used way of talking to MSSQL from PHP 4? Freetds/ODBC/Openlinks/other? Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comman

[PHP-DB] Access 2000 to PostgreSQL

Hi-- Does anyone have a tutorial or sample commands on how to EXPORT data FROM MS ACCESS 2000 to POSTGRESQL? Thanks! Julio Cuz, Jr. Riverside Community College [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional