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

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

[PHP-DB] var_dump and sizeof database entry?

17.5 KB file). What I was wondering 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 insi

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] 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] 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: > > > > > > Saves me a lot of time, although it can be confusing for those unfamili

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 Dummi

Re: [PHP-DB] Getting Started..

d to point me 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 threa

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

one of the "=" signs, or you may get something "=" to CURDATE() twice (not sure how SQL handles this). Maybe try (taking out one of the "="): SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() OR END < CURDATE(); Maybe it's just late over here. Has anyone else r

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 >

[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] 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

[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: 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]> wrote:[EMAIL PR

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

not arbitary bitwidth this is what happens: "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. Y

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

eparate each element in the array and "||" to separate each key from its value). Just find a divider you know your data will not contain, such as a pipe: "|". This has worked well for me. Jordan On Sep 1, 2005, at 8:55 AM, Miguel Guirao wrote: I want to store an a

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 = &

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" <[EM

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

[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, J

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]> [EMAIL PROTECTED]> wrote: Using

[PHP-DB] RE: [SPAM] Re: [PHP-DB] Using sessions to gather visitor information

John and everyone else, thanks for all the help. Here is what I have for code. Again you help is greatly appreciated. "; echo $_SESSION['user_agent'] . ""; echo $_SESSION['host_name'] . ""; echo $_SESSION['visit_time'] . ""; } // look for db entry $IpSearch = mysql_query("SELECT ip, time FROM

[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

[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?

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

You have no html link. Try echo " $company $webaddress" > -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 pasted table struc

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

t be to hard with the M$ people. > > Michael. > > > > > On Mon, 9 Aug 2004 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 o

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

age- > 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 attor

[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 we

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;

RE: [PHP-DB] SQL Insert problem

that'll > make > the query bomb. > > Rich > > > > -Original Message- > > From: Vincent Jordan [mailto:[EMAIL PROTECTED] > > Sent: Thursday, August 05, 2004 10:25 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] SQL Insert problem > > > > >

[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. http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> "; $message = "$firstname $lastname $address $address2 $city $state $zip $ph

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 PROTECT

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

I wrote this, $message is not displaying. What am I doing wrong?? > -Original Message- > From: Torsten Roehr [mailto:[EMAIL PROTECTED] > Sent: Friday, July 30, 2004 2:52 PM > To: Vincent Jordan > Subject: RE: [PHP-DB] Re: form results to email > > >

[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 ha

[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 ( k

[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

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] 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] DB table creation question

rd month 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

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

2004 5:46 PM To: Vincent 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'

[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 Firstn

[PHP-DB] Rewrite value from form data

I have a form with a field for a telephone number. I would like to either apply some kind of formatting to force format of XXX-XXX- or rewrite after submit to insert - in 3 and 5 (or 6). Here is what I have for code: --Form- Home Phone: handler.php $home = $_POST['home_phone' I hav

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

rcnt($last_name), 1 . Datetime(?) // takes the 1st character from $last_name and adds datetime in format of 715041200 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 Ma

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

d, clear password2, allow form to submit > df["password2"].value=""; > return true; > else { > alert("Passwords did not match"); > return false; > } > } > > Cheers -

[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 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 rewrite data from a tinyint. the tinyint will return 1 or 0, I have

[PHP-DB] Re: Php form & row delete problems

"could not del user" . mysql_error()); } echo "Done"; ?> - Original Message - From: "Torsten Roehr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 25, 2004 1:35 PM Subject: [SPAM] [PHP-DB] Re: Php form & row delete problem

[PHP-DB] Php form & row delete problems

box and if the box is checked and delete button is clicked it is passed to userdel.php which would take the user_id and delete row. Any help would be greatly appreciated. Vincent Jordan Technical Support Smart Parts, Inc. Loyalhanna Business Complex 100 Station Street Loyalhanna, PA 15661 80

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 u

[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 as

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

&f=1&t=2&s=1a1c5747443deb838a59b393fd11ccc7 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

Re: [PHP-DB] Unique Format

Tonya, If the handle is only for display purposes in Html, you should look into the htmlentities () or htmlspecialchars () functions. htmlentities: http://www.php.net/htmlentities htmlspecialchars: http://www.php.net/htmlspecialchars Jordan S. Jones Tonya wrote: PHP 4.3.3 and MYSQL I am

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

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

City Name 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. This part works just fine. What I want to do now

[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 (http://www.php.net

[PHP-DB] Most Read Article

If I 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 unsubscri

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

, you 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

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

[PHP-DB] Interbase/PHP/Apache implimentation

in advance, --Jordan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

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

fon: +49-(0)7531-89207-17 > fax: +49-(0)7531-89207-13 > e-mail: mailto:[EMAIL PROTECTED] > internet: http://www.suchtreffer.de > ___ > > > -Original Message- > > From: Jordan Elver [mailto:[EMAIL PROTECT

[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 - - - frank But it doesn't continue p

[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

[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 -> Cabba

[PHP-DB] Selecting Dates

Hi, I'm trying to select records based on dates. I have a table with dates in the format 2001-04-08 and I'm using the query: SELECT name, description, date_time FROM events WHERE YEAR(date_time) = 2001 AND MONTH(date_time) = 04 AND DAYOFMONTH(date_time) = 08 But it doesn't yield any records? I

[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] 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: [EMAIL

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 ass

[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, 'addres

[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) >

Re: AW: [PHP-DB] Structure Question

igned database modell, 'cause you have only one table (instead > of 10 or twelve depending on the count of your datatypes), but you are able > to select over the filetyp criteria!! > > Stefan Siefert > > -Ursprüngliche Nachricht- > Von: Jordan Elver [mailto:[EMAIL PROTECT

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

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

able and have one 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 w

[PHP-DB] Structure Question

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 different table like one table for real audio, one for quicktime, one for mp3. Or, would it better to store them all in the same table but

Re: [PHP] Query - Grouping Results

do you get. > > > -Original 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

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

gt; user_logins.user_id = users.id > 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 - Groupi

[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, U

[PHP-DB] Login System with access levels

Hi, I've got a db with a username and password in it. I can let people log in, like SELECT * FROM table WHERE username = username AND password = password. But how can I add an access level column so that I can have different levels of security. So admin's can read everything, but users can only

[PHP-DB] Sessions in Functions

Hi, I have some code which I decided to make into a function. Some of the code updates a session var which holds the current time. It now does not work. // update session variable with new time session_register("LOGGED_IN['time']"); $LOGGED_IN['time'] = mktime();

[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, Cheers,

[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 sti

[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 unsubscribe,