RE: [PHP] Re: PHP-MySQL AND Case Sentivity

xed column to BINARY. If you want to compare a blob case-insensitively you can always convert the blob to upper case before doing the comparison: SELECT 'A' LIKE UPPER(blob_col) FROM table_name; We plan to soon introduce casting between different character sets to make string comparis

RE: [PHP] convertion from string to time & substracting

Is there a reason you insist on using a CHAR field, instead of a TIME field, which would make this all easier and allow you to use the multitude of MySQL Date and Time Functions in your query... ??? ---John Holmes... > -Original Message- > From: juaid [mailto:[EMAIL PROTECTED]]

RE: [PHP] convertion from string to time & substracting

Umm...How about using UNIX_TIMESTAMP() in your query, then you won't need any of that PHP code you just wrote... ---John Holmes... > -Original Message- > From: Erik Price [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 07, 2002 2:22 PM > To: juaid > Cc: [EMAIL PROT

RE: [PHP] convertion from string to time & substracting

easy query to get exactly what you need if you use the correct column types. ---John Holmes > -Original Message- > From: juaid [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 07, 2002 2:20 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] convertion from string to time

RE: [PHP] convertion from string to time & substracting

Okay, sorry. I stand corrected. :) Either way, the query still failed for some reason. The recommendation to use MySQL_error() is still a good one... ---John Holmes... > -Original Message- > From: Chris Knipe [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 07, 2002 2:44 PM >

RE: [PHP] convertion from string to time & substracting

Yeah, if he kept CHAR, then he'd have to do all of that. We were trying to convince him to switch to a TIME column, though, to make things easier. Which he did...which does... :) ---John Holmes... > -Original Message- > From: Erik Price [mailto:[EMAIL PROTECTED]] > Sent

RE: Re[2]: [PHP] Re: strip_tags bug ?

I don't see why people use strip_tags at all. I would hate posting to a forum that will strip tags, esp. if I want to show an example of something. Just use htmlentities() and the data will be shown exactly as the user typed it, but none of the HTML or code within it will be evaluated. So if the

RE: [PHP] dynamic pull-down menus?

write some javascript arrays to be evaluated when the page is loaded in the browser. It can't do anything after that point. ---John Holmes... > -Original Message- > From: Lazor, Ed [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 07, 2002 5:41 PM > To: '[EMAIL PROTECTED

RE: [PHP] Warning: Too many connections in xxx on line xx

It's nothing to do with PHP. Raise your max_connections in your MySQL configuration file... ---John Holmes... > -Original Message- > From: Dan Morris [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 08, 2002 4:54 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Warning:

RE: [PHP] mysql_connect()

machine, then there shouldn't be any % signs in the host column. Have you read over the GRANT command in the MySQL manual? How did you set up these users? ---John Holmes... > -Original Message- > From: Jason Soza [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 08, 2002 5:04

RE: [PHP] PHP function for listing number of columns in table

No. There is, however, a function that'll tell you how many columns are in a result set. So, if you select all columns, then you can use that function to find out how many columns are in the table. www.php.net/mysql_num_fields ---John Holmes... > -Original Message- > F

RE: [PHP] Fw: Excel Spreadsheet

It would be better to just have PHP do the calculating for you, instead of trying to figure out how to pass data back and forth between a spreadsheet. You can maybe use COM for passing the data, if you still need to do it that way. ---John Holmes... > -Original Message- > From:

RE: [PHP] simplicity with 2 queries..

Read the JOIN chapter of the MySQL manual and it'll tell you how to do it. It's not a PHP issue. (watch for line wrapping) http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #JOIN ---John Holmes... > -Original Message- > From: Jule Slootbee

RE: [PHP] Thumbnails

Why reinvent the wheel? http://gallery.jacko.com/modules.php?op=modload&name=News&file=index or... http://gallery.sourceforge.net ---John Holmes... > -Original Message- > From: Mantas Kriauciunas [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 10, 2002 9:48 PM >

RE: [PHP] URL / slash reduction

sed within strings defined by ') Echo 'hello ' . $_GET['id'] . ' world'; Or... Echo "hello $_GET[id] world"; Etc...adapt to your needs... ---John Holmes... > -Original Message- > From: X-power.be [mailto:[EMAIL PROTECTED]] > Sent: Monday

RE: [PHP] Re: Arrays

$echo .= "". $name .""; Notice the . in .= Equivalent of saying $echo = $echo . "". $name .""; ---John Holmes... > -Original Message- > From: Dan [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 10, 2002 9:36 PM > To: [EMAIL PROTEC

RE: [PHP] Adding zeros in front

integer column, you may experience problems when MySQL generates temporary tables for some complicated joins, as in these cases MySQL trusts that the data did fit into the original column width. ---John Holmes... > -Original Message- > From: Justin French [mailto:[EMAIL PROTECTED]]

RE: [PHP] Include question

Umm...that's what it's supposed to do...it's "including" it... ---John Holmes... > -Original Message- > From: Tom Ray [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 11, 2002 9:29 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Include question >

RE: [PHP] WHAT IS NEW to PHP 4.2.1

I'm banking it's your register_globals setting in PHP.ini. Set it to on, then read the release notes of the program you just installed so you can learn why you want it OFF. ---John Holmes... > -Original Message- > From: Septic Flesh [mailto:[EMAIL PROTECTED]] > Sen

RE: [PHP] Unlink question more or less

You can't use wildcards. Use a system() or exec() call to do it. Why use the datetime part at all? The usernames are unique, right? ---John Holmes... > -Original Message- > From: Tom Ray [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 11, 2002 11:06 PM > To:

RE: [PHP] Unlink question more or less

Just be aware that if the name is based on the username, it'll be easy for other people to guess the names of files on your computer and possibly inject code into it. Just something to be aware of. ---John Holmes... > -Original Message- > From: Tom Ray [mailto:[EMAIL PROTECT

RE: [PHP] Automatic user login under NT

It is $_SERVER["LOGON_USER"]. You have to enable Integrated Windows Authentication under Directory Security in IIS> ---John Holmes... > -Original Message- > From: Barajas, Arturo [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 12:43 PM > To: 

RE: [PHP] Querying for MAX

Just note that this will fail miserably unless you are locking your tables around the SELECT MAX() and the INSERT. What if 3 different users all select the same MAX() and try to insert the next number? You really need to re-think your database design if you have to do it this way. ---John

RE: [PHP] RE: Thumbnails from mySQL binary data

Make it when it's uploaded. Then you make just one user wait on the server, instead of the multitude of users just viewing pages... ---John Holmes... > -Original Message- > From: Shane [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 4:10 PM > To: Philip Ha

RE: [PHP] Extracting from an Array

How about just SELECT RIGHT(fieldname,4) FROM tablename ---John Holmes... > -Original Message- > From: Lazor, Ed [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 7:09 PM > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: [PHP] Extracting f

RE: [PHP] Extracting from an Array

() in your query to re-format the date back to dd-mm- if you want to? Do you realize that if you ever wanted to sort by this column, you'd be all messed up? It'll sort as a string, where "10" is less than "2". Do you realize what I'm trying to say?? ---John H

RE: [PHP] POST/GET var problem

'm pretty sure that's how it still works. ---John Holmes... > -Original Message- > From: Anzak Wolf [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 6:09 PM > To: [EMAIL PROTECTED] > Subject: [PHP] POST/GET var problem > > take the following html code &

RE: [PHP] POST Arrays with register globals..

$_POST['groups'] is an array. It's size is going to be dependant on how many check boxes were checked. So, in your example, if only blah2 is selected, you'll have $_POST['groups'][0] == '2' You can use count($_POST['groups']) t

RE: [PHP] Re: Querying for MAX

Show your code and learn how to use the MySQL_fetch_array() function... www.php.net/mysql_fetch_array ---John Holmes... > -Original Message- > From: César Aracena [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 6:19 PM > To: PHP DB List; PHP General List > Su

RE: [PHP] safe scripting

Restart apache. > -Original Message- > From: Georgie Casey [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 8:52 PM > To: [EMAIL PROTECTED] > Subject: [PHP] safe scripting > > How do i setup safe mode scripting (each script has a different uid) on my > win32, apache, php setup

RE: [PHP] Value of variable with name stored in another variable

Echo $$field; --John Holmes... > -Original Message- > From: Daniele Baroncelli [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 13, 2002 12:27 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Value of variable with name stored in another variable > > How can I

RE: [PHP] PHP with No Web Server?

;t do much good. For anyone else to see your PHP creations, yes, you need a web server. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Re: how can i insert date

INSERT INTO table (date_column) VALUES ('$insert'); If you're using a varchar() type column, then that'll work. If it's a DATE/DATETIME/etc... column in your DB, then you have to format it in the DB format... What DB are you using? ---John Holmes... > -

RE: [PHP] Varible Varibles

ou think of with variable variables could be better solved by using arrays. ---John Holmes... > -Original Message- > From: Peter [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 10:42 PM > To: Php > Subject: [PHP] Varible Varibles > > howdy, > I'm just c

RE: [PHP] possible to add a "record number" to a query?

You can do it with two queries. SELECT @a:=0; SELECT @a:=@a+1, * FROM table; This would be better taken to a MySQL list, though. Actually, you never said what DB you were using. This works in MySQL. ---John Holmes... > -Original Message- > From: Jeff Field [mailto:[EMAIL PRO

RE: [PHP] possible to add a "record number" to a query?

You can use SET @a=0; Instead of the first SELECT, too. ---John Holmes... > -Original Message- > From: John Holmes [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 13, 2002 12:44 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: [PHP] possible to add a "

RE: [PHP] MySQL Query Help!!!!

ate_m,detail_start_date_d,detail_star t_time_h,detail_start_time_m' <= '$ttwo' You are comparing the literal string of 'detail... ' is less than or equal to a string like '200203041234' or something. That's going to fail. You need to go back to your SQL books... ---Joh

RE: [PHP] Extracting from an Array

Step through your code. What value does $rexpiry have? What do you see when you do print_r($Date) ?? Troubleshoot... ---John Holmes... > -Original Message- > From: Andre Dubuc [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 10:36 PM > To: [EMAIL PROTECTED]

RE: [PHP] MySQL Query Help!!!!

for help and people might be nice enough to offer any kind of answer they want. If it's not to your liking, restate your question and ask again or ignore them. If you can't do that, then go away and keep learning on your own, we don't have to help you. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Dreamweaver MX?

Yes, download it and see. Gives you a GUI to program recordsets from the database, and drag and drop for results. Other PHP stuff along with highlighting built in. If it didn't cost so much, I'd recommend it. ---John Holmes... > -Original Message- > From: Lazor, E

RE: [PHP] closing mysql connections

Use it in your code; it'd be a good programming habit to get into. --John Holmes... > -Original Message- > From: David McInnis [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 12:57 PM > To: [EMAIL PROTECTED] > Subject: [PHP] closing mysql connections >

RE: [PHP] row pointer

Keep track of it yourself as you loop through the data. Maybe if you explained what you need "overall" then we could suggest a method... ---John Holmes... > -Original Message- > From: Zac Hillier [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 14, 2002 3:59 AM >

RE: [PHP] massive find/replace on MySQL db

Yeah, do it all with regular queries. You shouldn't have to do any replacing in PHP. You can even use the MySQL regular expressions in your query for some more complex matching and replacing... It's all in the manual... ---John Holmes... > -Original Message- > Fr

RE: [PHP] Determine week

d you'll have the start of the week. 6 minus the result of date('w'), added to the day component of mktime(), will give you the end... HTH, ---John Holmes... > -Original Message- > From: Rosen [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 15, 2002 7:55 PM &

RE: [PHP] get a html page and save it to a file

Fopen("http://www.example.com/page.html","r";); Or File(http://www.example.com.page.html); My email program might mess up that code...either way, just use fopen() or file() to open the page, read it into a variable, then write that variable somewhere on your own syste

RE: [PHP] Help on including cgi scripts into php documents.

Take a look at virtual() www.php.net/virtual ---John Holmes... > -Original Message- > From: Vegitas Pride [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 16, 2002 2:54 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Help on including cgi scripts into php documents. >

RE: [PHP] URGENT

tually being sent to MySQL. ---John Holmes... > -Original Message- > From: Phil Reid [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 7:33 PM > To: [EMAIL PROTECTED] > Subject: [PHP] URGENT > > I am in urgent need of help! (AGAIN) > > Can anyone spot anythi

RE: [PHP] table porblem in netscape!!

background...heh... You ever look at your old code and realize how funny it is... ?? ---John Holmes... > -Original Message- > From: Anil Garg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 5:35 PM > To: [EMAIL PROTECTED] > Subject: [PHP] table porblem in netscape!! >

RE: [PHP] disable ability to download image?

ing to the picture, there are ways to handle that in .htacess and PHP. ---John Holmes... > -Original Message- > From: Steph [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 18, 2002 5:14 PM > To: Php-General > Subject: [PHP] disable ability to download image? > > Is t

RE: [PHP] How do I hide download link ...

Depends what you're protecting. If someone wants it bad enough, they'll find it. It's like using a "really hard to guess password" and then leaving your box open to the world to guess at... ---John Holmes... > -Original Message- > From: Fargo Lee [m

RE: [PHP] Incoming Development

set a session variable like 'logged-in'. On every other page, check for this variable. If it exists, they are logged in, if not, then redirect to the log in page. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] catch the client OS user logon from php script

Look at a phpinfo(); page. All of the variables you can get are shown there. Look for the one you want. ---John Holmes... > -Original Message- > From: èdy kurniawan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 19, 2002 4:44 AM > To: [EMAIL PROTECTED] > Subject:

RE: [PHP] read how many caracter

> i want read how caracter from onepage like this > > asasassasa > sasassasa > sasasassas > sasassasasa > sasasassasa Yes, I want to one give you answer like this, okay? Thanks, no. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Stumped on a function

Why don't you just use DATE_FORMAT() in your query, then you don't have to do any extra PHP code at all?? ---John Holmes... > -Original Message- > From: Jason Soza [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 21, 2002 3:50 AM > To: PHP-General Mailing List >

RE: [PHP] Mysql Insert from select problem with php

e varchar(20)); Query OK, 0 rows affected (0.02 sec) mysql> insert into list values (1,'John'),(2,'O\'Hare'),(3,'Smith'); Query OK, 3 rows affected (0.02 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql> select * from list; +--+----+

RE: [PHP] How can I output a query in a table with the output in multiple columns?

tval .= "\n"; } $count++; } //this will finish the table, i.e. if you only have one //name on last row, this will fill in the remaining table //cells $left = $Num_Across - (--$count % $Num_Across); for($x=0;$x<$left;$x++) { echo " \n"; } That last part isn't test

RE: [PHP] mass sql update array

Can you add a checkbox to say "update this row", then just check for checked checkboxes....?? ---John Holmes... > -Original Message- > From: Daniel Hoffman [mailto:[EMAIL PROTECTED]] > Sent: Friday, June 21, 2002 9:28 PM > To: [EMAIL PROTECTED] > Subject: [P

RE: [PHP] Current date & time in MySQL datetime format

Use NOW() in your query... INSERT INTO table VALUES (NOW()),'John'); ---John Holmes... > -Original Message- > From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 22, 2002 12:56 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Current date &

[PHP] Anyone have slides for an Intro to PHP Class?

rn through actual programming from there. Does anyone have a presentation like this? My audience will be people that have an HTML knowledge and possibly a c/c++ introduction. Thanks for any help. ---John Holmes.

RE: [PHP] PHP 4.2

You can use the HTTP_*_VARS for now, but they are depreciated. They will work right now on most any version of PHP. I would just maintain two different versions, one for PHP 4.2+ and one for earlier versions. Sure, it's a little more of a pain...though... ---John Holmes... > -

RE: [PHP] Insert an array into MySQL

, just for the checkboxes. Also, what does your CREATE TABLE look like for the table your trying to insert this data into? ---John Holmes... > -Original Message- > From: Rob Packer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 23, 2002 7:50 AM > To: [EMAIL PROTECTED] > Subje

RE: [PHP] Remote cgi script function

page. http://www.example.com/cgi-bin/script.cgi?text="; . $ftext, "r"); while($data = fread($fp,1000)) { $contents .= $data; } fclose ($fd); ?> The response is now in $contents. Adapt to your needs. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscr

RE: [PHP] Error(Newbie)

magic quotes or by addslashes(), then he's open to getting bad data inserted into his table... If magic_quotes_gpc is ON, then you're fine... ---John Holmes... > Chris > > 1LT John W. Holmes wrote: > > >Yeah, magic_quotes will be enough, but it only handles GET, POS

RE: [PHP] Limiting text inputs by character count?

The best way to do this is server side with strlen(). You can use javascript or maxlength, but if a user wants to get around it, they can. ---John Holmes... > -Original Message- > From: Martin Towell [mailto:[EMAIL PROTECTED]] > Sent: Sunday, June 23, 2002 9:47 PM >

RE: [PHP] Time Delay using phpscript

ay at all. Best you could do is output some JavaScript along with your HTML and attempt to control it that way. Basically, since you already know how to do it with JavaScript, have PHP write the JavaScript for you... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To un

RE: [PHP] copying the structure of a blank table in mysql

> Anyone have a link (or the code) to copy the structure of a blank table > to a new table using mysql? Untested, add in some error checking and validate the $old and $new names, and adapt to your needs... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsub

RE: [PHP] URGENT!!! File Uplaod

> You're completely right - as usual - now for the file handling... what's > better? Storing it to the DB or as file?? File -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Compile error.

> Using the 4.2.1 source available from the main downloads page, I'm > getting: > php_functions.c:93:27: missing binary operator before '!' You get an error when you do what? Unzip the source, compile it, run it, load a .php page, crap your pants??? ---John Holmes...

RE: [PHP] PHP server error...

Check your session.save_path in PHP.ini. If you don't have a PHP.ini, make one from PHP-ini.dist or PHP-ini.recommended ---John Holmes... > -Original Message- > From: Phil Schwarzmann [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 24, 2002 5:30 PM > To: [EMAIL PRO

RE: [PHP] Lost, need help debuggin....

U...what was the question again? John "you're not paying us" Holmes > -Original Message- > From: Chuck "PUP" Payne [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 24, 2002 7:46 PM > To: PHP General > Subject: Re: [PHP] Lost, need help debug

RE: [PHP] newbie on security

it's worth paying for. And if it's worth protecting, it's worth cracking into so you don't have the protection... What do you have that you think is so good? There are plenty of programs that release open source code and do well... ---John Holmes... -- PHP General Mailing

RE: [PHP] finding the highest primary key in a table

> I want to find the number of the highest primary key in a particular > MySQL table. SELECT MAX(ID) FROM table Can you tell us why you need to do this? I have a feeling you're doing something bad... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubsc

Re: [PHP] Re: Re: PHP 4.2

I use http://php.net/strnatcasecmp since version_compare is only available since 4.1.0, which is rather self-defeating :-) "Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > You mean like php.net/version_compare ? > > On Mon, 24 Jun 2002, Dreamriv

RE: [PHP] Easy Date & MySQL Question...

Look it up in the MySQL manual, chapter 6: Date and Time Functions... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Downloading Files

even try this if you're not going to validate the download directory and filename... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Seperating presentation from logic

7;s not exactly like that, mind you, but you get the idea. You can't ever completely separate you designers and programmers. What you do is provide an easy to understand way for your designers to include the programming elements. What's easier, teaching them to put or {name} in the do

RE: [PHP] Print a char from a variable number

Why not use str_repeat()? www.php.net/str_repeat ---John Holmes... > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, June 25, 2002 11:45 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Print a char from a variable number > > He

RE: [PHP] Automated Downloads WAS File Retrieval, unusual

. > > I hope to do this via a stand alone PHP executable called by a CRON on a > daily basis. Any ideas for passing the three variables to the login page > and > activating the login? > [/snip] > > More thoughts, could I pass the needed information in an HTTP header > f

RE: [PHP] using variables in a function within a fuction

> function test1() > {$hello="hello";} > > function test2() > {test1(); > print $hello;} > > test2(); > > ?> > This should print hello. But it does'nt work. Any idea? Read here to find out why: http://www.php.net/manual/en/language.varia

RE: [PHP] Re: MySQL Problem with PHP

> I just preg_replace("/\'/","\'",$text) and all was good :o) That's what addslashes() is for. It handles single and double quotes, backslashes, and nulls, so you won't have any problems... ---John Holmes... -- PHP General Mailing List (http:

RE: [PHP] Seperating presentation from logic

to XSL, but I haven't seen any speed comparisons on it. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Require()

oint is available to the included/required file. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Seperating presentation from logic

's why you use templates... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL Problem with PHP

is',char(39),'that'); ++ | concat('this',char(39),'that') | +----+ | this'that | ++ 1 row in set (0.01 sec) ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] MySQL query time

27;s not the actual time of the query, but it's the best you can get. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Security problem?

home/user/includes/myfile.php'); Works just as well as Include('/home/user/www/includes/myfile.php'); Where /home/user/www is your web root. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] 4.2.1 installation under WIN2k with IIS - Extensions just won't work

is an nable to load module error on the client browser and on the systems console. I've copied dll's 'til I'm blue in the face but am getting no-where fast. any thoughts would be gratefully appreciated. Best Wishes, John Brown. Host Europe System Administration. Host Eu

RE: [PHP] Re: redeclaring functions

7;t have two functions with the same name. Period. Use some logic when you're programming and rethink your solution. Use function_exists() before each function declaration so you don't declare it twice? Are both functions exactly the same? ---John Holmes.. -- PHP General Maili

RE: [PHP] Seperating presentation from logic

w. It's a simple unzip and run, everything is all packaged together. Results may vary on different servers; I'd like to see a *nix/Apache result set posted... Tested on Win2K / 1Ghz AMD / 512MB RAM / IIS 5.0 / PHP 4.2.1 (ISAPI Module), YRMV ---John Holmes... TEST 1.1 :: 20 registered var

RE: [PHP] MySQL fetch data

ing such things if I have to, that way I'm not wasting a bunch of memory in PHP by creating these huge arrays... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Accessing cookies in required files

Function whatever() { global $testcookie; or global $HTTP_COOKIE_VARS; or upgrade your PHP and jus use $_COOKIE['testcookie'] and it's always available, regardless of scope. ---John Holmes... > -Original Message- > From: Chris Morrow [mailto:[EMAIL PROTECT

RE: [PHP] Newbie problem - Slashes

Show us your code. ---John Holmes... > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 5:33 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: [PHP] Newbie problem - Slashes >

RE: [PHP] preg_replace pains

Wouldn't you want to use preg_match() before you replace it? www.php.net/preg_match ---John Holmes... > -Original Message- > From: Richard Davey [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 9:37 PM > To: [EMAIL PROTECTED] > Subject: [PHP] preg_repla

RE: [PHP] SESSION's from common computers

or the new computer, they'll have to start a new session there automatically, because they won't have the same cookie matching the session ID from the first computer. ---John Holmes... > -Original Message- > From: César Aracena [mailto:[EMAIL PROTECTED]] > Sent: Saturda

RE: [PHP] SESSION's from common computers

erson log in. ---John Holmes... > -Original Message- > From: César Aracena [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 29, 2002 2:11 AM > To: 'PHP General List' > Subject: RE: [PHP] SESSION's from common computers > > Got it but... What happens i

RE: [PHP] ASP style "application-level" variables

e the auto_append_file and auto_prepend_file settings of PHP.ini. Make that file load the application variables from the database, and the prepend file saves any changes... ---John Holmes... > -Original Message- > From: Lee [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 29, 2002 11:11 A

RE: [PHP] ASP style "application-level" variables

> Make that file load the application variables from the database, and the > prepend file saves any changes... errr...prepend loads...append save. Damn English language... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Limiting number of decimal places reported

How do I limit the number of decimal places returned in this query? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Limiting number of decimal places reported

ed from a query like that without a GROUP BY clause. Also, you don't need the quotes around $order_total when printing it out. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Javascript to PHP?

Not possible. You must refresh the page to send something back to PHP. Only workaround is using a hidden frame or layer and refreshing that... ---John Holmes... > -Original Message- > From: Jed Verity [mailto:[EMAIL PROTECTED]] > Sent: Saturday, June 29, 2002 3:14 PM >

<    3   4   5   6   7   8   9   10   11   12   >