RE: [PHP-DB] Database abuse help needed

made it through totally unscathed. Spam containing ads for all known s3xual enhancement products are delivered to my doorstop every day. Kinda makes the point that you'll never trap even a fraction of the offensive content given the immense creativity of the human mind. Doug

[PHP-DB] Re: mysql_fix_privilege_tables error

In article [EMAIL PROTECTED], [EMAIL PROTECTED] (Carson Au) wrote: Hi Guys, I am a newbie and having a lot of trouble with PHP/MySQL lately... We have a number of PHP/MYSQL solutions developed on our server and I have the pleasure to maintain them... The copy of MySQL 3.23 has started

Re: [PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

On 6/22/05, Doug Hernandez [EMAIL PROTECTED] wrote: I can't help but wonder why you're using the line_order field at all. Can't you nix it and count the number of records with each order# as a stored procedure or some such? It would make your entire order system easier. Also, you may think

Re: [PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

the order_line. Or maybe I can bother you to give me more info about it? It's hard to judge without being closer to the situation. Peace, Doug On 6/22/05, Doug Hernandez [EMAIL PROTECTED] wrote: On 6/22/05, Doug Hernandez [EMAIL PROTECTED] wrote: I can't help but wonder why you're using the line_order

[PHP-DB] mysql_connect() with a multi-file format

I'm new to PHP, due to having been all hard-nosed and obtuse about using Perl/CGI. I've been looking for a good way to pick up php tricks and what-nots, so I joined the list. That said, I have an immediate question. I have a multi-file script: main.php requires_once config.php, and so on. I'd

[PHP-DB] RE: Looking for help.

in the right direction. HTH Doug -Original Message- From: John R. Sims, Jr. [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 12:31 PM To: php-db@lists.php.net Subject: Looking for help. I need help. I am building a database for a collaborative non-profit organization. Originally

RE: [PHP-DB] Aggregate MySQL functions in html table via php - having problems

...$myrow['avg(RawData)'], $myrow['std(RawData)']... returns an error (listed below) What am I not seeing here? Thanks for your reply. Doug -Original Message- From: Juffermans, Jos [mailto:[EMAIL PROTECTED] Sent: Monday, May 02, 2005 10:10 AM To: php-db@lists.php.net Subject: RE: [PHP

[PHP-DB] Aggregate MySQL functions in html table via php - having problems

- am I wrong here???). I have a working method so I am in good shape, I'm just trying to learn other ways to get the same result. Any tips or pointers are appreciated. Doug /// Query for STATISTICAL data / $sql = SELECT RunID, ItemSN, RawDataDesc

[PHP-DB] OCI ignoring NLS_DATE_FORMAT parameter

, and the PEAR DB Oracle driver uses the oci calls. Version info: Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production PHP 4.3.4 Apache 1.3.29 Anyone have any ideas or suggestions on why I'm seeing this problem? Thanks, Doug -- PHP Database Mailing List (http://www.php.net

[PHP-DB] DB Connect with SCALA script

the results. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dynamic data manipulation in form

the ability to be able to highlight the text and click on a paragraph tag and it automatically insert that tag - or a bold, itallic, underline, etc. I have searched the web but came up empty-handed. Any ideas? I don't even know where to begin. thanks, Doug -- PHP Database Mailing List (http

Re: [PHP-DB] Given only one mySQL user account by Host Company

to. Doug Shay wrote: My hosting company gave me one database and one root user account, and I have no access for priviliges at all. So as far as I can tell, the only way for me to connect to the database on my site is to do a mysql_connect(host, user, pass), where the user and pass are the ones

Re: [PHP-DB] Given only one mySQL user account by Host Company

you have a business model that calls for that. In which case, refer to my first comment in my original reply. I have a question about what you said Doug: Use INCLUDEs for the login portions of the script(s) and place them in a protected directory. If you are unable to protect directories

Re: [PHP-DB] Given only one mySQL user account by Host Company

error message: Error Code : 1044 Access denied for user: '[EMAIL PROTECTED]' to database 'mysql' Shay is in the same boat as user test. Doug Bastien Koert wrote: Another thought on this: Even though you don't have access via phpmyadmin to get to the users table, could you try to create users

Re: [PHP-DB] Integrating Interbase.so and PHP

=107118069802473w=4 Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: MySQL version issue

I isn't my intention to start a peeing contest, but if *you* get rid of the chip and actually read the manual excerpt, the equivalent SQL statements it cites are very definitely available in mysql 3.xx.xx. DT Mark Benson wrote: Doug, read my e-mail again, specifically the second and third

Re: [PHP-DB] MySQL version issue

try to avoid using the ON DUPLICATE KEY clause on tables with multiple UNIQUE keys. Or, you might find a more interesting answer on a MySQL list. Doug Mark Benson wrote: As some of you will recall, I enquired on this list about versions of MySQL and PHP a while back regarding and issue wit using

Re: [PHP-DB] List Active??

Dave, The list has been very active with many posts per day all week. Based on your domain, you might check with the sysops and see if they've done any updating to firewalls and/or corporate filters. Good luck, Doug [EMAIL PROTECTED] wrote: Just testing the list mail server as I haven't received

Re: [PHP-DB] select particular columns in query

The manual is your friend. You cannot execute the SQL statement you provided because mysql specifically disallows it: http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html Same reference, your presumption about auto-increment columns is also wrong. Doug blackwater dev wrote: Hello, I want

Re: [PHP-DB] searching an entry in inventory db

Aravalli Sai wrote: hi i had designed an inventory management system where in i can ADD,INSERT,DELETE,UPDATE the data elements..but when i am trying to find(search) an entry in theinventory data base system (i want to find the entrybased on the tagno since this is the primary key in my table)

Re: [PHP-DB] php newsletter with mysql data

at http://hotscripts.com/PHP/Scripts_and_Programs/index.html They have several hundred scripts listed, some free - some not, that can help you complete your project quickly. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Cisco UBR interface with PHP

enable mode access to run this function and two, I would fear creating a security loophole by running an enabled function all of the time. Can I get your thoughts on this? thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] timestamp problem

I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not going well. In reading up on it, I see that the idea is to convert the Timestamp type to Unix format using the strtotime() function, then using the date() function to format that result. However, this only appears to work

Re: [PHP-DB] timestamp problem

, DATE_FORMAT('%m %d %Y', projects.Date2) AS Date2,... etc any other suggestions? John Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Doug Parker wrote: I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not going well. In reading up on it, I see

Re: [PHP-DB] MySQL problem..

ian wrote: Any body met this error? Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /usr/local/apache2/html/poems/browse.php on line 15 http://dev.mysql.com/doc/mysql/en/Old_client.html -- PHP Database Mailing List

Re: [PHP-DB] Problems with mysql_num-rows()

=password('.$password.') Good luck, Doug Arne Essa Madsen wrote: I have the following problem: This one does not work: $query = SELECT * from user where name='$userid' and pass=password('$password'); $result = mysql_query($query, $link); $num_rows = mysql_num_rows($result); I get this error

Re: [PHP-DB] parse error in php backend sqlite

); ? /body /html i would appreciate if you can help me in correcting this error.. thanks in advance.. sai Your braces don't match up. The problem starts at the ELSE statement in line 33. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MultSelect ListBox hell!

LocationState = 'Alabama' OR LocationState='California' . Doug Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] where can I post some mysql related questions?

Mike wrote: hi, I've currently been looking for a mysql news server where I could post some questions on mysql database design (cause they shurely wouldn't fit here) and I have yet to find one. Can anyone help? http://lists.mysql.com/ -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] mysql results with limit

SQL_CALC_FOUND_ROWS as it works somewhat differently, and probably faster, than the approach you suggest above. This function was introduced in mysql 4.0.0. http://dev.mysql.com/doc/mysql/en/Information_functions.html Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Q

[EMAIL PROTECTED] wrote: Dear Friends, Data in the table is displayed by php query. .Say column A, in which name of company will be stored. Now i want to add another column B to table in which web addresse will be stored against each name in Column B.and same should be displayed in an html

Re: [PHP-DB] MySQL denying access to...everything

[EMAIL PROTECTED] wrote: I finally got my PHP5 installation to support MySQL and now this. When I try to edit anything on mysqlgui.exe, it just gives me this error: error in database function: access denied for user @localhost... I don't know if this has to do with my php installation or what.

Re: [PHP-DB] Php if statement in a form

if (is_null($row[timeout]).) [EMAIL PROTECTED] wrote: Still no joy. The parse error actually refers to the -- if ($row[timeout] IS NULL); --- line. -Original Message- From: Eric Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 11:32 AM To: [EMAIL PROTECTED] Subject: Re:

Re: [PHP-DB] Case sensitive search

/doc/mysql/en/Case_Sensitivity_Operators.html Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Getting a result from MAX() query

ORDER BY fee_recd DESC LIMIT 1,$connectup)or die (Query failed:br$latestbrError: . mysql_error()); Louise Here's a concept: RTM In MySQL versions prior to Version 3.22.5, you can use MAX() instead of GREATEST. What does your inquiry have to do with PHP? Doug -- PHP Database Mailing List (http

Re: [PHP-DB] supernoob strikes again

() to test for this condition. Doug Finished product at http://www.dibcomputers.com/new-dibcomputers/index.php.txt if anyone wants to steal it... D -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PostgreSQL lib and character case

Tumurbaatar S. wrote: I use pg_fetch_array() to get a record content. But it seems that to access elements of the returned associative array, I should use lowercase field names. Is there any way to use case-insensitive field names? Assuming you want all lower case, convert the form field entry

Re: [PHP-DB] Handling missing rows on joins

to a different one. Any suggestions for handling this better would be appreciated ... TIA Rene Maybe I haven't had enough coffee, yet, but my first inclination is to suggest adding a user_status flag to hf_users. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Can't access HTTP Post Array

[EMAIL PROTECTED] wrote: I'm running Apache/2.0.49 and PHP/4.3.5 on windows XP with MSIE 6.0. -- local host. When I try to access the variables in the array (HTTP POST), they are empty or null. Did I miss a PHP or Apache setting in the php.ini or httpd.conf? Use$_POST['array_element'] Doug

Re: spam: [PHP-DB] php, mysql security question

JeRRy wrote: Hi, I have a php, mysql security question. You know how there is a way to enable/disable hot linking to your images via CPanel to allow/disallow people to link to your images from an external site? Well is there a way to allow/disable external sites connecting to a mysql via

[Fwd: Re: [PHP-DB] php, mysql security question]

Oops. For some reason my filter concluded your email was spam and it modifies the subject line. I missed cleaning the subject line on the first reply. Here is is again in case others filter on that keyword. I apologize for the double post and possible confusion. \Doug JeRRy wrote: Hi, I

Re: [PHP-DB] Strange problem with mySQL

and some other error checking in there and quit tearing out your hair over assumptions that may be wrong. Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] tick mark `

Craig: I don't see a reply to your question in today's posts. Backticks or tick marks allow you to use reserved words for column names. Interval is a reserved word. Hope you weren't waiting this long for a response. Doug Thompson Craig Hoffman wrote: Why is it when I have this ` tick mark

[PHP-DB] Stuck on basic concept, how to use a list selection?

I want to: Populate a dropdown list with values from a MySQL db (done and working). Use the selected value as the 'where' clause in a second query. Return the results and display them to the user. Any pointers are appreciated - noob^3 (html, mysql, and php). Doug Code that I'm using: html body

Re: [PHP-DB] Pulldown value not passed to next page

Hi Karen, Depending upon the method used for your form, you should be able to find the value in either $_GET['pagesize'] or $_POST['pagesize']. hth, Doug Karen Resplendo wrote: What is wrong with this picture? I build a pulldown for selecting page size(number of rows in one page). If page

Re: [PHP-DB] How to calculate size of INT(x) field

(for example, INT(4)). /quote There is much more about how INT(x) works, but if I copied it all to here you wouldn't discover the other useful information available. Doug On Fri, 5 Mar 2004 11:29:03 +, Richard Davey wrote: Hi all, Sorry for such a newbie question! But I have been digging

Re: [PHP-DB] Re: How to calculate size of INT(x) field

the number of digits that will be displayed for values whose width exceeds that specified for the column. ... http://www.mysql.com/documentation/mysql/bychapter/manual_Column_types.html#Numeric_types Pay particular attention to the second and third sentences in the excerpt above. Doug Best

Re: [PHP-DB] Password encryption

). Neither does anyone else who hacks in. hth, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Password encryption

information than you want. Doug On Thu, 4 Mar 2004 15:35:52 -0500, Kevin wrote: Hi Doug and All, I am real new to PHP and wanted to know if you can explain the [md5(password);] code? Is this a set function? Thanks, Kevin - Original Message - On Thu, 04 Mar 2004 12:46:51 -0600, Mignon

Re: [PHP-DB] MySql PHP API

a cut-and-paste copy of the portion of the code that isn't working and all error messages being returned by the system. Finally, please don't cross port to several lists at once. Regards, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySql PHP API

I'm confused. I replied to your inquiry to tell you what information you need to provide if you are to receive help.. Why are you asking me questions about *your* problem? And keep the discussion on the list. Doug Mike Ni wrote: Do you know for certain whether it is a matter

Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)

the above process and it is very reliable and repeatable. hth, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Q

On Sun, 22 Feb 2004 11:02:29 EST, [EMAIL PROTECTED] wrote: Dear friends, I have pap4, mysql, apache installed. How do I enable to access /$_SERVER[PHP_SELF]/ .Comments, please Correct your syntax errors: \$_SERVER['PHP_SELF']\ Doug -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: php/mysql weblog - addnews function problems

= INSERT INTO news ; $query .= VALUES('',$id,'.$_POST['postdate'].',; $query .= '.$_POST['title'].',; $query .= '.$_POST['newstext'].'); You should also add some db error checking and reporting, then you wouldn't get the erroneous success message. hth, Doug -- PHP

[PHP-DB] Selecting between using letters

How would I create a select statement in MySQL that would return a range of records from the LastName field where the value starts with a designated letter - for example, returning the range where the first letter of LastName is between A and E... Any help would be greatly appreciated.

[PHP-DB] query problem

I'm having a problem with a specific query. SELECT DISTINCT(contents_.company_id), companies.* FROM contents_, companies WHERE contents_.Products LIKE '%heating%' OR contents_.Manufacturer LIKE '%heating%' AND contents_.company_id = companies.id The query works fine without the OR segment, for

RE: [PHP-DB] odbc

I solved my problem (here). IBM came out with new drivers and they sovled the problem. THanks -Original Message- From: Simpson, Doug Sent: Monday, September 29, 2003 11:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] odbc I am trying to connect to an AS/400 from a Linux box running RH9

[PHP-DB] odbc

error: [unixODBC][IBM][iSeries Access ODBC Driver][DB2 UDB], SQL state S1000 in SQLExecDirect in /var/www/htdocs/odbcquery.php on line 15 Does anyone know why I am getting this? Thank you for your time Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] To slash or not to slash....

these in the SQL_STRING as it falls down there then! Somebody must have come across this before, any help much appreciated. Cheers Craig Try using the built-in functions addslashes() and stripslashes(). Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] % operator

The % is called the Modulus operator. It is very briefly explained in the PHP manual in table 11-2. In your example, $mod = $a % $b == $mod = 0.8 It is a very easy operator to use. Doug On Tue, 12 Aug 2003 11:04:39 +0200, Alain Barthélemy wrote: Hello, If you have $a = 24; $b = 5

Re: [PHP-DB] % operator

One day I'll learn to wait until two cups of coffee before attempting to post replies. On top of which, I have no idea where 0.8 came from. 8-/ Sorry for the confusion factor. Doug On Tue, 12 Aug 2003 10:47:21 +0100, Phil Driscoll wrote: On Tuesday 12 August 2003 10:39 am, Phil Driscoll

Re: [PHP-DB] query works fine on console but not with PHP - why?

OR there was an error returned by the query. It's all in the manual. Doug On Sun, 3 Aug 2003 09:59:42 -0400, Aaron Wolski wrote: Hi guys, I have the following query which returns FINE through the console but not in PHP select t.id, t.colour, t.colourID, t.price, t.type, g.thread_index, g.groupNameUrl FROM

Re: [PHP-DB] Regular Expressions? URGENT

Try one of these: http://zez.org/article/articleprint/11 http://www.javaworld.com/javaworld/jw-07-2001/jw-0713-regex_p.html Doug On Fri, 1 Aug 2003 11:34:16 -0400, Aaron Wolski wrote: Hi All, Sorry for OT post but need some info. Does anyone know a good tutorial that explains regular

Re: [PHP-DB] MySQL full text search

Full text searches only work against fulltext indexes. http://www.mysql.com/doc/en/Fulltext_Search.html This isn't a PHP issue. Doug On Fri, 18 Jul 2003 09:42:17 +0200, Angelo Zanetti wrote: Hi I have a table which contains 3 fields (ID, Title, Abstract) the title and abstract fields have

[PHP-DB] redirection checking

I am compiling latest PHP4 and get a warning telling me that I am about to compile without redirection checking. Should I be concerned about this? If so, what flag should I use in the config to alleviate this? DF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] generating sequence without AUTO_INCREMENT

Maybe it's because I'm not fully awake yet that the problem seems less complex than it is. What is wrong with using a seperate table for each year? Doug On Thu, 26 Jun 2003 08:43:17 +0200, anders thoresson wrote: Hi, I'm working on a web based article planning system for a news paper, based

[PHP-DB] latest version of php only cgi?

Is the newest version of php 4 only available as a cgi-based program? DF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Rand() Emulation

An incredible interpretation of quote If called without the optional min, max arguments rand() returns a pseudo-random value between 0 and RAND_MAX. If you want a random number between 5 and 15 (inclusive), for example, use rand (5, 15). /quote Doug On Tue, 24 Jun 2003 11:14:55 -0400

Re: [PHP-DB] connect to db with php?

connecting from the same machine. It doesn't hurt, but it may add confusion at some future point in your troubleshooting. 3. All of this is really mysql specific and you would do better using that list, too. Doug On Sun, 22 Jun 2003 00:45:12 +1000, David wrote: Warning - beginner :-) I'm new

Re: [PHP-DB] PHP Install conflicts w/ MySQL

Check that mysql is still the owner of its subdirectories. You might also look on the mysql list for other possibilities as this is a frequent topic. Doug On 17 Jun 2003 10:02:29 +0800, Ramil G. Sagum wrote: On Tue, 2003-06-17 at 03:08, Nathan wrote: # ./bin/mysqld_safe Starting mysqld

Re: [PHP-DB] Adding MySQL support to PHP - libmysqlclient.so version problem

rpm. end quote Doug On Sun, 15 Jun 2003 23:38:31 -0400, Jack Orenstein wrote: I need MySQL support from PHP to support the HORDE/IMP webmail package. I just installed RedHat 9, and this included PHP 4.2.2-17. According to the PHP test.php page, MySQL support was configured: --with-mysql

Re: [PHP-DB] Adding MySQL support to PHP - libmysqlclient.so version problem

So look a little farther down the list and try the RPM for RH9.0. On Mon, 16 Jun 2003 00:05:19 -0400, Jack Orenstein wrote: Doug Thompson wrote: This is in the archives, but it was faster to find it in my stack of saved stuff: quote For those who installed RH 8.0 and went threw the same php

Re: [PHP-DB] Select statement drops 10th digit during table lookup?

the dotted-quad representation of a network address as a string, returns an integer that represents the numeric value of the address. Addresses may be 4 or 8 byte addresses: mysql SELECT INET_ATON(209.207.224.40); - 3520061480 end quote Doug On Fri, 13 Jun 2003 10:19:32 +0100, Ronan

Re: [PHP-DB] HELP, Still not be able to connect to MySQL

Your IP users have no permissions. (Hint: N = No) How is this a PHP problem? (Hint: It is all over the mysql list archives.) Doug On Thu, 12 Jun 2003 13:35:21 +0300, nabil wrote: GUYS help me please. 1- mysql server in on my own machine.. 2- my machine IP is 192.168.0.1 3- when i tired

RE: [PHP-DB] Can't do anything with variables

. The revision needs to be nothing more than a series of statements near the beginning of a page to initialize the local variables to the global array values. For example, $searchtype = $_POST['searchtype']; ... etc. ... Then the rest of your script(s) should work as written. Enjoy, Doug

Re: [PHP-DB] Re: [PHP] mysl_connect question

The access denied message you are seeing is usually the result of either an incorrect password or username, but you don't give enough information to allow guessing beyond that. Are you certain your script is submitting the expected values? Doug On Sat, 05 Apr 2003 21:54:33 -0600, [EMAIL

Re: [PHP-DB] multiple connections to MySQL in a single script example

are using multiple servers, you will require a connection to each with unique resource link_identifiers. Then you will have to include the desired resource link_id in each call to mysql_select_db(). There is no need to close and re-open connections between each use. Doug On Sat, 29 Mar 2003 19

Re: [PHP-DB] Re: sorting results in PHP

by zipcode from a database I have at hand. Mysql Version 4.0.1a select last_name, zipcode from mytable where last_name like sm% group by last_name, zipcode order by last_name, zipcode; You could simplify your life by combining your y,m,d fields into a single DATE type, too. Doug On Tue, 18 Mar

Re: [PHP-DB] retrieve last n records

OK, I would like to do it with the method you suggested. However, I'm having a few problems. Firstly, I can't seem to figure out how to sort rows returned from mysql_fetch_array. sort() or any other array function won't work because each row is an array, and I need to sort by the column.

[PHP-DB] Converting Dates...

colums into this type. Any help would be GREATLY appreciated! Thanks, Doug Coning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Confusing Date...

for April 2nd, 2003. The field is set to to send as a date: GetSQLValueString($HTTP_POST_VARS['Sch_StartDate'], date) So how do I send dates to MySQL so that it stores it correctly? Thank you!! Confused, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Random not working?

This recent thread from the mysql list explains a lot about the problem. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:15034 hth, Doug On Sat, 1 Mar 2003 12:24:57 +0100, Frank Keessen wrote: Hi All, I'm trying to get a random record each time this script runs; Only it's giving me everytime

Re: [PHP-DB]

Nikos: The mysql.sock file is created by mysqld when it is running. The error you report is very common and you will find troubleshooting tips at: http://www.mysql.com/doc/en/Can_not_connect_to_server.html Doug On Tue, 18 Feb 2003 10:18:42 +0200, nikos wrote: GlacierHi List I run mysql 3,23

Re: [PHP-DB] Question about replacing large textfields

http://www.hotscripts.com/PHP/ One example: http://www.hotscripts.com/Detailed/9026.html Good luck, Doug On Fri, 14 Feb 2003 16:09:34 +0100, Ingen, Wart van wrote: Hi there, I'm looking for a way to let people without any knowledge of coding replace large fields of text and images

Re: [PHP-DB] sorting values

Merlin: You might find it easiest to CREATE a temporary table. You can use an INSERT .. SELECT query to extract the values from your data tables and insert them in the temp table. Then you can SELECT from the temporary table and use all of the SQL functions for ordering, grouping, etc. Doug

Re: [PHP-DB] question about access

were running security at your site, I would closely monitor that client's activities on the system assuming that's how you are set up. That is a loose cannon out there. Doug On Mon, 10 Feb 2003 10:29:18 -0600, Terry Romine wrote: I'd like to get some opinions from the list. We run php/mysql

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

Try getting the results from the query like the following. Doug // generate and execute query $query = select * from changelog where changedBy = '$changedBy' or vendorNumber = '$vendorNumber' or oldName like '$oldName' or newName like '$newName' or newVendorNumber = '$newVendorNumber'; $result

Re: [PHP-DB] Remnant data from previous queries when using mysql_fetch_array...

On Thu, 06 Feb 2003 10:33:23 -0700, Doug Thompson wrote: Try getting the results from the query like the following. -snip- With the correct syntax. 8-( Doh! // $numrows = mysql_num_rows ($result); ^ -- PHP Database Mailing List (http

Re: [PHP-DB] update

. Doug On Thu, 30 Jan 2003 13:34:41 -0500, Ike Austin wrote: Hello, Newbie question. And can the same SQL portion of the code be written something like... query= UPDATE taablename SET (username, email, location) VALUEs( $username, $email, $location); Any reason why this Update command would

Re: [PHP-DB] Secure variable transport (newbie)

Here is a link to a tutorial which explains the issues and introduces how to use the new global variables. Write Secure Scripts with PHP 4.2! http://www.webmasterbase.com/article/758 Regards, Doug On Thu, 23 Jan 2003 00:30:24 +0100, Karina S wrote: Hi, I have read, that use global variables

Re: [PHP-DB] db connect probs

., inside the double quotes. hth, Doug On Tue, 14 Jan 2003 22:08:11 -0600, Addison Ellis wrote: hello, do you have any idea why the following(line 106)would return the following error message ? the login.php has an included form to create an account and that is what will not connect

[PHP-DB] export query

I need to essentially take a query and make it into a table. I'll first settle for the ability to export the query into a text file, somehow delimited. Can anyone help me with this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] If select query doesn't net any results

... if ($result) { while ($row... ... } $result will be 0 (false) if nothing satisfies the query. Any other comparison is just extra typing with no improvement in logic. Regards, Doug On Thu, 09 Jan 2003 13:06:51 -0500, Michael Cortes wrote: I am a programming novice

[PHP-DB] join query/relational database question

I have a relational database issue that I'll simplify for the sake of this post. I have one table, called clients, that has an id and the company name. For example: id | company --- 46 Jones Inc. 54 Baker Inc. etc. I have another table called projects, that looks

RE: [PHP-DB] php variables to JS

to display a large image after clicking on a thumbnail. The principle is the same regardless what you want to pass to the scripts. Hope there is some inspiration here. Regards, Doug On Sun, 5 Jan 2003 09:35:04 -0500, Rich Hutchins wrote: From what I have learned PHP and JS don't talk directly

Re: [PHP-DB] php and mysql on RH8.0

Manual for Post-installation Setup and Testing http://www.mysql.com/doc/en/Post-installation.html hth, Doug On Sun, 29 Dec 2002 16:46:38 +0100 (CET), franco stridella wrote: Hi, i apologize in advance for my stupid question. I installed RedHat8.0 with built in apache 2 and php 4.2.2

[PHP-DB] Upload Images...

the fields. 2) allow the user to upload new images to replace current images and then update the image name in the image column. Is this best served as 1 page or is it better to break this down into a page to upload images and a separate page to edit the content? Thank you. Doug -- PHP

Re: [PHP-DB] Upload Images...

Yes, but do you know where I can find a sample of merging the upload script with the Update script? Thanks!!! Doug - Original Message - From: Boaz Yahav [EMAIL PROTECTED] To: Doug Coning [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, December 27, 2002 1:09 PM Subject: RE: [PHP-DB

Re: [PHP-DB] PHP and MySQL

to the improved security properties. Here is a good article to explain what's going on and point you to even more info: Title: Coding PHP with Register Variables OFF http://www.zend.com/zend/art/art-sweat4.php hth, Doug On Wed, 25 Dec 2002 13:22:20 +0100, JabMaster wrote: Hello, I have created

Re: [PHP-DB] Checking if number is in bottom three?

DISTINCT num FROM myfile ORDER BY num LIMIT 3; which will return 1,2,4 I hope this answers your question. Merry Christmas, Doug On Mon, 23 Dec 2002 11:13:31 -0500, Leif K-Brooks wrote: I need a way to check if a number is in the bottom three of a column in my database. For example, if I had

  1   2   >