[PHP-DB] problems with variables

2003-02-03 Thread Marcel
input type=\hidden\ name=\q1\ value=\$q1\\n; echo input type=\hidden\ name=\q2\ value=\$q2\\n; ... ... So I want to make the variables $q1 .. $qX from q$i Is this possible and if so, how? Thanks for your support, Marcel -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Re: problems with variables

2003-02-03 Thread Marcel
=first_var input type=hidden name=q2 value=\second_var Hope you can help me, Marcel - Original Message - From: [EMAIL PROTECTED] Newsgroups: php.db To: [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 3:24 AM Subject: Re: problems with variables Marcel [EMAIL PROTECTED] wrote: Can

[PHP-DB] insert binary file into MSSQL

2001-04-06 Thread Marcel Liberda
Anybody got a sample script for store/retrieve binary data (images, wav files, mp3) to/from a MSSQL database (7.0)? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

[PHP-DB] ODBC and Memofields

2001-05-07 Thread Marcel Spaarman
To anyone that may know... I'm having a problem with the memofields in my Paradox Database. My DSN cannot handle them and I don't know why. All I get is an external error: Warning: SQL error: [Microsoft][ODBC Paradox Driver] Unexpected error from external database driver (28610)., SQL state

[PHP-DB] Connecting to Sybase-DB on another UNIX-Machine

2001-07-17 Thread Walter, Marcel
to connect to a Sybase database on another server (So, the Server exists in the interfaces-file) But when I try this: sybase_connect(SERVER,USER,PASSWD); I don´t get a link-identifier back ... The Parameters are correct !! What could be the problem ??? MfG Marcel Walter If you have received

RE: [PHP-DB] Protecting database password

2001-07-18 Thread Walter, Marcel
... Imagine your PHP-Engine won´t work and someone accesses a page where you included this file with the settings he will never see your Password but just the include-statement ... nothing else ... And he won´t be able to access the file since its not in yout /htdocs - Path ... Cheers, Marcel

[PHP-DB] Sybase Mailing List?

2001-07-20 Thread Walter, Marcel
Sorry to ask this here, but I don´t know where to ask else ... Does someone know a good mailinglist about specific sybase questions? I have some questions about BCP ... MfG Marcel Walter Dresdner Kleinwort Wasserstein Foreign Exchange Money Market Address:Jürgen-Ponto-Platz 1, 60301

RE: [PHP-DB] Access counter

2001-07-24 Thread Walter, Marcel
Another idea of mine: You could start sessions and register a variable... and everytime a new user wants to request a page you can find out whether its a new user or not if you check the variable ... If it is new, then do the stuff below ... elso don´t ... Cheers, Marcel -Original

RE: [PHP-DB] database abstraction for php3

2001-07-25 Thread Walter, Marcel
I use the CDBAbstract but don´t know if it is possible to use it with PHP3 ... Just give it a try Go to http://www.zend.com/codex.php?id=105single=1 Although I have changed it a bit to fit my needs the version you get there is quite good ... Cheers, Marcel -Original Message- From

RE: [PHP-DB] delete user but keep the article

2001-08-15 Thread Walter, Marcel
Do you really have to delete the users ? You could for example give the users a special flag which shows that the users can´t no longer log in ... so you have still the information about your user and the user cannot log in (at least if you check the flag) Is this okay ? -Original

RE: [PHP-DB] How to create table?

2001-08-15 Thread Walter, Marcel
pet (name VARCHAR(20) is okay Because he wrote: create table pet ( -- pet = Table Name name VARCHAR(20), owner ) the query is okay ... But I would allow NULL in the death - column (I don´t know what the default is in MySql) Or is every (!) pet you enter in your

RE: [PHP-DB] A newbie question

2001-08-15 Thread Walter, Marcel
You tried this: print(a href=whateverpage.phpLink/a); = Watch the ... How should print know where your output is terminating ? Try either: print a href=\whateverpage.php\Link/a; - In here you can use variables (like: $link) they will get parsed ... Or: print 'a

RE: [PHP-DB] getting ID

2001-08-20 Thread Walter, Marcel
Is there a similar function for a Sybase - Database ? -Original Message- From: Ian Grant [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 12:20 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] getting ID mysql_insert_id([resource link_identifier]) returns the value of the

RE: [PHP-DB] getting ID

2001-08-20 Thread Walter, Marcel
Yap ... this works quite fine with Sybase Thank you very much ... -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 12:27 To: Walter, Marcel Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] getting ID With MSSQL I do

RE: [PHP-DB] Slightly OT - maybe just SQL not php

2001-08-21 Thread Walter, Marcel
On Sybase the following script: create table #temp_table ( a varchar(10), b numeric identity ) insert into #temp_table (a) values (1234) insert into #temp_table (a) values (234) insert into #temp_table (a) values (134) insert into #temp_table (a) values (124) insert into

RE: [PHP-DB] Accessing fields with the same name in MySQL

2001-08-28 Thread Walter, Marcel
You have two times the field id Look at your query ... especially the Where-Clause .. You only want to show Recordsets where id = id ... = In both columns is the same value ... -Original Message- From: Trevor Lanyon [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 27, 2001 20:13

RE: [PHP-DB] Resource ID

2001-08-28 Thread Walter, Marcel
I don´t know what your class does ... but normally queries work like this: open database $qresult = query(select blah,$link_id); // Now, in $qresult is a number with which you can go through your resultset ... // For Example: while ( $Recordset = ezi_fetch_array($qresult) ) { print

RE: [PHP-DB] Seperate Tables for Same Data?

2001-08-31 Thread Walter, Marcel
trigger for blahblah on insert as begin take the inserted recordset and put it in another table ... end Cheers, Marcel -Original Message- From: jv [SMTP:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 17:44 To: [EMAIL PROTECTED] Subject: [PHP-DB] Seperate Tables for Same

[PHP-DB] Problem with arrays

2002-06-14 Thread Marcel Schindler
Hi there, Sorry for my bad english. I want to read a table from a mySQL-database and store it in an array built like this: $value[column][row]; I am not sure, how this is done. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] template problem!!!

2002-07-08 Thread Marcel Schindler
Hi Just enclose it in ?php ? You can do this in either templates or html pages Yeah, but this is against the template-system. Of course, this is possible but templates are usually for seperating the code from the design -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Problem whith mysql_connect()

2002-07-10 Thread Marcel Schindler
Fernando Gonzalez [EMAIL PROTECTED] wrote Php Was installed when installing the Red Hat 7.0 . Mysql Was installed later from rpm. Any ideas of what can I do??? write this script ?php phpinfo(); ? save and start it through your browser. Check the following parts: CONFIGURE COMMAND: Is

[PHP-DB] Re: Great tool

2002-07-10 Thread Marcel Schindler
César aracena [EMAIL PROTECTED] wrote: Hi all. I found in one of these DB lists a word about a tool called MySQL - Front so I went there, downloaded it and ran it today for the first time and well... ¡¡TWO THUMBS UP!!! It really seems like a great GUI app. I installed it over Win XP

[PHP-DB] Re: extract data from database into an array

2002-07-15 Thread Marcel Schindler
; // Stores the current Database Connection ID var $db_datasets = array(); // Stores the last read database-Set as hash [colum-name][row_number] /** * Connect * @author Marcel Schindler * @param bool $persistant * @return void **/ function connect($persistant = FALSE

[PHP-DB] PHP, Sybase, Stored Procedures

2002-10-04 Thread Walter, Marcel
to this problem ??? Looking forward to all answers ... Regards, Marcel -- If you have received this e-mail in error or wish to read our e-mail disclaimer statement and monitoring policy, please refer to http://www.drkw.com/disc

RE: [PHP-DB] a where clause question

2002-10-07 Thread Walter, Marcel
Hi Alex, I believe your database-design is not good ... think about a re-design or send us some info about your tables. Maybe we find a better solution... Regards, Marcel -Original Message- From: Alex Shi [mailto:[EMAIL PROTECTED]] Sent: 06 October 2002 22:43 To: [EMAIL PROTECTED

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Walter, Marcel
For mysql: Alter table tablename add column column-name columntype; Regards, Marcel -Original Message- From: Shaun Thornburgh [mailto:shaun;mania.plus.com] Sent: 31 October 2002 13:39 To: [EMAIL PROTECTED] Subject: [PHP-DB] Add column to a table Hi, Please could someone tell me what

RE: [PHP-DB] Re: cookie trouble

2002-11-01 Thread Walter, Marcel
Try something like $_COOKIE_VARS[user] ... or $COOKIE_VARS[user] ... dunno exactly ... -Original Message- From: Seabird [mailto:jacco;vliegt.nl] Sent: 01 November 2002 10:04 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: cookie trouble Now, I have set the cookie, but when I run this