[PHP-DB] Escaped Apostrophes and Quotes

2001-02-15 Thread Rick Emery
My PHP output displays escaped apostrophes and quotes. Given the following example FORM and PHP3 script: index.html == HTML HEAD/HEAD BODY FORM method="post" action="http://www.somedomain.com/myscript.php3" Enter data: INPUT type="text" name="mydata"BR INPUT type="submit"

RE: [PHP-DB] Redirect command?

2001-02-22 Thread Rick Emery
header ("Location: http://www.php.net"); /* Redirect browser -Original Message- From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 22, 2001 4:23 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Redirect command? Hi-- I've been looking for a "redirect" command

RE: [PHP-DB] Can't connect to local MySQL server error

2001-02-26 Thread Rick Emery
I'm also having trouble connecting to the MySQL server. I can connect as root, but not as a user from the command line. When connect to the mysql server as ROOT, I've granted all privileges to the user using 'user@localhost' and 'user@"%" '. Still no luck. I'm using MySQL on Redhat Linux.

RE: [PHP-DB] Can't connect to local MySQL server error

2001-02-26 Thread Rick Emery
ct Manager "There is no 'trying'... There is only 'Do' or 'Not Do' " -Original Message- From: Brunner, Daniel [mailto:[EMAIL PROTECTED]] Sent: Monday, February 26, 2001 2:18 PM To: 'Rick Emery' Cc: '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] Can't connect to local MySQL server error Hello.

RE: [PHP-DB] array awry

2001-02-27 Thread Rick Emery
All, Perhaps I've misunderstood. I thought this IS a PHP list (see Rolf Hopkins below). Secondly, this list is not only for MySQL questions and issues (see Cal Evans below). It is for all database questions, as we've seen from uestins concerning other databases. Am I incorrect? Richard L.

RE: [PHP-DB] Can't connect to local MySQL server error

2001-02-28 Thread Rick Emery
and execute perms on the parent directories, the world cannot see the file to have read write and execute to the socket file. gl "Rick Emery" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... MySQL is running; I can execute MySQL as ROOT. The /var/li

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825 -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 12:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] php and mysql file insertion! Hi, I have a MySQL database that is

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
Yes. There's another tutorial on the site which addresses that question. rick -Original Message- From: Kevin Connolly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 1:39 PM To: Rick Emery Subject: Re: [PHP-DB] php and mysql file insertion! great thanks! Will I be able

RE: [PHP-DB] php and mysql file insertion!

2001-03-06 Thread Rick Emery
Yes, you can. But you still ahve to extract it and format it for display. The tutorial explains the ins and outs of the process. -Original Message- From: David Balatero [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 2:03 PM To: Rick Emery Cc: 'Kevin Connolly'; '[EMAIL

RE: [PHP-DB] About MySQL connections

2001-03-08 Thread Rick Emery
mysql_pconnect() opens a persistent connection, that is, one that remains open for the duration of you session. Therefore, you don't need to re-open it. Either that, or you can use mysql_connect() to open a non-persistent connection. -Original Message- From: Rosen [mailto:[EMAIL

RE: [PHP-DB] Using text files instead of a DB

2001-03-13 Thread Rick Emery
I use an ISP (http://intercession.net/specialoffers) who provides PHP and MySQL support on an Apache server (Cobalt Linux) for $5 per month...yes, $5 per month. No extra charges for either. $250 meg space. Full FTP. -Original Message- From: David W. Fenton [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] Using text files instead of a DB

2001-03-13 Thread Rick Emery
- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 8:39 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Using text files instead of a DB I use an ISP (http://intercession.net/specialoffers) who provides PHP and MySQL support on an Apache server (Cobalt

RE: [PHP-DB] Using text files instead of a DB

2001-03-13 Thread Rick Emery
, 2001 10:53 AM To: Rick Emery; '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Using text files instead of a DB so ... Virtual Web Site Hosting* 250 MB - $199.99/year one time setup fee. if i divide 199 by 12 i get 5 -Original Message- From: Rick Emery [mailto:[EMAIL

RE: [PHP-DB] PHP and MySQL

2001-03-14 Thread Rick Emery
Laurent, Show us the code/statements you are using. It is easier to help you that way. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 14, 2001 1:43 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MySQL Hi all, I have a few questions

RE: [PHP-DB] Javascript and PHP

2001-03-14 Thread Rick Emery
Assume in HTML file is: FORM name="myform" method="post" action="http://my_site.com/do_form.php3" INPUT type="text" name="text1" /FORM Then, in do_form.php3: ?php the_value = $text1; ? $text1 refers to the name of the field in the HTML form. This convention applies to all fields in the

RE: [PHP-DB] Login System with access levels

2001-03-16 Thread Rick Emery
First, I would NOT store passwords in a database. Rather, I'd store a hash based upon the password and username. Storing a password is dangerous as regards security. Second, if you're asking for syntax on how to add the security level column: ALTER TABLE mytable ADD access tinyint unsigned

RE: [PHP-DB] Call to undefined function: mysql_pconnect()

2001-04-10 Thread Rick Emery
I had this same problem. You require not only PHP and MySQL, but there is another RPM (if using RedHat) that links the two. I don't remember it off the top of my head, but it is entitle something like "php-mysql.rpm" or "mysql-php.rpm". -Original Message- From: Bruno [mailto:[EMAIL

RE: [PHP-DB] Photo Album Schema

2001-08-21 Thread Rick Emery
This has been done. see http://www.photopoint.com This is a free service available to the public. rick Richard Emery Excel Communications, Inc. IT Sr. Project Manager (972) 478-3398 (972) 944-0542 (pager) There is no trying... There is only Do or Not Do -Original Message- From:

RE: [PHP-DB] Photo Album Schema

2001-08-21 Thread Rick Emery
I would suggest that you do not store the photos in the database. Rather, store the directory/ file name where each photo is located on the weberver. This should decrease access speeds and reduce size of DB. have fun with this project. It sounds like a good start. Richard Emery Excel

RE: [PHP-DB] Photo Album Schema

2001-08-21 Thread Rick Emery
just do something like echo Img src=\$queryresult['location']\; Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Rick Emery [EMAIL PROTECTED] To: [EMAIL PROTECTED]; PHP-DB [EMAIL PROTECTED] Sent: Tuesday, August 21

RE: [PHP-DB] HS : translations

2001-08-21 Thread Rick Emery
If you post the English website site, then folks can look at it and send suggestions to you. rick Richard Emery Excel Communications, Inc. IT Sr. Project Manager (972) 478-3398 (972) 944-0542 (pager) There is no trying... There is only Do or Not Do -Original Message- From: tatare

RE: [PHP-DB] accents in mysql db?

2001-08-22 Thread Rick Emery
What do you mean when you say ...with accents out of the database, the charactes don't come out correctly? Can you show example of data in database and that which is output? Richard Emery Excel Communications, Inc. IT Sr. Project Manager (972) 478-3398 (972) 944-0542 (pager) There is no

RE: [PHP-DB] using A NAME ref

2001-08-22 Thread Rick Emery
The NAME indicator (#), must precede the data separator (?). I think what you want is: a href=\/members/members.php?$memltr=$memb\$member/a To use the NAME indicator, your line would read: a href=\/members/members.php#$memb?$memltr\$member/a which I doubt is what you want. Richard Emery

RE: [PHP-DB] What's the PHP function for clearing out the garbage code inside the variable?

2001-08-22 Thread Rick Emery
unset($variable); -Original Message- From: Scott Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 2:42 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] What's the PHP function for clearing out the garbage code inside the variable? Hi! When I receive the data from the

RE: [PHP-DB] It's just a logo..

2001-08-23 Thread Rick Emery
What's a spammer worth? Nothing. -Original Message- From: Wisam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 22, 2001 7:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] It's just a logo.. Do you know What's a logo worth: PRICELESS. Do you have a logo ? Do you have what it takes to

RE: [PHP-DB] listing

2001-08-23 Thread Rick Emery
Assuming you've opened a MySQL connection and stored connection in $connect: $query=SELECT * FROM mytable; $result = mysql_query($query,$connect) or die(ERROR); print TABLE; while( $row = mysql_fetch($result) { print TRTD.$row['field1'].TD.$row['field2'].TD.$row['field3']./TR ; } print

RE: [PHP-DB] listing

2001-08-23 Thread Rick Emery
: Thursday, August 23, 2001 11:51 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] listing Okay, but what if I want to use data from two tables not only from companies ? Assuming you've opened a MySQL connection and stored connection in $connect: $query=SELECT * FROM mytable

RE: [PHP-DB] Store Procedures

2001-08-23 Thread Rick Emery
no -Original Message- From: Francisco Carvalho [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 4:20 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Store Procedures Newbie question. I've been developing web application in IIS using ASP and Microsoft SQL Server 7.0. I use

RE: [PHP-DB] I am really stuck

2001-08-24 Thread Rick Emery
I don't believe anybody answered this, but here's an option: 1) Assumes table mytable has defined a field as: article_date date. The following will purge anything before today. $query = DELETE FROM mytable WHERE article_date .date(Y-m-d,time()); 2) $query = SELECT DISTINCT

RE: [PHP-DB] Getting SQL queries from existing DB

2001-08-27 Thread Rick Emery
Use mysqldump utility (see MySQL manual, section 14.5) shell mysqldump [OPTIONS] database [tables] ORmysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...] ORmysqldump [OPTIONS] --all-databases [OPTIONS] -Original Message- From: Andrey Hristov [mailto:[EMAIL

RE: [PHP-DB] go to another URL

2001-08-27 Thread Rick Emery
header(Location: http://new.url.com/index.html; ); exit; This MUST be executed BEFORE any other data/html are displayed. -Original Message- From: Andrius Jakutis [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 26, 2001 4:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] go to another URL

RE: [PHP-DB] Accessing fields with the same name in MySQL

2001-08-27 Thread Rick Emery
Since you're matching on id, why does it matter which table it came from? It came from both. Perhaps, I do not understand your question. rick -Original Message- From: Trevor Lanyon [mailto:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 1:13 PM To: [EMAIL PROTECTED] Subject: [PHP-DB]

RE: [PHP-DB] newbie - correct use of Grant in mysql

2001-08-28 Thread Rick Emery
use one account/password for all. Otherwise, when you write your PHP/ASP script, you'd have to have an mysql database open for each guest. MySQL should be able to handle the number of guests that you indicate. For each guest, store their username in the database and a MD5 hash of their

RE: [PHP-DB] Error in SQL syntax

2001-08-28 Thread Rick Emery
Have you tried typing this SELECT statement directly into MySQL? If not, try it; MySQL may indicate a more precise error. rick -Original Message- From: Alex V.Varavva [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 1:03 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Error in SQL

RE: [PHP-DB] query question

2001-08-28 Thread Rick Emery
What exactly are you trying to do? Do you want to delete certain rows from $result? Or delete ALL rows, in which you'd use: mysql_return_result($result); If you want to delete certain rows, you can't. You just have to make your selection criteria more precise. Then, fetch row by row to weed

RE: [PHP-DB] How to delete specific row in mysql table?

2001-08-28 Thread Rick Emery
Your statement is saying: if 3 is greater than 2, delete all Your WHERE criteria should be based upon a specific field's contents, NOT its position in a data base -Original Message- From: Jan Grafström [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 11:51 AM To: [EMAIL

RE: [PHP-DB] Warning: Page has Expired

2001-09-04 Thread Rick Emery
I consistently use the POST method when submitting a form to a PHP script. I seldom use GET. -Original Message- From: olinux o [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 1:34 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Warning: Page has Expired I have the same

RE: [PHP-DB] How can you hide database login passwd in your script?

2001-09-04 Thread Rick Emery
At $2400.00 per license, Zend Encoder is an expensive option -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 02, 2001 1:00 AM To: rbtree Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] How can you hide database login passwd in your script? An

RE: [PHP-DB] html generated web pages

2001-09-04 Thread Rick Emery
I don't understand the phrase html generated web pages. What are you trying to do? rick -Original Message- From: RSalomo [mailto:[EMAIL PROTECTED]] Sent: Monday, September 03, 2001 12:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] html generated web pages hello, how can i make html

RE: [PHP-DB] html generated web pages

2001-09-05 Thread Rick Emery
and page format)? sorry my english is not very good. rudy - Original Message - From: Rick Emery [EMAIL PROTECTED] Sent: Tuesday, September 04, 2001 21:57 I don't understand the phrase html generated web pages. What are you trying to do? rick -Original Message- From: RSalomo

RE: [PHP-DB] How can you hide database login passwd in your script?

2001-09-05 Thread Rick Emery
Another solution is DO NOT store passwords and usernames in the database file. Rather, store a hash of the password and username using the php MD5() function. Something like: $username = $HTTP_POST_VARS['user']; # from FORM page $password = $HTTP_POST_VARS['pw']; # from FORM page $hash =

RE: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-05 Thread Rick Emery
unset() simply deletes the pointer to the data without releasing the space held by the data. mysql_free_result() releases the data storage pointed-to by the $result pointer. This is important because $result could be pointing-to a dataspace containing a large number or rows returned by the

RE: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-06 Thread Rick Emery
You free-up the dataspace pointed-to by $string with unset(). PHP knows that this variable points-to character data or numeric or whatever. unset() then releases the dataspace held by the $string itself and erases its name from the symbol table. Using mysql_free_result($string) will not work

RE: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ?

2001-09-06 Thread Rick Emery
nope. see my previous reply -Original Message- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 06, 2001 10:11 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MYSQL/PHP what is the difference between unset() and mysql_free_result() ? And how can i free the

RE: [PHP-DB] Checkboxes with mySQL

2001-09-07 Thread Rick Emery
You have to check each checkbox value in you selection criteria. Somthing like: $query = UPDATE articles SET pr=1 WHERE 0; # assume $nbr is size of array $p for($i=0; $i$nbr;$i++) { if( isset($p[$i]) ) { $query .= || id=$p[$i] ; } This will construct a query that looks like: UPDATE

RE: [PHP-DB] Grant statement

2001-09-10 Thread Rick Emery
yes, you do. Set-up a generic account, with password, for all users. Then use it in the mysql_connect() statement. You need to set-up this account only once; not when accessing the database each time. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September

RE: [PHP-DB] does MySql needs driver

2001-09-10 Thread Rick Emery
what did you try to do? Need specifics. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] does MySql needs driver i didn't use a driver just inserted data directly throw phpmyadmin. do i need a

RE: [PHP-DB] how to enter cgi-bin folder?

2001-09-10 Thread Rick Emery
What does ypur site tree look like? -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 6:51 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] how to enter cgi-bin folder? i want to access the file: test.php and its located in cgi-bin folder. and my

RE: [PHP-DB] Parsing of db results by PHP

2001-09-10 Thread Rick Emery
use this PHP function: eval() As quoted from the PHP manual: eval() evaluates the string given in code_str as PHP code. Among other things, this can be useful for storing code in a database text field for later execution Further info is in the manual under the Miscellaneous Functions chapter

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-10 Thread Rick Emery
$myarray=explode(,,$DCD['fieldname']); In the above, substitute fieldname for the name of the field which contains name1,name2,name3,name4,... Then, cycle through each $myarray element as you've done below. -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent:

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-10 Thread Rick Emery
$myarray=explode(,,$DCD['DCD_Access']); Then, cycle through each $myarray element as you've done below. -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 2:55 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] reading arrays within a field from

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-10 Thread Rick Emery
3:30 PM To: Rick Emery Subject: Re: [PHP-DB] reading arrays within a field from mysql and separating the values Rick, I tried it and it made no difference. Could you give me a more complete example? Thanks for the help. Robert - Original Message - From: Rick Emery [EMAIL PROTECTED

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-10 Thread Rick Emery
, September 10, 2001 3:53 PM To: Rick Emery Subject: Re: [PHP-DB] reading arrays within a field from mysql and separating the values The same as my original message. - Original Message - From: Rick Emery [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 3

RE: [PHP-DB] reading arrays within a field from mysql and separating the values

2001-09-11 Thread Rick Emery
option value='$val'$val/option\n; } -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:45 PM To: Rick Emery Subject: Re: [PHP-DB] reading arrays within a field from mysql and separating the values NASA, BBCI I want to separate

RE: [PHP-DB] access my cgi-bin

2001-09-11 Thread Rick Emery
yeah, that should have worked. FORM method=post action =../cgi-bin/test.php -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 3:19 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] access my cgi-bin here is my folders tree: (i'm on windows)

RE: [PHP-DB] CHAR(0) retrival

2001-09-13 Thread Rick Emery
CHAR(0) allocates no space to the variable, ther than house-keeping space. Why are you dong that? You say you can SELECT but cannot retrieve. SELECTing is retrieving. Please elaborate. -Original Message- From: Krishnakumar S [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001

RE: [PHP-DB] Table display Driving me Crazy!

2001-09-13 Thread Rick Emery
What does you mysql table look like? What does your SELECT statements look like? What does function p() do? What does function f() do? Need more info -Original Message- From: Adv. Systems Design [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 11:09 AM To: PHP List

RE: [PHP-DB] eregi and ereg??

2001-09-14 Thread Rick Emery
You cannot specify multiple strings. However, you CAN concatenate strings and perform ereg()/eregi(): if( eregi(x, $string1.$string2.$string3, $regs ) -Original Message- From: Jason Caldwell [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 12:14 AM To: [EMAIL PROTECTED]

[PHP-DB] Student Suspended Over Suspected Use of PHP

2001-09-14 Thread Rick Emery
http://www.bbspot.com/News/2000/6/php_suspend.html -- 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] string problem

2001-09-14 Thread Rick Emery
Don't know why you're getting problem. However, you can use stripslashes() to avoid the problem. -Original Message- From: Bruno Franx [mailto:[EMAIL PROTECTED]] Sent: Friday, September 14, 2001 10:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] string problem scenario: Win.nt 4.0 pach6a

RE: [PHP-DB] Another Image prob

2001-09-14 Thread Rick Emery
The consensus is that it is best if you DO NOT store the images as blobs in a database. Rather, store the images in separate files and store the names of those files in the database. Then retrieve the file names for the database, open the image files, and then send the images to the client's

RE: [PHP-DB] Re: NEWBIE - Needs Assistance with Joins

2001-09-17 Thread Rick Emery
SELECT artist_name, album_title FROM album_titles LEFT JOIN artist USING(aid) WHERE artist_id = aid -Original Message- From: Michael Egan [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 8:22 AM To: [EMAIL PROTECTED]; Cecily Walker Kidd Subject: [PHP-DB] Re: NEWBIE - Needs

RE: [PHP-DB] Quotes, double-quotes, and the like.

2001-09-17 Thread Rick Emery
If the essays will be long, I'd suggest storing them in separate files and storing the file name for each essay in the MySQL database. -Original Message- From: Ari M. Roth [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 3:15 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Quotes,

RE: [PHP-DB] Cookies ???

2001-09-17 Thread Rick Emery
Q1. If you simply wish to READ the cookie from each web page, you need do nothing. It is created atuomatically as a variable for you. For instance, a cookie named mycookie is available as $mycookie. Q2. The Cookie Path is the reference point on the web server. I creates a context for the

RE: [PHP-DB] Help Please! Complex AND OR LIKE queries MySQL/PHP

2001-09-18 Thread Rick Emery
Just use PHP's string searching functions. I had a similar situation where I was inserting user-provided data into a MySQL database. I searched for MySQL bad words that I didn't want a hacker to insert into queries, such as DELETE, ADD, INSERT, MODIFY, etc. to prevent mischief. FYI, you can

RE: [PHP-DB] problemhandling form variables

2001-09-18 Thread Rick Emery
When you printed the string $imgupload, what were its contents? -Original Message- From: Todd Moy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 12:40 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] problemhandling form variables I have an upload field on a form that is

RE: [PHP-DB] Renaming a database name...

2001-09-19 Thread Rick Emery
There is no command to do so. Have you tried simply renaming the files and sub-directory where the database files are located? I've not tried that. -Original Message- From: Arief Fajar Nursyamsu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 5:05 PM To: PHP-DB Subject:

RE: [PHP-DB] Cookies ???

2001-09-19 Thread Rick Emery
He's not trying to set multiple cookies...only one. -Original Message- From: Mark Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 18, 2001 4:01 PM To: Rick Emery; 'Jason Caldwell'; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Cookies ??? instead of setting multiple cookies, why

RE: [PHP-DB] Query construction

2001-09-19 Thread Rick Emery
When you printed-out the string variable containing the SELECT statement, what did it look like? -Original Message- From: Russ Michell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:01 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Query construction Hi there: Further to

RE: [PHP-DB] uploading and stuff

2001-09-19 Thread Rick Emery
Did you look at Chapter 19 of the PHP manual? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 8:54 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] uploading and stuff Hello there... I want to upload textfiles and store them in my

RE: [PHP-DB] uploading

2001-09-19 Thread Rick Emery
PHP manual, chapter 19 -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 8:27 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] uploading i want the user to upload files to server when i worked offline i used to write: $updir =

RE: RE: [PHP-DB] Query construction

2001-09-19 Thread Rick Emery
To: Rick Emery Cc: [EMAIL PROTECTED] Subject: Re: RE: [PHP-DB] Query construction If you mean did the pattern I'm trying to match: $team, contain what I though it should: 'footballSat' then yes it did. I also receieve no error message from MySQl The string in the table field I can view/alter

RE: RE: RE: [PHP-DB] Query construction

2001-09-19 Thread Rick Emery
To: Rick Emery Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: [PHP-DB] Query construction I'm sorry but I must be missing something fundamental here. This is how my code looks, and if the SQL query yields nothing and emits no error (as it currently is) it simply reverts to error.php: $sql = SELECT * FROM

RE: [PHP-DB] Query construction

2001-09-19 Thread Rick Emery
YES!!! Exactly Russ...do what Steve syas... -Original Message- From: Steve Cayford [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:32 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query construction Usually what I do when I'm having this

RE: RE: [PHP-DB] Query construction

2001-09-19 Thread Rick Emery
:[EMAIL PROTECTED]] Sent: Wednesday, September 19, 2001 9:56 AM To: Rick Emery Cc: [EMAIL PROTECTED] Subject: Re: RE: [PHP-DB] Query construction Ok ok ok!! Thank you both for the pointers, they did of course yield the problem - as bloody always it's something completely different! As my old-dad

RE: [PHP-DB] Re: log out

2001-09-19 Thread Rick Emery
the header() function MUST be sent prior to any other output. Otherwise, it will fail. What else in the page precedes the header()? - On 9/12/01 5:54 AM, in article [EMAIL PROTECTED], Its Me [EMAIL PROTECTED] wrote: ?php session_start();

RE: [PHP-DB] MySQL Query Weirdness

2001-09-21 Thread Rick Emery
easier solution: while ($line = mysql_fetch_array($result)) { print \ttr\n\t\ttd.$line['first_name'].\n\t/tr\n; } -Original Message- From: Steve Cayford [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 20, 2001 5:16 PM To: Chris S. Cc: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] How to do this with PHP

2001-09-21 Thread Rick Emery
SELECT * FROM mytable LIMIT 0,5 SELECT * FROM mytable LIMIT 6,5 SELECT * FROM mytable LIMIT 11,5 SELECT * FROM mytable LIMIT 16,5 -Original Message- From: Alawi Albaity [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 1:44 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to do

RE: [PHP-DB] Grant statement

2001-09-24 Thread Rick Emery
no, if all you wan the user to do is to read/write data -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 5:03 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Grant statement GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON

RE: [PHP-DB] Re: mysql_fetch_array() doesn't work

2001-09-25 Thread Rick Emery
I agree with Steve. Also, print value of $num; is it 0? Is $res valid; is it NULL? We need far more details than what you think we need. -Original Message- From: Steve Brett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 6:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB]

RE: [PHP-DB] warning/error

2001-09-25 Thread Rick Emery
show us code -Original Message- From: Wild ! [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 3:01 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] warning/error I get the following error: Warning: Supplied argument is not a valid MySQL result resource in

RE: [PHP-DB] how do I update fields in a mysql database with php?

2001-09-26 Thread Rick Emery
Wht is the error message you get? What does the table look like? what does the preceding code loo like? show us code!!! show us output!!! -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:10 AM To: [EMAIL PROTECTED] Subject:

RE: [PHP-DB] Huw do I perform update? I missed the accual code bit.. sorry

2001-09-26 Thread Rick Emery
What does table look like? What does preceding code look like? What error message are you getting? Try printing the value of $query. What does it look like? Copy/paste that into mysql directly; what error do you get? -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]]

RE: [PHP-DB] More info..

2001-09-26 Thread Rick Emery
try executing the query string directly in the mysql command line. What happens? -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 11:53 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] More info.. Hi. I get no error, it works fine. I get

RE: [PHP-DB] Update... more info

2001-09-26 Thread Rick Emery
are you saying the table is updated properly? -Original Message- From: Tommy Nilsson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 26, 2001 12:04 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Update... more info If i put the code into mysql directly it says it works nicely, so the

RE: [PHP-DB] mysql_fetch_array() doesn't work

2001-09-27 Thread Rick Emery
change coding to (note, each line is enclosed in quotes and ends withn .): $query=select user_id, user_name, time, status, comment from users. where sign=1. order by user_name. limit $offset, $step; print $query; //sanity check...contents of $query $res=mysql_query($query) or

RE: [PHP-DB] create data array

2001-09-27 Thread Rick Emery
the following assumes you've opened database. $query = SELECT TextVal,Val1,Val2,Val3 FROM mytable WHERE some_condition; $result = mysql_query($query) or die(mysql_error()); $mycmd = \$data_array = array (; while( $row = mysql_fetch_array($result) ) { $mycmd .=

RE: [PHP-DB] Hellllp DBF

2001-09-27 Thread Rick Emery
sounds like database manipulation was not compiled into PHP when it was installed on your server. -Original Message- From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 8:25 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Hep DBF I need HELP, I can´t

RE: [PHP-DB] attach file

2001-09-27 Thread Rick Emery
Follow this link which describes how to create attachments for email: http://www.phpbuilder.com/columns/kartic2807.php3 Use these techniques after retrieving the data from the database to be formed into an attachment -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL

RE: [PHP-DB] Hellllp DBF

2001-09-27 Thread Rick Emery
]] Sent: Thursday, September 27, 2001 8:39 AM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Hep DBF Who I do ? - Original Message - From: Rick Emery [EMAIL PROTECTED] To: 'Marcelo Ramos Souza' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 10:27 AM

RE: [PHP-DB] Hellllp DBF

2001-09-27 Thread Rick Emery
if phpdbase.dll is disabled, then you can't use dbase_open() -Original Message- From: Marcelo Ramos Souza [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 27, 2001 8:55 AM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Hep DBF Using PHP 4 installed and the phpdbase.dll

RE: [PHP-DB] Free PHP/MySQL webhosting

2001-10-02 Thread Rick Emery
start here: http://www.freewebspace.net/ -Original Message- From: Francisco Carvalho [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:11 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Free PHP/MySQL webhosting Is there a free web hosting services that support PHP and MySQL?

RE: [PHP-DB] Howto make a double LEFT JOIN

2001-10-02 Thread Rick Emery
Remove the parentheses SELECT table1.id FROM table1 LEFT JOIN table2 LEFT JOIN table3 ON table2.id=table3.id ON table1.id=table2.id -Original Message- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 3:00 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Howto make a

RE: [PHP-DB] Howto make a double LEFT JOIN

2001-10-02 Thread Rick Emery
SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id LEFT JOIN table3 ON table2.id=table3.id -Original Message- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 3:13 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Howto make a double

RE: [PHP-DB] Howto make a double LEFT JOIN

2001-10-02 Thread Rick Emery
please show the REAL output from your query and what it should REALLY look like -Original Message- From: Bas Jobsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 3:38 PM To: Rick Emery; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Howto make a double LEFT JOIN SELECT table1.id

RE: [PHP-DB] mysql - php DATE QUESTION...

2001-10-03 Thread Rick Emery
Check the MySQL manual DATE/TIME functions. try: DELETE FROM mytable WHERE date_column ( CURRDATE()-30 ) -Original Message- From: Koutsogiannopoulos Karolos [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 7:41 AM To: 'Php-Db (E-mail) Subject: [PHP-DB] mysql - php DATE

RE: [PHP-DB] mysql - php DATE QUESTION...

2001-10-03 Thread Rick Emery
sorry for misspelling: curdate() -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 8:23 AM To: 'Koutsogiannopoulos Karolos' Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql - php DATE QUESTION... Check the MySQL manual DATE/TIME

[PHP-DB] RE: CGI Urgent

2001-10-03 Thread Rick Emery
I apologize for answering a day late, but I get only the digest version of this list. If you can use PHP instead of PERL, the following article will point you in the right direction. If you cannot use PHP, this article should provide you with the background knowledge you need to send the

RE: [PHP-DB] Check Boxes/UPDATE

2001-10-03 Thread Rick Emery
for( $i=0; $i3; $i++ ) { if( isset($chkAuthStatus[$i]) ) { do something } } -Original Message- From: Matt C [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 10:17 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Check

RE: [PHP-DB] Cybercash? or Who?

2001-10-03 Thread Rick Emery
www.cardservice.com -Original Message- From: Raquel Rice [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 1:29 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Cybercash? or Who? On Wed, 3 Oct 2001 09:49:20 -0600 Ricky Theil [EMAIL PROTECTED] wrote: I just recently

  1   2   3   4   >