[PHP-DB] Re: How to Make a Pop Up Window and show there a mysql table?

2003-01-20 Thread Edwin Boersma
I use this: function CopyValue(ChangeWhat,ValueToCopy,aForm) { changer = window.opener.document.+ aForm + . + ChangeWhat + .value=' + ValueToCopy.toUpperCase() + '; eval(changer); submitme = window.opener.document. + aForm + .submit(); eval(submitme); window.close(); }

[PHP-DB] Re: passing variables through frames

2003-02-01 Thread Edwin Boersma
It's better to use input type=hidden name=... value..., because my experience is that it does not work with passing them in the action-option of form. This is the case if u have other input boxes, at least I think it is. If u don't have other input fields, just use a href=url.php?var1=

[PHP-DB] Re: to connect access mdb

2003-02-01 Thread Edwin Boersma
Use the correct ng for your problems. this is for PHP, not ASP. Qt wrote: Dear Sirs, I try to connect my access mdb with following script but I can not succed. I get following error. This server is currently overloaded - please try again later Any idea where is the my mistake. I am using

Re: [PHP-DB] MySQL result resource

2003-02-01 Thread Edwin Boersma
Agree fully Try this: $query = select * from category where id=$scrow-category; $result = mysql_query($query) or die( mysql_error() ); If your query fails, and u still can't find the reason from the information that mysql_error() give you, put a echo $query inbetween to see which string

Re: [PHP-DB] REVISED; need INSERT help

2003-02-01 Thread Edwin Boersma
What about using a form identifier? In each form, use input type=hidden name=formident value=form1 and so on. Then, use: switch ($formident) { case form1: your action for this form break; case form2: and so on. Edwin Mark wrote: I haven't been following any other

[PHP-DB] Parsing html entities to javascript

2003-02-01 Thread Edwin Boersma
the entities (and html at all), and thus displays them as they are, e.g. 913;954;. How can I use php to solve this? I tried unescaping and so, but without result. Or can I tell PHP to store the characters as it did before? Greetz, Edwin Boersma Naxos, GR -- PHP Database Mailing List (http

[PHP-DB] Re: font options

2003-02-02 Thread Edwin Boersma
add some html: echo font family= color= size..., or use a style sheet where you define a DIV. Then echo div [class=...]. At the end of your echo, don't forget to close the tag. Edwin Addison Ellis wrote: hello, what is the proper way to get a block of echoes to echo with the same

Re: [PHP-DB] Re: to connect access mdb

2003-02-02 Thread Edwin Boersma
Boersma wrote: To: [EMAIL PROTECTED] Date: Sat, 01 Feb 2003 18:41:49 +0200 From: Edwin Boersma [EMAIL PROTECTED] Subject: [PHP-DB] Re: to connect access mdb Use the correct ng for your problems. this is for PHP, not ASP. Qt wrote: Dear Sirs, I try to connect my access mdb with following

[PHP-DB] Re: list menu

2003-02-02 Thread Edwin Boersma
You mean, with font? For this, you need a style sheet, or at least style entry in 'select', like this: select style='font-family: ...; font-size: ...;' name=property, etc. See http://www.w3.org/Style/ for more info on styles. BTW: if the values are the same a what you are displaying, you don't

[PHP-DB] Re: Problem

2003-03-08 Thread Edwin Boersma
Does not sound like a PHP problem to me, more like IIS. Try and find some system messages that relate to the link between the servers. Edwin Kiswa wrote: Ok here is the problem. At home i run an Apache server with php4 and the server its supposed to be run on is NT5 and iis with php4 The site

[PHP-DB] Re: Need help with php and apache

2003-03-08 Thread Edwin Boersma
Post this message to php.install. Stephen K Knight wrote: I am currently running on a Windows Box the OS is ME I have installed apache 2.0.44 and I have downloaded the newest PHP download for windows. I have read the configuration manual repeatedly for getting the php into the apache httpd.conf

[PHP-DB] Re: mysql - first element missing

2003-03-08 Thread Edwin Boersma
Therefor, add a mysql_data_seek($this-result,0) to reset the pointer. Furthermore, instead of the for-next loop, I would use while ($row = mysql_fetch_row($this-result). Edwin Foong wrote: i guess the problem is the last line of your Query function: $this-ligne =

[PHP-DB] Re: subtracting times

2003-03-08 Thread Edwin Boersma
I see 2 replies Edwin David Rice wrote: I know I asked this before buy no-one gave me an answer i was looking for, I want to subtract two times and the ammount of hours worked to 2decimal places (3.41 hours) cheers, dave _

Re: [PHP-DB] php, mssql and french accents

2003-03-11 Thread Edwin Boersma
Your code page setting might be wrong. Edwin Benjamin Masdoua wrote: Hello, I'm developping an application using php and mssql. I have problems with french accents, when I insert something from php, and i consult it by enterprise manager (sql server) the accents are replaced, example paté

[PHP-DB] Re: sorting results in PHP

2003-03-18 Thread Edwin Boersma
What about making an array with dates, that you compiled from Year, Month, Date using mktime(), and sort that? Edwin Bill wrote: I have a query that returns results including the fields Year, Month, and Day that I want to sort by date. Because of the nature of the query (it includes a GROUP BY

Re: [PHP-DB] Define()

2003-03-18 Thread Edwin Boersma
Where is the $-sign in front of the vars??? Edwin Jonathan Villa wrote: Jim, I don't think that matters. One can escape into PHP in several ways (depending on the php.ini config of course) 1. ?php 2. ? 3. script language=php 4. % 5. ?= (to echo something right away) Anyway, I tried that

[PHP-DB] mysql_affected_rows() question: what was changed?

2003-03-18 Thread Edwin Boersma
Hi, Is there a function to show WHAT fields were changed in the records, instead of only how many records were changed (with mysql_affected_rows())? I would like to report to the user which fields were altered, e.g. if he would change his phone number, to tell him: phone number changed to

[PHP-DB] Re: Does Php support Flash files ?

2003-03-19 Thread Edwin Boersma
What the fuck R U doing in my thread??/ Rajni Arya wrote: Hi, Does PHP supprots Flash files on Open BSD platform ? Thanks in advance. --Rajni -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL and Cyrillic

2003-03-19 Thread Edwin Boersma
You have to put these lines in your html-page: meta HTTP-EQUIV=Content-Type CONTENT=text/html; CHARSET=Windows-1252 Edwin Nikolay Nikolov wrote: Hello! I have problem with database, where have field with cyrillic char(1). I cant select by this field, because MySQL dont understand this chars

Re: [PHP-DB] Re: Does Php support Flash files ?

2003-03-19 Thread Edwin Boersma
Swearing Well, the word 'fuck' is a bit rude, but I don't think it is swearing. But I get the reactions that I was looking for :-) At 11:34 19-3-03, you wrote: Hi Edwin On Wednesday 19 March 2003 17:21, Edwin Boersma wrote: What the fuck R U doing in my thread??/ Rajni Arya wrote

Re: [PHP-DB] mysql_affected_rows() question: what was changed?

2003-03-20 Thread Edwin Boersma
Not really true, unless I learned programming in a different way ;-) I mean, if I send an update query, like update table set field1=$nfield1, field2=$nfield2 ..., I don't know WHICH fields have changed. mysql_affected_rows() only reports how many records were changed. So, if I want to know

[PHP-DB] Re: Really easy question

2003-03-20 Thread Edwin Boersma
I think Jeremy means how to use it as an integer, if it is stored as a string. In this case, use $intvalue = $strvalue + 0, where $strvalue is 0, 1 and so on. Edwin Jeremy wrote: Hey folks, Im apologize that this is just a really easy general php question but any help would be appreciated. if

[PHP-DB] Re: Reading from file on local disk

2003-03-20 Thread Edwin Boersma
Jan, You cannot get access to files on the client side with PHP, because there is no connection with the client. Have your client copy the file to a directory on the server, that is accessible for PHP and then read them from there. If you use unique names, e.g. workstation names, you should

Re: [PHP-DB] removing values from arrays

2003-06-09 Thread Edwin Boersma
You can also use unset(): if (!array[$key]) unset array[$key]. Edwin Peter Beckman wrote: $x=0; while ($row = mysql_fetch_array($r)) { while(list($key,$val)=each($row)) { if (!empty($val)) $mydata[$x][$key] = $val; } $x++ } Peter On Wed, 21 May 2003, John wrote: ok I've