Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread CPT John W. Holmes
I started to use PHP with MySQL last december. Personal use: list of inhabitants of a town in the 15th century Problem is the following: one person has an arbitrary number of children. It is heavy to have fields child1,child2,child3,...,childn containing the row number of each child

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread CPT John W. Holmes
Thank You. Tell me if I misunderstood or if I did not express me clearly. Sounds like you got it! :) You may also want to read up on nested sets for your database structure. They work the parent_id and child_id differently and it may make queries easier for your situation. For instance, with

Re: [PHP-DB] several pointers to records in one field

2003-03-17 Thread CPT John W. Holmes
Here's one explanation... search for others: http://threebit.net/tutorials/nestedset/tutorial1.html#t Here's the example I was looking for... it took me a while to find it: http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci537290,00.html It's good reading for anyone working with

Re: [PHP-DB] Addslashes (MSSQL)

2003-03-20 Thread CPT John W. Holmes
where my $content value is osmethign like this. Step 1: Access the homepage Step 2: type in your username under the field 'username' and after the addslashes funciton there would be \ around the 'username' like this.. \'username\'and now after running this program I got an error

Re: [PHP-DB] creating a date array

2003-03-25 Thread CPT John W. Holmes
trying to make an array with every date (in -MM-DD format) of the current week in it... the below code ain't working, any ideas?! cheers, dave function createdatearray($sunday){ $date = date('Ymd',strtotime($date)); for($x=0; $x=7; $x++){ $y = $x + 1; $date[$y] =

Re: [PHP-DB] date to Y-M-D

2003-03-25 Thread CPT John W. Holmes
function datetoymd($date){ $dateymd = date('Y-m-d',$date); return $dateymd; } this function when output gives me the date 1970-01-01 (date of the unix timestamp start) so, ehm, why!? Because you're not passing a valid Unix timestamp or whatever your passing is empty. ---John Holmes...

Re: [PHP-DB] wanted: example use of PHPv4 class DB

2003-03-26 Thread CPT John W. Holmes
Hey, I'm developing a brand-new PHP application and want to use a generic interface instead of DBMS-specific function calls. Is the PHP v4 DB class what I should start with, and can anyone point me to a code example using it? Which class are you talking about? You can use ODBC (not

Re: [PHP-DB] Datetime help in an INSERT...

2003-06-06 Thread CPT John W. Holmes
I have actually discovered that the $td value is blank. The reason appears to be that the page is reloading when a button is pushed, and that is when the $td value is being lost. My question now is, how do I keep the $td value after the page is reloaded? I would rather keep the value from

Re: [PHP-DB] Supress MySQL error messages...

2003-05-27 Thread CPT John W. Holmes
Does anyone know if it is possible to suppress MySQL error messages? For example Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/killerspin/public/preview_checkout.php on line 25 Stop using mysql functions on invalid result sets? This is

Re: [PHP-DB] Member login

2003-05-27 Thread CPT John W. Holmes
Having a member login is just checking the password against the database and starting a session for that person, right? Sure... might want to check the username, also. :) ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Query loop issues.

2003-05-30 Thread CPT John W. Holmes
I'm having a problem with looping a query here is the skeleton of the code: $query_result = mysql_query(SELECT * FROM Boats WHERE Serial='$serial' OR Make='$make') if(mysql_num_rows($query_result) 1) { while($row = mysql_fetch_array($query_result, MYSQL_NUM)) { } } else {

Re: [PHP-DB] another redirecting question

2003-05-31 Thread CPT John W. Holmes
If the user has disabled JavaScript in the browser doesn't that create another problem? Yes, it does. You've already said you're not going to rewrite your code so it's correct, though, so why worry about disabled javascript? John Holmes... -- PHP Database Mailing List

Re: [PHP-DB] Array Question

2003-06-03 Thread CPT John W. Holmes
Hello everyone. If I wanted to pass a item ID along with a quantity to an associative array called CartArray how would I pass it to the PHP script? I'll get this shopping cart working yet !! If the question is how do you pass an array to another PHP page, you serialize() and urlencode() it,

Re: [PHP-DB] Datetime help in an INSERT...

2003-06-05 Thread CPT John W. Holmes
I am stumbling across something that I thought I have done before, and I am not having any luck finding an example of this. Basically, I am wanting to timestamp the date and time into new entries in a simple database table. The following section is the actual code for this, and I cannot

Re: [PHP-DB] Datetime help in an INSERT...

2003-06-05 Thread CPT John W. Holmes
2. Place single quotes within your VALUES parens, e.g. If they are really strings. Integers or dates in a MMDD format do not require quotes. $denylog = INSERT INTO deny (account, td, datefield ) VALUES ('$tmp', '$td', NOW() ) ---John Holmes... -- PHP Database Mailing List

Re: [PHP-DB] address info, forms, maintanance

2003-06-05 Thread CPT John W. Holmes
I need to modify some company web pages that include a form for asking the company departments questions, such as service dept, etc. As the forms are currently built there is some field validation but no cookies. This info is saved in a mysql database, problem is, there are duplicate entries,

Re: [PHP-DB] php-db Form var perpetually resetting

2003-06-09 Thread CPT John W. Holmes
I am trying to customize a shopping cart. I need to inject a page in the checkout process that must be checked (terms and conditions), before continuing. I have it working halfway. In checkout_payment.php I have an if stmt

Re: [PHP-DB] mysql_connect error

2003-06-10 Thread CPT John W. Holmes
PHP was not compiled with MySQL support. Re-compile. ---John Holmes... - Original Message - From: Sparky Kopetzky [EMAIL PROTECTED] To: PHP DB Group [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 3:35 PM Subject: [PHP-DB] mysql_connect error Good afternoon! I have Apache w/php

Re: [PHP-DB] Date Formatting in PHP

2003-06-10 Thread CPT John W. Holmes
I have a simple need to reformat a variable coming in as $DatePick, brought forward from a MySQL select in the format: 2003-11-18 I need to convert it to the format November 18, 2003 $f_date = date('F d, Y',strtotime($db_date)); ---John Holmes... -- PHP Database Mailing List

Re: [PHP-DB] Relationships in MySQL

2003-06-11 Thread CPT John W. Holmes
Hi every1...I'm new to this list and hope find it funny... Welcome to the PHP list. Your question has nothing to do with PHP. Did you mean to post this to the MySQL list, perhaps?? :) A question that maybe answered sometime ago: How to create relationships between tables in MySQL? I used a

Re: [PHP-DB] hiding db password

2003-06-12 Thread CPT John W. Holmes
?php putenv(TWO_TASK=ORCL2); putenv(ORACLE_HOME=/u01/home/oracle/product/9.2.0); $conn = OCILogon(USER1,USER1PASS); $query = OCIParse($conn,select * from state); OCIExecute($query); ? Thank you Use an include file buried below your site root with $user=USER1;

Re: [PHP-DB] ODBC equiv for mysql_insert_id

2003-06-16 Thread CPT John W. Holmes
I am connecting to MySQL (4.1) using ODBC (I have my reasons) and am looking for an equivalent to the mysql_insert_id() function so that I can get the ID of the record just created. You could always just issue a SELECT LAST_INSERT_ID() query and get the resulting number that way. ---John

Re: [PHP-DB] query selection

2003-06-16 Thread CPT John W. Holmes
Okay... and? Do you have a question? Are you wanting us to write this for free? Do you want bids on the project? ---John Holmes... - Original Message - From: Ryan Holowaychuk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 16, 2003 2:30 PM Subject: [PHP-DB] query selection

Re: [PHP-DB] query selection

2003-06-16 Thread CPT John W. Holmes
the first list that is displayed has an ID for each product. But when I click on it, it goes to the next page but does not display the rest of the products that are listed in the second table. $query = SELECT * FROM product_list WHERE productid = id; Id being the description ID that came

Re: [PHP-DB] 4.2.3 session login problem...

2003-06-17 Thread CPT John W. Holmes
I have an application that is currently working fine under 4.1.2, and I am in the process of upgrading to 4.2.3. The problem is that after upgrading PHP the application login no longer works. Additionally, this same application works fine on another machine running 4.2.3. The only

Re: [PHP-DB] MySQL editor

2003-06-19 Thread CPT John W. Holmes
Next time ask on the MySQL list! Navicat Mascon PHPMyAdmin (for web interface) SQLYog MyCC (from www.mysql.com) The first two are very professional programs that offer a lot of features including Reports and Query wizards. Similar to using Access on Windows (interface wise), but without the

Re: [PHP-DB] MySQL editor

2003-06-19 Thread CPT John W. Holmes
With the exception of phpmyadmin is there anything else out there that will allow you to work on your mysql stuff remotely? Any of the programs will. The real questions whether you have permission to connect remotely, though... :) ---John Holmes... -- PHP Database Mailing List

Re: [PHP-DB] Problems with formvalues by using Suse 8.2

2003-06-19 Thread CPT John W. Holmes
under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? I really have no idea what you

Re: [PHP-DB] Limit return Size

2003-06-20 Thread CPT John W. Holmes
I would like to know how I limit my answer from a mysql database query to display only a limited size? Is this done in the query or the php? i.e. Our Performance Results area includes First Quarter 2003 investment returns for virtually every 529 savings programs. See how your 529 plan

Re: [PHP-DB] Session error?

2003-06-23 Thread CPT John W. Holmes
Warning: session_start() [ http://www.php.net/function.session-start function.session-start]: open(/tmp\sess_bf0c0a0a020087aa573e357a2553f828, O_RDWR) failed: No such file or directory (2) in C:\Program Files\Apache Group\Apache2\htdocs\MailOrderDynamic\c.php on line 6 The default

Re: [PHP-DB] Having trouble with this SQL query

2003-06-23 Thread CPT John W. Holmes
First of all, I'm a newbie to PHP and MYSQL and started working on a create table query in PHP to execute on MYSQL. Can someone take a quick look at the following code to see if there are any problems? Can you also advise some tips on debugging? Print out your SQL queries when debugging.

Re: [PHP-DB] checking a string for numbers

2003-06-26 Thread CPT John W. Holmes
From: Jamie Saunders [EMAIL PROTECTED] I'm trying to find a way of simply checking a string for numbers. e.g. if ($myVar contains a number) { //numbers present } else { //no numbers present } if(preg_match('/[0-9]/',$myVar)) { //number present } else { //no numbers present }

Re: [PHP-DB] Connect User from website does not work.

2003-07-14 Thread CPT John W. Holmes
I have created a user webuser with the following line. mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'xx'; mysql grant all privileges on *.* to [EMAIL PROTECTED] identified by 'xx'; I would think that this should have unlimited access to the database

Re: [PHP-DB] Connect User from website does not work.

2003-07-14 Thread CPT John W. Holmes
Did you FLUSH PRIVILEGES after creating your user? We're off the subject of PHP, but you don't have to do this with the GRANT command, btw. :) ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] UPDATE query

2003-07-14 Thread CPT John W. Holmes
$query1 = UPDATE news,autori SET news.titolo='$titolo', news.testo='$testo', news.data='$data', news.nome='$nome', autori.mail='$mail' WHERE news.nome = autori.nome AND id='$id'; You can't do an update across tables the last time I checked. Even if it's possible in newer versions, using

Re: Re: [PHP-DB] UPDATE query

2003-07-14 Thread CPT John W. Holmes
Can someone please unsubscribe/boot the ydnarb.com address below? Every time I send a message to the list I receive a blank reply from the address. I assume this is happening for others, also. ---John Holmes... - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: [PHP-DB] PHP MySQL news display probs

2003-07-15 Thread CPT John W. Holmes
I have created a simple news system and am having a problem in that all the code compiles so I think it is correct and the news headlines display but when you point to the link to read the article (for example http://localhost/news/user/story.php?id=2) nothing displays, it returns that there

Re: [PHP-DB] getting MySQL column header?

2003-07-21 Thread CPT John W. Holmes
How would one get the column name/header out of this query so that I could display it as the header for my columns? Honestly, did you read the manual after I told you last time?? $num_fields = mysql_num_fields($result) for($x=0;$x$num_fields;$x++) { echo mysql_field_name($result,$x); }

Re: [PHP-DB] Line of code should work...but doesn't

2003-07-24 Thread CPT John W. Holmes
I never use a full URI unless I am directing to a secure server and things always work on my end. Works either way I guess? There's a big difference between works and the right way to do it... ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] MYSQL and PHP cast() function...

2003-07-25 Thread CPT John W. Holmes
Thanks for that, but I get a NULL entry in the field then for all the dates. What column type is the DATE column? Also, since DATE is a reserved word in MySQL, naming a column DATE probably wasn't a good idea. If you know you always want the first 11 characters, you can always do LEFT(Date,11)

Re: [PHP-DB] query and display acting weird...

2003-07-25 Thread CPT John W. Holmes
Probably need: ORDER BY t.manufacturer, t.colourID ---John Holmes... - Original Message - From: Aaron Wolski [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 25, 2003 2:58 PM Subject: [PHP-DB] query and display acting weird... Hi Guys, Code: echo select

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread CPT John W. Holmes
From: Andrew D. Luebke [EMAIL PROTECTED] $date = date(Y-m-d H:i:s); $result = mysql_query(INSERT INTO Boats (Make, Model, Serial, Stock, Extension, Cust_Name, Store, Date) VALUES ('$make', '$model', '$serial', '$stock', '$extension', '$name', '$store',

Re: [PHP-DB] MySQL Date insert

2003-07-28 Thread CPT John W. Holmes
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] I actually think I know part of this answer... I don't think you need to define a variable to insert into your date field. Inserting an empty value into this filed will populate the field in the database with the current time, which it appears

Re: [PHP-DB] Limit

2003-08-04 Thread CPT John W. Holmes
From: Marie Osypian [EMAIL PROTECTED] I don't want to use the limit on this query anymore. What I want is to display all that are dated within the last 3 months. What would be the easy way to do that? SELECT federal_development_id, UNIX_TIMESTAMP(date) AS date, topic, body

Re: [PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-05 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] So.. do I need to use 2 different incrementors? $z and say $x for each part? I basically pieced this code together from several examples I found so forgive forgive the fact I don't know a whole lot about the code even though I've tried to understand it as

Re: [PHP-DB] displaying result across 3 cells - where did I go wrong?

2003-08-05 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] while($z++ %3 !==0) [snip] echo (++$z %3 == 0) ? '/tr' : ''; The first time through your code, $z is zero. Since the thread titles don't match, your going to get to your while loop above. $z is

Re: [PHP-DB] Maximum execution time of 30 seconds exceeded

2003-08-12 Thread CPT John W. Holmes
I'd agree with what someone else said about keeping a separate table full of possible pin numbers. Fill it with all of the pin numbers to begin with, add in a building or department row so you know what sequences go with what building, etc. Then, to get a pin number for someone, you can just:

Re: [PHP-DB] Extracting result - unknown number of fields

2003-08-14 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] While doing a cross tabulation, I've got a query which gives me a variable number of fields: Maybe mysql_num_fields() and mysql_field_name() will be of use, here? Check the manual.. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Table Field type

2003-08-14 Thread CPT John W. Holmes
From: Michelle Whelan [EMAIL PROTECTED] Does anyone know what field type to use for inserting a webpage name into a database? Example pagename.html When I fill in the form information everything seems to insert fine, then I do a search to see the result and nothing is there, so I check the

Re: [PHP-DB] Database Design Issue

2003-08-14 Thread CPT John W. Holmes
From: Jason Lange [EMAIL PROTECTED] Here's my question. I'm creating a website for a weekly radio show. One of the items I would like to store in the database is the list of songs played in each show (there's normally between 20-25 songs per show), and the songs will be displayed by show.

Re: [PHP-DB] Query Cache not Working? MySQL 4.0.14-standard

2003-08-14 Thread CPT John W. Holmes
From: Matt Babineau [EMAIL PROTECTED] For some reason my MySQL doesn't seem to be caching queries! And you expect PHP to solve this how? Do you want PHP to cache the queries? You must say please... You need to set the four variables mentioned at the following URL in your my.cnf file.

Re: [PHP-DB] Pulling an ID list from a DB, then filtering that list againstanother list of ID's

2003-08-14 Thread CPT John W. Holmes
From: Matt Babineau [EMAIL PROTECTED] Got an interesting problem! I have a list of ID's, basically things people have viewed on my website. When I pull the viewable items from my database, I need to be able to filter out all the ID's people have already viewed, so that they only get a list of

Re: [PHP-DB] adding integer to field in query

2003-08-14 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] Thanks to both responses. In fact, it decided to work once I put 0 in the cell that 1 was to be added to! It seems it got it started.. 1+NULL=? 1 + NULL = NULL Any math statement with NULLs in it will equal NULL. (DB wise) ---John Holmes... -- PHP

Re: [PHP-DB] RE: Pivot tables

2003-08-14 Thread CPT John W. Holmes
All of the work is in the queries, so it doesn't matter that the example at the end is in Perl. The whole concept is that you're using SUM(IF(column=value,1,0)) to sum up your values. To get each of the values you can run a query and use the results of that query to build your second query with

Re: [PHP-DB] MYSQL 4.1 derived tables and PHP

2003-08-22 Thread CPT John W. Holmes
From: Jack van Zanen [EMAIL PROTECTED] I have installed MYSQL 4.1 with support for derived tables. If I query Mysql with a query that has a subquery in the from clause it works fine. If I now load this query in PHP I get invalid resource error. If I change the select for another select w/o the

Re: [PHP-DB] join across databases - how to select databases?

2003-08-22 Thread CPT John W. Holmes
From: Moshe Weitzman [EMAIL PROTECTED] I have looked all over the web but can't find an example *in php* for connecting to a mysql server, selecting database(s), and issueing a query which joins across databases. I already know the SQL required to achieve a multiple database query. My

Re: [PHP-DB] join across databases - how to select databases?

2003-08-22 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] to my knowledge this is not possible in MySQL. There are only joins at the table level. I've been curious about this in the past myself, so if i'm incorrect, i'm hoping to hear it via this post. You can stop hoping now. It is indeed possible. :) mysql select * from

Re: [PHP-DB] WHERE mydatestamp '2003-08-22 13:13:13'

2003-08-22 Thread CPT John W. Holmes
From: Matt Babineau [EMAIL PROTECTED] I'm trying to find things in my database that are greater then Now(), but the date is stored in a blob (don't ask, I know :-0). Is there a way I can do that comparison to find things that are in the future? Option 1: Make a second column of DATETIME and

Re: [PHP-DB] It\'s wierd when I\'ve used forms...

2003-08-22 Thread CPT John W. Holmes
From: Jacob A. van Zanen [EMAIL PROTECTED] You'll have to look into stripslashes function (of the top of my head) PHP automatically puts slashes around variables PHP automatically escapes quotes in incoming form data when magic_quotes_gpc is enabled. If you do not want then, then either

Re: [PHP-DB] Logic Help...

2003-08-26 Thread CPT John W. Holmes
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] This isn't specifically a DB related question, but... The following code snippet is not functioning for me. I keep receiving a parse error on the if line. Basically I want to stop execution of this page if either of the conditions in the if

Re: [PHP-DB] changing datatypes in the query

2003-08-27 Thread CPT John W. Holmes
From: Matt Babineau [EMAIL PROTECTED] On Tue, 2003-08-26 at 11:21, Matt Babineau wrote: Tough question (I think). I am pulling some numbers out of a data base, currently they are stored in a blob. When I try to order by user_hits desc it does a text ordering, not a numerical ordering. Is

Re: [PHP-DB] timestamp formatting on display?

2003-08-27 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] Having a brain laps and not sure where in the manual to look and sadly I need a QUICK solution. I have a date formatted in a table like: 20030826132457 Now.. I went to MySQL timestamp from UNIX timestamps because I like the readability of them when just

Re: [PHP-DB] Problem in executing linux command from PHP

2003-08-27 Thread CPT John W. Holmes
From: Gnanavel [EMAIL PROTECTED] I have problem in executing linux command $output=exec(ls -a); echo pre$output/pre; the above coding works, but $output=exec(cp file1 file2); echo pre$output/pre; does not works. can any one help me out of this problem Riddle me this... exec()

Re: [PHP-DB] MySQL query failing on apostrophe in data

2003-08-27 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] How do I avoid the problem in the subject hereto? SELECT query uses variable in the WHERE clause. Fails on the following query: SELECT Tbl.fld FROM Tbl WHERE Tbl.fld2='11301201 0603A HKA 3902 #3708_JD's AE Exp' AND ... Escape the single quote with a

Re: [PHP-DB] Logic Help...

2003-08-27 Thread CPT John W. Holmes
From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] Thanks for the feedback. This seems to have helped, but something is still not working with the logic. Here is the updated code: ?php while($cntr != 0) { $cntr--; if (($shell[$cntr] == ) || ($grp[$cntr] == )) { echo p

Re: [PHP-DB] looking for a .exe file

2003-08-28 Thread CPT John W. Holmes
From: blond al [EMAIL PROTECTED] I need a php editor file thanks for help! file:///WINNT/system32/notepad.exe You're welcome. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Populating an array from mysql db

2003-08-28 Thread CPT John W. Holmes
From: mike karthauser [EMAIL PROTECTED] I have a course booking system that allows the client to add courses and then specify how long they run for. The admin system I have built allows the client to add up to 30 dates for each instance of the course and these are adding to a database row in

Re: [PHP-DB] Populating an array from mysql db

2003-08-28 Thread CPT John W. Holmes
From: mike karthauser [EMAIL PROTECTED] Thanks for this - I ended up rehashing my query to this: ? $result = mysql_query(SELECT * FROM dates WHERE bookcode = '$bookcode' ORDER BY date1,$db); // loop to populate array $myrow = mysql_fetch_array($result); $i = 1; while ($i = '30') {

Re: [PHP-DB] SESSION SID Question

2003-08-28 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] Can someone explain to me the mechanism by which SID acquires a value? For example, $FOO = SID; echo $FOO; produces something like PHPSESSID=ade4055eef947f1a00cdb280470e859b when IE is first opened and the page is loaded, whereas reloading of the page produces an

Re: [PHP-DB] Heop someone can help with this.. involves sessions.

2003-09-02 Thread CPT John W. Holmes
From: Aaron Wolski [EMAIL PROTECTED] I really hope you don't mind the OT post but I've looked everywhere and can't seem to find a solution to my problem. I am passing a var in a session (not in the URL) to my secure checkout area and it's not capturing the variable. I know there is a

Re: [PHP-DB] how to recognize user login name?

2003-09-04 Thread CPT John W. Holmes
From: David Smith [EMAIL PROTECTED] Spychaa Wojciech wrote: I have to do user recognizing in m php project. Simplest method i know is to recognize for example login name (when user is logging into his local PC) I've tried to use $USERNAME variable but it isnt what i want because it

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: Jonathan Villa [EMAIL PROTECTED] I have an application which creates temporary tables. My plan is to remove them after a 24 hour period and only those which are have a created time greater than 24 hours. That part I can do, my question is how will I be able to run this script which

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: Jonathan Villa [EMAIL PROTECTED] wget -q -O - www.domain.com/cron.php /dev/null Interesting... how does this fair concerning security? So I'll have to have this file located in my document root, is this a good thing? My current directory structure consists of several files located

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
From: Ryan Marks [EMAIL PROTECTED] Not necessarily. You can wget /path/to/file.php or my personal preference is not to use wget, but php directly /path/to/php/executable /path/to/file.php Are you sure about that? I thought wget had to go through HTTP? This didn't work for me, am I doing it

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

2003-09-15 Thread CPT John W. Holmes
- Original Message - From: Pat Lashley [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, September 15, 2003 5:12 PM Subject: Re: [PHP-DB] Need to Run a PHP script using CRON or ? --On Monday, September 15, 2003 15:27:45 -0500 Jonathan Villa [EMAIL PROTECTED]

Re: [PHP-DB] Working query not able to run with PHP script.

2003-09-19 Thread CPT John W. Holmes
From: Jonathan Villa [EMAIL PROTECTED] I have several tables I want to delete as well as their reference in another database The query produced is this: === DROP TABLE xxx.zorder_47629403705b7e7f0c97387559d8c811;

Re: [PHP-DB] sql optimizing assistance

2003-09-19 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] I have two tables and am running a simple join between them to get questions and their repsective response averages from a survey. The question table has 49 rows and the Response table has 126,732. I'd like to cut down on the time its taking to run this specific

Re: [PHP-DB] Query Filter in GUI

2003-09-22 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] I have a PHP GUI in which a select box gets populated by a query of a MySQL DB for all CD's by all artists when the page is first opened. I am now trying to implement the same query but with a WHERE clause that filters the returned CD's to be displayed in the same

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] Is there a limit to the number of session variables one can create/store ? Or is the limit imposed by the size of the file ? Size of file is only limit, although you should impose a practical limit yourself. If you need to ask this question, you're probably relying on

Re: [PHP-DB] update db with variables

2003-09-24 Thread CPT John W. Holmes
From: Robbie Staufer [EMAIL PROTECTED] I'm writing an application that will display the contents of a db in the browser, including the db-assigned id number. The user can then enter the id number in a form and the browser will display the record corresponding to that id number, with the data

Re: [PHP-DB] Storing Session Variables

2003-09-24 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] CPT John W. Holmes [EMAIL PROTECTED] From: [EMAIL PROTECTED] Is there a limit to the number of session variables one can create/store ? Or is the limit imposed by the size of the file ? Size of file is only limit, although you should impose a practical

Re: [PHP-DB] ereg_replace

2003-09-30 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] strip_tags() is used to remove HTML tags, eg for showing text on the browser and then sending it by plain text email or storing in the db. As a matter of interest, how is this done using ereg_replace. I thought this would work ^.*$, that is being with

Re: [PHP-DB] Replacing + with question

2003-09-30 Thread CPT John W. Holmes
From: Graeme McLaren [EMAIL PROTECTED] Jason, thank you for reply. I tried switching the 1st 2 parameters in the str_replace function so that it now looks like this: $AddressLine1 = urlencode($AddressLine1); $AddressLine1 = str_replace(+, , $AddressLine1); Unfortunately as I am now

Re: [PHP-DB] mySQL field structure question

2003-10-01 Thread CPT John W. Holmes
From: Susan Ator [EMAIL PROTECTED] If I have a field in mySQL consisting of a number with 8 digits a decimal point and 4 more digits what is the field type it needs to be to sort it numerically? I've tried decimal(8,4) but it converts everything to .. I've also tried float but

Re: [PHP-DB] inserting date from text file

2003-10-15 Thread CPT John W. Holmes
From: Aleks @ USA.net [EMAIL PROTECTED] I have a large text file that I am inserting into a mysql db and seem to have a problem with the date format. The data is currently in the mm/dd/ format. MySQL expects a MMDD or -MM-DD format (the delimiter for the string version can be any

Re: [PHP-DB] Sessions and MySQL?

2003-10-16 Thread CPT John W. Holmes
From: [EMAIL PROTECTED] And I'm trying to add a session variable to a MySQL database. I've done this page that takes the results from a previous form... But I get this error: Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' On line 83 Which is the

Re: [PHP-DB] problem - query inside a function

2003-10-16 Thread CPT John W. Holmes
From: Luis M Morales C [EMAIL PROTECTED] My Comment bellow: On Wednesday 15 October 2003 14:38, Kirk Babb wrote: Hi, I'm having trouble with a query inside a function. I thought I'd written this so that the function would fail if email and zipcode supplied were not in the same row

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread CPT John W. Holmes
From: Devon [EMAIL PROTECTED] I have been scouring the online documentation and experimenting for hours trying to find a solution. I just can't do it. I have two colomns of data that I am retrieving from MySQL: SELECT id, name FROM a_table; I just cannot figure out how to get that

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread CPT John W. Holmes
From: Chris Boget [EMAIL PROTECTED] My bad. If MySQL had crosstab functionality, that *might* be able to help. A crosstab is just a specifically formatted query, of which MySQL is certainly capable of handling. I've done them in the past, but maybe you're thinking of something more complex.

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread CPT John W. Holmes
From: David T-G [EMAIL PROTECTED] [Actually, maybe I'm just too new at this, but I can't think of a practical example for which I would loop over $row... Care to help me out?] How about a dynamic query where you do not know the number of columns that'll be returned? You would not want to use

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread CPT John W. Holmes
From: Chris Boget [EMAIL PROTECTED] From: Chris Boget [EMAIL PROTECTED] My bad. If MySQL had crosstab functionality, that *might* be able to help. A crosstab is just a specifically formatted query, of which MySQL is certainly capable of handling. I've done them in the past, but maybe

Re: [PHP-DB] Re: looping over $row (was Re: [PHP-DB] Using two colomns ...)

2003-10-20 Thread CPT John W. Holmes
From: David T-G [EMAIL PROTECTED] Hmmm... I suppose so, but I can't picture it. Shouldn't you always know the DB schema and format of what you're going to get back? I can see not knowing how many RECORDS you'll get back but I should think you would know how many FIELDS will be in each.

Re: [PHP-DB] Load MySQL from a variable

2003-10-21 Thread CPT John W. Holmes
From: Kim Kohen [EMAIL PROTECTED] I have some data from Filemaker Pro which needs to have a lot of search/replacing done before importing into MySQL. I have used ereg_replace in PHP and end up with a variable holding the correct data. (there are several hundred rows of data in the variable)

Re: [PHP-DB] Load MySQL from a variable

2003-10-21 Thread CPT John W. Holmes
From: Rory McKinley [EMAIL PROTECTED] AFAIK, LOAD DATA INFILE will only work off a file. So you would have to create a temp file. Another option is to create a multiple value insert query e.g. INSERT INTO arb_table (arb_column_1...arb_column_n) VALUES (arb_value_1..arb_value_n),

Re: [PHP-DB] Error settings

2003-10-21 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] How do I get rid of the undefined variable errors I get on a new (default) set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works on the internet on my host providers server but I am running this on localhost. I also get undefined offset

Re: [PHP-DB] Multiple adds?

2003-10-21 Thread CPT John W. Holmes
From: Robert Sossomon [EMAIL PROTECTED] I am working on a quote system and have been trying to figure out how to make them system automatically add an entire vendor or category at one time. I can make the system display all of them and give the sales folks in my office a chance to change the

Re: [PHP-DB] Error settings

2003-10-21 Thread CPT John W. Holmes
From: Dillon, John [EMAIL PROTECTED] Hm. Adjusted error_reporting to none. Why would I still get: Forbidden You don't have permission to access /method=post on this server. -- -- Apache/1.3.28 Server at

Re: [PHP-DB] Multiple adds?

2003-10-21 Thread CPT John W. Holmes
From: Robert Sossomon [EMAIL PROTECTED] An example is: http://www.garlandcnorris.com/quotes/seestore.php I have a session tracker installed on it already, but the modifying the information (instead of remove and readding it) and adding an entire group are pieces I am stumbling on. So you

Re: [PHP-DB] Unique Format

2003-10-22 Thread CPT John W. Holmes
Use htmlentities() or htmlspecialchars()... ---John Holmes... - Original Message - From: Tonya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 1:07 PM Subject: [PHP-DB] Unique Format PHP 4.3.3 and MYSQL I am constructing a site for gamers that has a member

Re: [PHP-DB] removing space ?

2003-10-28 Thread CPT John W. Holmes
From: Larry Sandwick [EMAIL PROTECTED] When I select data from my data base I have spaces on the lead side for example the data that is stored is 33.jpg. Spaces included, exclude the quotes, quotes are example only to show the spaces. I would like to remove these spaces. Is there a

  1   2   >