Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Michael Stowe
Can we kill this thread? Or can you guys continue the conversation between yourselves. We now have 8 emails pertaining to the technical question, and 8 emails ranting about him asking it. I understand that some people do not believe this is the appropriate forum for that question - but personal

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Jim Giner
On 6/18/2014 2:16 PM, Aziz Saleh wrote: On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers wrote: Sent from losPhone On Jun 18, 2014, at 7:56 AM, Jim Giner wrote: On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Aziz Saleh
On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers wrote: > > > Sent from losPhone > > > On Jun 18, 2014, at 7:56 AM, Jim Giner > wrote: > > > >> On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: > >>> On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: > >>> Hi Ethan, > >>> > >>> Here are some

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Karl DeSaulniers
Sent from losPhone > On Jun 18, 2014, at 7:56 AM, Jim Giner wrote: > >> On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: >>> On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: >>> Hi Ethan, >>> >>> Here are some things to clean up your code: >>> >>> Your line: >>> >>> $phn = $_POST[phone

Re: [PHP-DB] Newbie Question $2

2014-06-18 Thread Jim Giner
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote: On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname fr

Re: [PHP-DB] Newbie Question $2

2014-06-17 Thread Ethan Rosenberg, PhD
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote: Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname from Customers where Phone = $Phn '; Should use doubl

Re: [PHP-DB] Newbie Question $2

2014-06-17 Thread onatawah...@yahoo.ca
Hi Ethan, Here are some things to clean up your code: Your line: $phn = $_POST[phone]; should use quotations as follows: $phn = $_POST['phone']; Your line: $sql1 ='select Lname, Fname from Customers where Phone = $Phn '; Should use double quotes if you need the variable to be interpreted:

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Mike Stowe
Oh a few quick things. First, you can use substr to break up the phone instead of grabbing characters- might be a little easier to read long term. Secondly, mysql_real_escape_string will return the cleaned string, but doesn't change the original variable. So you'll need $phn = mysql_real_esc

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Karl DeSaulniers
On Jun 16, 2014, at 10:05 PM, Karl DeSaulniers wrote: > On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg > wrote: > >> Dear List - >> >> I have the following code: >> >> The input from the form is a 10 digit string [1234567890] which is converted >> to phone number format [123-456-7890] >> >>

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Aziz Saleh
On Mon, Jun 16, 2014 at 10:58 PM, Ethan Rosenberg < erosenb...@hygeiabiomedical.com> wrote: > Dear List - > > I have the following code: > > The input from the form is a 10 digit string [1234567890] which is > converted to phone number format [123-456-7890] > > $phn = $_POST[phone]; > $phn = (str

Re: [PHP-DB] Newbie Question $2

2014-06-16 Thread Karl DeSaulniers
On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg wrote: > Dear List - > > I have the following code: > > The input from the form is a 10 digit string [1234567890] which is converted > to phone number format [123-456-7890] > > $phn = $_POST[phone]; > $phn = (string)$phn; > $dsh = '-'; > $Phn = >

[PHP-DB] Newbie Question $2

2014-06-16 Thread Ethan Rosenberg
Dear List - I have the following code: The input from the form is a 10 digit string [1234567890] which is converted to phone number format [123-456-7890] $phn = $_POST[phone]; $phn = (string)$phn; $dsh = '-'; $Phn = $phn[0].$phn[1].$phn[2].$dsh.$phn[3].$phn[4].$phn[5].$dsh.$phn[6].$phn[7]

[PHP-DB] Newbie question on MDB2 error handling

2009-06-01 Thread P.A.
Hello all, I am quite new to php and especially MDB2 package. Despite some thorough research I could not find an answer yet. When I try to connect to a database using MDB2::connect method, and the database server is not running, I only get an error code of -1 and a message saying "MDB2 Error:

[PHP-DB] newbie question on PHP & Mysql...

2005-09-21 Thread Evert Meulie
Hi all! I'm taking my first steps with PHP & MySQL. Can anyone give me a hint on why this would not work? * $result = mysql_query('SELECT SUM(AcctInputOctets), SUM(AcctOutputOctets) FROM radacct WHERE username = $argv[1] '); echo mysql_result($result,0), "\n"; echo mysql_

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
or user ''@'localhost' to database > > 'mydb' > > > > So I think that the username is not interpreted at all. Why not? > > > > Regards, > > > > Chris > > > > Am Fr, den 24.09.2004 um 13:43 Uhr +0100 schrieb Peter Lovatt: > &

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Pablo M. Rivas
> > So I think that the username is not interpreted at all. Why not? > > Regards, > > Chris > > Am Fr, den 24.09.2004 um 13:43 Uhr +0100 schrieb Peter Lovatt: > > > > Hi > > > > try $db = mysql_connect("localhost", "myuser","m

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
t; > > -Original Message- > > From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] > > Sent: 24 September 2004 13:31 > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Newbie Question - mysql_select_db fails with access > > denied. > > > &

RE: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Peter Lovatt
Hi try $db = mysql_connect("localhost", "myuser","mypassword") - without it you are not submitting a password Peter > -Original Message- > From: Christian Schlaefcke [mailto:[EMAIL PROTECTED] > Sent: 24 September 2004 13:31 > To: [EMAIL PROT

Re: [PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread John
This might be a stupid idea, but did you remember to issue the Flush Privelages; command to the mysql database after granting your user all the rights? --John Christian Schlaefcke <[EMAIL PROTECTED]> wrote: Hi Folks, I want to do something like the following: $db = mysql_connect("localhost",

[PHP-DB] Newbie Question - mysql_select_db fails with access denied.

2004-09-24 Thread Christian Schlaefcke
Hi Folks, I want to do something like the following: $db = mysql_connect("localhost", "myuser") or die("Connect failed : " . mysql_error()); mysql_select_db("mydb",$db) or die("SELECT_DB failed : " . mysql_error ()); $result = mysql_query("SELECT * FROM mytable", $db) or die("Query failed : " .

RE: [PHP-DB] Newbie question

2004-03-24 Thread Hutchins, Richard
Try: > -Original Message- > From: Gajo Csaba [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 24, 2004 4:10 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Newbie question > > > Hi! > I'm new to PHP, so this may be an easy question. I tried to make

[PHP-DB] Newbie question

2004-03-24 Thread Gajo Csaba
Hi! I'm new to PHP, so this may be an easy question. I tried to make a simple form-page, where the user enters his name, and on the following page it says "Hello $name". What happens is that on the second page it says soemthing like "unknown identifier $name". I'm using Apache 2 so that may be

Re: [PHP-DB] newbie question

2004-02-13 Thread Peter Beckman
On Fri, 13 Feb 2004, t wrote: > hi, > > i am relatively new to php and new to this email list. > > i have what i think are fairly simple questions about using mysql and > php. i have done some research and can't seem to find the answer i > need. > > # 1. i want to set the date format to display da

[PHP-DB] newbie question

2004-02-13 Thread t
hi, i am relatively new to php and new to this email list. i have what i think are fairly simple questions about using mysql and php. i have done some research and can't seem to find the answer i need. # 1. i want to set the date format to display dates in a format other than the standard mys

Re: [PHP-DB] newbie question on data accumulation

2003-11-12 Thread CPT John W. Holmes
From: "Joffrey Leevy" <[EMAIL PROTECTED]> > Curious as to what happens after data is repeatedly > selected from a mysql table overtime. Does it > accumulate as junk data, stored at some location and > eventually slow down the database/program/server? > Does any purging have to take place? I woul

[PHP-DB] newbie question on data accumulation

2003-11-12 Thread Joffrey Leevy
Hi all: Curious as to what happens after data is repeatedly selected from a mysql table overtime. Does it accumulate as junk data, stored at some location and eventually slow down the database/program/server? Does any purging have to take place? Thanks J __ Do y

RE: [PHP-DB] Newbie Question - PHP and MSACCESS

2003-02-17 Thread Gary . Every
//Place your request into a variable: $result = odbc_do($connection,"select * from events where id=$id"); $var = odbc_fetch_row($result); // Now you have an array to work on foreach($var as $line){ //Do your formatting thusly: echo ' ' . $line[0] . '

RE: [PHP-DB] Newbie Question - PHP and MSACCESS

2003-02-16 Thread Dennis Cole
$cnx = odbc_connect( 'DSN' , 'USER', 'PASS' ); if (!$cnx) { ?>Could not connect to ODBCmailto:[EMAIL PROTECTED]] Sent: Sunday, February 16, 2003 4:01 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Newbie Question - PHP and MSACCESS Hi, Am using php t

[PHP-DB] Newbie Question - PHP and MSACCESS

2003-02-16 Thread J.M. Cocchini
Hi, Am using php to open a customer's msaccess file. First time for everything. It's a very small database of less then 25 rows, and will always be this small. Am needing to return all the rows to a web page using php at all times. Very simplistic. Am apparently set up correctly on the DSN

RE: [PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Marcus Fleige
great! @ryan & josh: thank you for the quick answers! :-) marcus -- ^v^ [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Josh Johnson
-Mailinglist Subject: [PHP-DB] Newbie-Question: What's that @? hi there, i've got a general question about php-scripts: whats the difference between @mysql_query($query) and @mysql_query($query)? is it the same as in batch programming? like, ignore all return messages? thanks and gree

RE: [PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Ryan Jameson (USA)
t Subject: [PHP-DB] Newbie-Question: What's that @? hi there, i've got a general question about php-scripts: whats the difference between @mysql_query($query) and @mysql_query($query)? is it the same as in batch programming? like, ignore all return messages? thanks and greetings fr

[PHP-DB] Newbie-Question: What's that @?

2002-10-30 Thread Marcus Fleige
hi there, i've got a general question about php-scripts: whats the difference between @mysql_query($query) and @mysql_query($query)? is it the same as in batch programming? like, ignore all return messages? thanks and greetings from germany, marcus -- ^v^ [EMAIL PROTECTED] -- PHP Databa

[PHP-DB] ****Newbie Question****

2002-09-27 Thread Ron
I am use to running MySql & PHP but now I am running into a situation, where the website I am admin at is changing the server over to MSSql is the and easy way to convert all the existing data and webpages from MySql to MSSql. Any assistance with this would be greatly appreciated..TIA

[PHP-DB] ***Newbie Question***

2002-09-27 Thread Ron
I have an issue I need to see if I can resolve. I am and admin of a company website that uses MySql for the database, They are going to change the server to MSSql is there and easy way to convert on the existing Info over from MySql to MSSql any help would greatly be appreciated . TIA

[PHP-DB] newbie question: fetchrow or smth else ?

2002-02-01 Thread Alecs
Could some one please check the following code and guesstimate where am I wrong ? (the only thing I got from browser is: Fatal error: Call to undefined function: fetchrow() pc_list.php on line 14, but on that line I have fetchRow() not fetchrow(). To make it worse even when I am replacing f

[PHP-DB] newbie question: request & response

2002-01-30 Thread Luke Crouch
Does PHP have built-in support for using request and response objects? Thanks, -L -- 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] Newbie question - other way than insert statement?

2001-11-21 Thread Daniel Schwab
ok, thnx > No, but SQL is your friend *lol* greez daniel -- 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] Newbie question - other way than insert statement?

2001-11-20 Thread Miles Thompson
No, but SQL is your friend, and is actually easier than messing around with recordsets, once you get the hang of it. The exact form of your INSERT statement will depend a bit on the database are you using, but the following is typical. This is MySQL syntax, I believe PostgresSQL is similar. I

[PHP-DB] Newbie question - other way than insert statement?

2001-11-20 Thread Daniel Schwab
Hi I came from ASP and I'm sort of a newbie. I'm sure you'll see that after my question :-) I'm looking for a way to insert data in an mysql db but not with an insert into statement. Is there any way i can do some sort of: mydb.myfieldname = $myvalue ?? (same as in asp with recordsets: rs!fie

Re: [PHP-DB] Newbie Question

2001-11-08 Thread Kodrik
>>Hi Kodrik: I just looked at your function and would like to use it myself, but shouldn't the ampersand line: $copy=eregi_replace ("&", "&", $copy); look like this instead? So it matches the other lines that have a symbol replaced by HTML?? $copy=eregi_replace ("&", "&", $copy); Cheers. Russ<<

Re: [PHP-DB] Newbie Question

2001-11-08 Thread Russ Michell
Yes there is: Using a php function called: nl2br() When the data is called from the db and printed to the page use $textdata = nl2br($textdata) This will preserve the enter button being pressed. Regards: Russ On Thu, 08 Nov 2001 09:54:16 -0600 Jay Fitzgerald <[EMAIL PROTECTED]> wrote: > Ok, I

[PHP-DB] Newbie Question

2001-11-08 Thread Jay Fitzgerald
Ok, I am still fairly new at PHP and MySQL also, so please bear with me. TASK: I have a client that wants to have job openings listed on their site and they want to be able to add, edit and delete the postings themselves. I would do this in flat-file format but there is the risk of that file s

RE: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql

2001-10-19 Thread Rick Emery
5 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql No, I am not trying to delete with a select statement. That was just there to show my tables, fields, etc. So if I understand what you are saying I can not do a delete statement with a join in i

Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql

2001-10-19 Thread Heikki Tuuri
two different tables, you must use two different DELETE >> statements. >> >> -Original Message- >> From: Shaun Honsvick [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, October 16, 2001 3:59 PM >> To: [EMAIL PROTECTED] >> Subject: [PHP-DB] Newbie Question: Conv

Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql

2001-10-18 Thread Shaun Honsvick
un Honsvick [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 16, 2001 3:59 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in > mysql > > > I am trying to run a delete on a mysql database. The delete query needs to >

Re: [PHP-DB] Newbie question

2001-05-03 Thread ~BD~
EXACTLY what I was looking for... Thanks! http://www.bustdustr.net Home of Radio Free Bd - Original Message - From: CC Zona <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 03, 2001 1:42 PM Subject: Re: [PHP-DB] Newbie question > In article <034

Re: [PHP-DB] Newbie question

2001-05-03 Thread CC Zona
In article <034101c0d3f3$0dd747e0$41041dd8@winbox>, [EMAIL PROTECTED] ("~BD~") wrote: > at the end of my script, I run a set of closing and clean-up procedures.. > what I would like to be able to do is that when a user bails out of the > script by closing the browser or leaving the site/page, de

[PHP-DB] Newbie question

2001-05-03 Thread ~BD~
I've gone thru everything I can find, and I'm sure I'm just missing it (it's happened before), but... at the end of my script, I run a set of closing and clean-up procedures.. what I would like to be able to do is that when a user bails out of the script by closing the browser or leaving the site

Re: [PHP-DB] newbie question on form..

2001-03-25 Thread Andreas D. Landmark
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At 25.03.2001 22:36, you wrote: >Hello boys that's ok?? well >I have this question >I connect to a database (on interbase 6) and retrive some datas from a >table... >now i want to create a form where the input field show old datas into

[PHP-DB] newbie question on form..

2001-03-25 Thread TONIATI ORAZIO
Hello boys that's ok?? well I have this question I connect to a database (on interbase 6) and retrive some datas from a table... now i want to create a form where the input field show old datas into the respective input text box... anyone can help me?? thank's at all... by David

[PHP-DB] Newbie Question - Importing a table

2001-03-13 Thread Michael J. Waters
I'm new to MySQL and am having trouble importing a table. The table is a text file. Where I think I'm having trouble is on the options. The table has no text delimiter and uses "," as a field separator. Where I think I'm having problems is with the options. What I'm using is [-c, --columns

Re: [PHP-DB] newbie question

2001-02-05 Thread Lisa Elita
]> Sent: Monday, February 05, 2001 9:49 AM Subject: Re: [PHP-DB] newbie question > Hi Lisa, > > >Can search engines index any HTML pages that have .php as its extension (any > >.php pages without a '?' or '&' in the URL) ? For example: > >http://

Re: [PHP-DB] newbie question

2001-02-04 Thread Victor Foitzik
Hi Lisa, >Can search engines index any HTML pages that have .php as its extension (any >.php pages without a '?' or '&' in the URL) ? For example: >http://www.blablabla.com/blabla.php > >Thanks, >Lisa E yes they can, but my experience is, that most search engine robots do _not_ index pages endi

Re: [PHP-DB] newbie question

2001-01-27 Thread jaskirat singh
Yes, It will index the page as any html page At 10:58 PM 1/27/01 +0700, Lisa Elita wrote: >Can search engines index any HTML pages that have .php as its extension (any >.php pages without a '?' or '&' in the URL) ? For example: >http://www.blablabla.com/blabla.php > >Thanks, >Lisa E > > > > >--

[PHP-DB] newbie question

2001-01-27 Thread Lisa Elita
Can search engines index any HTML pages that have .php as its extension (any .php pages without a '?' or '&' in the URL) ? For example: http://www.blablabla.com/blabla.php Thanks, Lisa E -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition