[PHP-DB] any ideas?
hello and thank you for your time... any ideas why this isn't working? thank you again. best regards, addison $query = "select * from stores,subcategory,category where stores.category = $crow->id and subcategory.category = $crow->id and (stores.city = '$city' and stores.state = '$state') and que='checked' order by 'name'"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $count++; ?> // url of site with problem: http://www.momandpopcentral.com - 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 small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] addisonellis.com THIS E-MAIL AND ANY FILES TRANSMITTED WITH IT ARE CONFIDENTIAL AND ARE INTENDED SOLELY FOR THE INDIVIDUAL OR ENTITY TO WHOM THEY ARE ADDRESSED. IF YOU ARE NOT THE INTENDED RECIPIENT, PLEASE DO NOT READ, COPY OR RE-TRANSMIT THIS COMMUNICATION BUT DESTROY IT IMMEDIATELY. ANY UNAUTHORIZED DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS STRICTLY PROHIBITED. A
[PHP-DB] concatenate issue?
hello and thank you for your time... i have not been able to get the below to produce any results... i'm getting no mysql error messages... just "There are no stores that match your search. Please try another..." no matter what i have tried it worketh not... thank you again. best regards, addison // url of site with problem: http://www.momandpopcentral.com - select a category(arts & crafts) and state(TN) -next page enter city(nashville) there is a test store there that will not appear. //top of page: $count = 0; $scobj = mysql_db_query($dbname,"select * from subcategory where id=$id"); $scrow = mysql_fetch_object($scobj); $cobj = mysql_db_query($dbname,"select * from category where id=$scrow->category"); $crow = mysql_fetch_object($cobj); ?> //mid-page or so: working fine. name; ?> -> Select-A-Business //where i need results and not getting any: $query = "select * from stores,subcategory,category where stores.category = $crow->id and subcategory.category = $crow->id and (stores.city = '$city' and stores.state = '$state') and que='checked' order by 'name'"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $count++; ?> name; ?> shortdesc; ?> if ($row = mysql_fetch_object($obj)) { ?> name; ?> echo $row->shortdesc; } else { echo " "; } ?> } ?> if ($count == 0) { ?> There are no stores that 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 PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] addisonellis.com THIS E-MAIL AND ANY FILES TRANSMITTED WITH IT ARE CONFIDENTIAL AND ARE INTENDED SOLELY FOR THE INDIVIDUAL OR ENTITY TO WHOM THEY ARE ADDRESSED. IF YOU ARE NOT THE INTENDED RECIPIENT, PLEASE DO NOT READ, COPY OR RE-TRANSMIT THIS COMMUNICATION BUT DESTROY IT IMMEDIATELY. ANY UNAUTHORIZED DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS STRICTLY PROHIBITED. A
[PHP-DB] validate list menu selection
hello, what do i need to do to make sure someone has made a selection from a list menu. my foreach($HTTP_POST_VARS as $value) { if ($value == "") { unset($do); $message_new = "Required information missing.\n Please 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, 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/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Confirmation e-mail
this is what i use. hope it helps, addison /* send email to new member */ $emess1="Thank you...\n"; $emess2="Your Member ID and password are:\n"; $emess3="\n\n\tID:$email\n\tPassword:$password\n\n"; $emess4="Each time you submit an ad, please use your existing ID and password.\n\n"; $emess5="Please e-mail ?@?.com with questions or comments."; $emess = $emess1.$emess2.$emess3.$emess4.$emess5; $ehead="From: ?@?.com\r\n"; $subject = "this appears in the subject of the email to the new member"; $mailsend=mail("$email","$subject","$emess","$ehead"); header("Location: index.php (where you want them directed after they sign in. it could be a welcome page."); Hello people., I am developing a website with a user login system, i would like to send an confirmation e-mail to the user when he/she registers for the site, asking for confirmation...for instance click on a link to activate thier account. My question is what would be the 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 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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] subdate
hello, thank you for your time. please note the time "intervals" that are working. what i want is to select only data that is two weeks old or younger. i did a test with one day and it worked great. i inserted the two-week/14days and neither of them worked. 1 month worked. i could not find anything on php.net that directed me to this. thank you again, addison this works:(*note end of syntax "interval 1 day") $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 createdate >=subdate(now(), interval 1 day)"); this does not: (*note end of syntax "interval 14 days") $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 createdate >=subdate(now(), interval 14 days)"); this does not: (*note end of syntax "interval 2 weeks") $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 createdate >=subdate(now(), interval 2 weeks)"); 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 createdate >=subdate(now(), interval 1 month)"); -- 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] "where" limits?
hello, is there a limit to how many "where" statements one can include in a query? i am wondering if i can add this: where createdate >= subdate(now(),interval 1 month)" to this: $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'"); 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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] print_r($row);
hello, i do print_r($row); and all my data is printing properly from my db. however, with the below code only one row is not printing: {$row->property_type} thank you for your time. addison // Begin Ad Block $count = 0; $id = 45; $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'"); if ($obj && mysql_num_rows($obj)>0) { while($row = mysql_fetch_object($obj)) { $count++; ?> bedrooms}Bedroom/{$row->baths}Bath {$row->property_type} {$row->description} {$row->distance} from campus. Available: {$row->date_available} {$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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] date: reverse order
thank you... this worked. best, addison Simple MySQL. After your ORDER BY clause use either ASC (I think this is the default) or DESC. I'm pretty sure this'll work on date fields to produce the results you want. Your query will end up looking like: "...order by 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 the order so that the most recent entry appears first? here's what i have now: 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/) To unsubscribe, visit: http://www.php.net/unsub.php -- 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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 that the most recent entry appears first? here's what i have now: require("config.php"); $obj = mysql_db_query($dbname,"select * from ads 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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] select
hi and thank you, is there a reason this will not work? i am trying to echo an option that has already been selected in a list menu. best, addison $obj = mysql_db_query($dbname,"select * from ads where id=$id;"); while($row = mysql_fetch_object($obj)) { if ($row->property_type == $row->id) { $selected = "SELECTED"; } else { $selected = ""; } ?> selected> property_type; ?> house 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 my \n commands. here's the code: // Begin Ad Block $count = 0; $id = 50; $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'"); if ($obj && mysql_num_rows($obj)>0) { while($row = mysql_fetch_object($obj)) { $count++; ?> bedrooms}Bedroom/{$row->baths}Bath{$row->property_type}\n {$row->description}\n {$row->distance} From Campus Available {$row->date_available}\n {$row->price}\n Contact: {$row->contact}"; ?> } } // End Ad Block ?> 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]
[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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] list menu
hi and thank you for your time... how do i, as my text fields are echoing a selected value, get my list menus to do the same? text field has: contact; ?> list menu has: property_type; ?> house condo duplex apartment 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] font options
hello, what is the proper way to get a block of echoes to echo with the same font, size, color, etc... as in: property_type; ?> bedrooms; ?> baths; ?> description; ?> distance; ?> date_available; ?> 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 Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL result resource
hello, i have a new issue... :-) i am getting: Warning: Supplied argument is not a valid MySQL result resource in /users/infoserv/web/register/ca/admin/catads.php on line 54 from: while($row = mysql_fetch_object($obj)) { $scobj = mysql_db_query($dbname,"select * from 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 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
hello, i can not pinpoint this. your time and help is very much appreciated. best, addison Error: id=, HTTP_POST_VARS=Array, key=, value=, category=, subcategory=, [EMAIL PROTECTED] Error in query: insert into ads values (year,make,model,color,mileage,condition,price,other,contact,next_,,created) values ('',,NOW()),Error:You have an error in your SQL syntax near 'created) values ('',,NOW())' at line 1 Code: else { foreach($HTTP_POST_VARS as $column_name => $column_value) $column_names .= $column_name . ','; $column_values .= "'$column_values',"; $query = "insert into ads values ($column_names,created) values ($column_values,NOW())"; $result = 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!
hello and thank you for taking a look at this. i, no matter what id do can not get variables to echo a value or inserted into my db. i uploaded the original file and parse error line by parse error line had to remove all brackets, which doesn't make sense to me right now, except for the 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 session_start(); if (@$auth != "yes") { header("Location: login.php"); exit(); } include("config.php"); $sql = "SELECT first_name,last_name FROM accounts WHERE email='$logname'"; $result = mysql_query($sql) or die("Couldn't execute query 1."); $row = mysql_fetch_array($result,MYSQL_ASSOC); extract($row); echo " Create an Ad $first_name $last_name"; echo " id=$id, HTTP_POST_VARS=$HTTP_POST_VARS, key=$key, value=$value, category=$category, subcategory=$subcategory, logname=$logname"; foreach ($HTTP_POST_VARS as $key => $value) $key = stripslashes($key); /* is there a better way to do this? the below if ($key !=...) are all fields from all the various forms that submit to this page that are not required to be filled in. so if ($value == "") checks all the other fields, which are the required fields. there are almost as many required as not, so i opted to go with if ($key !=...)*/ if ($key != "destination" and $key != "depart_city" and $key != "quantity" and $key != "depart_time" and $key != "depart_date" and $key != "arrival_time" and $key != "return_date" and $key != "return_depart" and $key != "return_arrive" and $key != "price" and $key != "other" and $key != "contact" and $key != "condition" and $key != "color" and $key != "date_available" and $key != "distance" and $key != "pets" and $key != "deposit" and $key != "lease" and $key != "mileage" and $key != "dates_available") if ( $value == "" ) echo "Required information is missing.\n Please click your browser's back button, try again.\n"; exit(); if (ereg("^[A-Za-z' -]{1,50}$",$key)) echo "Some information is not processing.\n Please click your browser's back button, check you entries and try again.\n"; exit(); $$key = strip_tags(trim($value)); /*this next section checks the contact field to see if it is an irregular phone or email address. i would prefer to have two seperate fields(phone,email) to be checked individually but only one or the other is required and i don't know how to have it check; if one field is filled in and if it contains no irregularities, it is ok if the other field is not filled in. then, on to "else."*/ if (ereg("^[0-9)(xX -]{7,20}$",$contact)) echo "It appears your Contact Phone Number may be entered incorrectly.\n Please click your browser's back button, check your entry and try again.\n"; exit(); if (!ereg("^.+@.+\\..+$",$contact)) { echo "It appears your eMail Address may be entered incorrectly.\n Please click your browser's back button, check your entry and try again.\n"; exit(); } else foreach($HTTP_POST_VARS as $column_name => $column_value) $column_names .= $column_name . ','; $column_values .= "'$column_values',"; $today = date("-mm-dd"); $query = "insert into ads values ($column_names,createdate) values ($column_values,'$today')"; $result = mysql_db_query($dbname,$query) or die (mysql_error()); /* send email to account holder */ $emess1="\n\n\tUsername:$email\n\n"; $emess2="A new Vanderbilt Register Classified Ad has been setup for you."; $emess3="We appreciate your Placing an ad with us.\n\n"; $emess4="If you have any questions or problems, email "; $emess5="[EMAIL PROTECTED]"; $emess = $emess1.$emess2.$emess3.$emess4.$emess5; $ehead="From: [EMAIL PROTECTED]\r\n";
[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 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 !=
hello and presumably, thank you again... i have quite a few fields from different forms that are not required and almost as many that are so i have opted to go with if ($key != "middle_name") format. in using this can i separate the different fields like so if ($key != "'middle_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 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] elseif
hello and thank you for your time. will the below work to check if one field or the other is filled in upon submission? either contact_phone or contact_email is required but not both. best, addison $error = ""; if ($name == "") { $error = "$errorYou must enter a company name."; } if ($address == "") { $error = "$errorYou must enter an address."; } if ($city == "") { $error = "$errorYou must enter a city."; } if ($state == "") { $error = "$errorYou must enter a state."; } if ($zip == "") { $error = "$errorYou must enter a zip."; } if ($contact_phone == "") { $error = "$errorYou must enter a contact phone number or email address."; } 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?
i searched at mysql.com and it said basically what you are asking. i contacted the server admin and they are going to re-set the server. thank you for your time. best regards, addison Assuming that line 5 is the dbconnect, is there a limit on the number of connections that your MySQL server 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 downloaded it from the server to see if it had been modified and it had not. thanks again and best, addison Warning: 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 -- Shannon Johnston <[EMAIL PROTECTED]> -- 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] too many connections?
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 downloaded it from the server to see if it had been modified and it had not. thanks again and best, addison Warning: 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 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
[PHP-DB] REVISED; need INSERT help
hello again and i am sorry i was not more specififc in my last post. here is where i am confused: else { $today = date("Y-m-d h:m:s"); $sql = "INSERT INTO ads ("") VALUES ('$first_name','$last_name','$email','$phone','$univ_status', '$password','$today')"; mysql_query($sql); $auth="yes"; $logname = $email; for the actual insert, what do i put in order to avoid having to do a separate .php for each form and list the fields/values from each form? thanks and sorry again. addison previous post: hello, can someone help me with this? i have tried all i know and i am very new at this... my apologies. i am trying to have multiple forms, all with different fields/values, point to one .php that will foreach($HTTP_POST_VARS as $key => $VALUE) 1) check for if ($value == "") 2) ereg function 3) $$key = strip_tags(trim($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 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 PROTECTED] [EMAIL PROTECTED]
[PHP-DB] need INSERT help
hello, can someone help me with this? i have tried all i know and i am very new at this... my apologies. i am trying to have multiple forms, all with different fields/values, point to one .php that will foreach($HTTP_POST_VARS as $key => $VALUE) 1) check for if ($value == "") 2) ereg function 3) $$key = strip_tags(trim($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 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 PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] empty query
whew! is there a tutorial you know of that might help me? in essence i have page 1 "select category," page two "select subcategory," page 3 "fill out the form, click submit," data is entered into database, user is directed to a new page. i thought from this php 4.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") or die (mysql_error()); $crow = mysql_fetch_object($cobj); $sql = "SELECT first_name,last_name FROM accounts WHERE email='$logname'"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) extract($row); I don't see anything in that code which would carry the category and subcategory forward, UNLESS $scrow and $crow are registered as session variables. again, from this new php 4.1 book, i am following the examples and guidelines. i guess that since register_globals is turned on on the server they are passing.? >I would hazard a guess and say that "next_" is the name of a button and >"Submit Your Ad" is it's value? As it is part of the form and you're >programmatically (or indiscriminately) extracting everything from $_POST > (or equivalent) then that is why you end up with it. how am i to get rid of it. Don't put it into $formdata! Remember you're the one who is putting it in there! i guess i am not sure how to keep it out of $formdata. again, the book... addison Presumably at some point you have some code which will insert the contents of $formdata into your database. If that code is properly written then the presence (or otherwise) of "next_" should not affect its operation. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Once upon a time, four AMPHIBIOUS HOG CALLERS attacked a family of DEFENSELESS, SENSITIVE COIN COLLECTORS and brought DOWN their PROPERTY VALUES!! */ -- 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 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/) To unsubscribe, visit: http://www.php.net/unsub.php
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) and it is now displaying this: year, 1971 make, chevy model, impala color, green mileage, condition, none price, other, Ad may not exceed 25 words. contact, [EMAIL PROTECTED] next_, Submit Your Ad But this contradicts your initial assertion that you wasn't able to echo any values from $formdata? correct... i am able to echo values again. which is what i entered into the form except it is not passing the category, subcategory info that was selected from the two previous pages. From _TWO_ previous pages? How are you carrying forward the values category & subcategory? If you're not carrying them forward then it shouldn't come as a great surprise that they're not available in the latter pages. You need to pass those values along either using hidden field elements in your form or by placing them into session variables. i had the following to carry forward cat and subcat values: session_start(); if (@$auth != "yes") { header("Location: login.php"); exit(); } include("config.php"); $scobj = mysql_db_query($dbname,"select * from subcategory where id=$subcategory") or die (mysql_error()); $scrow = mysql_fetch_object($scobj); $cobj = mysql_db_query($dbname,"select * from category where id=$scrow->category") or die (mysql_error()); $crow = mysql_fetch_object($cobj); $sql = "SELECT first_name,last_name FROM accounts WHERE email='$logname'"; $result = mysql_query($sql) or die (mysql_error()); while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) extract($row); and, in the table the data goes into needs to have a category and subcategory id. also, i don't know why i am getting the next_,Submit Your Ad values passed. I would hazard a guess and say that "next_" is the name of a button and "Submit Your Ad" is it's value? As it is part of the form and you're programmatically (or indiscriminately) extracting everything from $_POST (or equivalent) then that is why you end up with it. how am i to get rid of it. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* You have an ability to sense and know higher truth. */ -- 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 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: [PHP-DB] empty query
thank you so much for responding... i added this: { echo "$key, $value"; } underneath function storeForm($formdata,$ads) and it is now displaying this: year, 1971 make, chevy model, impala color, green mileage, condition, none price, other, Ad may not exceed 25 words. contact, [EMAIL PROTECTED] next_, Submit Your Ad which is what i entered into the form except it is not passing the category, subcategory info that was selected from the two previous pages. and, in the table the data goes into needs to have a category and subcategory id. also, i don't know why i am getting the 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 failed again. at one point i was able to echo values and see that they were in fact passing from my form. now i can't even get that. anyway, if you could take a look at this and tell me where i'm going wrong i will greatly appreciate it. thank you... addison Are you saying that now $formdata is empty?? If it is, where are you getting $formdata from? [snip] $result = mysql_query($query) or die ("Couldn't execute query."); Don't use die(), use: $result = mysql_query($query) or echo "Couldn't execute query. " . mysql_error(); -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* "Now here's something you're really going to like!" -- Rocket J. Squirrel */ -- 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 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
[PHP-DB] empty query
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. at one point i was able to echo values and see that they were in fact passing from my form. now i can't even get that. anyway, if you could take a look at this and tell me where i'm going wrong i will greatly appreciate it. thank you... addison session_start(); if (@$auth != "yes") include("config.php"); function storeForm($formdata,$ads) { $query = "INSERT INTO $ads ("; $query2 = " VALUES ("; $counter = 0; foreach ($formdata as $key => $value) { $formdata[$key] = trim($formdata[$key]); $formdata[$key] = strip_tags($formdata[$key]); $counter++; if ($counter == sizeof($formdata) ) //if this is last field { $query = $query.$key; $query2 = $query2."'".$value."'"; } else //if this is not the last field { $query = $query.$key.","; $query2 = $query2."'".$value."'".","; } } $query = $query.")"; $query2 = $query2.")"; $query=$query.$query2; $result = 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
you might try pulling the semi colon out before while. i put it in red. i think,that's probably it. addison When i run this script it tells me that I have a parse error on line 34? I really can't see it anyhelp (please!) would be much appreciated Cheers, Dave session_start(); if(!$HTTP_COOKIE_VARS["username"]) { /* The Cookie is not set, so load the page as if it is the first time */ include("library/include/header.php"); include("library/include/database.php"); /* Include a header file and a database connections/functions file */ ?> $query = "SELECT * FROM Staff WHERE ResterauntId = 1"; $result = mysql_query($query) or die( mysql_error () ); While( $row = mysql_fetch_array($result) ) { ?> "> } ?> _ 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 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: [PHP-DB] using Flat File
here is what i use. have your login_form.php post to this and call this login.php. hope it helps. addison session_start(); session_register('auth'); session_register('logname'); include("config.php"); //this file ("config.php") contains the database connection info. { case "login": $sql = "SELECT username FROM accounts WHERE username='$username'"; $result = mysql_query($sql) or die("Couldn't execute query1."); $num = mysql_num_rows($result); if ($num == 1) // login name was found { $sql = "SELECT username FROM accounts WHERE username='$username' AND password='$password'"; $result2 = mysql_query($sql) or die("Couldn't execute query2."); $num2 = mysql_num_rows($result2); if ($num2 > 0) // password is correct { $auth="yes"; $logname=$username; $today = date("Y-m-d h:m:s"); $sql = "INSERT INTO login (username,logintime) //this is a login table in the db. not necessarily needed. VALUES ('$username','$today')"; mysql_query($sql) or die("Can't execute query login."); header("Location: where_you_want_user_to_go_if_authorized.php"); } else// password is not correct { $message="This account exists,\n but you have not entered the\n correct password!\n Please try again."; include("login_form.php"); } } elseif ($num == 0) // login name not found { unset($do); $message = "The eMail Address you entered\n can't be found!\n Please try again or\n Create a New Account."; include("login_form.php"); //this is the file that actually contains the log in text fields } ?> Hi, I have posted my question to this list before but I did not get a help that I was expected. All I wanted to do is to give access for the users to view a page in which the below code is embedded. The user will enter his/her username and password. But the code is not working. I don't know what to think. I need your help guys. Don't let me die on this code $auth = false; if (isset( $PHP_AUTH_USER ) && isset($PHP_AUTH_PW)) { $filename = 'c:\\php_data\\file.txt'; $f = @fopen($filename, "r"); if ($f != FALSE) {$a = @fread($f, filesize($filename)); fclose($f); } else { echo "Could not open file"; } $lines = explode ( "\n", $file_contents ); foreach ( $lines as $line ) { list( $username, $password ) = explode( ':', $line ); if ( ( $username == "$PHP_AUTH_USER" ) && ( $password == "$PHP_AUTH_PW" ) ) { $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
hello, i was hoping someone could help me further this? i have multiple form possibilities someone can fill out. each form, on submit would point to say, add.php. it would check for blank fields. if there are no blank fields it would insert the current values into the database accordingly. the issue i am facing is each form has different fields, for instance: form 1 has name, email and question. form 2 has name, email, ticket_type, price, how many. form 3 has name, email, vehicle, color, year. and on and on. i appreciate your taking time to read this and any input you may have is also appreciated. if i use this: You must enter a company name."; } if ($address == "") { $error = "$errorYou must enter an address."; } etc. and the form, say yardsale.php, doesn't have 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 Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
[PHP-DB] revised: foreach($HTTP_POST_VARS...
hello, i am trying to point all my forms to this .php file to check for errors, and if they are ok, insert the submitted form values into a table in a database. if i use this: You must enter a company name."; } if ($address == "") { $error = "$errorYou must enter an address."; } etc. and the form, say yardsale.php, doesn't have the field "name" in it, will it skip over that field or will it return an error saying "name" is blank?or can you tell me where to go from beyond the attached email below? below the code following i don't know where to go. do i need to list each value individually or can i do something with $HTTP_POST_VARS or am i even headed in the right direction? foreach($HTTP_POST_VARS as $key => $value) { if ($key != "") { if ($value == "") { $message_new = "Required information missing.\n Please try again."; } } if (ereg($key)) { if (!ereg("^[A-Za-z' -]{1,50}$",$key)) { $message_new = "Some information not processing.\n Please try again."; } } $$key = strip_tags(trim($value)); } if (!ereg("^[0-9)(xX -]{7,20}$",$contact_phone)) { $message_new = "Not a valid phone number.\n Please try again."; } if (!ereg("^.+@.+\\..+$",$contact_email)) { $message_new = "Not a valid email address.\n Please try again."; } else 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 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
[PHP-DB] foreach($HTTP_POST_VARS as $key => $value)
hello, i do appreciate your time... below the code following i don't know where to go. do i need to list each value individually or can i do something with $HTTP_POST_VARS or am i even headed in the right direction? i am trying to point all my forms to this .php file to check for errors, 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 == "") { $message_new = "Required information missing.\n Please try again."; } } if (ereg("{name)",$key)) { if (!ereg("^[A-Za-z' -]{1,50}$",$key)) { $message_new = "Some information not processing.\n Please try again."; } } $$key = strip_tags(trim($value)); } if (!ereg("^[0-9)(xX -]{7,20}$",$phone)) { $message_new = "Not a valid phone number.\n Please try again."; } if (!ereg("^.+@.+\\..+$",$email)) { $message_new = "Not a valid email address.\n Please try again."; } else if ($message == "") { $query = "insert into ad_columns 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] datetime
hello and thank you... probably again. using datetime, &/or something else if applicable, is it possible to have entries to a page and entries to a db automatically delete? i have looked through many docs at php.net and mysql and can't find anything. perhaps i'm using the wrong search 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 Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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. 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] elseif with header
hello and thank you... i have two pages where on 1-category is selected. on 2 subcategory is selected. on submit from page two it goes to direct.php. there i have if ($category = 2 and $subcategory = 52) { header("Location: http://www.vanderbilt.edu/register/ca/vacation_rentals.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. 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] not a valid MySQL result resource
hello and thank you for your time. can you tell me why the below: i think this whole section is line 22 because whatever i change in these first four lines still has the error message point to line 22. $cobj = mysql_db_query($dbname,"select * from category where id=$category"); //line 22 $crow = mysql_fetch_object($cobj); $scobj = mysql_db_query($dbname,"select * from subcategory where category=$category"); $scrow = mysql_fetch_object($scobj); name;?> name;?> gives me this: Warning: Supplied argument is not a valid MySQL result resource in /users/infoserv/web/register/ca/direct.php on line 22 perhaps i should use something different. i am trying to print the results from two previous selections on this third page. the second page works with $cobj = mysql_db_query($dbname,"select * from category where id=$category"); $crow = mysql_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?
hello, if you could check this code that would be awesome. i am getting a parse error on line 16 but line 16 has nothing on it and my eyes are missing something... maybe my mind. anyway... thank you again. best, addison session_start(); if (@$auth != "yes") { header("Location: login.php"); exit(); } include("config.php"); $sql = "SELECT first_name,last_name FROM accounts WHERE email='$logname'"; $result = mysql_query($sql) or die("Couldn't execute query 1."); $row = mysql_fetch_array($result,MYSQL_ASSOC); extract($row); ?> $cobj = mysql_db_query($dbname,"select * from category where id=$category"); $crow = mysql_fetch_object($cobj); ?> $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;?> Directing . . . -- 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] header?
hello, i have a page where the user selects a category. they are directed to a page that takes them to subactegory and displays the subcategory according to category id. my question is can i from there direct them to a particular page from a list of a number of different pages according to their subcategory choice? my thought was to direct them to one page that contains all the relations between category and subcategory and if subcategory=id where category=$category then include or header example.php. i wasn't even sure about that. anyway... thank you for your time and thoughts. 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] is this possible?
hello, i have a page where the user selects a category. they are directed to a page that takes them to subactegory and displays the subcategory according to category id. my question is can i from there direct them to a particular page from a list of a number of different pages according to their subcategory choice? my thought was to direct them to one page that contains all the relations between category and subcategory and if subcategory=id where category=$category then include or header example.php. i wasn't even sure about that. anyway... thank you for your time and thoughts. 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/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] session_cache_limiter
hello, thank you for your time... i am getting a login name to print now on the new account page but i get the following error message: Warning: Cannot send session cache limiter - headers already sent (output started at /users/infoserv/web/register/ca/new_account.php:6) in /users/infoserv/web/register/ca/new_account.php on line 76 [EMAIL PROTECTED] my code is as follows: session_start(); if (@$auth != "yes") { header("Location: login.php"); exit(); } include("config.php"); echo "logname=$logname"; $sql = "SELECT first_name,last_name FROM accounts WHERE email='$logname'"; $result = mysql_query($sql) or die("Couldn't execute query 1."); $row = mysql_fetch_array($result,MYSQL_ASSOC); extract($row); echo " New Account Welcome Welcome $first_name $last_name\n"; ?> without the below: session_start(); if (@$auth != "yes") { header("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?
hello, i have a form someone fills out. on submit it takes them to a new accounts page that say welcome new member. how can i get their name to print on the new page from the form they just filled out? i have been trying the following but it keeps giving me error messages regardless of how i manipulate the following. thank you for your time. addison include("config.php"); $sql = "SELECT firstName,lastName FROM accounts WHERE email='$logname'"; $result = mysql_query($sql) or die("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/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
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 to be an array in /users/infoserv/web/register/ca/new_account.php on line 82 include("config.php"); $sql = "SELECT first_name,last_name FROM accounts WHERE email='$email'"; $result = mysql_query($sql) or die("Couldn't execute query 1."); $row = mysql_fetch_array($result); extract($row); echo " New Account Welcome! Welcome $firstName $lastName\n"; ?> -- 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] $user=$email
hello, i am trying to do the following: case "login": $connection = mysql_connect($host, $user,$password) //15 or die ("Couldn't connect to server."); $db = mysql_select_db($database, $connection) or die ("Couldn't select database."); $sql = "SELECT email FROM accounts WHERE email='$email'"; $result = mysql_query($sql) or die("Couldn't execute query."); $num = mysql_num_rows($result); if ($num == 1) // login name was found //25 { $sql = "SELECT email FROM accounts WHERE email='$email' AND password=password('$password')"; $result2 = mysql_query($sql) or die("Couldn't execute query."); $num2 = mysql_num_rows($result2); if ($num2 > 0) // password is correct { $auth="yes"; //35 $user=$email; $today = date("Y-m-d h:m:s"); $sql = "INSERT INTO login (loginName,loginTime) VALUES ('$email','$today')"; 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 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 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]
[PHP-DB] db connect probs
hello, do you have any idea why the following(line 106)would return the following error message ? the login.php has an included form to create an account and that is what will not connect. $connection = mysql_connect($host, $user,$password) //this is line 106 Warning: Access denied for user: 'x,@host' (Using password: YES) in /users/infoserv/web/register/login.php on line 106 Warning: MySQL Connection Failed: Access denied for user: 'x,@host' (Using password: YES) in /users/infoserv/web/register/login.php on line 106 Couldn't connect to server. my required 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 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] 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 Avenue North Nashville, TN 37203 (615) 321-1791 [EMAIL PROTECTED] [EMAIL PROTECTED] subsidiaries of small independent publishing co. [EMAIL PROTECTED] [EMAIL PROTECTED]