Re: [PHP-DB] How to do a Newsletter

2008-05-01 Thread Jason Pruim
, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http

Re: [PHP-DB] How to do a Newsletter

2008-05-01 Thread Jason Pruim
run a query according to user criteria of newsletter and send it via email - Original Message From: Jason Pruim [EMAIL PROTECTED] To: Nasreen Laghari [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Thursday, May 1, 2008 5:03:43 PM Subject: Re: [PHP-DB] How to do a Newsletter That's

Re: [PHP-DB] Timestamps

2008-05-02 Thread Jason Pruim
On May 1, 2008, at 8:31 PM, Chris wrote: PS... Was it you, Jason, or someone else who asked about the security of the community knowing their database structure and I encouraged the use of `backticks` around all field and table names? Yeah it was me... Old habits die hard :) I'm

Re: [PHP-DB] Multi-level marketing system

2008-08-14 Thread Jason Pruim
And what precisely does this have to do with PHP or databases? I have a feeling if you google for MLM Systems you'll get more then you could ever want... -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED

[PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Jason Pruim
Hi Everyone, I am attempting to wrap my head around an issue and wanted to see if I was thinking right. I am attempting to setup a pURL site, one where they go to something like: example.com/purl.php?purl=jason1234 and the site says Welcome Jason. I have that part of it working, and it's

Re: [PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Jason Pruim
Jason. I have that part of it working, and it's pulling the info from the database just fine, what I'm wondering about is locking it down a little bit more so that they can't just edit the info in the main page, but they have to specifically hit a button to edit the info. Is it better

[PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
, it erases the info in the field. Anyone got a clue as to what is going on? :) Thanks for looking! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
suggestion: you may want put mysql_real_escape_string() wrappers around all those $_POST[] fields to prevent SQL hijacking of your site. HTH, Yves -- Original Message -- Received: Wed, 27 Aug 2008 11:07:20 AM CDT From: Jason Pruim [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
fine, if I DO disable it then they don't submit. I need to find a better to stop accidental editing rather then just input type=text disable On Wed, Aug 27, 2008 at 6:38 PM, Jason Pruim [EMAIL PROTECTED] wrote: On Aug 27, 2008, at 12:24 PM, Evert Lammerts wrote: Your index.php looks

Re: [PHP-DB] Kesalahan posting?

2008-08-27 Thread Jason Pruim
Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
On Aug 27, 2008, at 12:48 PM, Jason Pruim wrote: For everyone that has helped me on this thank you! :) the solution was changing from: input type=text name=txtFName DISABLED to input type=text name=txtFName READONLY Read only fields still get passed with POST'ed info where as disabled

Re: [PHP-DB] solution reqd for summation of vertical columns in PHP

2008-09-13 Thread Jason Pruim
On Sep 13, 2008, at 10:05 PM, Vaibhav Informatics wrote: Please let me know if there is a simple method to total up the column values in Mysql database tables using php as in excel. I believe what you are looking for is count(fieldname) -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Question about databases and foreign keys

2008-09-15 Thread Jason Pruim
the actual time, hopefully making the math part easier :) Do I need the foreign key and the 2 tables? Or should I just add the column's into the database since it will be for a small company? Ideas? Suggestions? Thanks! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287

Re: [PHP-DB] re:php debugging skills

2008-09-26 Thread Jason Pruim
with databases (Since this is the DB list :)) I'd recommend to echo out your db statements to make sure you are doing what you think you are doing... Can't tell you how many times that screwed me up... Just my experience, take it or leave it :) -- Jason Pruim Raoset Inc. Technology Manager

Re: [PHP-DB] re:php debugging skills

2008-09-26 Thread Jason Pruim
On Sep 26, 2008, at 1:17 PM, muhsin wrote: Jason Pruim wrote: On Sep 26, 2008, at 11:22 AM, muhsin wrote: Could you guys share your development setup, like what kinds of software (IDE's/Editors) you are using for developing php scripts? It might sound silly but I am just curios, as I just

Re: [PHP-DB] session variable in select query showing picture from database

2009-02-12 Thread Jason Pruim
On Feb 12, 2009, at 6:07 AM, Mika Jaaksi wrote: I'm trying to show picture from database. Everything works until I add variable into where part of the query. It works with plain number. example ...WHERE id=11... ...picture is shown on the page. Here's the code that retrieves the picture.

Re: [PHP-DB] postgres - pg_query works; pg_query_params doesn't

2009-06-15 Thread Jason Gerfen
Carol Walter wrote: Hello, I have a php 5 and PostgreSQL 8.3.6. I wrote the original program using pg_query. Now, I need to replace pg_query with pg_query_params. I'm having trouble doing so. In this code pg_query works but pg_query_params doesn't work. The code snippet is as follows:

Re: [PHP-DB] multiple finder

2009-06-29 Thread Jason Gerfen
Emiliano Boragina wrote: Hi, I must do e finder for properties... I know do a simple search but not a search like this with more one possibility, with all or some fields full... How do it? Thanks a lot Example database table to search: TableName Field001 Field002 Field003 Example SQL to

Re: [PHP-DB] mysqli error

2009-07-01 Thread Jason Gerfen
Kevin Castiglia wrote: Whenever I run the following code, I get the error: Commands out of sync; you can't run this command now as I try to execute my prepared Update statement. ?php $fpiDataAddr = fopen('outputAddr.txt','r') or die(can not open In File ); //Connect to mySQL server

Re: [PHP-DB] mysqli error

2009-07-01 Thread Jason Gerfen
Jason Gerfen wrote: Kevin Castiglia wrote: Whenever I run the following code, I get the error: Commands out of sync; you can't run this command now as I try to execute my prepared Update statement. ?php $fpiDataAddr = fopen('outputAddr.txt','r') or die(can not open In File ); //Connect

Re: [PHP-DB] Re: [PHP] A prepared statements question

2009-07-12 Thread Jason Carson
[Redirected to PHP-DB: php...@lists.php.net] On Sun, Jul 12, 2009 at 00:31, Jason Carsonja...@jasoncarson.ca wrote: Hello everyone, I am having a problem getting my prepared statements working. Here is my setup...    index.php - authenticate.php - admin.php 1)index.php

[PHP-DB] MySQLand a prepared statement problem

2009-07-16 Thread Jason Carson
Hello everyone, I have a problem. When I insert a href=http://example.comExample/a into my database with the following code... $connect = mysqli_connect($hostname, $username, $password, $database); $sql=INSERT INTO notes VALUES ('$id', '$note'); $result=mysqli_query($connect, $sql);

Re: [PHP-DB] MySQLand a prepared statement problem

2009-07-16 Thread Jason Carson
Hello everyone, I have a problem. When I insert a href=http://example.comExample/a into my database with the following code... $connect = mysqli_connect($hostname, $username, $password, $database); $sql=INSERT INTO notes VALUES ('$id', '$note'); $result=mysqli_query($connect, $sql);

Re: [PHP-DB] MySQLand a prepared statement problem

2009-07-16 Thread Jason Carson
I was under the impression that using prepared statements means you don't need to use those functions. check into stripslashes ,addslashes and mysqli_real_escape_string functions. Jack 2009/7/17 Jason Carson ja...@jasoncarson.ca Hello everyone, I have a problem. When I insert

Re: [PHP-DB] MySQLand a prepared statement problem

2009-07-17 Thread Jason Carson
I solved the problem by turning off magic_quotes_gpc in my php.ini file. I was under the impression that using prepared statements means you don't need to use those functions. check into stripslashes ,addslashes and mysqli_real_escape_string functions. Jack 2009/7/17 Jason Carson ja

[PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Hello everyone, I have a problem. I use the following to *try* and insert data into my MySQL database... //Variables come from a form $username= $_POST['username']; $password = $_POST['password']; $email = $_POST['email']; //Connect to the database $connect = mysqli_connect($hostname,

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
, sha1($password), $email); On Tue, Jul 21, 2009 at 8:01 PM, Jason Carson ja...@jasoncarson.ca wrote: Hello everyone, I have a problem. I use the following to *try* and insert data into my MySQL database... //Variables come from a form $username= $_POST['username']; $password = $_POST

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Done. Thanks for letting me know about that. kesavan trichy rengarajan wrote: could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin, sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
/a here to enter the members page; $_SESSION['username']=$username; } else echo incorrect password; } else die(That user dosen't exist); } else die(pelase enter a username and a password); ? -- Jason Gerfen Systems Administration/Web application development jason.ger

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
in' /form /html Did you try looking at the $_POST array data? echo var_dump(print_r($_POST)); -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112-0806 Ext

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
prasad wrote: Yes I did but still its not working on my web server however its working fine with my WAMP server locally. On Fri, Oct 2, 2009 at 9:17 PM, Jason Gerfen jason.ger...@scl.utah.edu mailto:jason.ger...@scl.utah.edu wrote: nagendra prasad wrote: OK so here is the form

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
Maybe you should google for information regarding the php.ini and error reporting. nagendra prasad wrote: Yes I did but still its not working on my web server however its working fine with my WAMP server locally. On Fri, Oct 2, 2009 at 9:17 PM, Jason Gerfen jason.ger...@scl.utah.eduwrote

Re: [PHP-DB] DATETIME

2009-10-08 Thread Jason Gerfen
WHERE event_date BETWEEN ('2009-09-01 00:00:00.000' AND '2009-10-01 23:59:59.999') -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112-0806 Ext 5-9810 -- PHP Database

Re: [PHP-DB] DATETIME

2009-10-08 Thread Jason Gerfen
something like: SELECT * FROM my_table WHERE event_date BETWEEN ('2009-09-01 00:00:00.000' AND '2009-10-01 23:59:59.999') -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112

Re: [PHP-DB] PHP Update query

2009-11-04 Thread Jason Gerfen
From the manual page: For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, *mysql_query()* returns *TRUE* on success or *FALSE* on error. If $client_result == true you know the query was successful. -- Jason Gerfen Systems Administration/Web application development jason.ger

[PHP-DB] php, session_set_save_handler disappearing session vars

2010-02-04 Thread Jason Gerfen
with: $handles['session']-register( 'token', $token ); -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112-0806 Ext 5-9810 -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Storing Images #2

2010-02-04 Thread Jason Gerfen
If its outside the html root you would need to create a symlink pointing to the appropriate folder % ln -s /path/to/hidden /path/to/public *however this is very insecure Then if your wise you could create a simple image serving script to prevent direct navigation by checking the referring

Re: [PHP-DB] session management

2010-04-22 Thread Jason Gerfen
How secure would you want it? Is this is a public facing web application? Are you in a shared hosting environment vs. a dedicated hosting environment? Do you require alternative session management such as database or mcache vs. flat file session support? Have you thought about cross site

Re: [PHP-DB] session management

2010-04-23 Thread Jason Gerfen
Here I have a blog I setup but have not finished regarding web application authentication which includes source code and classes you can utilize. Unfortunately I have not been able to finish writing the article due to three jobs and school work. I can however assist you in getting it up and

[PHP-DB] always the logic that messes me up.... Database fun!

2010-07-18 Thread Jason Pruim
Hi everyone! I'm trying to put together a completely database driven site so I can learn how to do it... I've gone to the extent of creating apache rewrite rules to redirect all non-existent files/folders to my script to see if it exists which works perfectly. Where I'm running into

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-24 Thread Jason Pruim
On Oct 24, 2010, at 2:46 PM, Ethan Rosenberg wrote: Dear list - Thanks for all your help. I have a tab delimited file which I wish to import into a data base. In MySQL I can use the LOAD DATA command. As far as I know, that command cannot be used in PHP as a mysqli_query. As I

[PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
it keeps timing out the connection. Is there any advice for working with large datasets? I'm wanting this to be able to load quickly. Thanks in advance! Jason Pruim li...@pruimphotography.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Oct 10, 2011, at 2:20 PM, Jim Giner wrote: Toby Hart Dyke t...@hartdyke.com wrote in message news:00da01cc8768$ca9e9200$5fdbb600$@hartdyke.com... It sounds as though you don't have an index on the right field. 8 million records should be no problem

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Oct 10, 2011, at 2:42 PM, Jim Giner wrote: I don't do command line stuff so I may not be right in my thinking. If you are running a php query from a client, does the query get executed on the database server, or does all the data have to come down to you

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 10, 2011, at 5:27 PM, Thompson, Jimi wrote: I really think that you should try running it from the command line and see what the issues are. Get both Apache and php out of the way. I've seen some PHP scripts use up all the file handles (OS

[PHP-DB] Odd MySQL Problem...

2011-10-13 Thread Jason Pruim
areacode, exchange, subscriber) "; $sql .= "VALUES({$data[1]}, {$data[2]}, {$padded_number}) "; //mysql_query($sql) or die("Didn't insert you dumb ass FIX IT NOW CLOWN " . mysql_error());echo "SQL: " . $sql . "BR"; } } echo "File Bitches!"; fclose($handle);}?Any ideas on what I'm missing?Thanks everyone! Jason Pruimli...@pruimphotography.com

[PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
records, will be expanding that to many many more times that... To the tune of possibly a couple billion records... Any ideas? :) Jason Pruim li...@pruimphotography.com

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote: On 29/11/11 01:38, Jason Pruim li...@pruimphotography.com wrote: Given the following 2 queries: SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'; SELECT DISTINCT areacode FROM main

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jason Pruim
Jim, Similar yes... But this was specifically about replacing distinct with something since it was taking WAY to long... But it did evolve into a very similar conversation :) Jason Pruim pru...@gmail.com On Nov 29, 2011, at 6:25 PM, Jim Giner wrote: Didn't the OP begin this very same

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
If you load up handleweight.php outside of the script does it load normally? Trying to pin down where the actual problem is. Jason Pruim 352.359.0002 On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
instead of the entire site. Jason Pruim 352.359.0002 On Mar 15, 2015, at 2:40 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/15/2015 09:44 AM, Jason Pruim wrote: If you load up handleweight.php outside of the script does it load normally? Trying to pin down where

Re: [PHP-DB] FW: strange numbers in link

2001-06-28 Thread Jason k Larson
Shawna, Feel free to change this value, it doesn't appear to bear any significance and is probably a typo. Jason k Larson [EMAIL PROTECTED] wrote in message BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1">news:BB6D932A42D6D211B4AC0090274EBB1D2EEE87@GLOBAL1... Our website uses mysql

Re: [PHP-DB] How do I keep the values of objects when refreshing page?

2001-06-28 Thread Jason k Larson
Please be more specific. Hector M Banda [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hi all, My page is getting the values and the submits itself displaying the information but the original selection is gone showing the objects with no info. Thanks,

Re: [PHP-DB] delay script

2001-06-28 Thread Jason k Larson
You may find that the HTML meta tag can help you there. -- 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] delay script

2001-06-28 Thread Jason k Larson
sorry so brief earlier .. anyway this is a working sample meta http-equiv=refresh content=5;url=http://www.php.net; -- 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

Re: [PHP-DB] static or dynamic printer-friendly webpages?

2001-06-28 Thread Jason k Larson
the proper plug-ins for their browsers (a bit of a headache, if you asked me, but can none the less be done). Good Luck! Jason k Larson -- 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

Re: [PHP-DB] mysql errors .... or php errors ????

2001-06-28 Thread Jason k Larson
). One might decide to resolve these errors once and for all by applying single or double quotes on all named Array indexes. For the short term you may look into error_reporting() in php. Jason k Larson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

Re: [PHP-DB] delay script

2001-06-29 Thread Jason k Larson
Or perhaps it did. = ) Sorry - I guess CC-ing the message list doesn't work. -- 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]

[PHP-DB] Re: Formating TimeStamp

2001-10-18 Thread Jason L. West
Thanks for all of the input. Here is the solution that I finally went: DATE_FORMAT(v_date, '%b %e, %Y') AS v_date v_date being the column name. -- Jason L. West, Sr. Web Architect SalesTek Inc. Jason [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... DATE_FORMAT is a MySQL

Re: [PHP-DB] SQL: Limit 1 usage?

2003-01-30 Thread jason wesley upton
- Original Message - From: jason wesley upton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 30, 2003 9:42 PM Subject: [PHP-DB] SQL: Limit 1 usage? Currently I have a script that contains this piece of code: $sql = SELECT MIN(network

[PHP-DB] Re: sending a form feed to a printer

2003-04-02 Thread Jason S Motes
form feeds don't work in html. It is interpreted as a space. Arthur Chevalier wrote: Hello, I am having problems getting the \f (form feed) expression to work. After a certain amount of lines print I want to start printing the next line on a new sheet of paper. Any ideas of what I could be

[PHP-DB] how many rows updated

2003-09-11 Thread Jason S Motes
When updating or deleting a table is there anyway to find out how many rows where affected using php?? I am using Postgresql 7.2 and php 4.2 using pgsql from the the command line I enter this query update teststock set item_num ='something' where item_num ='something'; and it returns UPDATE

Re: [PHP-DB] how many rows updated

2003-09-11 Thread Jason S Motes
Thanks, i could not find that function in the book i was using. sorry for the inconvenience. John W. Holmes wrote: Jason S Motes wrote: When updating or deleting a table is there anyway to find out how many rows where affected using php?? I don't even use PG, but it took me 5 seconds to find

[PHP-DB] Re: Using PHP to print using LP on Linux

2003-10-24 Thread Jason S Motes
This is what i use: exec (lpr -P $PrinterName $PostscriptFile,$printOut , $printReturn); Paul Fitz wrote: Hi Guys, I suppose this isn't a database specific question, but it is the only PHP mailing list I am subscribed to. Trying to trigger a printer in the office hooked up to a Mandrake

[PHP-DB] Re: postgresql

2004-04-14 Thread Jason S Motes
if i remember correctly you have to do this su su postgres createuser your-user-id Adam Williams wrote: Hi, I know this isn't PHP related but I have a quick question about postgresql. I come from a mysql enviroment so I'm a little clueless, even after reading the postgresql docs. I

[PHP-DB] Cookies with databases

2004-10-20 Thread Jason T. Davidson
align=centerAwaiting Approval/div/td /tr /table /body /html So I am assuming that somewhere in my first page that my cookie isn't actually gettting set properly. I have tried many varitites and can't find any help sections on cookies from a database. Any help would be appreciated! -- Jason

Re: [PHP-DB] Cookies with databases

2004-10-21 Thread Jason T. Davidson
just fine, but it's variable doesn't come from a database. -- Jason Davidson Bastien Koert wrote: Hi Jason, 1. I don't think you need the quotes around the values. 2. is the user cookie set? bastien From: Jason T. Davidson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: [PHP-DB] Cookies with databases

2004-10-21 Thread Jason T. Davidson
Tyler- I have been to that section of php.net many times. My first cookie ($cid) doesn't have them domain listed and works just fine. Don't see I would need it for the cookie ($user)? -- Jason Davidson Tyler Replogle wrote: Yes you need to set the string domain http://us2.php.net/manual/en

[PHP-DB] Forms list from database

2004-11-01 Thread Jason T. Davidson
I am trying to take information from a database and show that info in a forms list. I have been trying this with while(), but it never comes out and displays correctly. Any help would be appreciated. -- Jason Davidson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Forms list from database

2004-11-01 Thread Jason T. Davidson
($check=mysql_fetch_array($result)){ print $check[LNAME],$check[FNAME]($check[CID]); } ? /option /select /div/td /tr -- Jason Davidson Juan Stiller wrote: It might be usefull to see the code you are using to show the query results. --- Jason T. Davidson [EMAIL

[PHP-DB] Data from a pull down menu

2004-12-10 Thread Jason T. Davidson
that is right under my nose. If there is some material out there on this can someone point me in the right direction or show some sample coding? -- Jason Davidson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Converting database from MS Access to MySQL on Linux

2002-10-29 Thread SELPH,JASON (HP-Richardson,ex1)
I use this, it has a nag screen but doesn't require any money. http://www.accessmysql.com/ works as an access plugin, just select an access table, point it to your mysql db and click a button. easy to use. -Original Message- From: Matthew Hildebrand [mailto:gosherm;byu.edu] Sent:

RE: [PHP-DB] MySQL password protection?

2002-11-06 Thread SELPH,JASON (HP-Richardson,ex1)
actually you can make a .php file with your connection info, include it in your .php files at the top and encrypt that one file (they don't need to see it anyway). use a php encoder for the file with your login info in it. -Original Message- From: 1LT John W. Holmes

RE: [PHP-DB] date()

2002-11-13 Thread SELPH,JASON (HP-Richardson,ex1)
use the php function substr to chop off what you don't need, since all the dates can come from mysql as -mm-dd or however, just use substr($mydate, 0, 10) or however far out, that truncates the actual $mydate. -Original Message- From: [EMAIL PROTECTED] [mailto:epeloke;echoman.com]

RE: [PHP-DB] How do I... (update one table from one page which displays multiple editable tables)?

2002-12-09 Thread SELPH,JASON (HP-Richardson,ex1)
. Cheers Jason -Original Message- From: Michael Knauf/Niles [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 1:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] How do I... (update one table from one page which displays multiple editable tables)? I have a simple form that displays

RE: [PHP-DB] Update Query Help...

2002-12-10 Thread SELPH,JASON (HP-Richardson,ex1)
is it a mysql field type of datetime? if so, you may want to use this instead $timestamp=date(Y-m-j H:i:s); $update = UPDATE accounts SET atime='$timestamp' WHERE id-sys='$tmp'; that puts the current timestamp in mysql format for entry into your table. Cheers Jason -Original Message

RE: [PHP-DB] php- odbc- access

2002-12-11 Thread SELPH,JASON (HP-Richardson,ex1)
the records over. You can also have them export their data to a CSV file, upload that file and mysql can import it. Other than that I am not sure what you can do. Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 7:41 AM

RE: [PHP-DB] copying data

2002-12-12 Thread SELPH,JASON (HP-Richardson,ex1)
. This may be tricky as I am not sure if you can bait and switch the file from under the odbc connections nose. Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 10:33 AM To: PHP-DB Subject: [PHP-DB] copying data I

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread SELPH,JASON (HP-Richardson,ex1)
the option to Protect my computer or network. Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 7:54 AM To: SELPH,JASON (HP-Richardson,ex1) Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] mysql-windows xp that didn't

RE: [PHP-DB] mysql-windows xp

2002-12-13 Thread SELPH,JASON (HP-Richardson,ex1)
work until I disable ICF. Try running winmysqladmin though if you haven't already. or give a more detailed error message. Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB

RE: [PHP-DB] My question in precise reg PHP and relational tables.

2002-12-18 Thread SELPH,JASON (HP-Richardson,ex1)
\$category_type/OPTION; } then in your form, use this code for the select box: SELECT name=product_type ? echo $option_block; ? /SELECT This will give you a drop down list that is dynamicly generated each time the page is viewed by the values in your category table. Cheers Jason -Original Message

RE: [PHP-DB] Now not selecting enough

2002-12-18 Thread SELPH,JASON (HP-Richardson,ex1)
Try putting this: echo (h5A HREF=\minutes_detail.php?id=$id\$meetingdate/A/h5); in your while loop. Right now it is just popping out the last record. Cheers Jason -Original Message- From: Alex Francis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 11:00 AM To: [EMAIL

RE: [PHP-DB] extracting data

2002-12-19 Thread SELPH,JASON (HP-Richardson,ex1)
If you are on a windows machine, you can create a DSN to the access file and use odbc from php to connect to it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] extracting data I

RE: [PHP-DB] extracting data

2002-12-20 Thread SELPH,JASON (HP-Richardson,ex1)
? To another odbc? to mysql? where? And do you want to manipulate the data before moving it? Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:17 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] extracting data Ok, I am

RE: [PHP-DB] Help with date....

2003-01-07 Thread SELPH,JASON (HP-Richardson,ex1)
( string format [, int timestamp]) and w - day of the week, numeric, i.e. 0 (Sunday) to 6 (Saturday) http://www.php.net/manual/en/function.date.php Not sure which you wanted since this is the php-db group :) Cheers Jason -Original Message- From: Rodrigo Corrêa [mailto:[EMAIL PROTECTED

RE: [PHP-DB] Help with converting data type from Database in PHP

2003-01-28 Thread SELPH,JASON (HP-Richardson,ex1)
I think I remember something about pack and unpack working with aunti endian, uncle endian and all the little endians. Jason -Original Message- From: Robert Trembath [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 9:02 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP

RE: [PHP-DB] login script

2003-01-31 Thread SELPH,JASON (HP-Richardson,ex1)
try: http://www.hotscripts.com/PHP/Scripts_and_Programs/User_Authentication/ there are loads of pre done scripts you can reference. Cheers Jason -Original Message- From: Matt [mailto:[EMAIL PROTECTED]] Sent: Friday, January 31, 2003 11:48 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] login

RE: [PHP-DB] matching data from one table with another and displaying results?

2003-02-04 Thread SELPH,JASON (HP-Richardson,ex1)
Seek out LEFT JOIN on mysql web site, thats what you want. Cheers Jason -Original Message- From: Aaron Wolski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 10:43 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] matching data from one table with another and displaying results

RE: [PHP-DB] newsletter optimization help needed

2003-03-12 Thread SELPH,JASON (HP-Richardson,ex1)
Jason -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 12, 2003 11:41 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] newsletter optimization help needed Hi there Everyone, Below is some code I use to send a newsletter to clients subscribed on my mailing

RE: [PHP-DB] newsletter optimization help needed

2003-03-12 Thread SELPH,JASON (HP-Richardson,ex1)
of 1 or 2 to email it to a few test email accounts (hotmail or whatever) and see if it all works. I stress this as I may have accidently at one time in the past tried a test similar to yours with live data. Needless to say our exchange admin was a bit unhappy. Jason -Original Message- From

RE: [PHP-DB] Problem with passing variables in PHP

2003-03-14 Thread SELPH,JASON (HP-Richardson,ex1)
I am sure someone else will beat me to this but here is an example update.php --- ?php echo html\n; echo body\n; //add this to assign POST to a variable you can use on this page $sname=$_POST[sname] //that will give you an idea of what to do if (isset($sname)) {

<    4   5   6   7   8   9