[PHP-DB] any ideas?

select a category(arts & crafts) and state(TN) -next page enter city(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

[PHP-DB] concatenate issue?

hat match your search. Please try another... } ?> //i have checked my db and my admin area and that all works fine... i can't figure it out... thanks again... -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL

[PHP-DB] validate list menu selection

lease try again."; 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,

Re: [PHP-DB] Confirmation e-mail

best approach to achieve this? How is this usualy done? Any thoughts and help is appreciated. Best regards, Davy Obdam -- Davy Obdam - Obdam webdesign© mailto:[EMAIL PROTECTED] web: www.davyobdam.com ---- -

[PHP-DB] subdate

); this works: (*note end of syntax "interval 1 month") $obj = mysql_db_query($dbname,"select a.*,s.name as subcategory_name,c.name 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 cr

[PHP-DB] "where" limits?

ategory_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'"); with no complications and if so, where should i insert it??? i do appreciate your time. best regards, addison -- Addison Ellis small independent

[PHP-DB] print_r($row);

{$row->price} Contact: {$row->contact}"; ?> } } // End Ad Block ?> this is what is printing: 2Bedroom/2Bath great place less than 5 miles From Campus Available immediately $500.00/month Contact: 321-1791 -- Addison Ellis small independent publ

RE: [PHP-DB] date: reverse order

createdate DESC" -Original 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 t

[PHP-DB] date: reverse order

order by createdate"); ?> 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 Mail

[PHP-DB] form field rejection

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

[PHP-DB] select

condo duplex apartment land -- 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 D

[PHP-DB] print

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

[PHP-DB] print resolved- thank you

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

[PHP-DB] print

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

[PHP-DB] list menu

rtment land thank you again, addison ellis -- 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 Da

[PHP-DB] font options

t; price; ?> 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 independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]

[PHP-DB] MySQL result resource

. thank you and 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-DB] sql syntax error

= mysql_query($query) or die ("Error in query: $query,Error:" .mysql_error()); } ?> -- 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] really stumped!

e two 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 ses

[PHP-DB] $HTTP_POST_VARS

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 inde

[PHP-DB] if ($key !=

iddle_name','address','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

[PHP-DB] elseif

} elseif ($contact_email == "") { $error = "$errorYou must enter a contact phone number or email address."; } 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] resolved : Re: [PHP-DB] too many connections?

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] too many connections?

: 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] REVISED; need INSERT help

value)); 4) $today = date("-m-d"); 5) $sql = "INSERT INTO tablename ("$HTTP_POST_VARS) VALUES ('$$HTTP_POST_VARS values')"; mysql_query($sql); 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

[PHP-DB] need INSERT help

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 North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED]

Re: [PHP-DB] empty query

.1 book that i was doing that. :-) i 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: category")

Re: [PHP-DB] empty query

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, $value"; } underneath function storeForm($formdata,$ads)

Re: [PHP-DB] empty query

e next_,Submit 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 fa

[PHP-DB] empty query

"'".$value."'".","; } } $query = $query.")"; $query2 = $query2.")"; $query=$query.$query2; $result = mysql_query($query) or die ("Couldn't execute query."); } ?> -- Addison Ellis small independent publ

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

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 independent publishing co. 114 B 29th Avenue North Nashville, TN 37

Re: [PHP-DB] using Flat File

$auth = true; break; } } } if ( ! $auth ) { header( 'WWW-Authenticate: Basic realm="Private"' ); header( 'HTTP/1.0 401 Unauthorized' ); echo 'Authorization Required.'; exit; } else { echo 'You are authorized!'; > } ?> - 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] [EMAIL PROTECTED]

[PHP-DB] add.php

r 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 Nash

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

} if (!ereg("^.+@.+\\..+$",$contact_email)) { $message_new = "Not a valid email address.\n Please try again."; } else if ($message == "") { $query = "insert in

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

rrors, 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 != "") {

[PHP-DB] datetime

arch key words.? 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 Mail

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

hello, will the following work or should i be attempting something else? http://www.etc.com";> thank you and best, addison -- Addison Ellis small independent publishing co. 114 B 29th Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries

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

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] elseif with header

s.php";); } elseif ($category = 2 and $subcategory = 50) { header("Location: http://www.vanderbilt.edu/register/ca/rentals.php";); } , etc. for some reason all the elseifs are going to the if header. any input as to how i can correct this is greatly appreciated. thank you again. addi

[PHP-DB] not a valid MySQL result resource

ql_fetch_object($cobj); name;?> and then they make selection two... thank you 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-DB] ghost parse error?

t; $scobj = mysql_db_query($dbname,"select * from subcategory where id=$subcategory"); while ($scrow = mysql_fetch_object($scobj); ?> echo " Directing $first_name $last_name\n"; ?> name;?> > name;?>

[PHP-DB] header?

ughts. 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] is this possible?

ughts. 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] session_cache_limiter

Location: login.php"); exit(); } i can not get the new account name to print from the form just submitted. any ideas are greatly appreciated and thank you 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-DB] print new account name on new account page?

Couldn't execute query 1."); $row = mysql_fetch_array($result,MYSQL_ASSOC); extract($row); echo " New Account Welcome Welcome $firstName $lastName\n"; ?> here is an example of the errors: Warning: extract() expects first argument to be an array in /users/info

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

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 argume

[PHP-DB] $user=$email

mysql_query($sql) or die("Can't execute query."); header("Location: cat_ad.php"); } else// password is not correct { in my config.php file which is a required file i have $user=$email, etc. i contin

[PHP-DB] db connect probs

quired file is as follows: $user="$email,$femail"; $host="$hostname"; $password="password('$password'),password('$fpassword')"; $database="$classes"; ?> thank you again for your time. addison -- Addison Ellis small independent pu

[PHP-DB] error message print

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 Av