[PHP-DB] Re: code example to store PHP session data in mySQL ?

2004-10-16 Thread Torsten Roehr
/package/HTTP_Session Just set those two packages up, create a session table (see HTTP_Session/Container/DB.php for the schema) and set this HTTP_Session option: HTTP_Session::setContainer('DB', array('dsn' = $dsn, 'table' = 'sessions', 'autooptimize' = true)); ...and off you go. Regards, Torsten

[PHP-DB] Re: downloading from database

2004-10-16 Thread Torsten Roehr
. Instead right now, it just downloads the page that the button is on. Any ideas? Thanks in advance. Adil. Try this: http://pear.php.net/package/HTTP_Download Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: This is awesome

2004-09-05 Thread Torsten Roehr
Theeb Basheer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, If you have been marketing on the Internet for any length of time, chances are you have heard of Corey Rudl. Corey is one of the most successful REAL-LIFE Internet marketing experts online today. As one of my mentors,

Re: [PHP-DB] Re: Newbie Questions

2004-09-04 Thread Torsten Roehr
times. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2004-09-04 Thread Torsten Roehr
($messages); // will return a random array index echo $messages[$randomKey]; Hope this helps. Regards, torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: chmod

2004-09-04 Thread Torsten Roehr
.php.net/chmod Please do a bit of research before posting to the list. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Newbie Questions

2004-09-02 Thread Torsten Roehr
Pete Holsberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Wed, 1 Sep 2004, Pete Holsberg wrote: On Wed, 1 Sep 2004, Torsten Roehr wrote: Pete Holsberg [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I want to set up a directory with the following

[PHP-DB] Re: Newbie Questions

2004-09-01 Thread Torsten Roehr
own from scratch! :-) Best regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: log in script kicks me out

2004-08-31 Thread Torsten Roehr
and compare the session settings. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: log in script kicks me out

2004-08-27 Thread Torsten Roehr
that there are a number of others who seem to have similar problems, and no solutions. I couldn't see in your messages what PHP version you are using. Any chance to upgrade to 4.3.8? Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Array

2004-08-26 Thread Torsten Roehr
' = $Desc_value3, 'Qty' = $Qty_value3) ); Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Date Conversion

2004-08-18 Thread Torsten Roehr
: $timestamp = strtotime($inputDate); $isoDate = date('Y-m-d', $timestamp); http://de2.php.net/strtotime http://de2.php.net/manual/en/function.date.php Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Basic MySQL Query Question

2004-08-16 Thread Torsten Roehr
. Please try if those changes solve your problem. Whenever one of your values will contain a single quote you will get an SQL error - so use addslashes() or (better) mysql_real_escape_string() on all insert values. Hope this helps. Regards, Torsten Roehr -- PHP Database Mailing List (http

Re: [PHP-DB] Re: Basic MySQL Query Question

2004-08-16 Thread Torsten Roehr
Chad Stalvey [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Ok. It seems that a $_POST value comes over with the escaped single quote as in O\'Neal. So why does it not preserve that escape when pulling a value from a table field, and inserting it back into another table field? When I

Re: [PHP-DB] Lock Record on Postgresql

2004-08-13 Thread Torsten Roehr
be very seldom) he has to cancel and start again. I hope you get my point - it's a bit difficult to explain. Best regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql query

2004-08-13 Thread Torsten Roehr
Justin Patrin [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Fri, 13 Aug 2004 15:20:36 +0200, Quentin Cotillard [EMAIL PROTECTED] wrote: Consider a table similar to the one below. What I want to do is to get ONE random record from categories(cat) A and 5 random record from

Re: [PHP-DB] PHP and mysql script error in webhosting

2004-08-10 Thread Torsten Roehr
break the code of thousands of their clients. You shouldn't judge an ISP from their register_globals setting ;) Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SQL Insert problem

2004-08-05 Thread Torsten Roehr
= '$value1', column2 = '$value2', column3 = '$value3', ... Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: form results to email

2004-07-30 Thread Torsten Roehr
they have to do is fill in the form, hit submit and it will create a new message to be sent. Hi Vincent, wouldn't it be easier to point the form (action) to a web script that will then email the values to wherever it needs to be sent? This would require one less step from the user. Regards, Torsten

[PHP-DB] Re: query problem..

2004-07-14 Thread Torsten Roehr
, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: query problem..

2004-07-14 Thread Torsten Roehr
14 July 2004 11:48, Torsten Roehr wrote: Micah Stevens [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I'm getting an unknown colum `num` in where clause error with this query: $options = mysql_query(select options.*, count(option_items.optionID) as `num

[PHP-DB] Re: table locking ... not required ?

2004-07-09 Thread Torsten Roehr
Michael Gale [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello, I have a web app that uses a mysql database, now lots of INSETS and UPDATES are done on a daily bases. Now I do not want to start locking tables. For the INSERTS it is just a plain insert with a auto incrementing

Re: [PHP-DB] table locking ... not required ?

2004-07-09 Thread Torsten Roehr
John W. Holmes [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Michael Gale wrote: For the UPDATES ... what would have it in theory two people hit the UPDATE button at the exact same time ? Would one just over write the other ... cause that is fine ? Hi Michael, is it really OK

[PHP-DB] Re: $_SERVER['HTTP_REFERRER']

2004-07-09 Thread Torsten Roehr
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] For some reason I cannot get this to work. I'm trying to use the referrer to redirect at the end of a form processing script, but it wont recognize the referrer. I read that it just wont work with some browsers, isps, and/or security

Re: [PHP-DB] fetch row DISTINCT

2004-07-08 Thread Torsten Roehr
with the distinct value as the key and the whole row as the value. Then on each loop iteration check if you already have a row in your array with the current distinct_col value. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: Re[2]: [PHP-DB] MySQL: Random select with specific count of a column

2004-07-06 Thread Torsten Roehr
Pablo M. Rivas [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Torsten, TR thanks for your help. Unfortunately it's always returning the same row for TR each category (maybe because of the group by) and only one row for each TR category. I need to select 2 random rows for

[PHP-DB] Re: MySQL query, using DISTINCT...

2004-07-06 Thread Torsten Roehr
-30' Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Validation Form require.

2004-07-04 Thread Torsten Roehr
Rinku [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear All, Can any of you send me one of your validated form for Numeric value checking Alphabetic Value Checking I have done it but still not succeed. Your answer wd be highly appriciated. Regards, Rinku You can use PEAR's

[PHP-DB] Re: MySQL: Random select with specific count of a column

2004-06-30 Thread Torsten Roehr
Rui Cunha [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Torsten, until now,the best i could get was getting 6 random rows...still working on ensuring to retrive just 2 rows for category...meanwhile,you can solve the problem easily with a php loop trough the following query:

[PHP-DB] Re: images in db

2004-06-30 Thread Torsten Roehr
names and there structure in the database. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MySQL: Random select with specific count of a column

2004-06-29 Thread Torsten Roehr
a 2 de c 3 de a 3 de b Any help greatly appreciated. Thanks and best regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL: Random select with specific count of a column

2004-06-29 Thread Torsten Roehr
Pablo M. Rivas [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Torsten, This is one, but I think you can find another one: Supose your table is called tablename select * from tablename as a left join tablename as b on a.category = b.category and

[PHP-DB] Re: Two Tables on One Page

2004-06-29 Thread Torsten Roehr
tried starting the second script where the select language begins. These options produce an error message and no table. Just duplicate the code that outputs your first table and change the parameters to work with your second table!?! Could you post some of your code? Regards, Torsten Roehr

[PHP-DB] Re: 2 requests: validate 2 password fields as equal and rewrite data

2004-06-28 Thread Torsten Roehr
Vincent Jordan [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Could someone instruct me or point me in the right direction. I would like to have a input type=password name=password input type=password name=password2 when submit it will check to se if password and password2 are = ( i do

[PHP-DB] Re: problem in updating data

2004-06-28 Thread Torsten Roehr
as the field names. $field_values = ''; foreach ($values as $column = $value) { $field_values .= (empty($field_values)) ? SET $column = '$value' : , SET $column = '$value'; } Hope this helps, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] How to define array variable while accessing it ???

2004-06-28 Thread Torsten Roehr
this as an array The closing php tag and quote of the value attribute was missing: input type=checkbox name=delete[] value=?= $row[0] ? / Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Auto increament

2004-06-27 Thread Torsten Roehr
/CREATE_TABLE.html (Seatch for AUTO_INCREMENT in the text) Please do a bit more reasearch on your own before posting to the list. Thanks. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: return array

2004-06-26 Thread Torsten Roehr
($field) instead of return $field to see if the contents is what you are expecting. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: ummm i am confused

2004-06-26 Thread Torsten Roehr
TR Water_foul [EMAIL PROTECTED] wrote in message TR news:[EMAIL PROTECTED] i get the following error: Parse error: parse error, unexpected ';' in TR C:\Inetpub\localroot\aichlmayr.net\sites\aaron\module\runescape\runerunner\s ervices.php on line 4 from the following code: ?php

[PHP-DB] Re: Date Select

2004-06-25 Thread Torsten Roehr
. The date format in the field is -MM-DD Please go to the mysql.com website, search for date and you'll find a detailed description of how to query date columns. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Php form row delete problems

2004-06-25 Thread Torsten Roehr
table where user_id = ' . $user_id; // commit query } Hope this helps, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Posting Data to MySQL

2004-06-24 Thread Torsten Roehr
a lot of information to display on one page. Can you split it up into several forms? Of course this would not mean fewer work but maybe make it a bit mor concise. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Posting Data to MySQL

2004-06-24 Thread Torsten Roehr
Mark A Galbreath [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Doesn't matter how many fields are on a form; they are returned as an array of strings in the request object. Just iterate through the array and update the corresponding database fields. Mark, what I was trying to say

[PHP-DB] Re: Stopped working?

2004-06-21 Thread Torsten Roehr
was my counter kept your number so that you were only counted once. But now it's not getting the number. Has this command changed in the past 2 SuSE version? Try accessing the value via $_SERVER['REMOTE_ADDR']. HTH, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] get all records but limit to 6

2004-06-14 Thread Torsten Roehr
6. No. The sorting is done BEFORE the limitation. So Sunmaia's query will work as required by Gawie. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: auto update mysql table with the current date time

2004-06-14 Thread Torsten Roehr
Gawie Marais [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi guys, me again ! i need to update a record in a mysql table. now i have defined a datetime field when a record is modified... i want to 'auto update' that field whenever a record is modified... what would the php script

[PHP-DB] Re: diplicate entries

2004-06-11 Thread Torsten Roehr
and therefore the form should not be processed. IMPORTANT: When creating the random token check if a token with this value already exists in the session array. Hope this helps. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Re: mysql results, arrays, and for loops

2004-06-11 Thread Torsten Roehr
// do what you want with row, e.g. print a field value from column date echo $row['date']; } Is this what you are looking for? Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: HTTP header information

2004-06-10 Thread Torsten Roehr
'??? Make sure that NO output is done before session_start() is called. Can you post some of your code? Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: HTTP header information

2004-06-10 Thread Torsten Roehr
Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Jun 10, 2004, at 9:44 AM, Torsten Roehr wrote: Philip Thompson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all. I am running a website to where a user needs to login to authenticate

[PHP-DB] Re: Getting data from mysql db for html form

2004-06-09 Thread Torsten Roehr
column. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] DISTINCT and multiple results...

2004-06-07 Thread Torsten Roehr
, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: big/small letters with oracle No2

2004-06-01 Thread Torsten Roehr
() to make the first letter uppercase: echo ucfirst(mb_strtolower($fieldname)); Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: big/small letters with oracle No2

2004-06-01 Thread Torsten Roehr
() to make the first letter uppercase: echo ucfirst(mb_strtolower($fieldname)); Regards, Torsten Roehr I know, but there are not only elements but also abbreviations like PCB, PAK..., which should stay as they are. Torsten Then I see only one way: create a mapping array to map your field names

[PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all, I have a problem: my $_SESSION variables and $_COOKIE variables get destroyed very often, even though my clients are actively browsing the site (that means, the variables should not be garbage collected). Our

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi.. the situation is like this: my clients' $_SESSION gets destroyed even after only a few seconds of inactivity! so, with my current setting for gc_maxlifetime (1440), it should be more than enough to have their sessions

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Message - From: Torsten Roehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 6:19 PM Subject: Re: [PHP-DB] Re: $_Session vs $_Cookie Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi.. the situation is like this: my clients

[PHP-DB] Re: Re: $_Session vs $_Cookie

2004-05-31 Thread Torsten Roehr
Alexey Kupershtokh [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi. Is your server running on Windows? Have you tried using a database as your session container? Hmm... that's something new for me :) How to implement it ? Manually ? Or it is available in php config file? Or

[PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread Torsten Roehr
. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread Torsten Roehr
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ... Thanks for responding, Torsten. If I'm understanding your suggestion, then what happens where the data from the dB already has a ; (semi-colon) in it? Wouldn't this corrupt the import into excel? This might cause a problem because

Re: [PHP-DB] Re: Convert HTML Table to Tab Delimited .TXT file

2004-05-24 Thread Torsten Roehr
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ... Thanks for responding, Torsten. If I'm understanding your suggestion, then what happens where the data from the dB already has a ; (semi-colon) in it? Wouldn't this corrupt the import into excel? Please take a look at PEAR's

[PHP-DB] Re: Printing Forms

2004-05-21 Thread Torsten Roehr
Hi Mike, you could put placeholders into your Word document and then replace them with your MySQL data by opening the file contents and applying str_replace() to all placeholders. Regards, Torsten Mike Koponick [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have a need to extract

[PHP-DB] Re: Informix and PHP

2004-05-21 Thread Torsten Roehr
D. Sandmann [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Any help would be appreciated on this. I have already asked this question on the regular PHP and Informix news groups and have not had any luck. Maybe one of you can resolve my problem. I have had this problem in the past

[PHP-DB] Re: search engine query

2004-05-19 Thread Torsten Roehr
Bobo Wieland [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi! I'm new to this list. I usually try to get my answers at the php-win mailing list... But since this is a mysql question I thought it would be better to ask i t here; How do I get the best result from a simple search

[PHP-DB] Re: MySQL to DBF

2004-05-19 Thread Torsten Roehr
Emilio Alvarado [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I need to make a dbf file with some mysql records The creation of the dbf with the dbase_create works FINE Now I need to fill the dbf, I have a mysql database with some of the data, I have the apropiate SQL to view that

Re: [PHP-DB] explode() and a database call...?

2004-05-18 Thread Torsten Roehr
Tristan Pretty [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] com... HH, didn't work...? Please echo out $row['bands'] and post the contents. Regards, Torsten Mikhail U. Petrov [EMAIL PROTECTED] 18/05/2004 16:20 Please respond to Mikhail U. Petrov [EMAIL PROTECTED]

[PHP-DB] Re: inserting data into database!

2004-05-14 Thread Torsten Roehr
Ronald Allen [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Two questions? First why am I getting undefined variable tmp , yet it works Second how would I insert data into this table? ? $db_table = 'log'; $conn = mysql_connect($db_host,$db_user,$db_pass); if ($conn == true) {

[PHP-DB] Re: I'm new at PHP and MySQL and have a problem

2004-05-11 Thread Torsten Roehr
News.Php.Net [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] To help me learn using these awesome tools together, I'm creating a sample application for myself - a movie database. In this database (which is named movies), I have five tables. One named moviemain, one named actors,

[PHP-DB] Re: From MySQL to PostgreSQL

2004-05-08 Thread Torsten Roehr
Marcjon Louwersheimer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi. I developed a forum using php5 and mysql. Right now I'm hosting it on my computer, for version for myself and another for a school I volunteer at. I would like to move the forums to the school's server.

[PHP-DB] Re: how to parse php code stored in databases?

2004-05-08 Thread Torsten Roehr
Florian Wagner [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi there, I thought it would be a great idea to store the code of nearly all my web pages in text fields of a mysql database. Now I've got the problem that I want to use php in those pages. Let's say $row[content]

[PHP-DB] Re: Insterting date in an MySQL table

2004-05-06 Thread Torsten Roehr
Charalambos Nicolaou [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi everyone, I want to created a MYSQL table which will get the date in the form (-MM-DD) automatically. I have created the table below but it doesn’t get the form of date that I want. It has the form

[PHP-DB] Re: Page cannot be displayed continues

2004-04-30 Thread Torsten Roehr
Matthew Perry [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Everyone, Thank you very much for your advice about not using PUT. I will use GET or POST from now on. I am, however, failing to understand how to use headers to change pages instead of meta tags. After checking if

Re: [PHP-DB] Session

2004-04-27 Thread Torsten Roehr
Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] thanx Mike, i'm sure i have session_start() on all my pages. Why I'm so confident is because my session gets unset occassionally and not everytime. i cannot find a pattern and so it is not a consistent problem.. it's so

Re: [PHP-DB] Session

2004-04-27 Thread Torsten Roehr
. But does it mean that by lengthening this value, the session will still be kept even if the user closes his browser?? Please advice! looking forward to solving this!! many thanks, Hwee - Original Message - From: Torsten Roehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 27

Re: [PHP-DB] Session

2004-04-27 Thread Torsten Roehr
to check if a user is logged in, the session is expired and so on. Regards, Torsten look forward to your reply! thanks again, Hwee - Original Message - From: Torsten Roehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 6:48 PM Subject: Re: [PHP-DB] Session

Re: [PHP-DB] Session

2004-04-27 Thread Torsten Roehr
On that note, here are a few things you might want to consider if you want to make sessions more secure: - use only cookies for sessions. (session.use_only_cookies = 1) This prevents the session ID from *ever* being added to the URL. URLs get logged -- by apache, by proxy servers, by user

[PHP-DB] Re: assigning variables after one-to-many query

2004-04-23 Thread Torsten Roehr
Rachel Rodriguez [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi! I have a one-to-many relationship between two tables (table1 and table3) with a linking table between them (table2): table1: table2 +---++ +---++ |id | f_name | |id | emailID|

Re: [PHP-DB] Problem with update-command

2004-04-22 Thread Torsten Roehr
Jeffrey N Dyke [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] $result=mysql_db_query(usr_172_1,UPDATE artikel SET Preis='\$preis\' WHERE ID='\$id\'); //mysql_error($result); Here you're escaping the $ and then the ', have you tried $result=mysql_db_query(usr_172_1,UPDATE

[PHP-DB] Re: Remove white space?

2004-04-22 Thread Torsten Roehr
Robert Sossomon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am pulling data from a MySQL DB and I need to remove the whitespace on the variable and turn it to lowercase. ! Code Snippet $get_items = select * from PFS_items; $get_items_res = mysql_query($get_items) or

[PHP-DB] Re: What's wrong with this IF statement?

2004-04-22 Thread Torsten Roehr
Robert Sossomon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] My IF statement should be picking up on the numbers, and if the number matches not be displaying out the information, however I look at the outputted page and the information is still there, what have I got wrong on the

[PHP-DB] Re: Mysql Foreign Keys

2004-04-21 Thread Torsten Roehr
foreign key constraints. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: mysql foreign key syntax / tutorial

2004-04-21 Thread Torsten Roehr
Sales ADD FOREIGN KEY ItemID(ItemID) REFERENCES Items(ItemID) ON DELETE RESTRICT; Am I correct? thanks. Take a look here: http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Re: Double Submission into DB if Hit Refresh

2004-04-18 Thread Torsten Roehr
id. This should work for MySQL - I don't know if it works for other DBs as well. I don't see a problem for multiple updates as the data usually won't change between the refresh. Regards, Torsten Roehr __ Craig Hoffman - eClimb Media v: (847) 644 - 8914 f: (847