[PHP-DB] any ideas?

2003-06-30 Thread Addison Ellis
(nashville) there is a test store in the db that will not appear. -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED

[PHP-DB] concatenate issue?

2003-06-29 Thread Addison Ellis
figure it out... thanks again... -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] addisonellis.com THIS E-MAIL AND ANY

Re: [PHP-DB] Confirmation e-mail

2003-02-09 Thread Addison Ellis
-- Davy Obdam - Obdam webdesign© mailto:[EMAIL PROTECTED] web: www.davyobdam.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Addison Ellis small independent

[PHP-DB] validate list menu selection

2003-02-09 Thread Addison Ellis
Please try again./font; include(place_ad.php); exit(); } } is checking everything but my list menu. thank you and i have searched, to no avail. best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville

[PHP-DB] subdate

2003-02-05 Thread Addison Ellis
as category_name from ads a,subcategory s, category c where a.subcategory=s.id and s.category=c.id and a.subcategory=$id and a.que='checked' and createdate =subdate(now(), interval 1 month)); -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791

[PHP-DB] date: reverse order

2003-02-04 Thread Addison Ellis
); ? thank you addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] date: reverse order

2003-02-04 Thread Addison Ellis
Message- From: Addison Ellis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 5:28 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] date: reverse order hello, when retrieving data from the db and displaying it on the page by creation date how can i reverse the order so

[PHP-DB] print_r($row);

2003-02-04 Thread Addison Ellis
Contact: 321-1791 -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

[PHP-DB] where limits?

2003-02-04 Thread Addison Ellis
,category c where a.subcategory=s.id and s.category=c.id and a.subcategory=$id and a.que='checked'); with no complications and if so, where should i insert it??? i do appreciate your time. best regards, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN

[PHP-DB] font options

2003-02-02 Thread Addison Ellis
; ? ? echo $row-date_available; ? ? echo $row-price; ? ? echo $row-contact; ? thank you and best regards, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small

[PHP-DB] list menu

2003-02-02 Thread Addison Ellis
-property_type; ? /option option value=househouse/option option value=condocondo/option option value=duplexduplex/option option value=apartmentapartment/option option value=landland/option /select thank you again, addison ellis -- Addison

[PHP-DB] print

2003-02-02 Thread Addison Ellis
hello, i have a form someone fills out, say with the field # of bedrooms. they submit. data goes into db. how can i get the # of bedrooms to print 4 Bedrooms instead of just 4? thank you, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615

[PHP-DB] print resolved- thank you

2003-02-02 Thread Addison Ellis
hello, i have a form someone fills out, say with the field # of bedrooms. they submit. data goes into db. how can i get the # of bedrooms to print 4 Bedrooms instead of just 4? thank you, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615

[PHP-DB] print

2003-02-02 Thread Addison Ellis
hi, i still am having a problem. can you see what is wrong with what i've got. and... thank you. best regards, addison ellis this is what is printing: 2Bedroom/2Bath great From Campus Available imm 500.00 Contact: 321-1791 it is not printing the property_type and it is not following my \n

[PHP-DB] select

2003-02-02 Thread Addison Ellis
option value=househouse/option option value=condocondo/option option value=duplexduplex/option option value=apartmentapartment/option option value=landland/option /select -- Addison Ellis small independent publishing co. 114 B 29th Avenue North

[PHP-DB] form field rejection

2003-02-02 Thread Addison Ellis
hello, thank you for your time... what is the best way for me to have a form field, phone reject certain phone prefixes? for example: someone enters 321-1791 and 321 prefix can not be allowed as an entry... thank you again, addison -- Addison Ellis small independent publishing co. 114 B 29th

[PHP-DB] MySQL result resource

2003-01-29 Thread Addison Ellis
subcategory where id=$row-subcategory); $scrow = mysql_fetch_object($scobj); $cobj = mysql_db_query($dbname,select * from category where id=$scrow-category);//54 $crow = mysql_fetch_object($cobj); ? any ideas, of course, are most appreciated. thank you and best, addison -- Addison

[PHP-DB] really stumped!

2003-01-28 Thread Addison Ellis
encompassing header:. one of many forms submitted to this will actually process and post now with no errors but will not, as i mentioned, print any of my echo. here is the thing in it's entirety and i very much appreciate your time and efforts. best regards, addison ellis ? session_start

[PHP-DB] need INSERT help

2003-01-27 Thread Addison Ellis
but i know there is a better way. and... anyway... thanks for looking at this. best regards, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL

[PHP-DB] REVISED; need INSERT help

2003-01-27 Thread Addison Ellis
); the problem i am having is i have so many different form fields/values. i am almost resigning to having one .php for each form but i know there is a better way. and... anyway... thanks for looking at this. best regards, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue

[PHP-DB] too many connections?

2003-01-27 Thread Addison Ellis
: Too many connections in /users/infoserv/web/register/ca/admin/config.php on line 5 Warning: MySQL Connection Failed: Too many connections in /users/infoserv/web/register/ca/admin/config.php on line 5 -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203

[PHP-DB] resolved : Re: [PHP-DB] too many connections?

2003-01-27 Thread Addison Ellis
allows? Is there a limit set in php.ini? Shannon Johnston On Mon, 2003-01-27 at 15:13, Addison Ellis wrote: hello and thank you. any idea what this means? i have not touched or changed my config.php file since i put it up the first time... it contains my db connect info. also, i just

[PHP-DB] elseif

2003-01-27 Thread Addison Ellis
; } if ($error == ) { $query = insert into stores set -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]

[PHP-DB] if ($key !=

2003-01-27 Thread Addison Ellis
','etc.') or must i do this: if ($key != middle_name and $key != address and $key != etc. ) { if ($value == ) } etc... best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small

[PHP-DB] $HTTP_POST_VARS

2003-01-27 Thread Addison Ellis
hello, will this work? $sql = INSERT INTO ads ($HTTP_POST_VARS,createdate) VALUES ('$key','$today'); mysql_query($sql); i have this at the top: foreach ($HTTP_POST_VARS as $key = $value) thanks again, addison ellis -- Addison Ellis small independent publishing co. 114 B 29th

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
Your Ad values passed. again, i really appreciate your time. best regards, addison ellis On Sunday 26 January 2003 14:31, Addison Ellis wrote: hello, i have unsuccessfully tried for three days to write, re-write something that will insert data into my db and ashamedly have failed again

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
first, i must apologize as i am very new at this... and... i really appreciate your help. addison On Sunday 26 January 2003 16:14, Addison Ellis wrote: Please do not top-post. Sorry here... i added this: { echo $key, $valuebr; } underneath function storeForm($formdata,$ads

Re: [PHP-DB] empty query

2003-01-26 Thread Addison Ellis
guess not. anyway... thank you very much, again. addison On Sunday 26 January 2003 18:59, Addison Ellis wrote: correct... i am able to echo values again. Hmm, okay :-) i had the following to carry forward cat and subcat values: ? session_start(); if (@$auth != yes

[PHP-DB] empty query

2003-01-25 Thread Addison Ellis
= mysql_query($query) or die (Couldn't execute query.); } ? -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [PHP-DB] need help spotting this php parse error

2003-01-23 Thread Addison Ellis
? } ? /select /form _ Stay in touch with MSN Messenger http://messenger.msn.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Addison Ellis small

[PHP-DB] revised: foreach($HTTP_POST_VARS...

2003-01-22 Thread Addison Ellis
if ($message == ) { $query = insert into ad_columns set (from here can i write something like $query = foreach($HTTP_POST_VARS as $key = $value) insert into ad_columns set??? thank you. addison ellis -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203

[PHP-DB] add.php

2003-01-22 Thread Addison Ellis
the field name in it, will it skip over that field or will it return an error saying name is blank? this goes at the end of my ifs... } else { $query = update ads set name = '$name', etc. my best regards, addison ellis -- Addison Ellis small independent publishing co. 114 B 29th Avenue North

Re: [PHP-DB] using Flat File

2003-01-22 Thread Addison Ellis
'; } ? - Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED

[PHP-DB] preview form field entries before db submission?

2003-01-21 Thread Addison Ellis
hello, do you know of a way to preview form field entries in a new page, the way they will appear in a query result, so that the user has a chance to edit their entries prior to their actual submission to the db? thank you and best, addison -- Addison Ellis small independent publishing co

[PHP-DB] session_destroy(); on submit?

2003-01-21 Thread Addison Ellis
hello, will the following work or should i be attempting something else? /form input type=submit name=submit value=Submit onClick=?session_unset();,session_destroy();? input type=hidden name=url value=http://www.etc.com; thank you and best, addison -- Addison Ellis small independent

[PHP-DB] datetime

2003-01-21 Thread Addison Ellis
.? thanks again, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http

[PHP-DB] foreach($HTTP_POST_VARS as $key = $value)

2003-01-21 Thread Addison Ellis
, and if they are ok, insert the submitted form values into a table in a database. thank you. addison ellis foreach($HTTP_POST_VARS as $key = $value) { if ($key != ) { if ($value

[PHP-DB] ghost parse error?

2003-01-20 Thread Addison Ellis
;? font size=3gt;/font ? echo $scrow-name;? /font/b font color=#3399FF size=3 face=Arial, Helvetica, sans-serif Directing . . ./font/p form method=post action= /form -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED

[PHP-DB] is this possible?

2003-01-19 Thread Addison Ellis
. best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

[PHP-DB] header?

2003-01-19 Thread Addison Ellis
. best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

[PHP-DB] print new account name on new account page?

2003-01-18 Thread Addison Ellis
/infoserv/web/register/ca/new_account.php on line 82 -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]

[PHP-DB] extract() expects first argument to be an array

2003-01-17 Thread Addison Ellis
hello, i have received the following error message and don't know what to do to correct it. i have tried several things but what i have tried does not work. i will post my code below the error message. thank you for your time. best, addison ellis Warning: extract() expects first argument

[PHP-DB] $user=$email

2003-01-15 Thread Addison Ellis
config.php file which is a required file i have $user=$email, etc. i continually receive an access denied/couldn't connect to server. i'm sure i'm leaving something out... thank you for your time. addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203

[PHP-DB] error message print

2003-01-14 Thread Addison Ellis
hello, how can i get an error message to print in the color red as in the code below? thank you for your time, addison $message_new = $zip is not a valid zip code. Please try again.; -- Addison Ellis small independent publishing co. 114 B 29th Avenue North

[PHP-DB] db connect probs

2003-01-14 Thread Addison Ellis
: ? $user=$email,$femail; $host=$hostname; $password=password('$password'),password('$fpassword'); $database=$classes; ? thank you again for your time. addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL