Re: [PHP] ADV SQL Help Needed.

2003-01-21 Thread Rick Emery
SELECT risk_level, COUNT(*) FROM mytable GROUP BY risk_level; - Original Message - From: [-^-!-%- [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 21, 2003 6:06 AM Subject: [PHP] ADV SQL Help Needed. Hello everyone, I need help with the following query. I have a table

Re: [PHP] Read Mysql Access

2003-01-21 Thread Rick Emery
what did you find with a google search? - Original Message - From: Karl James To: php Sent: Monday, January 20, 2003 7:01 PM Subject: [PHP] Read Mysql Access Is there a free ware program that will, allow me to take mysql dbase and convert it to ms ascess?

Re: [PHP] simple date question

2003-01-20 Thread Rick Emery
Why not just get the month with another call to date(m) as well? Then call date(W) to get the week, if that's required? - Original Message - From: adrian [EMAIL PROTECTED] [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 20, 2003 8:42 AM Subject: [PHP] simple date question

Re: [PHP] $HTTP_GET_VARS

2003-01-17 Thread Rick Emery
Show us your code - Original Message - From: Mike Tuller [EMAIL PROTECTED] To: php mailing list [EMAIL PROTECTED] Sent: Friday, January 17, 2003 4:05 PM Subject: [PHP] $HTTP_GET_VARS I am following an example in a book and have run into a problem with a script that I am trying to run

Fw: [PHP] Number Sign in String Variables

2003-01-17 Thread Rick Emery
I have data that have #, so that is not the problem. Show us more code AND your database structure. - Original Message - From: Joab Ben Stieglitz [EMAIL PROTECTED] To: Sent: Friday, January 17, 2003 2:25 PM Subject: [PHP] Number Sign in String Variables I have a MySQL database that

Re: [PHP] Display Dates in English o_O

2003-01-16 Thread Rick Emery
look at mysql's DATE_FORMAT() Let mysql do it for you, instead of PHP - Original Message - From: Stephen To: PHP List Sent: Thursday, January 16, 2003 7:16 PM Subject: [PHP] Display Dates in English o_O I have a PHP driven site that as a time schedule. Since the site isn't exactly

Re: [PHP] Question about $_GET

2003-01-15 Thread Rick Emery
Make life easy for yourself: $query = SELECT Newsheadline, News, Contact FROM news WHERE Newsid = .$_GET['id']; - Original Message - From: Frank Keessen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 15, 2003 4:50 AM Subject: [PHP] Question about $_GET Hi All, Can you

Re: [PHP] dynamic variables in a while loop?

2003-01-15 Thread Rick Emery
for($ii=1; $ii20; $ii++) { $helpz = help$ii; if(${$helpz} == yes) { } else { } } - Original Message - From: Philipp Hartmann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 15, 2003 6:50 AM Subject: [PHP] dynamic variables in a while loop? Hi

Re: [PHP] sending array

2003-01-15 Thread Rick Emery
show us the test1.php code. show us the test2.php code. We can't read your mind. - Original Message - From: Danielle van Gladbach [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 15, 2003 6:59 AM Subject: [PHP] sending array Hi, I am trying to send an array from one php

Re: [PHP] Persistent global data ?

2003-01-14 Thread Rick Emery
cookies? - Original Message - From: Mathias Rockel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 7:33 AM Subject: [PHP] Persistent global data ? Hi all ! I am currently writing some kind of Document/File-Library in a LAMP environment. As the library should

Re: [PHP] Persistent global data ?

2003-01-14 Thread Rick Emery
access to stuff that is not meant to be seen ... no cookies =). thanks anyway ! mathias rockel - Original Message - From: Rick Emery [EMAIL PROTECTED] To: Mathias Rockel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 3:06 PM Subject: Re: [PHP] Persistent global data

Re: [PHP] data move, Please Help..

2003-01-14 Thread Rick Emery
try GOOGLE: access mysql php conversion I did - Original Message - From: Edward Peloke [EMAIL PROTECTED] To: PHP general list [EMAIL PROTECTED] Sent: Tuesday, January 14, 2003 8:48 AM Subject: [PHP] data move, Please Help.. Ok, I know I have asked this question before and I have asked

Fw: [PHP] attach image with the mail command?

2003-01-14 Thread Rick Emery
this class will do all the work you need: instantiate with CMIMEMail() then attach with attachfile() add body with makebody() send with send() = /* * Notes from [EMAIL PROTECTED] 25 Mar 2000: * This library based idea of Dan Potter * Improvements: Multi attachmends in

Re: [PHP] Error in variable when looping

2003-01-13 Thread Rick Emery
so where is $rowe set? Show us code that calls this page - Original Message - From: menezesd [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 6:21 PM Subject: [PHP] Error in variable when looping Hello friends, I have made the following table of data and a button

Re: [PHP] forms

2003-01-13 Thread Rick Emery
Do you mean like two SUBMIT buttons? Yes. - Original Message - From: cj [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 7:32 PM Subject: [PHP] forms G'day All Just a quick question This is really a html more than a php question. Is it possible to have two

Re: [PHP] forms

2003-01-13 Thread Rick Emery
in HTML form: FORM method=post action=myscript.php . . . INPUT type=submit name=submita value=Do This INPUT type=submit name=submitb value=Do That /FORM in myscript.php: if(ISSET($HTTP_POST_VARS['submita'])) { } if ISSET(($HTTP_POST_VARS['submitb'])) { } - Original Message - From: cj

Re: [PHP] increment numbers...

2003-01-13 Thread Rick Emery
$num = sprintf(%05d,$num); - Original Message - From: Senani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 13, 2003 10:21 PM Subject: [PHP] increment numbers... HI all, I need help on incrementing numbers starting with a 0 or more on php-4.2.3.

Fw: [PHP] What means ioctl

2003-01-12 Thread Rick Emery
ioctl is an IO controls structure. Just look at the fopen(,r). Do you notice anything missing? - Original Message - From: [EMAIL PROTECTED] To: Sent: Sunday, January 12, 2003 3:59 PM Subject: [PHP] What means ioctl I got the error-message: Warning: fopen(, r) - Inappropriate ioctl

Re: [PHP] building web album - design questions

2003-01-09 Thread Rick Emery
1. Store images separately with pointers in the database. It permits faster database queries. 2. 3. int imagecopyresized ( resource dst_im, resource src_im, int dstX, int dstY, int srcX, int srcY, int dstW, int dstH, int srcW, int srcH) - Original Message - From: Anders Thoresson

Re: [PHP] How can I redirect to another php page

2003-01-08 Thread Rick Emery
header(location: nextpage.php); the above must be sent before any other text is output - Original Message - From: Teo Petralia [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 08, 2003 2:46 PM Subject: [PHP] How can I redirect to another php page Hi All! I would like

Fw: [PHP] Img src

2003-01-07 Thread Rick Emery
the problem is the before the width word it should be \ - Original Message - From: Ezequiel Sapoznik [EMAIL PROTECTED] To: Sent: Tuesday, January 07, 2003 7:30 PM Subject: [PHP] Img src I am having a parse error in the following sentence: print img src=\ . $row[foto] .

Re: [PHP] help - WHILE in FOREACH

2003-01-07 Thread Rick Emery
Is this your exact code? I ask, because the following should generate a parse error: echo option value = ''/option; You have 3 double-quotes (). - Original Message - From: James Brennan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 07, 2003 7:29 PM Subject: [PHP] help

Fw: [PHP] time stamp screwing up

2003-01-06 Thread Rick Emery
show us your database table structure (the whole thing). the NOW() will always work with a date or timestamp field - Original Message - From: - [ Paul Ferrie ] - [EMAIL PROTECTED] To: Sent: Monday, January 06, 2003 11:28 AM Subject: Re: [PHP] time stamp screwing up Well i am still

Re: [PHP] Mysql update problems

2003-01-05 Thread Rick Emery
what appeared when you printed the text of your query: $query = update bloggers set cache='$blog', title='$title' where url='$address'; print $query; I'm thinking that your single quotes preventd $blog, $title, $address form being expanded. - Original Message - From: Jesse Lawrence

Re: [PHP] Mysql update problems

2003-01-05 Thread Rick Emery
] To: [EMAIL PROTECTED] Sent: Sunday, January 05, 2003 11:50 AM Subject: Re: [PHP] Mysql update problems No, the query is working fine... all variables are printing correctly. This is what has me confused. Everything seems to be as it should, it's just not updating the db table. Rick Emery wrote: what

Fw: [PHP] Unexpected $end error?

2003-01-05 Thread Rick Emery
When you get an error that points to /HTML, it means you did not close a {} or In this case, you did not close the: if ($row = mysql_fetch_array($result)) { Although you did close the while do {} immediately thereafter. - Original Message - From: Vincent Bouret [EMAIL PROTECTED] To:

Re: [PHP] Recommend payment processors?

2003-01-03 Thread Rick Emery
I use PayPal. Does not require a merchant account. PHP payment interface and interaction is easy to implement. Via HTML in your webpage, you pass to PayPal the URL of the PHP script to be executed when a payment is received. - Original Message - From: Chad Day [EMAIL PROTECTED] To:

Re: [PHP] Still executing afte die()?

2003-01-03 Thread Rick Emery
You'll never get to the die() statement, because you redirected with the header() statement. - Original Message - From: Leif K-Brooks [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 03, 2003 6:14 PM Subject: [PHP] Still executing afte die()? I have a page called 404.php

Re: [PHP] Warning: 1 is not a valid File-Handle resource - HELP!

2002-12-29 Thread Rick Emery
The last line cannot be producing the warning; it does not refer to a file. Please show us the EXACT error message. Are you certain the file was opened? Did you try to print $stuff after reading it? Did it have the info you thought it should? - Original Message - From: Phil Powell

Re: [PHP] Populating textboxes and listboxes from a query result of a database table

2002-12-26 Thread Rick Emery
Text box: print INPUT type=text name=myname value=\$data_value\\n; List box: print SELECT name=myselect\n; while($row = mysql_fetch_array($result)) { extract($row); print OPTION value=\$data_value\$data_title/OPTION\n; } print /SELECT\n; - Original Message - From: Denis L. Menezes

Re: [PHP] Cheap Hosting

2002-12-26 Thread Rick Emery
www.nomonthlyfees.com $200 first year, $70 per year thereafter. I put all my clients with this service. rick People will forget what you said. People will forget what you did. But people will never forget how you made them feel. - Original Message - From: Stephen To: PHP List Sent:

Re: [PHP] how to specify dimensions of opened window?

2002-12-23 Thread Rick Emery
Can't do this with PHP, which is server-side. You can, however, use PHP to generate JavaScript that will set the window parameters when executed. - Original Message - From: Jody Cleveland [EMAIL PROTECTED] To: Php-General (E-mail) [EMAIL PROTECTED] Sent: Monday, December 23, 2002 8:19 AM

Re: [PHP] how to specify dimensions of opened window?

2002-12-23 Thread Rick Emery
Use PHP print/echo statements to create the JavaScript code, just as you would HTML code. - Original Message - From: Jody Cleveland [EMAIL PROTECTED] To: 'Rick Emery' [EMAIL PROTECTED]; Php-General (E-mail) [EMAIL PROTECTED] Sent: Monday, December 23, 2002 8:41 AM Subject: RE: [PHP] how

Re: [PHP] how to specify dimensions of opened window?

2002-12-23 Thread Rick Emery
Do you know JavaScript? If not, start there. print open(\url\,\window_name\,\width=400,height=300menubar=no,status=no\); - Original Message - From: Jody Cleveland [EMAIL PROTECTED] To: 'Rick Emery' [EMAIL PROTECTED]; Php-General (E-mail) [EMAIL PROTECTED] Sent: Monday, December 23, 2002

Re: [PHP] MySQL vs PostgreSQL

2002-12-23 Thread Rick Emery
You accidentally published this to the wrong email list. I assume you meant to send this to the MySQL email list. - Original Message - From: Miro Kralovic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 23, 2002 9:10 AM Subject: [PHP] MySQL vs PostgreSQL Hi, I'm just

Re: [PHP] Forms

2002-12-23 Thread Rick Emery
For my Linux (RedHat 7.1), it's at /etc/php.ini - Original Message - From: Vicente Valero [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 23, 2002 10:25 AM Subject: [PHP] Forms I'm having problems using variables from a html form. I've been reading, and it seems that I

Re: [PHP] calendar solution for workgroups ???

2002-12-23 Thread Rick Emery
Another good PHP/mySQL calendar application. Group scheduling, etc. Does not have extraneous things such as web-mail. Cost is $35 http://abledesign.com/demo/calendar/ rick People will forget what you said. People will forget what you did. But people will never forget how you made them feel.

Re: [PHP] Are there macros in PHP?

2002-12-23 Thread Rick Emery
What happened when you experimented with this code? You did try, right? - Original Message - From: Don [EMAIL PROTECTED] To: php list [EMAIL PROTECTED] Sent: Monday, December 23, 2002 11:57 AM Subject: [PHP] Are there macros in PHP? Hi, I need to search a MySQL table based on a

Re: [PHP] Email problems.

2002-12-22 Thread Rick Emery
This is not realy a PHP question; rather, it is an OutLook question. Regardless...when you opened the OutLook window to create your mail, did you go to the Menu-Format and select Rich Text (HTML) - Original Message - From: Steve Jackson [EMAIL PROTECTED] To: Php-General [EMAIL PROTECTED]

Re: [PHP] login

2002-12-20 Thread Rick Emery
Do you mean loggged-in in the current browser session? If that, then cookies are good. If you mean EVER ogged in, then you'll want to look at a database, perhaps, mySQL. - Original Message - From: Edward Peloke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:20

Re: [PHP] Re: mail()

2002-12-20 Thread Rick Emery
Actually, you don't need to send this as an html A hyperlink. Simply using: http:\\www.aircharterunited.com\pages\activate_account.php?clientid=$uname Should work; it does for me. - Original Message - From: Edward Peloke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December

Re: [PHP] Re: mail()

2002-12-20 Thread Rick Emery
that should be: http://www.aircharterunited.com\pages\activate_account.php?clientid=$uname (Grrr...that's what I get for using copy/paste from original email) - Original Message - From: Rick Emery [EMAIL PROTECTED] To: Edward Peloke [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday

Re: [PHP] Problem with functions

2002-12-20 Thread Rick Emery
Please show a bit more of the actual code - Original Message - From: Beauford.2002 [EMAIL PROTECTED] To: PHP General [EMAIL PROTECTED] Sent: Friday, December 20, 2002 9:55 AM Subject: [PHP] Problem with functions Hi, I keep getting errors in my script that says 'x' function is

Re: [PHP] Regex Help

2002-12-19 Thread Rick Emery
addslashes() - Original Message - From: Jim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 11:26 AM Subject: [PHP] Regex Help Could someone show me how to use preg_replace to change this: test OPTION VALUE=testtest/OPTION test into: anotherword OPTION

Re: [PHP] Regex Help

2002-12-19 Thread Rick Emery
=testtest/OPTION anotherword Note that what I want to accomplish is to change 'test' into 'anotherword' only if it is not within the option tag. Thanks! - Original Message - From: Rick Emery [EMAIL PROTECTED] To: Jim [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 12:42 PM

Re: [PHP] date part

2002-12-19 Thread Rick Emery
Following on to the L T: $ar = explode(/,$thestring); thenL $ar[0] = 06 $ar[1] = 07 $ar[2] = 200 - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: 'Diana Castillo' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 11:56 AM Subject: RE: [PHP] date part

Fw: [PHP] case statement?

2002-12-19 Thread Rick Emery
switch() { case a: case b: case c: default: } RTFM - Original Message - From: Max Clark [EMAIL PROTECTED] To: Sent: Thursday, December 19, 2002 12:19 PM Subject: [PHP] case statement? Hi- I was wondering if php had a case function? Instead of building a large if/elseif/else

Re: [PHP] Regex Help

2002-12-19 Thread Rick Emery
for helping. Unfortunately, that doesn't quite accomplish the task either. The other example for my first post would be mangled with that. - Original Message - From: Rick Emery [EMAIL PROTECTED] To: Jim [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 1:09 PM

Re: [PHP] Question about the exit() command

2002-12-19 Thread Rick Emery
What do you mean return to the calling page? The exit() command simply ceases processing of PHP and HTML. I believe what you're saying is that if the user clicks on a PHP hyperlink on the first page, then goes to another page. If there is something wrong there, you nwant to return to the page

Re: [PHP] Another problem with conditional statements

2002-12-19 Thread Rick Emery
switch() does not work that way. Switch uses the value in the parentheses and selects a CASE based upon that value. Read the manual. You will have to use a series of if()-elseif()-else() - Original Message - From: Beauford.2002 [EMAIL PROTECTED] To: PHP General [EMAIL PROTECTED] Sent:

Re: [PHP] Date Formatting

2002-12-13 Thread Rick Emery
MYSQL will do all the formatting that you need. Look up sect 6.3.4, Date and Time Functions in mysql manual. Look at the DATE_FORMAT(date,format) command - Original Message - From: Clint Tredway [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 11:55 AM Subject:

Re: [PHP] Free MySQL Hosting...again

2002-12-12 Thread Rick Emery
The page would not display for me. It did, however send the following HTML. Please note that the ?PHPSESSID is not enclosed in ? ? delimiters. Also, PHPSESSID needs to be $PHPSESSID. Could that be the problem? Finally, dump the FRAMES. htmlheadtitleFree MySQL Hosting/titlemeta

Re: [PHP] Question Regarding Cookies, Sent Headers, and Functions That Return Values

2002-12-11 Thread Rick Emery
PROTECTED] To: Rick Emery [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:54 AM Subject: Re: [PHP] Question Regarding Cookies, Sent Headers, and Functions That Return Values Here is the code in a readable form (alterations for security, simplicity ...) if ((stristr

Fw: [PHP] Add column to table

2002-12-11 Thread Rick Emery
First, you've asked the wron list; ask the mysql list Second: ALTER mytable ADD COLUMN new column INT UNSIGNED AFTER old_column; - Original Message - From: Shaun [EMAIL PROTECTED] To: Sent: Wednesday, December 11, 2002 8:25 AM Subject: [PHP] Add column to table Hi, please could

Fw: [PHP] upload image

2002-12-11 Thread Rick Emery
If it is a GIF file, the header format is: Byte # 0 - 2 GIF 3 - 5 87a or 89a 6 - 7 Width (in pixels) 8 - 9 Height (in pixels) Be advised, the dimensions are in reverse major order; that is, 50 pixels is represented as 32 00 - Original Message - From: Shaun [EMAIL PROTECTED] To:

Fw: [PHP] Help please: Unable to get $_POST[variable]; to work in a form.

2002-12-10 Thread Rick Emery
Try $_POST['name'] and $_POST['age'] Try $HTTP_POST_VARS['name'] and $HTTP_POST_VARS['age'] - Original Message - From: David Scott [EMAIL PROTECTED] To: Sent: Tuesday, December 10, 2002 10:56 AM Subject: [PHP] Help please: Unable to get $_POST[variable]; to work in a form. I am going

Fw: [PHP] Re: Help please: Unable to get $_POST[variable]; to work in a form.

2002-12-10 Thread Rick Emery
What version of PHP are you using? I believe that anything earlier than 4.05 does not support $_POST. Did you try $HTTP_POST_VARS['name']? This will work, regardless of version. - Original Message - From: David Scott [EMAIL PROTECTED] To: Sent: Tuesday, December 10, 2002 12:54 PM

Re: [PHP] Re: Help please: Unable to get $_POST[variable]; to work in a form.

2002-12-10 Thread Rick Emery
First, please respond to the list, not me. Second, I'm not asking the question, David Scott is. Third, I don't use either; I use ' ' - Original Message - From: Victor [EMAIL PROTECTED] To: 'Rick Emery' [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:49 PM Subject: RE: [PHP] Re

Re: [PHP] Question Regarding Cookies, Sent Headers, and Functions That Return Values

2002-12-10 Thread Rick Emery
Hey Aggie, Show us the rst of the code. stristr() should not be a problem. Chances are there's a blank line elsewhere that's being sent. - Original Message - From: KANM MD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 2:34 PM Subject: [PHP] Question Regarding

Re: [PHP] Post Problem

2002-11-18 Thread Rick Emery
No, he's saying that: echo $sqn; displays SQN=4. it should say simply 4 - Original Message - From: BigDog [EMAIL PROTECTED] To: Dave J. Hala Jr. [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 18, 2002 4:33 AM Subject: Re: [PHP] Post Problem That is what you should be

Re: [PHP] attachement

2002-11-10 Thread Rick Emery
Here is a PHP mail class that handles multiple attachments and several other functions: ?php /* * Notes from [EMAIL PROTECTED] 25 Mar 2000: * This library based idea of Dan Potter * Improvements: Multi attachmends in one e-mail, ability to post html plain trext, up to 3x speed improved. *

Re: [PHP] Help me learn! with an explanation of these two functions.

2002-11-05 Thread Rick Emery
$orderid WILL NOT contain all the rows. mysql_fetch_array() returns only one row each time it is called. Upon fetching last row, it returns NULL/FALSE/0. Therefore, as you fetch each row, you will then execute your second function to pull all the data for that particular order number.

Fw: [PHP] PHP/MySql Array problem (newbie)

2002-11-05 Thread Rick Emery
show us your code...we can't read your mind - Original Message - From: alex koppie [EMAIL PROTECTED] To: Sent: Monday, November 04, 2002 4:58 AM Subject: [PHP] PHP/MySql Array problem (newbie) Hi there, I am trying to send an array to a database and visualize it again. Alltough this

Re: [PHP] addslashes/stripslashes

2002-11-05 Thread Rick Emery
what happens when you type: Select * from tblContacts, tblCountries WHERE (tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE '%o\'mallies%' ) at the mysql command line? - Original Message - From: Paul Dionne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday,

Re: [PHP] arrays

2002-11-05 Thread Rick Emery
If I understand your question, you are trying to store values into an array: for( $=0; $i5; $i++) { ...get $picture from somewhere... $mypics[] = $picture; } To retrieve: foreach($mypics as $pic) { ...do something with $pic... } - Original Message - From: Edward Peloke [EMAIL

Re: [PHP] Using info from a MySQL Query

2002-11-05 Thread Rick Emery
$sql =SELECT company, name, email FROM $table_name WHERE email = '$_POST[email]' AND password = password('$_POST[password]'); $result = mysql_query($sql) or die(Error: $sqlBR.mysql_error()); extract(mysql_fetch_row($result)); print $company $mail; rick People will forget what you said.

Re: [PHP] Executing the value of a variable

2002-11-02 Thread Rick Emery
eval() - Original Message - From: Jackson Miller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 02, 2002 7:02 AM Subject: [PHP] Executing the value of a variable I would like to store some code in a database and load/execute that code based on a query. Is it possible

Fw: [PHP] Can't store info on a mysql database...

2002-11-01 Thread Rick Emery
$md = MD5($passwdtxt); $sql=INSERT INTO users (login,passwd) VALUES (\$logintxt\, \$md\); mysql_query($sql) or die(mysql_error()); next time, show the error messages you got. Also, ALWAYS USE mysql_error() when executing mysql_query() -- see above = Mr.

[PHP] File Random Access

2002-10-30 Thread Rick Emery
I never noticed before...there is no easy way to perform random-access read and WRITE on a file. I vote/recommend/suggest that this most basic functionality be added to the next release of PHP. This would not be an enhancement; rather, it is correcting a serious flaw. Or am I missing

Re: [PHP] write on the begin of a file

2002-10-30 Thread Rick Emery
Mike Ford had the answer: $fp = fopen(test, r+); - Original Message - From: Marek Kilimajer [EMAIL PROTECTED] To: PHP [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 6:28 AM Subject: Re: [PHP] write on the begin of a file There is no insert in fputs, you need to make a new file and

Re: [PHP] File Random Access

2002-10-30 Thread Rick Emery
You are correct. In fact, simply r+ works; I just tried it. Thanks - Original Message - From: Ford, Mike [LSS] [EMAIL PROTECTED] To: 'Rick Emery' [EMAIL PROTECTED]; PHP [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 8:05 AM Subject: RE: [PHP] File Random Access -Original

Re: [PHP] Mutiple header statements?

2002-10-30 Thread Rick Emery
? if ($_POST['var'] == this) { header(Location: scipt1.php); exit;} if ($_POST['var'] == that) { header(Location: script2.php); exit; } ? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 6:25 AM Subject: [PHP] Mutiple header

Re: [PHP] array question

2002-10-30 Thread Rick Emery
What happened when you tried both methods? - Original Message - From: John Meyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 10:29 AM Subject: [PHP] array question When retrieving an array from $_POST, which is the right way: $arrInterests =

Re: [PHP] array question

2002-10-30 Thread Rick Emery
What does you HTML look like? - Original Message - From: John Meyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 10:36 AM Subject: RE: [PHP] array question Either way, I'm not getting the interests. -Original Message- From: Rick Emery [mailto:remery

Re: [PHP] HTML Post

2002-10-30 Thread Rick Emery
On return, just cut out the part you don't need; PHP's string functions take care of this nicely - Original Message - From: Drew Kime [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 12:22 PM Subject: Re: [PHP] HTML Post I used a similar script and had the same

Re: [PHP] Multiple Addresses Mailer

2002-10-30 Thread Rick Emery
Put all addressees in the BCC?? - Original Message - From: Pushpinder Singh Garcha [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 30, 2002 1:47 PM Subject: [PHP] Multiple Addresses Mailer Hi All I am creating a mailing list system in which I should be able to

Re: [PHP] Php web hosting

2002-10-30 Thread Rick Emery
www.nomonthlyfees.com 600 megs space 6 gig bandwidth 5 mysql databases unlimited email addresses ssl ssh $200 for first year; $70 per year thereafter. Fee includes domain registration Fast tech support turnaround - Original Message - From: Steve Jackson [EMAIL PROTECTED] To:

Fw: [PHP] php form mail - checkbox problem

2002-10-29 Thread Rick Emery
What is $medlemskap[]??? You MUST refer to item_1[]. Also, I believe you REALLY meant that all values be accessed through an array; therefore the name= parameter in your HTML must all be the SAME name: input type=checkbox name=items[] value=hovedmedlemskap hovedmedlemskap [200 kr.] input

Fw: [PHP] php form mail - checkbox problem

2002-10-29 Thread Rick Emery
Please don't answer with Tried that without showing us your new HTML and code Show us the new code. - Original Message - From: Tine [EMAIL PROTECTED] To: Sent: Tuesday, October 29, 2002 9:12 AM Subject: Re: [PHP] php form mail - checkbox problem Rick Emery [EMAIL PROTECTED] wrote

Fw: [PHP] Select values in an array???

2002-10-29 Thread Rick Emery
Where are the selected values coming from? Please provide more details and code...we cannot read your mind... - Original Message - From: Craig [EMAIL PROTECTED] To: Sent: Tuesday, October 29, 2002 9:19 AM Subject: [PHP] Select values in an array??? I am trying to pass the values of a

Re: [PHP] Select values in an array???

2002-10-29 Thread Rick Emery
You don't even need the word multiple - Original Message - From: John Nichel [EMAIL PROTECTED] To: Craig [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:27 AM Subject: Re: [PHP] Select values in an array??? Change the name of your select field to select[]

Re: [PHP] Select values in an array???

2002-10-29 Thread Rick Emery
I've used it without multiple many times - Original Message - From: John Nichel [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED] Cc: Craig [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:33 AM Subject: Re: [PHP] Select values in an array??? You do if you want

Re: [PHP] Select values in an array???

2002-10-29 Thread Rick Emery
I HAVE selected multiple items without including MULTIPLE. - Original Message - From: John Nichel [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:54 AM Subject: Re: [PHP] Select values in an array??? Then you were not able

Re: [PHP] Select values in an array???

2002-10-29 Thread Rick Emery
. Yes, this page works... http://www.preferred-pet.com/volunteer/volunteer.php - Original Message - From: John Nichel [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:54 AM Subject: Re: [PHP] Select values in an array??? Then you

Re: [PHP] Select values in an array???

2002-10-29 Thread Rick Emery
Edwin, you are CORRECT. I had a brain-fart. I stand before you all, humbled Round of beer for everyone in the house cheers rick- Original Message - From: @ Edwin [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 10:25 AM Subject

Re: [PHP] HTML Post

2002-10-29 Thread Rick Emery
? // Sends GET or POST, with data, to URL // $form_url:full URI, http://www.isp.com/directory/directory // $form_method: GET or POST // $form_data: associative array of data for GET or POST // $ShowRequest: if set, return the request sent to server // Request text enclosed by

Re: [PHP] MySQL and images

2002-10-29 Thread Rick Emery
In order to speed-up queries, it is suggested that you DO NOT store images in the database. Rather, store the images in files and store file names in the database. - Original Message - From: John Meyer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 29, 2002 9:32 PM

Re: [PHP] Mail() function

2002-10-28 Thread Rick Emery
I don't know what Formulário de Cadastro is, but it doesn't belong as fourth parameter. That parameter is for From, CC, BCC headers - Original Message - From: Rodrigo de Oliveira [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 28, 2002 12:39 PM Subject: [PHP] Mail()

Re: [PHP] extract($_POST)

2002-10-25 Thread Rick Emery
2002 18:41:04 +0100 To: '1LT John W. Holmes' [EMAIL PROTECTED], Rick Emery [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: [PHP] extract($_POST) -Original Message- From: 1LT John W. Holmes [mailto:holmes072000;charter.net] Sent: 23 October 2002 19:51 Say you have

Re: [PHP] extract($_POST)

2002-10-25 Thread Rick Emery
: Chris Boget [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED] Cc: PHP General [EMAIL PROTECTED] Sent: Friday, October 25, 2002 8:53 AM Subject: Re: [PHP] extract($_POST) The more secure method ensures it MUST come from a form. Be advised: the user can create his own form with $admin

Re: [PHP] Ereg help

2002-10-25 Thread Rick Emery
?php $s = #12-3456 The Item description $35.43; $qq = ereg(#([0-9]*-[0-9]*) ([a-zA-Z0-9 ]*) \\$([0-9]{1,3}\.[0-9]{2}), $s,$a); $val = $a[1]./.$a[2]./.$a[3]; print $val; ? - Original Message - From: William Glenn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002

Re: [PHP] cutted values after posting multiple select list

2002-10-25 Thread Rick Emery
use $_POST, not $_REQUEST - Original Message - From: Heiko Mundle [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 10:39 AM Subject: [PHP] cutted values after posting multiple select list Hi i struggling with multiple select lists in HTML forms. The resulting

Re: [PHP] extract($_POST)

2002-10-25 Thread Rick Emery
You can still use extract($_POST). It is as safe/vulernable as $_POST['isAdmin']. In either case, use only variables that you know are yours and be certain these contain values which you believe to be safe. For instance, if you expect a variable called $firstname to contain a name to be stored

Re: [PHP] HTML filtering

2002-10-25 Thread Rick Emery
You could delete all HTML tags. Then use nl2br() to re-insert the BR tags - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 3:28 PM Subject: [PHP] HTML filtering I have a problem, I need to filter HTML from data but want to preserve the

Re: [PHP] extract($_POST)

2002-10-25 Thread Rick Emery
... - Original Message - From: Chris Boget [EMAIL PROTECTED] To: Rick Emery [EMAIL PROTECTED]; [EMAIL PROTECTED]; Monty [EMAIL PROTECTED] Sent: Friday, October 25, 2002 3:41 PM Subject: Re: [PHP] extract($_POST) This thread has been great! I've learned so much useful stuff. For instance, if you

Re: [PHP] extract($_POST)

2002-10-25 Thread Rick Emery
You assume mysql. Other SQL databases allow multiple statements. -Original Message- From: Rick Emery [mailto:remery;emeryloftus.com] Sent: Friday, October 25, 2002 4:59 PM To: Chris Boget; [EMAIL PROTECTED]; Monty Subject: Re: [PHP] extract($_POST) Lets say you have a statement

Re: [PHP] processing form checkboxes

2002-10-24 Thread Rick Emery
Add [] to name of variable tdinput type=checkbox name=state[] value=1nbsp;nbsp;Alabama/td - Original Message - From: James Taylor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 24, 2002 6:05 PM Subject: [PHP] processing form checkboxes Heya folks, not sure if

Re: [PHP] Calendar System

2002-10-17 Thread Rick Emery
http://myphpcalendar.sourceforge.net/

Re: [PHP] Inserting a variable into a mysql_query() statement

2002-10-16 Thread Rick Emery
$query = DELETE FROM product WHERE manufacturer=\$hidden_manuf_id\; mysql_query($query,$bb) or die(mysql_error()); or: mysql_query(DELETE FROM product WHERE manufacturer=\$hidden_manuf_id\, $bb); = Phil Clark wrote: I'm trying to insert the variable

Re: [PHP] SQL field problem

2002-07-10 Thread Rick Emery
SELECT DISTINCT kat FROM mytable; Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 10, 2002 12:40 PM Subject: [PHP] SQL field problem Hello I have a problem with mysql.I create a table with a field kat.In this field are entries like

<    1   2   3   4   5   6   >