Re: [PHP-DB] 'htaccess method : how to modify passwords from PHP scripts ?

There is a fantastic class that takes care of writing .ht* files... look here: http://phpclasses.upperdesign.com/ Couldnt find anything on writing .ht* files. Are you sure? I looked and originally had trouble finding the class there too. I think it is a mirror of a version of the

[PHP-DB] Re-using query result identifiers?

Does re-using a link identifier name free the resources used by the previous one? Consider this code: $result = mysql_result($query1); $result = mysql_result($query2); Is the memory used by $query1's results freed/overwritten by $query2's results? Even further, does calling mysql_free_results

RE: [PHP-DB] Re-using query result identifiers?

Does anyone know anything about this? -Original Message- From: Jordan [mailto:[EMAIL PROTECTED] Sent: Thursday, November 13, 2003 4:58 PM To: '[EMAIL PROTECTED]' Subject: [PHP-DB] Re-using query result identifiers? Does re-using a link identifier name free the resources used

[PHP-DB] DB Abstraction

Hi, I thought it was about time I started using a db abstraction class. Problem is, there are so many out there that I don't which one to start using? I've heard of ADODB (I think). Anyone have any suggestions? Cheers, Jord -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Ordering Articles

Hi, I'm trying to build an article management system. Basically it will have normal artcile type things, a picture or two etc. The articles will be ordered by date by default, but I want to include the option of being able to order the articles if need be. i.e. say I add more artciles but i

[PHP-DB] Text Searches on MySQL

Hi, I'm putting together a db with articles in it. Would it be better to have two tables with the main text of the articles in it linked to a main article table or just chuck it all in together in one table. I want to be able to do a full text search on the articles. Any help please,

[PHP-DB] Re: [PHP] Query - Grouping Results

d order by name,time -Original Message----- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 1:43 PM To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP] Query - Grouping Results Hi, I've got a table like: iduser_id ip

Re: [PHP] Query - Grouping Results

Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, March 19, 2001 2:39 PM To: Jeff Armstrong Cc: PHP Database Mailing List; PHP General Mailing List Subject: Re: [PHP] Query - Grouping Results Doesn't seem to work, how would I print that out with PHP? On Monday 19 March

[PHP-DB] Query - Grouping Results

Hi, I've got a table like: id user_id ip time 1 2 127.0.0.1 20010316105018 Etc, etc. I do a join on the this table and the users table to get the coresponding username to user_id like this: SELECT users.name AS name, user_logins.ip AS ip,

[PHP-DB] Re: Betr.: [PHP-DB] Structure Question

column which holds the filetype. There's (almost) no speed profit to put the information in several tables. Have fun, Maarten Verheijen Jordan Elver [EMAIL PROTECTED] 27-03-01 13:37 Hi, I want to keep filenames of different kinds of media(real sudio, qt, mp3) for articles in a db table

Re: [PHP-DB] Structure Question

I am. Jord On Tuesday 27 March 2001 14:06, you wrote: Why don't you just store the file names in a db? iets much easyer Hi, I want to keep filenames of different kinds of media(real sudio, qt, mp3) for articles in a db table. Would it be best to store each kind of media in a

[PHP-DB] Best way to check if a query succeeded

Hi, i was just wondering what you guys do to check if a wquery suceeded or not? I know about mysql_num_rows() and mysql_affected_rows(), just wondered what you guys do? I normally do something like: $sql = "SELECT something FROM table"; $result = mysql_query($sql); if(@mysql_num_rows($result)

[PHP-DB] Passing Arrays

Hi, How can I pass an array between two pages. I've tried using serialize and unserialize. But it doen't return an array. When I use gettype() on it, it say's that the typ-e is boolean? Any ideas? Cheers, Jord -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail:

Re: [PHP-DB] mysql_result()

Thanks for everyones help with this one, all suggestions appreciated. Cheers, Jord On Wednesday 04 April 2001 17:06, you wrote: Jordan, If you know your result is going to product one row, try using: $row=mysql_fetch_array($result, MSQL_ASSOC); // returns an assoc array where the field

[PHP-DB] mysql_result()

Hi, If I knnow that a query will only retrun one row, can I do thiss (below) rather than using a while loop for one record? $id = @mysql_result($result, 0, 'id'); $name = @mysql_result($result, 0, 'name'); $email = @mysql_result($result, 0, 'email'); $address1 = @mysql_result($result, 0,

[PHP-DB] Timestamps VS Date/Time Types

Hi, I'm getting a bit confused about what date types to use in my applications and MySQL db. I have used timestamps and I know how to format them, convert them and compare them etc but now I am about to build a calender type script and I'm not sure what to use. For example, if I insert a load

[PHP-DB] Retrieving and Printing Categories

Hi, I've got a load of records that are in different categories. What is the best way to get all the records or selected records and print them in such a way that they are grouped (on the page) in their relevent category, like: Fruit - Apples - Pears - Bananas Vegetables - Carrots - Cabbages

[PHP-DB] Checking query suceeded

Hi, If I'm doing more than one query on a page what is the best way to check if they all succeeded with out using transactions? TIA, Jord -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact

Re: [PHP-DB] Printing out usernames and logins

:[EMAIL PROTECTED] internet: http://www.suchtreffer.de ___ -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 7:35 PM To: PHP DB List; PHP General List Subject: [PHP-DB] Printing out

[PHP-DB] Printing out usernames and logins

Hi, I'm trying to print out a list of usernames and the times they logged in. I want to print it out like: joe fred frank Then when you click on one of the names it show just there login times, like this, so if I click on fred it prints out: joe fred - login time - login time - login time

Re: [PHP-DB] delete user but keep the article

wrote: Thanks for replying, Jordan. So when I want to delete a user, in fact, I just set the status of that user to be dormant so that I can still get the user information for displaying the article. Workls if your not going to have loads of users. but what if i have loads of users

[PHP-DB] Most Read Article

take out the title like: SELECT MAX(reads) FROM articles Then it gets the top article number but obviously not the title. Can anyone shed some light? Cheers, Jord -- Jordan Elver Web Developer The InternetOne UK Ltd -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e

[PHP-DB] Selecting Alphabetically

Hi, Could anyone point me in the right direction with this one please. I have a table of records wit a field of artists. I want to select all the records which begin with the letter a-h then i-p etc What is the best way to do this? Cheers, Jord -- PHP Database Mailing List

[PHP-DB] 2 requests: validate 2 password fields as equal and rewrite data

Could someone instruct me or point me in the right direction. I would like to have a input type=password name=password input type=password name=password2 when submit it will check to se if password and password2 are = ( i do not want password2 to end up in POST on submit.) also i am trying to

[PHP-DB] Re: [SPAM] RE : validate 2 password fields

{ alert(Passwords did not match); return false; } } Cheers - Neil Message-ID: [EMAIL PROTECTED] From: Vincent Jordan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Date: Sun, 27 Jun 2004 20:49:47 -0400 MIME-Version: 1.0 Content-Type: multipart

[PHP-DB] Printing selected characters (strcnt?)

(?) // takes the 1st character from $last_name and adds datetime in format of 715041200 /snip Thanks any help appreciated Vincent Jordan Technical Support Smart Parts, Inc. Loyalhanna Business Complex 100 Station Street Loyalhanna, PA 15661 800-992-2147 X 5617 -- PHP Database Mailing List (http

[PHP-DB] DB table creation question

I am creating a database to keep track of our warranty returns. Currently we do not have anything to track warranty info besides a big excel file. I would like to keep customer data, product info and RMA data in separate tables but still keep them related. If I had table customers: custid

[PHP-DB] RE: [SPAM] Re: [PHP-DB] DB table creation question

Jordan Cc: [EMAIL PROTECTED] Subject: [SPAM] Re: [PHP-DB] DB table creation question use the mysql 'auto increment' on a 'int' 'customer_id' field to generate a unique customer id. the RMA number is associated with a 'customer_id' since the 'customer_id' field is in both the customers table

Re: [PHP-DB] DB table creation question

and in stages of about 200 records monthly after that. Thanks for all the help everyone has provided thusfar. -Original Message- From: Matthew McNicol [mailto:[EMAIL PROTECTED] Sent: Monday, July 19, 2004 3:08 AM To: Vincent Jordan Cc: [EMAIL PROTECTED] Subject: [SPAM] Re: [PHP-DB] RE: [SPAM] Re

[PHP-DB] howto get PK id after INSERT??

I have a form to insert customer data into a table. The form goes to php page to input data to db hen uses header to go to a final page displaying customer's information. Is there a way to get the ID (custid PK UNIQUE AUTO_INCREMENT) from mysql after INSERT then pass to final page using urlencode

Re: [PHP-DB] howto get PK id after INSERT??

I think I got it correct got the most part. I am having a problem with the urlencode function I believe. On page CustomerAddNew1.php ( page than handles form data ) im using: $last_id = mysql_query(SELECT LAST_INSERT_ID() from customerinfo); $last_id = urlencode ($last_id); header(Location:

[PHP-DB] search form w/ multiple fields

I have a form with firstname, lastname, phone, and email fields. I would like to search the database and return results to the same page in an iframe. I want to be able to search my just one or multiple. For example I can search by firstname with value of john and it will return all john rows in

[PHP-DB] MySQL software question

Is there a piece of software that will allow my to create MySQL databases and table relations in a graphical format without having to connect to the database? I am looking for something where I can point and click the creation of tables and easily create several relationships between tables (

[PHP-DB] form results to email

We have to process almost the same information via email several times a day for customers to get items repaired. I would like to reply to their email with a .htm page containing a fill in form, on form action it will send an email. I have the form and page created, all is almost working. Im

RE: [PHP-DB] Re: form results to email

message $message = $firstname.$lastname; // Send email to support mail([EMAIL PROTECTED], RMA Request, $message); echo RMA Request Sent ? -Original Message- From: Torsten Roehr [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 2:52 PM To: Vincent Jordan Subject: RE: [PHP-DB] Re

RE: [PHP-DB] Re: form results to email

I wrote this, $message is not displaying. What am I doing wrong?? Nevermind. I forgot to add method=post to the html page. I have gotten it to work however I would like to add some formatting to the email. Sent. I currently have: $message = $firstname $lastname .; mail([EMAIL PROTECTED],

[PHP-DB] SQL Insert problem

Im having a problem inserting data. Ive looked over this again and again and can not find what ive missed. Everything else works besides the db insert. !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; ?php ini_set

RE: [PHP-DB] SQL Insert problem

- From: Vincent Jordan [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 10:25 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] SQL Insert problem Im having a problem inserting data. Ive looked over this again and again and can not find what ive missed. Everything else works

Re: [PHP-DB] SQL Insert problem (SOLVED), Thanks!

Thank you all for the help. I can't believe I forgot something so simple yet crucial. Thanks again for all the help. Vinny -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 11:04 AM To: Vincent Jordan; [EMAIL PROTECTED] Subject

[PHP-DB] Intellectual property rights

This is a bit off topic however it may be something people here have or will have the unpleasant opportunity to deal with. The company I work for has been having a problem tracking our customers warranty information and have used paper for items sent in for repair. I on my own time had created a

[PHP-DB] RE: [SPAM] RE: [PHP-DB] Intellectual property rights

- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Monday, August 09, 2004 7:23 PM To: 'Vincent Jordan'; [EMAIL PROTECTED] Subject: [SPAM] RE: [PHP-DB] Intellectual property rights You're asking a legal question and should contact an attorney. -Original Message- From: Vincent

[PHP-DB] RE: [SPAM] Re: [PHP-DB] Intellectual property rights

19:03:24 -0400 Vincent Jordan [EMAIL PROTECTED] wrote: This is a bit off topic however it may be something people here have or will have the unpleasant opportunity to deal with. The company I work for has been having a problem tracking our customers warranty information and have used

[PHP-DB] RE: [SPAM] [PHP-DB] Global Peace output

You have no html link. Try echo $company bra href='$webaddress'$webaddress/abr -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, August 22, 2004 5:33 PM To: [EMAIL PROTECTED] Subject: [SPAM] [PHP-DB] Global Peace output Dear friends, I have

[PHP-DB] php Form Validation help

have a form that I would like to validate before it is submitted to the DB. I am having trouble with a couple of sections. I have a select box with a listing of all the states, the first option is Choose One with a value of 0. Would this be the correct way to validate this field? CODE

[PHP-DB] Using sessions to gather visitor information

I am trying to track the users that visit one page on a site. I am having a couple of problems. The time seems to be 5 hours off. I do not have any tables as of yet what I would like to do is only count an ip address as one in a 24 hour period, if more than one visit then update visit count.I have

Re: [PHP-DB] SQL Injection attack

NOTE: http://www.php.net/mysql_escape_string Version: 4.3.0 Description: This function became deprecated, do not use this function. Instead, use mysql_real_escape_string(). Jordan On Aug 25, 2005, at 2:15 PM, [EMAIL PROTECTED] tg- [EMAIL PROTECTED] wrote: Using mysql_escape_string

[PHP-DB] maximum number of records in a db?

I was just wondering what is the maximum number of records that can be successfully handled with a db. any db will do. it doesn't have to be the fastest or best, just one that can hold the maximum number of records and still be able to interact well with php. any ideas? thanks, Jordan

Re: [PHP-DB] maximum number of records in a db?

i am talking about individual records, not putting all records into a very long string, if that's what you are saying. i know people routinely use millions of records... but how about billions or more? Jordan On Aug 26, 2005, at 10:29 AM, Miles Thompson wrote: At 12:11 PM 8/26/2005

Re: [PHP-DB] Re: maximum number of records in a db?

Dan, Wow, thank you very much for an actual answer. It is much appreciated. I am sorry that people like to ridicule noobs on this list. It was a simple question with a simple answer. Thank you!! Jordan On Aug 26, 2005, at 10:45 AM, Dan Baker wrote: Jordan Miller [EMAIL PROTECTED] wrote

Re: [PHP-DB] Brain not working, help needed :-)

you can also do this to save room without having to create $varname: ${id.$num} = some text; Jordan On Aug 29, 2005, at 12:10 AM, Micah Stevens wrote: Hi Chris, You can use variable variables.. like this: $num = 2 $varname = id.$num; $$varname = id2 is stored here!; It's in the docs

Re: [PHP-DB] Storing an array on a table?

: 20041001103319 equals hexadecimal: 0x123A28C06FD7h if you cut away the frontpart cutting down to 32bis, you get: 0x28C06FD7h wich equals 683700183. For simple arrays, I prefer storing everything as a simple imploded string. YMMV. Jordan On Sep 1, 2005, at 10:18 AM, [EMAIL PROTECTED] tg- [EMAIL

[PHP-DB] Re: [PHP] Help: Get the value of pi up to 200+ digits?

AM, Wong HoWang wrote: Dear Jordan, I know what you mean. But you may try this one and you will know: ?php ini_set('precision',200); echo pi(); ? the result is the same as 16!!! So that's why I ask this question! I am not stupid like that! Please help, thx! Jordan Miller [EMAIL PROTECTED

Re: [PHP-DB] DATE(r)

You need to use: date('Y-m-d H:i:s'); It's in the comments at: http://www.php.net/date Jordan On Sep 9, 2005, at 12:52 PM, Ron Piggott wrote: Question: I am trying to for the first time create a table with a column that is defined as datetime I wanted to populate that column

[PHP-DB] Re: retrieving field names in ascending order

Does php have anything like the Visual Basic statement Option Compare String or Option Compare Database which controls how visual basic sorts strings like this.? If it does, then it might help *rushes off to check php manual* -- --- theExile.vze.com www.stpaulswalsall.com -- PHP Database

Re: [PHP-DB] Question on CURDATE()

Rich, Did you try putting WHERE twice? try: SELECT * FROM WEEKS WHERE BEGIN = CURDATE() and WHERE END = CURDATE; Jordan On Sep 13, 2005, at 9:08 PM, reclmaples wrote: I am trying to write a statement that will basically do this: SELECT * FROM WEEKS WHERE BEGIN = CURDATE() and END

Re: [PHP-DB] Question on CURDATE()

(taking out one of the =): SELECT * FROM WEEKS WHERE BEGIN = CURDATE() OR END CURDATE(); Maybe it's just late over here. Has anyone else run into this same thing? Jordan On Sep 13, 2005, at 10:36 PM, Micah Stevens wrote: You can't do that in SQL, that would give you a big fat syntax error

Re: [PHP-DB] Getting Started..

to the Usenet diatribes... you won't sway me. Jordan On Sep 19, 2005, at 7:26 PM, Miles Thompson wrote: People don't like top posting, but I'm doing it for a reason. See what's at the end 1. Clint - Don't hijack threads. Some people use threaded mail clients, and your getting started

Re: [PHP-DB] Getting Started..

Maybe you don't need the trailing semicolon after the phpinfo()? This is just a thought as sometimes you don't need it in the final php statement before the ? tag. Mark On 20/09/05, Clint Lovell [EMAIL PROTECTED] wrote: I'm just getting started here and I'm working with PHP MySQL for Dummies.

Re: [PHP-DB] HTML Tables in PHP...

boo ... short tags though i admit it's gotta be easier to type. Why I don't like short tags : I use XML a lot. Mark On 26/09/05, Micah Stevens [EMAIL PROTECTED] wrote: Rasmus, there's a shortcut for this: ?php echo $width? ?=$width? Saves me a lot of time, although it can be confusing

[PHP-DB] MySQL 5 Stored Procedures

Ive heard that mysql 5 now supports stored procedures. Can you call these from PHP? or is it too early to expect functionality already? Mark -- This message is best viewed with your eyes. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL 5 Stored Procedures

Thanks a lot. Ive just been reading them up on the MySQL website, and they seem really useful, so this really helps. Mark On 03/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: It is possible using PHP 5. Simply make a query like this: Select name_of_procedure(parameter1,parameter2,...);

[PHP-DB] var_dump and sizeof database entry?

is if there is a simple way to get this information from mysql directly without having to 1) select the blob column and 2) do a var_dump with output buffering and parsing for the parenthetical file size, which seems very inefficient to me. any insight is greatly appreciated. Jordan -- PHP Database Mailing

Re: [PHP-DB] var_dump and sizeof database entry?

whoa, that was EXACTLY what I needed. Thanks!! Jordan On Jan 5, 2006, at 6:14 PM, Bastien Koert wrote: select *, (length(image_fiedl)/1024) as Kb from table [where clause] to get the size Bastien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] retaining and displaying line returns in a text field

The function you need is called nl2br: http://us2.php.net/nl2br -Jordan On Jan 6, 2006, at 5:34 AM, swoll2 wrote: Good morning - I'm trying to get a text field with line returns in it to be stored, retrieved, and displayed the way it gets entered. Specifically, my users use a form field

Re: [PHP-DB] Hyperlinking to a new page

a href=/location/to/page.php?city_id=2342343City Name/a Shiloh Madsen wrote: Ok, I know this should be easy, but im just blanking on how to do it. I have a webpage where you put in a city name, and it queries a database of all the cities in the US and brings back all cities matching that name.

Re: [PHP-DB] Hyperlinking to a new page

Yes.. J Shiloh Madsen wrote: actually theres a problem with this, the page returned usually has several returns in it, so i cant hand code the id in there, will it work to do page.php?city_id=$city_id? - Original Message - From: Jordan S. Jones [EMAIL PROTECTED] To: Shiloh Madsen

Re: [PHP-DB] how to deal with this (hack) attack?

CocoaMySQL (OSX) - http://cocoamysql.sourceforge.net/ MySQLCC (Linux) - http://www.mysql.com/products/mysqlcc/index.html Jordan Peter Monk wrote: Merlin wrote: I am running a medium size php/mysql website. In the last days I recieved more and more mysql errors due to url tempering. Now my website