Re: [PHP-DB] Picture Upload

2003-03-11 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Dallas Freeman) writes: > I have asked my host to update the php software, as for now, I need to > know what the lines for changing the size of a picture is. I couldn't > see any command lines for it, unless it is something different, I don't > know, so could you please show me.

Re: [PHP-DB] need help with foreach()

2003-03-09 Thread Fredrik de Vibe
[EMAIL PROTECTED] (David Rice) writes: > Hey thank's for the ideas but neither of them work, doh... > Okay fredrik I know your idea won't work cos list only works with > numericaly indexed arrays, both the arrays that i am using are indexed > by date. You really had me wondering there for a momen

[PHP-DB] Re: need help with foreach()

2003-03-09 Thread Fredrik de Vibe
[EMAIL PROTECTED] (David Rice) writes: > Okay, i have two arrays, $tips and $staff > > $tips has a key "date" (which is the date of the first day of the > week, the second result in the array has the key of the second day of > the week etc... ) and the value is a floating point decimal. > > $staf

[PHP-DB] Re: explode string variable

2003-03-08 Thread Fredrik de Vibe
[EMAIL PROTECTED] (André Sannerholt) writes: > Does anybody know how to "stop" an "explosion" of a string: Let me explain: > > $variable_aray=explode('-', $variable); > > I want the variable to be devided in only two other ones! If for example: > > $variable="Willy-Brandt-Platz-5" > > I want to

[PHP-DB] Re: file save

2003-03-06 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Ryan Holowaychuk) writes: > I am saving some data to a text file and what I want to do is have each > line of data collected to be on its own line. > > What I am collecting is a roster (no, name, grade) so there is 10-15 > people on a roster, and now when it saves it saves t

[PHP-DB] Re: Update MD5 field

2003-03-03 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Dani Matielo) writes: > my problem is the following: I just imported a csv file to a MySQL database > that contains name and email fields. It has about 9k lines on it and I need > a new field that orinally didn't exist called "code" thats suposed to be > > MD5(name.email) > > I

[PHP-DB] Re: Processing Page

2003-02-27 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Aspire Something) writes: > We are working on a project where the backend churns data for about > 1 Minute (time out limit is 2 min) we would like to put a page like > PROCESSING > during the database is busy doing its fine job. And also a sucess > page appears when the pr

[PHP-DB] Re: PHP/SSL and Hosting question

2003-02-27 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Chris Payne) writes: > ... What is the best SSL to use on Windows ... > [ snip ] > ... any thoughts? Kind of religious, but maybe not Windows at all, at least if you're concerned about safety ;-) -- --Fredrik If God is dead, who will save the Queen? -- PHP Database Mailing

[PHP-DB] Re: Get MySQL table schema for a dump

2003-02-26 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Jonathan Villa) writes: > Is there was to get a database's table schema? I don't think it's called schemas in mysql, but I'm not sure :-) > So far, I have a simple function which will output > INSERT INTO table (x,x,x,) VALUES(x,x,x); > [ ... ] > but what I'm missing is > CRE

[PHP-DB] Re: PHP session problems

2003-02-25 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Fredrik De Vibe) writes: > You can't register a session variable after output. You have already > registered it, just set $valid_user = 'something'. Sorry, I was a bit too quick here. You _can_ register session variables after output... -- --Fredr

[PHP-DB] Re: PHP session problems

2003-02-25 Thread Fredrik de Vibe
[EMAIL PROTECTED] (David Rice) writes: > I have been having trouble with PHP sessions, the session variables > are not able to be called through the script. > > If have commented the area at the bottome where the session variable > is NULL when var dump is called to check it (about 20 lines from t

[PHP-DB] Re: Question concerning hostnames

2003-02-25 Thread Fredrik de Vibe
[EMAIL PROTECTED] (2b4ever Php) writes: > I want http://www.pageTwo.com to be redirected to > http://www.pageOne.com/pageTwoindex.html, without losing the address > http://www.pageTwo.com. Maybe something like header("location: http://www.pageOne.com/pageTwoindex.html?ref=http://".$_SERVER["HT

[PHP-DB] Re: inserting binary data into a mysql blob field

2003-02-24 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Craig Kohtz) writes: > [ inserting images into a mysql db ] I haven't done it myself, but a search on php.net for "blob mysql file" gave (among others) http://www.php.net/manual/en/features.file-upload.php (seach the page for 'blob'). On the other hand, it has been said that st

[PHP-DB] Re: question

2003-02-24 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Ali M) writes: > Is this the place to post questions on php & db's? "php.db" - yes ;-) -- --Fredrik Whether you can hear it or not The Universe is laughing behind your back -- National Lampoon, "Deteriorata" -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Re: Getting results from MySQL

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Anders mellström) writes: > But I'm afraid that I don't really understand. Wouldn't I need a > webserver on my local computer to view serverside-code? That I don't > have. But that shouldn't be the problem since I have the same code > on another page on the same ISP (as I mention

[PHP-DB] Re: mysql to cvs file to excel

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Mark Snijders) writes: > does anybody know if it's possible (without php) to export data from > mysql to a cvs file, so i can import it in excel??? Not a cvs file, that's for sure, but I guess you mean csv. You can of course script this with other languages than php, but you can

[PHP-DB] Re: Getting results from MySQL

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Anders mellström) writes: > I have a PHP<->MySQl-problem. I would be very greatful if anyone > would help me. I am - with the following code - trying to get > results from a database. The problem isn't recieving the results, > it's where i get the results. All the information is

[PHP-DB] Re: php/mysql query

2003-02-21 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Julie Keywell) writes: > I am querying our database for 11,000 different zip codes and it seems > to be overloading MySQL. However, common sense says it shouldn't. > > My question is: > When needing to query 11,000 things, is it best to make 1 SQL statement > that has 11,000 or

[PHP-DB] Re: displaying hyperlinks in MySQL query results

2003-02-20 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Rick Tucker) writes: [ snip ] > The first 3 columns return perfectly. The Vendor URL data, on the other > hand, is returned as text, rather than hyperlinks. I've tried tweaking the > code several different ways with no success. > > The following code is what I started with. I

Re: [PHP-DB] Re: Final Date Question :-)

2003-02-19 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Chris Payne) writes: > Basically what I mean is I have an orderform for rooms. THey can select the > date they arrive and the date they leave, but if they leave on a different > month when the price is higher, the last day or however many will be a > higher price, what I need is

[PHP-DB] Re: Final Date Question :-)

2003-02-19 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Chris Payne) writes: > pardon les francais :-) Les Français - the (pl) french (people) ? ;-) > I don't know how else to explain it so sorry if I confused you. I don't know if anybody else might get this, but I have absolutely no idea what you mean. If I'm to say anything, I th

[PHP-DB] Re: Date Question

2003-02-19 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Chris Payne) writes: > I have the following 2 dates (FOr example): > 19-02-2003 > 21-02-2003 > How can I easily find out how many nights there are between the 2 > dates? For example, the above would be 2 nights as the 21st would be > the checkout date. I guess this will work:

[PHP-DB] Re: string manipulation

2003-02-18 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Martin Dziura) writes: > is there some sort of parsing call i can evoke to extract the url? > Beginning with the http and ending with the first white space? $str = "foobarbazhttp://www.foo.bar/";; preg_match("/(http:\/\/\S+)/", $str, $match); $match[1] should contain the url pa

[PHP-DB] Re: Help with array

2003-02-16 Thread Fredrik de Vibe
[EMAIL PROTECTED] (John Thorne) writes: [ snip ] > $data[$cpt]= > $rownu.","."\"".$row[0]."\"".",\"".$row[1]."\","."\"".$row[2]."\""; This is a string, not an array. > Could you go a step farther in the $foo[$i][$j] please $data[$cpt][0] = $rownu; $data[$cpt][1] = $row[0]; $data[$cpt][2] = $

[PHP-DB] Re: Newbie Question - PHP and MSACCESS

2003-02-16 Thread Fredrik de Vibe
[EMAIL PROTECTED] (J.M. Cocchini) writes: > $result = odbc_do($connection,"select * from events where id=$id"); > odbc_fetch_row($result); > > Am not understanding how to "print()" the fields in the rows, one after > the next, on the same line, and then do the same with the next record, > until a

Re: [PHP-DB] Web Page Caching

2003-02-16 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Ruprecht Helms) writes: > Normaly CGI and dynamic webcontents are not cached in proxies and in > browsercaches. How does the browser / proxy know that the output is dynamic? I don't know what PHP does to accomplish this, but if PHP always sends a cache-expire header, that won't

[PHP-DB] Re: Web Page Caching

2003-02-16 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Philip Zee) writes: > I don't know if this is the right list to send this question to. It > appears that the browser caches the result after a PHP page updates > the database. I have to manually reload it in order to see the > updates. Does anyone know how to overcome this? If y

[PHP-DB] Re: Help with array

2003-02-16 Thread Fredrik de Vibe
[EMAIL PROTECTED] (John Thorne) writes: > $data[$cpt]= $row[0].",".$row[1].",".$row[2].",".$row[3].",".$row[4]; What you need is a two dimensional array. The code above concatenates the $row elements into a string and puts this string into a one dimensional array. the 2D array $foo[3][5] can be s

[PHP-DB] Re: while loop help

2003-02-15 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Peter Gumbrell) writes: > if (isset($_POST['workshop_select'])) > { > print $header_string; > $user = $HTTP_POST_VARS['username']; > > * this is the section that needs some sort of loop if(isset($HTTP_POST_VARS['rank']) && is_array($HTTP_POST_VARS['rank'])){ f

[PHP-DB] Re: printing repeat table headers

2003-02-15 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Sam Folk-Williams) writes: > ...What I would like to do is have those headers repeat every 33 > rows... > $tableHeaders = "..."; $cnt = 0; > while ($row = mysql_fetch_array($result)) { // stuff if($cnt%33 == 0){ echo $tableHeaders; } $cnt++; > echo "$tableContent"; > }

[PHP-DB] Re: php & date manupulation functions

2003-02-15 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Rajesh Fowkar) writes: > Now while updating the form I want to retrieve the date and take out day, > month and year from that date and display the correct selection in the > combo. I could not find any function like say > > day($dbdate); > month($dbdate); > year($dbdate); > > A

[PHP-DB] Re: TXT files with fixed width

2003-02-14 Thread Fredrik de Vibe
[EMAIL PROTECTED] (Pedro Oliveira) writes: > I need to import a fixed width txt to a my sql database, I > know how to do that with a coma separated value. > any1 knows how i can do this easilly or know some software to do this? > any help would be appreciated. *nix or windows? If the file is tab s

[PHP-DB] c binary for (more securely) connecting to oracle

2003-02-09 Thread Fredrik de Vibe
Hi It's the old question all over again: How can I make my user / pass "impossible" to read for those who shouldn't? I've been thinking a lot the past few years about how to do this, and I've thought that one solution, a little better than keeping the information in a file in plain text, would be