[PHP-DB] Relational database

2002-03-21 Thread Ron
I am trying to get fields from 2 different tables that have the same field name to pull the records from one table For example mysql_connect($DBhost,$DBuser,$DBpass) or die(Unable toconnect to database); mysql_select_db($DBName) or die(Unable to select database $DBName); $sqlquery1 =

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
SELECT ccsd.Description, ccsd.Impact, ccsd.Isolation FROM ccsd, log WHERE ccsd.CCSD=log.logccsd I have tried this and the code and now I get to where it include variable from the table, but it is the wrong record??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
Is there a way under mysql to identify the last record in a table so that I can pull information that I need from that entry. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Relational database

2002-03-21 Thread Ron
But can you do that in PHP before you pull info from it -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Forms

2002-03-22 Thread Ron
I know this is suppose to be databases, but the most knowledgeable people seem to be in here. This is the first time that I have tried to conquer a form in PHP(which I obviously am not doing) so that I can have a total PHP script page and move away from HTML. Here is my code as followed by my

Re: [PHP-DB] Forms

2002-03-22 Thread Ron
(((Point taken))) no harm intended Parse error: parse error in C:\**\*\tt.php on line 53 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Forms

2002-03-22 Thread Ron
Line 53 is the line that is commented out Ron [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... (((Point taken))) no harm intended Parse error: parse error in C:\**\*\tt.php on line 53 -- PHP Database Mailing List (http://www.php.net/) To uns

[PHP-DB] Re: procedures?

2002-03-27 Thread Ron
Have you looked at or download the mysql.pdf.which is pretty clear and consise. If you would like to look at other sites go to www.php.net and on the top part click on links. There around the middle of the page you will find PHP tutorials. Any place that has PHP tutorials will probably have

[PHP-DB] Return the last record on database

2002-03-29 Thread Ron
My database has several records an ID is the primary key I want to diplay output using PHP to a table (no biggy) The problem for me is I just want the record of the database to be displayed!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] I LOVE PHP

2002-03-29 Thread Ron
I just wanted to say to everybody...I DO LOVE PHP AND MYSQLSWEETNESS!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2002-09-28 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] help query is so slow

2005-01-24 Thread ron
Hi All, What seems to be the problem why my query to mysql is so slow. I'm using it for accounting, wherein I need to get the start time they login and the time they logout then compute it. to get the start time I did select * from table where blah blah and blah blah and blah; to retrieve

[PHP-DB] playing longblob media

2008-04-27 Thread Ron
Hi, How can i retrieve via php a media stored in a mysql database as longblob? I'd like to be able to retrieve the media and stream it. TIA regards, ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] playing longblob media

2008-04-27 Thread Ron
of media are you trying to retrieve? Are you trying to retrieve the MySQL data and stream that through your script to the client? How big is the BLOB? If nothing else, you'll need to adapt the MIME-type in the header of your HTTP-message. HTH, Yves - Original Message - From: Ron

Re: [PHP-DB] playing longblob media

2008-04-28 Thread Ron
hi yves, not sure how large the file is, but i'm assuming a caller would not leave a voicemail longer than a minute. max maybe 30 secs. is there a query to get the size of a data in a certain row/column? thank you regards ron Yves Sucaet wrote: So how large is the file/BLOB? How many

[PHP-DB] upload file

2008-07-04 Thread Ron
it will also be transferred on the other server? can i use php to execute the rsync command, and transfer the uploaded file to the other server? or are there other ways to transfer? thank you regards, ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] upload file

2008-07-05 Thread Ron
Hi Sir, Is it possible to upload directly on a remote server using php file upload? so that i will have everything on the remote server instead of in the local server? regards, ron On Sat, 5 Jul 2008 10:55:48 -0400, Bastien Koert wrote On Fri, Jul 4, 2008 at 11:35 PM, Ron [EMAIL PROTECTED

[PHP-DB] using multiple apache

2008-08-15 Thread Ron
session on the db, would it prevent the session variable to get lost when a user 1 brose from server 1 o server 2 or vice versa? thank you regards, ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] pagination php mysql

2008-10-19 Thread Ron
to 10 of the total results. user chose 3 option on page 1, 3 option on page 2, 2 on page 3 and 2 on page 4. how can i get the values from page 1 2 and 3 so i cn insert it on the database? Hope i am not confusing. TIA Regards, Ron -- PHP Database Mailing List (http://www.php.net

[PHP-DB] mktimestamp help

2008-12-30 Thread Ron
'))); $expiredate = date(Y-m-d,mktime(0,0,0,date('m'),date('d'),date('Y')) + 2592000); the 2592000 timestamp for 1 month. how can i compute the timestamp for 6 months or maybe 1 year or more. Thank you Regards, Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] mktimestamp help

2008-12-30 Thread Ron
Thanks i will try strtotime. Phpster wrote: $endDate = date('Y-m-d', strtotime(+6 months); Should be close Bastien Sent from my iPod On Dec 30, 2008, at 8:43 PM, Ron r...@silverbackasp.com wrote: Hi, I'm trying to do online subscription on my site. I need to determine

[PHP-DB] printable pdf

2009-02-03 Thread Ron
Hi All, I'm creating a billing system wherein a user can view invoices. and if the user wants to print it a click on a button will generate a pdf file of their invoice. pdf or any other printable format will do. TIA Regards Ron -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] printable pdf

2009-02-04 Thread Ron
thanks to all your reply. i will check on both Yannick Mortier wrote: 2009/2/4 Ron r...@silverbackasp.com: Hi All, I'm creating a billing system wherein a user can view invoices. and if the user wants to print it a click on a button will generate a pdf file of their invoice. pdf or any other

[PHP-DB] php date/time zone

2009-03-18 Thread Ron
Hi All, I have a form where in a user will enter a time and choose a timezone. based on those, i need to insert to db the time as the actual time on their timezone. how can i compute that on php? is it possible? hope i'm not confusing. tnx regards Ron -- PHP Database Mailing List (http

[PHP-DB] session expiration

2010-09-27 Thread Ron
no activity, how can i make it in such a way it won't expire unless the user logs out? regards Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Hide Files

2001-02-19 Thread Ron Brogden
At 04:22 PM 2/19/2001 -0600, you wrote: while ($file_name = readdir($dir)) { if (($file_name != ".") ($file_name != "..") ($file_name !="*.php") ($file_name !="main.gif") ) how come that still displays all the *.php files? You cannot use wildcards in this comparison: $file_name

Re: [PHP-DB] PHP security

2001-02-20 Thread Ron Brogden
At 01:50 PM 2/20/2001 -0600, you wrote: As far as I know, you can not download PHP programs without access to download them. Meaning you need an account on the webserver, so they would need your account user and pass before they could steal your mysql user and pass. The main issue is that

[PHP-DB] close posting to non-subscribers please

2001-02-20 Thread Ron Brogden
At 12:29 PM 2/21/2001 +1100, you wrote: This will take one minute and is worth it! Arrgh. I just sent a test message as a non subscriber to see if this list was misconfigured, which it is. Whoever is the list admin, please please please close posting to non-subscribers. SPAM on mailing

Re: [PHP-DB] onMouseOver onMouseOut

2001-02-23 Thread Ron Brogden
sibility which means they should be avoided most of the time just like Macromedia Flash, Quicktime, etc. unless you are 100% sure your audience meets your site's requirements exactly. All IMHO of course. Cheers, Ron - Island Net

Re: [PHP-DB] Tricky database query involving two tables

2001-02-28 Thread Ron Brogden
At 09:50 PM 2/28/2001 -0500, you wrote: Is there a way to do this in MySQL? Or do I have to just query everything, and then have the skipping logic be in PHP? I'd love to encapsulate this in a query. Would it involve subqueries (something I know that MySQL doesn't directly support)? The

Re: [PHP-DB] Drop down box

2001-03-01 Thread Ron Brogden
At 06:32 PM 3/1/2001 -0300, you wrote: The action you want is only available using JavaScript. True but the action *you* want is most definitely not what many of your *users* are going to want. If you use Javascript this way your site will be un-navigable if Javascript is turned off or the

Re: [PHP-DB] ftp upload

2001-03-08 Thread Ron Brogden
ially when the answer is readily available in the PHP manual. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-305

Re: [PHP-DB] csv file with mysql

2001-03-12 Thread Ron Brogden
tead which will use less resources and not be subject to the same timeout issue. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra

Re: [PHP-DB] Using text files instead of a DB

2001-03-12 Thread Ron Brogden
At 09:29 PM 3/12/2001 -0400, you wrote: THE ROTTERS!! They don't have to do ANYTHING to support MySQL except: 1. Set up an empty database 2. Assign it a username/password and, just possibly 3. Provide the most elemental of scripts so you can do a bulk load,

Re: [PHP-DB] Text Searches on MySQL

2001-03-14 Thread Ron Brogden
you have little data then no big whoop. If you have lots of data then you need to look at different method of searching. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250

RE: [PHP-DB] Login System with access levels

2001-03-16 Thread Ron Brogden
At 02:00 PM 3/16/2001 -0600, you wrote: First, I would NOT store passwords in a database. Rather, I'd store a hash based upon the password and username. Storing a password is dangerous as regards security. Just to be a little picky and *not* to start an argument (discussion yes), this really

Re: [PHP-DB] Protecting files

2001-04-05 Thread Ron Brogden
At 03:09 AM 4/5/2001 +0100, Mick Lloyd wrote: But how do I then protect the directories/scripts from anyone wanting to have a look (not that they're worth much!). Create a .htaccess file that contains the following: deny from all Place it in the directories you wish to protect. Next, create

Re: [PHP-DB] images

2001-04-10 Thread Ron Brogden
be used to enforce access solely via the PHP script (i.e. deny from all). Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free

Re: [PHP-DB] Building a Shopping Cart

2001-04-10 Thread Ron Brogden
At 03:17 PM 4/10/2001 -0400, Matt Braynard wrote: I'm trying to build a shopping cart and am unsure of how to track what each visitor has purchased as they shop. How do I track what items they add as they move through the online catalog adding things and then checkout. Make a table that

Re: [PHP-DB] I know this has been asked before, but....

2001-04-11 Thread Ron Brogden
of "column_name" with the same value. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1 800 331-3055 Vic

Re: [PHP-DB] PHPNuke 4 error. Got any clues?

2001-04-18 Thread Ron Brogden
. If you absolutely must use it, it sounds like you are missing a necessary file since translate() is an internal function. This suggests that an include statement is silently failing somewhere due to a mangled path or filename. Cheers, Ron -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] How to redirect a user to main page once I capture his info in a form?

2001-04-18 Thread Ron Brogden
At 02:03 PM 4/18/2001 -0700, Hector M Banda wrote: Warning: Cannot add header information - headers already sent by (output started at page.php:42) in page.php on line 45 What's at line 42 of page.php? Cheers -

Re: [PHP-DB] Values for Popdownmenu (Categorie and Subcategorie) from MySQL

2001-04-19 Thread Ron Brogden
will be enabled and you will have to perform the sanity checking anyways. Cheers, Ron - Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free:1

[PHP-DB] pgsql 7.1 build

2001-05-02 Thread Ron Patterson
/rpatters/php-4.0.5/ext' gmake: *** [all-recursive] Error 1 Worked ok with PostgreSQL 7.0.3 Any ideas? Thanks, Ron Patterson USA.NET Get free email and a permanent address at http://www.netaddress.com/?N=1 -- PHP Database Mailing

[PHP-DB] Table results returning 2 sets of the same row

2001-08-18 Thread Ron Gallant
I used the code from this page http://php.net/manual/en/ref.mysql.php And my table results are shown 2 times per row. http://www.chizeledlight.com/test.php I also don't know how to specify the column I want the result from. Like $columnName. -- PHP Database Mailing List

[PHP-DB] Re: Table results returning 2 sets of the same row

2001-08-18 Thread Ron Gallant
I get Warning: Wrong parameter count for explode() in /www/chizeledlight/test.php on line 39 when I use this code. The line in error is explode($row); Hugh Bothwell [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Ron Gallant [EMAIL PROTECTE

[PHP-DB] Re: Table results returning 2 sets of the same row

2001-08-18 Thread Ron Gallant
OK, I got it... I used $date = $row[date]; $news = $row[news]; to define the rows. Thats great. I am a Cold Fusion user by trade and am diving head first into PHP. I like it a bunch. Ron Gallant [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]..

[PHP-DB] Masking a reacuring result

2001-08-19 Thread Ron Gallant
I am querying a list with a date field. I want to order the list by the date field and only show each days date once with the other fields showing. (row 1) 2001-08-19 - some text here. (row 2)more text under same date. My date does not show. (row 3) 2001-08-20 - Lots

[PHP-DB] Re: Masking a reacuring result

2001-08-19 Thread Ron Gallant
I just wanted to say that this is one of the most informative un-judging groups I have used. And thanks for everything Hugh. Ron Gallant [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am querying a list with a date field. I want to order

[PHP-DB] Re: ODBC and SQL Server

2001-09-08 Thread Ron Litzenberger
to everyone and hopefully your database isn't. Ron Litzenberger Todd Cary [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am trying to setup an ODBC connect to SQL Server. My DSN is Acct32_ODBC. I am using NT Authentication, so that could be my problem. odbc

[PHP-DB] Problem with the beginning variable

2002-04-03 Thread Ron Allen
I have a problem with the inital load of my page When it loads it says that the variable is not defined. When I click on search after that it works fine. How do I get PHP to recognize a variable as a certain value without making it a static value? -- PHP Database Mailing List

[PHP-DB] Database Sorting by date

2002-04-04 Thread Ron Allen
Here is the problem I want to be able to view all or search through the currency lists in the database by the month. Any help would be great!!! Here is the code TABLE FORM name=currency METHOD=POST ACTION=testtest.php TR HEIGHT=20TD COLSPAN=2FONT SIZE=+0 FACE=VERDANA BR TRTD ALIGN=LEFT BSelect

[PHP-DB] Re: Date Question

2002-04-04 Thread Ron Allen
Steve is right you can do it that way, but I would put in the area where you insert the information into the database. Either way is correct. but I find this way easier and you don't take up any area on your from. (preferences) mysql_select_db($DBName) or die(Unable to select database $DBName);

Re: [PHP-DB] Database Sorting by date

2002-04-05 Thread Ron Allen
PROTECTED]">news:[EMAIL PROTECTED]... Ron, This would indicate that $table was not set. Or that the table indicated in $table does not exist. Print out $query; is it as you expected? Enter the SELECT at the mysql command prompt: what is the result? -Original Message- Fro

[PHP-DB] Cosmetics

2002-04-05 Thread Ron Allen
Does anybody out there know how to get the amount of time that a search took and then display it on the webpage!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Cosmetics

2002-04-05 Thread Ron Allen
Works like a champ..friggin sweet Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Friday 05 April 2002 17:57, Ron Allen wrote: Does anybody out there know how to get the amount of time that a search took and then display it on the webpage!!! $TIMER_START

[PHP-DB] Re: Local to Global Variables

2002-04-11 Thread Ron Allen
guessing here, but have you tried to use include'filename.txt' in your if statement? Eat Pasta Type Fasta [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Not 100% DB related but soon I am processing a text file by looking for strings which later depending on

[PHP-DB] Re: count

2002-04-11 Thread Ron Allen
I know how to get the results for the total number of records select count(*) from $table but how do I put them into a variable for me to use later??? David Robley [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... In article [EMAIL PROTECTED], [EMAIL PROTECTED]

[PHP-DB] Re: count

2002-04-11 Thread Ron Allen
What is the Aliases used for??? Aliases. SELECT COUNT(*) AS howmany FROM table Then use the variable $howmany -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] appending new entry to old entries

2002-04-18 Thread Ron Allen
I would like to make it so that my helpdesk section can append entries in their Master Station Log. Update replaces the entryany clues?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] appending new entry to old entries

2002-04-18 Thread Ron Allen
Thanks Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Thursday 18 April 2002 16:51, Ron Allen wrote: I would like to make it so that my helpdesk section can append entries in their Master Station Log. Update replaces the entryany clues?? You would have

[PHP-DB] Pulling from 2 databases

2002-04-22 Thread Ron Allen
I would like to pull from 2 different databases at the same time so that I can have the relating information displayed together. This is what I have so far.any suggestions? $sqlquery = mysql_query(SELECT * FROM log, logtime WHERE log.ID=logtime.ID order by log.logtime desc;); $sqlquery1

[PHP-DB] error loading libifgen.so

2002-05-10 Thread Ron Andrews
GLIBC2.1.3 Ron Andrews Technical Services Nebo School District 801-354-7402 ext 1406 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] adding a space in mysql

2002-07-31 Thread ron wallace
How can I add a space to the end of a varchar string in mysql? I can't seem to do it directly, and I tried str_pad and other things, but no luck so far. The db doesnt hold the value of the space...its getting trimmed somewhere(?) The reason I want to do this is so I can search for exact

[PHP-DB] adding a space in mysql

2002-07-31 Thread ron wallace
thanks, helpers, but I think I have a simple solution: I will insert a space at the front of the string, where the db must accept and retain it. BTW, here is the SQL I am working with: // elseif ($desc==desc) { $sql=SELECT bandid, bandname, bandesc,

[PHP-DB] Code problem - need help.

2003-01-12 Thread Ron Clark
Hello all, I have the following code: echo td\n; echo table width=\100%\ border=\0\ align=\center\ cellpadding=\2\\n; $sql2 = mysql_query(SELECT signature FROM event ORDER BY cid DESC LIMIT 10); while ($row = mysql_fetch_array($sql2)) { // $cid_alert =

[PHP-DB] cookie blues

2003-02-11 Thread Ron Lloyd
I have 4 directories on my server saving different cookies for each one. When a 3rd or 4th cookie is saved, cookies on a directory get deleted. Has anyone come accross this problem?

[PHP-DB] Accessing MySql using Flash while using PHP as the middleware

2003-06-25 Thread Ron Allen
Does anybody have an idea how-to use Flash and PHP to access a MySql database. I know how to use PHP and mysql with no problem to pull info, but with Flash I am struggling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Multiple same values only wanting one

2003-07-15 Thread Ron Allen
How do I select * from a table, but I do not want it to return the same value if two fields are the same. Example test test test test new new new Results that I want are just test new Any suggestions? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Query problem

2003-07-22 Thread Ron Allen
I have done this in the past, but for some reason it isn't working now (maybe a moron). I am trying to select all of the empty or NULL fields in a column. This is what I have select * from ticket where Type = 'Line' and Closeddate = ' empty space' and have tried the following select * from

[PHP-DB] Comparing tables

2003-08-25 Thread Ron Allen
I would like to compare 2 tables in a database to determine which records are different!!! Any clues out there. Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Comparing 2 tables in the same database

2003-08-25 Thread Ron Allen
I would like to compare 2 tables in the same database so that I can find out which records are different! Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Exporting Data From MySQL Using PHP

2004-08-06 Thread Ron Piggott
on. I am new at PHP and I am not sure how to do this yet. My idea is that the user would click an UPDATE button and this action would be performed. Are any of you able to help me with this? Thanks. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: Exporting Data From MySQL Using PHP

2004-08-09 Thread Ron Piggott
play ... I didn't get too far in creating code, but I am learning at the same time. Thanks for the advice. Ron - Original Message - From: Guus der Kinderen [EMAIL PROTECTED] Newsgroups: php.db To: Ron Piggott [EMAIL PROTECTED] Sent: Monday, August 09, 2004 7:22 PM Subject: Re: Exporting Data

[PHP-DB] Inserting a ' into mySQL

2004-08-20 Thread Ron Piggott
'); I can look at this and understand that if an ' is keyed why it wouldn't save and that line would create an error --- How do you work around this? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Displaying Text From A Data File

2004-09-04 Thread Ron Piggott
. I am still new at PHP and I am not sure where to get started. But I was thinking about this and I am sure this has already been done many times ... I am not sure where to look on the web. Can any of you help me get started? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Re: Displaying Text From A Data File

2004-09-05 Thread Ron Piggott
Thanks for your responses guys. I got it to work. Ron - Original Message - From: Ron Piggott [EMAIL PROTECTED] To: PHP DB [EMAIL PROTECTED] Sent: Saturday, September 04, 2004 2:00 PM Subject: Displaying Text From A Data File I am still new to PHP and I wanted to ask a question. I

[PHP-DB] Building A Web Site Search Engine Using PHP / mySQL

2004-09-07 Thread Ron Piggott
to ask before I got started for any tips instead of re-starting. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Form Processing

2004-10-15 Thread Ron Piggott
and For Management to change the variable value to 2. Are any of you able to help me with this question? Sincerely thank you. It would again help me if a copy of your response is sent to my e-mail [EMAIL PROTECTED] Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Logging Into A MySQL (Web) Database

2004-10-21 Thread Ron Piggott
Any ideas on how to log into a mySQL database through a web form and creating user sessions? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Logging Into A MySQL (Web) Database

2004-10-21 Thread Ron Piggott
Hi Robby I knew clearly what I was trying to say in my mind but didn't do a good job expressing it. The web site address Alex sent me is what I am looking at creating. Ron - Original Message - From: Robby Russell [EMAIL PROTECTED] To: Ron Piggott [EMAIL PROTECTED] Cc: PHP DB [EMAIL

[PHP-DB] Frames mySQL

2004-11-18 Thread Ron Piggott
script do this? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] auto_increment

2004-12-26 Thread Ron Piggott
I have the auto_increment on one of my variables. During the past few days I have been doing testing on a live database and created several test records which I now have deleted from my table. Is there any way of setting the auto_increment value to match the last correct number? Ron -- PHP

Re: [PHP-DB] Math and mySQL

2004-12-31 Thread Ron Piggott
Do you have the actual syntax for the SELECT command to retreive the last record? Ron - Original Message - From: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Thursday, December 30, 2004 10:53 AM Subject: RE: [PHP-DB] Math and mySQL see

[PHP-DB] PHP form processing

2005-02-28 Thread Ron Piggott
Is there a way to find out the IP address of the computer submitting a form --- other than through a cookie. Is there a header command or something like this? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] onClick

2005-02-28 Thread Ron Piggott
Another question: Is there a way that I may set up an IF command with the onClick function so that my_web_page.php3 will not be displayed unless a web form was used to generate it? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Referring web page

2005-02-28 Thread Ron Piggott
I want to change my question --- Is there a way to check the referring web page --- IE where the link came from and what would that variable name be? I mean this in the same fashion that $_SERVER['REMOTE_ADDR'] gives you the IP address of the user. Ron -- PHP Database Mailing List (http

[PHP-DB] Expiry Date ($date function)

2005-03-02 Thread Ron Piggott
with this? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Expiry Date ($date function)

2005-03-02 Thread Ron Piggott
That strtotime is a neat little command. With a bit more searching I found that this works: $expiry_date = strtotime(+21 days); $expiry_date = date('Y-m-d', $expiry_date); echo $expiry_date; The computer couldn't cope with me doing it in just one line --- I got a parse error. Ron

[PHP-DB] Random Character String

2005-03-05 Thread Ron Piggott
of the web pages to be indexed that my PHP scripts are creating. Is there a tag you know of to prevent this from happening? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Random Character String

2005-03-05 Thread Ron Piggott
The robots that index the web. Bastien gave me a web site to use for this. Thanks. Ron - Original Message - From: Zareef Ahmed [EMAIL PROTECTED] To: Ron Piggott [EMAIL PROTECTED] Cc: PHP DB php-db@lists.php.net Sent: Saturday, March 05, 2005 11:56 AM Subject: Re: [PHP-DB] Random

[PHP-DB] mysql_real_escape_string for HTML p???

2005-03-05 Thread Ron Piggott
when the variable is defined as longtext and you are expecting the user to write a few sentences or where they may s/he may press ENTER to start a new line. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Command Line Error

2005-03-28 Thread Ron Piggott
/daily_maintenance.p hp3: line 3: `$todays_date = DATE(Y-m-d);' Any idea why the command line can't deal with but the http:// version works just fine? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Command Line Error

2005-03-28 Thread Ron Piggott
I didn't realize I was required to do this. Would you put this line where it belongs? I am not sure what to do with the ? and ? and if these are needed for the script to run from the command line. Ron #!/path to php cli binary ? $todays_date=DATE(Y-m-d); $username=user; $password=password

[PHP-DB] File retrieval

2005-04-02 Thread Ron Piggott
If I have a file named data.txt Is it possible to load the contents of it into a variable search as $contents idealy I would like to know if I am able to do something like $contents = data.txt; Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] That crazy IF command!

2005-04-03 Thread Ron Piggott
Hey guys ... I am wondering if you have a varable named $query_holder=the big fat cow made lots of milk today; are you able to use the if command to see if the words big fat are part of that phrase? What would the syntax be? Ron -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] That crazy IF command!

2005-04-03 Thread Ron Piggott
Many thanks! Ron - Original Message - From: Justin Gruenberg [EMAIL PROTECTED] To: Ron Piggott [EMAIL PROTECTED]; php-db@lists.php.net Sent: Sunday, April 03, 2005 3:05 PM Subject: Re: [PHP-DB] That crazy IF command! On Apr 2, 2005 3:52 PM, Ron Piggott [EMAIL PROTECTED] wrote: Hey

[PHP-DB] 'OR' logic in mySQL query

2005-04-17 Thread Ron Piggott
to the database within the past 2 days Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Database creation question

2005-04-28 Thread Ron Piggott
storage is more limited. I am just starting to think about this now. Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP Mail command

2005-06-05 Thread Ron Piggott
this problem I am having? Thanks :) Ron PS It is a really funny e-mail I just wrote and sure is computer in nature when entire words consist of ; ' GRIN -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   3   4   >