[PHP-DB] PHP, Sybase, Stored Procedures

Hello world, I´ve got a problem concerning PHP, Sybase and Stored Procedures I want to execute a stored proc from sybase called "sp_helprotect" ... this proc is directly from sybase so I don´t want to change it ... When I look at the proc I see that "nocount" is set on... This means that a q

RE: [PHP-DB] a where clause question

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

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

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

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] Connecting to Sybase-DB on another UNIX-Machine

Hello, I´m trying to connect a UNIX-Machine (Apache 1.3.19 and Php-4.0.5) with a Sybase Database on another Machine (The Sybase engine is not completely installed on this machine but I already compiled Sybase-Support into PHP and it worked ...) I can also use the isql-tool via command-line to

RE: [PHP-DB] Protecting database password

On Unix it is possible to make an include file with all the settings like $user, $passwd and so on and store it somewhere in the filesystem (not under your htdocs-path) So no one can access this file via web You can include this file with its variables with the include() - statement ... Im

[PHP-DB] Sybase Mailing List?

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

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

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- > From:

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

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?

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

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

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

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 ..... !

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

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

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

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

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?

Which database do you use ? I don´t know mySql ... but I know Sybase very well and there you have something called Triggers ... [Cite SybaseDoc] A trigger is a stored procedure that goes into effect when you insert, delete, or update data in a table [/CITE] You could say for example Create trig