[PHP-DB] problems with variables

2003-02-03 Thread Marcel
t;\n"; echo "\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/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: problems with variables

2003-02-03 Thread Marcel
Sorry, I see that I've got the a's and q's mixed up. I'll try to clarify it some more by giving an example with 2 variables. $q1 = "first_var"; $q2 = "second_var"; for($i=1;$i<=2;$i++) { echo "\n"; } The output should now be: Hop

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

[PHP-DB] Re: Urent please

2002-07-08 Thread Marcel Schindler
ho $var1 ?>&var2=<?php echo $var2?>"); HTH Marcel -- http://www.trancefish.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: mail()

2002-07-08 Thread Marcel Schindler
>does anyone knows how to configure the mail in PHP/Linux ? >i am triing to use the mail function but it does not work, perhaps lacks some php.in configuration ... Is "SENDMAIL" configured properly? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/

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 save and start it through your browser. Check the following parts: CONFIGURE COMMAND: Is "--with-mysq

[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

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

2002-07-15 Thread Marcel Schindler
"Chip Wiegand" <[EMAIL PROTECTED]> wrote > I have a database, all the data is numbers. I want to make a query that > will extract the data and then make it available in an array, so the > array is populated 'real-time'. I could just enter the number into an > array manually, but I want to automat

[PHP-DB] PHP, Sybase, Stored Procedures

2002-10-04 Thread Walter, Marcel
rkaround or does anyone have a solution 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

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 add column ; 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 the syntax is to add a column

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

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

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

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

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, 6

RE: [PHP-DB] Access counter

2001-07-23 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 > -Origi

RE: [PHP-DB] database abstraction for php3

2001-07-24 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=105&single=1 Although I have changed it a bit to fit my needs the version you get there is quite good ... Cheers, Marcel > -Original Message-

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 M

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("Link"); <= Watch the " ... How should print know where your output is terminating ? Try either: print "Link"; <- In here you can use variables (like: $link) they will get parsed ... Or: print 'Link';<- Note: In here you cannot use variables ... > -Original Mes

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

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] getti

RE: [PHP-DB] please, please can we stop this kind of thing ..... !

2001-08-20 Thread Walter, Marcel
Hmmm @B: In future... everything you send to me will go to /dev/spammer ... > -Original Message- > From: B. van Ouwerkerk [SMTP:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 16:09 > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] please, please can we stop this kind of thing

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] using ref

2001-08-22 Thread Walter, Marcel
Where do you have this "a href" tag? ? ?> 2: ? === If 1) print "$member"; if 2) Should work > -Original Message- > From: Howard Picken [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, August 22, 2001 10:50 > To: [EMAIL PROTECTED] > Subj

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

2001-08-27 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 2

RE: [PHP-DB] Resource ID

2001-08-27 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 $R

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

2001-08-30 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] Sepe