Re: [PHP-DB] question about '

2003-07-18 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hi there, > > The problem is the data is already in the DB, it was mass-added with the ' > already there, what I need is a way to retrieve the ' that is already in the > DB. > > Thanks > > Chris > > > yes, by adding stripslashes it wi

Re: [PHP-DB] question about '

2003-07-11 Thread Chris Payne
Hi there, The problem is the data is already in the DB, it was mass-added with the ' already there, what I need is a way to retrieve the ' that is already in the DB. Thanks Chris > yes, by adding stripslashes it will somewhat escape those quotes ('), > but when displaying the results there will

Re: [PHP-DB] question about '

2003-07-11 Thread Shahmat Dahlan
yes, by adding stripslashes it will somewhat escape those quotes ('), but when displaying the results there will not be any need to do so. unless it is your wish to actually store the backslash into the db. Jerry wrote: I think you should use addslashes to store the text in the database and the

RE: [PHP-DB] question about '

2003-07-11 Thread Jerry
I think you should use addslashes to store the text in the database and then stripslashes when displaying the text. I think that should work, but I'm new to PHP so I might be wrong. Jerry -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Saturday, July 12, 2003 2:11 P

RE: [PHP-DB] Question concerning hostnames

2003-02-26 Thread Gary . Every
The only way to do that is through the use of frames. You can have two frames in your html doc, one that holds nothing, and the other that holds the redirection info. When someone comes to the site www.pagetwo.com the second frame (that occupies 99.9% of the browser) redirects the page to www.pageo

Re: [PHP-DB] Question about replacing large textfields

2003-02-14 Thread Doug Thompson
http://www.hotscripts.com/PHP/ One example: http://www.hotscripts.com/Detailed/9026.html Good luck, Doug On Fri, 14 Feb 2003 16:09:34 +0100, Ingen, Wart van wrote: >Hi there, > >I'm looking for a way to let people without any knowledge of coding replace >large fields of text and images on thei

Re: [PHP-DB] question about access

2003-02-10 Thread Doug Thompson
If your client's friend wants to do learning/development, let him load PHPTriad, FoxServ, or one of the other trinity setups onto his computer. It is truly remarkable that you/your company would even consider such a request for longer than it takes to say: Never in a million years. Also, if I wer

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Jason Wong
On Thursday 30 January 2003 08:59, Louis Feng wrote: > Thanks for your help. The machine [A] is running MySQL is Not behind a > firewall, therefore all connection to [A] works fine (including 3306). > The machine [B] running PHP/apache is behind a firewall, and only port > 80 is open on [B]. If I

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Louis Feng
lt;[EMAIL PROTECTED]>* 01/29/2003 07:11 PM To: [EMAIL PROTECTED] cc: Matt Vos <[EMAIL PROTECTED]>, Louis Feng <[EMAIL PROTECTED]>, [EMAIL PROTECTED] bcc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL Thanks for reply, I'm going to try that,

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Louis Feng
t.com> cc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Jeffrey_N_Dyke
com> cc: Subject: Re: [PHP-DB] Question on the port PHP uses to connect to 01/29/2003remote MySQL

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-29 Thread Matt Vos
In a default setup, I believe the port is 3306. Check your MySQL config files, as this can be changed. Matt - Original Message - From: Louis Feng <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 10:34 PM Subject: [PHP-DB] Question on the port PHP uses to connect

Re: [PHP-DB] Question on the port PHP uses to connect to remote MySQL

2003-01-28 Thread Jason Wong
On Wednesday 29 January 2003 11:34, Louis Feng wrote: > Here is my problem. I have PHP running on one machine, mysql on another > one. Everything works fine till I put a firewall on the PHP machine, > which blocks pretty much every port there is except port 80. Now, PHP > can't connect to the mysql

RE: [PHP-DB] Question

2002-11-06 Thread Josh Johnson
This isn't the place for discussions of php development, I think php-dev is what you want... but ah, PHP is a full-blown programming language, even under widnows. http://www.php.net/manual/sv/features.commandline.php <-- check this page out You can write shell scripts with it, associate windows

Re: [PHP-DB] Question

2002-11-06 Thread Marco Tabini
Well, you can already do that--just download and install the CGI version. Unless, of course, you meant that you want to write Windows GUI applications, in which case I think someone is working on something like that with PHP-GTK. Oh, the attachments are either quoted messages or patches, for the

RE: [PHP-DB] question regarding date format

2002-09-17 Thread Smita Manohar
>To: 'Smita Manohar' <[EMAIL PROTECTED]>, [EMAIL PROTECTED] >Subject: RE: [PHP-DB] question regarding date format >Date: Mon, 16 Sep 2002 18:40:06 +0100 > > > -Original Message- > > From: Smita Manohar [mailto:[EMAIL PROTECTED]] > > Sent: 16 Sep

Re: [PHP-DB] Question

2002-06-24 Thread Tracker 1
in this instance, where a computer isn't likely to contain more than x drives, it may work, however, if he wants to later include sn's, and mfg's a separate table would be better.. :) -- === Michael J. Ryan - tracker1[*at*]ther

Re: [PHP-DB] Question

2002-06-23 Thread Mike Tuller
To: "Mike Tuller" <[EMAIL PROTECTED]>, "Chris Barnes" > <[EMAIL PROTECTED]>, "Php-Db (E-mail)" <[EMAIL PROTECTED]> > Subject: RE: [PHP-DB] Question > > Hi > > The correct way, IMHO, would be to consider the situation. The hard drives > ar

RE: [PHP-DB] Question

2002-06-23 Thread Peter Lovatt
3 June 2002 21:07 > To: Chris Barnes; Php-Db (E-mail) > Subject: Re: [PHP-DB] Question > > > That would probably work, but only for what I want right now. If I ever > wanted to create a report of all the hard drives I have, it would become > more difficult. > > I know I need

Re: [PHP-DB] Question

2002-06-23 Thread Mike Tuller
05:03:53 +1000 > To: "Php-Db \(E-mail\)" <[EMAIL PROTECTED]> > Subject: RE: [PHP-DB] Question > > i dont know how will this will work, but you could try storing the multiple > hard disk details for each computer in an "array" in 1 field. > then when you want to

RE: [PHP-DB] Question

2002-06-23 Thread Chris Barnes
i dont know how will this will work, but you could try storing the multiple hard disk details for each computer in an "array" in 1 field. then when you want to get the information from the db, use explode() to store the value in the field into an array again. e.g. the field in the DB might look l

Re: [PHP-DB] Question

2002-06-23 Thread Duncan Hill
On Sun, 23 Jun 2002, Mike Tuller wrote: > I know I will need to create a separate table to hold information about > the drives, and connect them to the computer by attaching the primary key > of the drives table to the Computer table. Good, you know a bit about normalisation. But, not enough.

Re: [PHP-DB] Question about Load Data to mysql through php

2002-04-30 Thread Jason Wong
On Tuesday 30 April 2002 16:56, Jack wrote: > Dear Jason > Thx for the reply, but do you know where i should copy that file to in > serverside? > is it got to be the same directory of mysql? It doesn't matter where as long as it is readable by the process running PHP (ie the process running your

Re: [PHP-DB] Question about Load Data to mysql through php

2002-04-30 Thread Jack
TED]> Sent: Tuesday, April 30, 2002 2:45 PM Subject: Re: [PHP-DB] Question about Load Data to mysql through php > On Tuesday 30 April 2002 14:33, Jack wrote: > > Dear all > > i'm a newbie in mysql, but there is one question about LOAD Data command in > > mysql, let s

Re: [PHP-DB] Question about Load Data to mysql through php

2002-04-29 Thread Jason Wong
On Tuesday 30 April 2002 14:33, Jack wrote: > Dear all > i'm a newbie in mysql, but there is one question about LOAD Data command in > mysql, let say if i had a CSV file in client side and i want to load this > file's data into particular table , so do i need to copy this CSV file into > Web serve

RE: [PHP-DB] Question about PHP Arrays syntax

2002-04-22 Thread Vania Smrkovski
> Hello, folks, and I apologize in advance if I break any rules here. This > is my first post on this list and I couldn't find any archive to review > existing posts for the answer to this question. http://www.php.net/mailing-lists.php Thanks for the URL. I feel stupid for having missed it, c

Re: [PHP-DB] Question about PHP Arrays syntax

2002-04-21 Thread pan
From: "Vania Smrkovski" <[EMAIL PROTECTED]> > host with PHP and MySQL support. > > a) How would you change the following the automatically find the tables and > run through the iteration. You should rtfm as php/mysql makes a lot of the torturous VB/MS/Access methods very simple. All the function

Re: [PHP-DB] Question about PHP Arrays syntax

2002-04-21 Thread Jason Wong
On Monday 22 April 2002 12:54, Vania Smrkovski wrote: > Hello, folks, and I apologize in advance if I break any rules here. This > is my first post on this list and I couldn't find any archive to review > existing posts for the answer to this question. http://www.php.net/mailing-lists.php > a)

Re: [PHP-DB] Question about setting up multiple relations

2002-02-28 Thread Paul Burney
on 2/28/02 2:21 AM, Monty at [EMAIL PROTECTED] appended the following bits to my mbox: > I have an Image table in a MySQL database that will be used to store the > location of all images used on my site. Some images will relate to an > Article table (article.id) and some images may relate to a Me

Re: [PHP-DB] Question about advanced SQL

2002-02-27 Thread Sommai Fongnamthip
Hi, I assumed that you was used MySQL for database. With MySQL you can used this SQL to find different row select tblcd.* from tblcd left join tblorder on tblcd.cdid=tblorder.cdid where tblorder.cdid is null sommai At 12:37 28/2/2002 +1000, Adam Royle wrote: >Hi. > >I need

Re: [PHP-DB] Question about advanced SQL

2002-02-27 Thread Bill Morrow
select * from tblCd where cdId not in (select distinct cdId from tblOrders); On Thu, Feb 28, 2002 at 12:37:49PM +1000, Adam Royle wrote: > Hi. > > I need some guidance for writing an effective query (instead of processing > through PHP). > > I lets says I have two tables, tblCDs and tblOrders.

RE: [PHP-DB] Question about advanced SQL

2002-02-27 Thread Kearns, Terry
SELECT tblCD.cdID, tblCD.cdTitle, tblCD.cdArtist FROM tblCD, tblOrders WHERE tblOrders.cdID = tblCD.cdID AND tblCD.cdID NOT IN ( SELECT cdID FROM tblOrders ) The support for this sort of "nested query" will very betwe

RE: [PHP-DB] question

2001-12-12 Thread David Piasecki
If you know what your result set is going to be, it would be easier to do something like this: list($firstname,$lastname,$midinitial,$preferredname,$address1,$address2 ,$city,$state,$zip) = mysql_fetch_row($result); Or if you are returning more then one row, and want to loop through the results:

Re: [PHP-DB] question

2001-12-12 Thread Robert Weeks
Yup, I knew it was something really simple. I should never touch a computer before the coffee is brewed ;-) Thanks! Robert On Wednesday, December 12, 2001, at 11:09 AM, Steve Cayford wrote: > > Do you want $$fname = $val here? Taking the string in $fname as the > name of a variable to which

Re: [PHP-DB] question

2001-12-12 Thread Steve Cayford
On Wednesday, December 12, 2001, at 09:03 AM, Robert Weeks wrote: > Hi, > > I'm a little stumped here, maybe I haven't had enough coffee yet... > > Anyway, I have a lot of SQL queries that return one row if there is a > match > and instead of having to write out something like this: > > $f

Re: [PHP-DB] Question in french about IMG SRC

2001-10-19 Thread DL Neil
"; break; } } ?> je souhaite faire apparait une l'image ki est donné dans ma base pour $colonne2["IMG"]>. Il m'affiche bien le bon texte qd je met echo $colonne2["IMG"]; , mais j'aimerai qu'il mettent cette valeur en img src. J'espere etre assez clair :) David, J

[PHP-DB] RE : [PHP-DB] Question In French.

2001-10-18 Thread david1980
Super, les 2 versions marchent. Merci David -Message d'origine- De : Bas Jobsen [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 18 octobre 2001 11:35 À : david1980; [EMAIL PROTECTED] Objet : Re: [PHP-DB] Question In French. -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Question In French.

2001-10-18 Thread Bas Jobsen
-- 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] Question In French.

2001-10-18 Thread George Lioumis
Il faut tu ecrire: if ($colonne["LIV_TYPE_EVT"] == 21) { $couleur = "yellow"; } else if ($colonne["LIV_TYPE_EVT"] == 1) { $couleur = "009933"; } else { $couleur = "FF"; } Georges Lioumis.

Re: [PHP-DB] Question on how to test a value

2001-07-26 Thread Dobromir Velev
Hi, even if there was no data in the price field when the form was submited the $price variable exists and isset($price) returns true. May be you could try !empty($price) instead of isset($price) - Something like. $query7 = !empty($price) ? "INSERT INTO price (itemid, price) VALUES ($itemid, '$pr

Re: [PHP-DB] Question regarding php and mysql with binary data...

2001-07-25 Thread Mitrana Cristian
Koutsogiannopoulos Karolos wrote: >Hello Again everyone... > >My question is simple... > >I have images submited IN my mysql Database. >What i want is when i display them and i right click on them and choose save >picture as i can get the name of the >picture from the DB and not have to insert i

Re: [PHP-DB] Question regarding php and mysql with binary data...

2001-07-24 Thread leo g. divinagracia iii
the web page that is generated, does the HREF tag supply a name? and at least for my netscrape 4.7x, whenever i right click on an image, it uses that name on the dialog box that pops up, prompting me where and how to save it as... btw, why save images on a table? wouldnt saving the URL better?

RE: [PHP-DB] Question about strlen .. I think

2001-07-16 Thread Ben Bleything
You could split the string on the slashes with explode('/',$string) and then manipulate the array elements you get back. Good luck, Ben -Original Message- From: Dennis Kaandorp [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 15, 2001 9:21 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Questio

Re: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-22 Thread Thies C. Arntzen
On Tue, May 22, 2001 at 09:41:25AM +0900, Michael Cheung wrote: > > On Mon, 21 May 2001 16:39:05 +0200 > "Thies C. Arntzen" <[EMAIL PROTECTED]> wrote: > > > On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote: > > > Hi; > > > Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface

Re: [PHP-DB] question about OCIBindByName(add some comment)

2001-05-21 Thread Thies C. Arntzen
On Mon, May 21, 2001 at 11:35:36PM +0900, Michael Cheung wrote: > Hi; > Linux 2.2.18 + oracle 8.1.7i + php-4.0.5 + oci8 interface. > > I use the following lines to get a result from database; > But It give me result 0, it is incorrect; > > $sql="Select count(*) From member wher

Re: [PHP-DB] question ! show binary

2001-01-31 Thread James Smith
The way you have it now, ur just storing the path to the gif. from the form field, use then in the insert area use: $result = mysql_query("insert into (filename) VALUES ('$file')") James --- Yui Hiroaki <[EMAIL PROTECTED]> wrote: > HI! > > I am using PHP in mySQL. I create table in datab

Re: [PHP-DB] Question about using php with Microsoft SQL server

2001-01-23 Thread signup
> Hello, I'm trying to use the mssql_connect function to connect to the > Microsoft SQL server with php4.0.3pl1 for window, but the return is "Fatal > error: Call to undefined function: mssql_connect()". And another mssql > function are also with the same result, but I have try use the mysql and >

Re: [PHP-DB] Question, using Interbase on Win32 platform, please help...

2001-01-17 Thread JJeffman
Check if the 'php_interbase.dll' is present and in the proper location. Jayme. http://www.conex.com.br/jjeffman -Mensagem Original- De: Kyoungsub, Wee <[EMAIL PROTECTED]> Para: PHP DB Mailing <[EMAIL PROTECTED]> Enviada em: quarta-feira, 17 de janeiro de 2001 16:40 Assunto: [PHP-DB]

<    1   2