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.

[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. $staff also

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

[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 have an array

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

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

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

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

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

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

[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... -- --Fredrik The chief cause of problems

[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/) To

[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

[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 ors, or

[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: 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: 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. It

[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

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 to

[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 part of

[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 seen as:

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

[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] = $row[1]; $data[$cpt][3]

[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); Am I

[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 = tr.../td; $cnt = 0; while ($row = mysql_fetch_array($result)) { // stuff if($cnt%33 == 0){ echo $tableHeaders; } $cnt++; echo $tableContent; }

[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'])){

[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

[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