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

2004-04-18 Thread Torsten Roehr
gnores multiple inserts with the same 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 > __ >

[PHP-DB] Re: Mysql Foreign Keys

2004-04-21 Thread Torsten Roehr
you need to know about 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
ientID(ClientID) > REFERENCES Clients(ClientID) > ON DELETE RESTRICT; > > ALTER TABLE 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/In

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_

[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. > > > > $get_items = "select * from PFS_items"; > $get_items_res = mysql_query($get_items) or die(mysql_

[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 >

[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 |

[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 "

[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 == t

[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. Ap

[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["cont

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

Re: [PHP-DB] Session

2004-04-27 Thread Torsten Roehr
person works a maximun of 12 hours a day. 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" <[EM

Re: [PHP-DB] Session

2004-04-27 Thread Torsten Roehr
e if it's what you want. I'm using the PEAR::HTTP_Session package to control the session data and have my own Auth class 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 > >

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

[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

[PHP-DB] Re: Optimize Tables

2004-05-03 Thread Torsten Roehr
You could set up a PHP cron job to do this. Regards, Torsten "Ng Hwee Hwee" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi, Is there a way to create a schedule to optimise my MySQL tables automatically? The overhead of some of my tables can reach 355,548 bytes over 3 working day

[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 (

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" <

[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 simp

[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 vie

[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 extra

[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 th

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

2004-05-24 Thread Torsten Roehr
. Just put a ; between all values and save it as a text file with .csv extension. I think you don't need to go all the way via HTML output and copy/paste. Hope this helps. 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 becau

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 Spr

[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).

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

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

2004-05-31 Thread Torsten Roehr
; do you think by upgrading it will solve all my problems?! > > thanx a million!! > > - Original Message - > From: "Torsten Roehr" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, May 31, 2004 6:19 PM > Subject: Re: [PHP-DB] Re:

[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 confi

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

2004-06-01 Thread Torsten Roehr
ower() to convert the column names to lower case and then ucfirst() 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
e. the parameter columns (Na, Mg...). Locations etc. >>>belonging of course to data sets. >>> >>> >> >>Hi Torsten, >> >>you can use mb_strtolower() to convert the column names to lower case and >>then ucfirst() to make the first letter uppercase

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

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

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

2004-06-09 Thread Torsten Roehr
echo ''; Haven't tested it. Change 'name' to the name of your table column. 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
I understand why > this is occurring, but is there an easy way to get around it without > creating a new page, such as 'submitproblem.php' instead of > 'viewer.php?type=submitproblem'??? 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. &

[PHP-DB] Re: diplicate entries

2004-06-11 Thread Torsten Roehr
e same form is re-submitted the token will be found in the session array 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 Mail

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

2004-06-11 Thread Torsten Roehr
the current record set as an associative array, keys represent the field names // 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

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

2004-06-14 Thread Torsten Roehr
whatever you have to do > with the first 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 ph

[PHP-DB] Re: Stopped working?

2004-06-21 Thread Torsten Roehr
>I believe that this has stopped working. The idea 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,

[PHP-DB] Re: Posting Data to MySQL

2004-06-24 Thread Torsten Roehr
n > sites like Hotscripts, but can't find anything. Hi Tom, that's 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

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 t

[PHP-DB] Re: Date Select

2004-06-25 Thread Torsten Roehr
results for the last week only. > 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/

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

2004-06-25 Thread Torsten Roehr
ry = 'DELETE FROM 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: return array

2004-06-26 Thread Torsten Roehr
$field[$i] = mysql_field_name($fields, $i);} > return $field[]; > } Do a print_r($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

[PHP-DB] Re: ummm i am confused

2004-06-26 Thread Torsten Roehr
word) You are missing a ; on the above line. PHP even told you on what line the error occurred. You do not have to post all of your code if the error occurs on line 4. And please choose a better subject for your posts. 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 foll

[PHP-DB] Re: Auto increament

2004-06-27 Thread Torsten Roehr
ev.mysql.com/doc/mysql/en/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: 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 > when submit it will check to se if password and password2 are = ( i do not want >password2 to end up in POST on submit.) > >also i a

[PHP-DB] Re: problem in updating data

2004-06-28 Thread Torsten Roehr
This way you don't need to get the field names from the table every time: $values = array('field1' => 'myValue', 'field2' = 25); Then you build your update statement by looping through this array and use the array keys as the field names. $field_values = &

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

2004-06-28 Thread Torsten Roehr
"Matt M." <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > " value="" > > > setup your checkbox something like this: > > 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
2 de 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
t; script. I have also 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? R

[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 qu

[PHP-DB] Re: images in db

2004-06-30 Thread Torsten Roehr
tructure. Store the files on the server and manage the file 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] 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

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

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

2004-07-06 Thread Torsten Roehr
e_name: SELECT DISTINCT email FROM `completed_downloads` WHERE `bu` = 'reech' AND date BETWEEN '2004-06-01' AND '2004-06-30' Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] fetch row DISTINCT

2004-07-08 Thread Torsten Roehr
col. Maybe you should try filtering the results in PHP. You could create an array 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 Datab

[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 increm

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

[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 secu

[PHP-DB] Re: query problem..

2004-07-14 Thread Torsten Roehr
ne.. Any idea > why it's popping the error? > > -Micah Remove the quotes around num and try again. Regards, 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
nks it's a column. Torsten > > > -Micah > > > > On Wednesday 14 July 2004 11:48, Torsten Roehr wrote: > > "Micah Stevens" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > > > Hi, > > > > > &

[PHP-DB] Re: form results to email

2004-07-30 Thread Torsten Roehr
o be sent? This would require one less step from the user. 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
#x27;, '$reason', '$rmanumber') or die > > (mysql_error())"; > > You list 13 columns to insert into but only give 12 values. > Vincent, you can use the alternative INSERT syntax to avoid this problem in the future: INSERT INTO table SET column1 = '$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

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

2004-08-10 Thread Torsten Roehr
t to On. ;-) > > -Robby register_globals itself is no direct security hole - it's the way the application is handling the data that might be insecure. ISPs that have been offering PHP for years just CANNOT turn off register_globals easily as it could 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] Lock Record on Postgresql

2004-08-13 Thread Torsten Roehr
nd the user will at least be able to "open" the record set and see all data - even if sometimes (should 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 r

[PHP-DB] Re: Basic MySQL Query Question

2004-08-16 Thread Torsten Roehr
difference? It seems that if it works one place, then it should > work every where? > > Or would it matter that name is not a key in the members table but is in the > tickets, or Vice Versa? > > This is really bugging me. Please try if those changes solve your problem. Whenever

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?

[PHP-DB] Re: Date Conversion

2004-08-18 Thread Torsten Roehr
ou can use strtotime() to convert various formats to a timestamp. Then use date() to convert it back to your preferred date format: $timestamp = strtotime($inputDate); $isoDate = date('Y-m-d', $timestamp); http://de2.php.net/strtotime http://de2.php.net/manual/en/function.date.php Rega

[PHP-DB] Re: Array

2004-08-26 Thread Torsten Roehr
7;Qty' => $Qty_value1), array('PN' => $PN_value2, 'Desc' => $Desc_value2, 'Qty' => $Qty_value2), array('PN' => $PN_value3, 'Desc' => $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: log in script kicks me out

2004-08-27 Thread Torsten Roehr
g like "$_SESSION second time" I >see 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 Mail

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

2004-08-31 Thread Torsten Roehr
lf? Do a echo phpinfo(); on both systems 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: Newbie Questions

2004-09-01 Thread Torsten Roehr
tarted? It seems like a pretty easy > things to do. Perhaps if someone has already done this, > they might share their stuff with me. I'm much better at > hacking away at other people's stuff than developing my 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: 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 >

Re: [PHP-DB] Re: Newbie Questions

2004-09-04 Thread Torsten Roehr
ay - should be quicker than doing it in the application in 9 out of 10 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
le() returns an array where each line is an array element $randomKey = array_rand($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
the search input field on php.net (search whole site) would have lead you to: http://de3.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

[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

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

2004-10-16 Thread Torsten Roehr
'table' => 'sessions', 'autooptimize' => true)); ...and off you go. Regards, Torsten Roehr -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: downloading from database

2004-10-16 Thread Torsten Roehr
t when I click on the download button I want the > file to download to my machine. 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 R