php-db@lists.php.net

2002-02-25 Thread Marco Coletta
I edit with phpMyAdmin and Mascon, but if I look at the recodr with Mysql client I have the same result : in the record I find & instead of & "Andrey Hristov" <[EMAIL PROTECTED]> ha scritto nel messaggio 00f401c1bdd4$7d3bec00$0b01a8c0@ANDreY">news:00f401c1bdd4$7d3bec00$0b01a8c0@ANDreY... > The p

RE: [PHP-DB] "The" Debacle

2002-02-25 Thread Adam Royle
To make sure that other names are not interfered with, I would refine what you're doing. ie. "Theater Nuts" would become "ater Nuts, The" obviously this is not acceptable... so you would do something like this... //does it begin with 'The '? $name_start = substr($band_name, 0, 3) if ($name_st

php-db@lists.php.net

2002-02-25 Thread Andrey Hristov
phpMyAdmin has changed & to & and then put it in the DB. So it is better not to use phpMyAdmin or any toher web based tool for tasks which includes & entering. Not sure for <,> Regards, Andrey Hristov - Original Message - From: "Marco Coletta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>

php-db@lists.php.net

2002-02-25 Thread Marco Coletta
It's not phpMyadmin that changed & to & but the PHP script. Than because I could not find with the PHP script the record I looked in with phpMyadmin. "Andrey Hristov" <[EMAIL PROTECTED]> ha scritto nel messaggio 010801c1bdd7$576e9dd0$0b01a8c0@ANDreY">news:010801c1bdd7$576e9dd0$0b01a8c0@ANDreY...

[PHP-DB] Still bangin my head

2002-02-25 Thread Jennifer Downey
Hi all, I'm still banging my head on this. Let's say I have $1000 to withdraw from my account. I withdraw that $1000 which leaves me $0 dollars in the account. With the code below if I enter another $1000 dollars in the form and hit enter it loans me the thousand and puts my account at -$1000 do

Re: [PHP-DB] Still bangin my head

2002-02-25 Thread Marius Ursache
if you follow your code you see that you do 0 - 1000 and it's logic to be -1000. Jennifer Downey a écrit : > Hi all, > > I'm still banging my head on this. > > Let's say I have $1000 to withdraw from my account. I withdraw that $1000 > which leaves me $0 dollars in the account. > With the code b

RE: [PHP-DB] Still bangin my head

2002-02-25 Thread Beau Lebens
you would need to do a select and find out how much is in the "account" first, then do a check on the equation to see if the result is going to come out negative - if it is, then either don't allow it, or give them an option to clear the account or whatever, otherwise just go ahead and do the with

[PHP-DB] evaluate file type

2002-02-25 Thread Nautilis
Hi everybody I am wondering if there is any way to evaluate which kind of file i have on my server. Explanation: I have a website where i upload some files for my registered users. I upload every file to a certain folder. Every user has his own folder so i upload some files to some users and so

Re: [PHP-DB] evaluate file type

2002-02-25 Thread Bas Jobsen
> I create a > list with readdir so i can show a list of files that user can download. you already have the filename? Op maandag 25 februari 2002 10:22, schreef Nautilis: > Hi everybody > > I am wondering if there is any way to evaluate which kind of file i have on > my server. > > Explanation:

RE: [PHP-DB] "The" Debacle

2002-02-25 Thread Steve Farmer
Hi, I have a similar system.. only problem is a band called "The The" :) we manually entered and corrected the artists http://www.musicexperts.com/ steve At 11:16 PM + 24/2/02, Peter Lovatt wrote: >When you add the data > >//does it begin with 'The '? >$name_start = substr($band_name, 0, 2

Re: [PHP-DB] evaluate file type

2002-02-25 Thread Jason Wong
On Monday 25 February 2002 17:22, Nautilis wrote: > Hi everybody > > I am wondering if there is any way to evaluate which kind of file i have on > my server. > > Explanation: > > I have a website where i upload some files for my registered users. I > upload every file to a certain folder. Every us

Re: [PHP-DB] PHP IDE

2002-02-25 Thread Karsten Dambekalns
On Sam, Feb 23, 2002 at 12:54:21 -0500, Aron Pilhofer wrote: > After spending two frustrating hours tracking down a bug yesterday - only to > discover it was a misplaced quote mark. I've had it. > > I am looking for suggestions out there for a good IDE for PHP development, > preferably one th

Re: [PHP-DB] Displaying data as while recieving form mysql server

2002-02-25 Thread O.J.I.K
Try to put all your Content to list of Array,.. So u can show the user what they have inputed,.. May it Help [EMAIL PROTECTED] www.indiga.org ---Original Message--- From: Roel Mulder Date: Saturday, February 23, 2002 07:00:50 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-D

php-db@lists.php.net

2002-02-25 Thread Jonathan Underfoot
In my experience PHPMyAdmin DOES NOT change anything. It never changes & for me, and it dosen't addslashes(), which makes it a complete pain in the ass to use, but better than changing things without your knowledge I suppose. Maybe I'm using an old version? -Jonathan - Original Message

php-db@lists.php.net

2002-02-25 Thread Andrey Hristov
The problem was solved. The programmer used htmlspecialchars() in one of his functions. So the function was the problem. No problemas with phpMyAdmin - too clever. Andrey - Original Message - From: "Jonathan Underfoot" <[EMAIL PROTECTED]> To: "[PHP-DB]" <[EMAIL PROTECTED]> Sent: Monday,

[PHP-DB] Delete selected files

2002-02-25 Thread Nautilis
Hi everybody, I show a list of files that I upload to the user's folder using the next code: $path= "../clients/$user"; $dir = opendir ($root); while ($archivo = readdir ($dir)) { $size = filesize("$path/$filename"); $size = ($size/1024); $s

Re: [PHP-DB] Array HELL!!!!

2002-02-25 Thread biorn
Try putting the hidden element statement down inside the while loop in he second page, but change it to "" and add $id=$row['id']; before it. I will show below where it should go. HTH MB jas <[EMAIL PROTECTED]> said: > I have made the changes you suggested which if you ask me have been

[PHP-DB] Re: PHP advice

2002-02-25 Thread Lerp
Hi there :) What happens when you change this line ($query = "select * from auth where password = ".$password.""; ) to this: (no periods) $query = "select * from auth where password = '$password'"; Cheers, Joe :) "Greg Lobring" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[E

[PHP-DB] Problem in programming PHP with WML

2002-02-25 Thread ªüYam
I'm doing a project involving in WAP & WEB applications which complementary with Mysql database. However, when i try to compile the wml page, it goes error. The page is about combining the scripts of wml and php so as to access the database and returning the result to the client-sided. I don't kno

Re: [PHP-DB] Problem in programming PHP with WML

2002-02-25 Thread Paul Burney
on 2/25/02 11:32 AM, ªüYam at [EMAIL PROTECTED] appended the following bits to my mbox: > I don't know why??That comes out a Err Msg about "Unsupported type: > text/html" . I've never done any WML scripting, but the error message offers a big clue. PHP by default sends a Content-type

[PHP-DB] Re: "The" Debacle

2002-02-25 Thread Frank Flynn
Interesting question... Libraries traditionally use "Distillers, The" but really this is a hold over from the card catalogues where if they didn't do it that way the "T" section would be over half of the catalogue. Also it's easier for people to notice that the library puts the "the" second but

[PHP-DB] MySQL query help - limit and group by

2002-02-25 Thread Faye Keesic
Hi there. I would like to return the 2 most recent events from my table, for each author (Author_ID). Here's my table structure (simplified). tblEvents ID Title Create_Date Author_ID Is there a way to do this with a query instead of getting every record, sorted by Author_ID, displaying the fir

[PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Ok to this point I have been able to query a database table, display the results in tables and within a form. As of yet I have been able to insert the contents of the db query into an array for further processing. However, when I try to pass the contents of that array on to another page to delet

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread biorn
Let's see what your code looks like now and where it is returning the word "array". That might help determine where the problem lies now. MB jas <[EMAIL PROTECTED]> said: > Ok to this point I have been able to query a database table, display the > results in tables and within a form. As of y

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Oops... yeah its a monday. Bjorn, I reverted back to my original code because I was getting confused... Here is page one... Current Inventory"; // Start to count number of records in selected table and loop until done $count = -1; while ($myrow = mysql_fetch_array($result)) { $count ++; // Begin

RE: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread Leotta, Natalie (NCI/IMS)
Jas, I've run into the same kind of problem with the site I'm doing for work. My first solution was to use the query string to pass contents of an array (array[0]&array[1]...) but I got to the point where I was passing too much information and it wouldn't work. Now I use hidden data in my for

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
As of right now if you run the php script and view source on the page you can see that it does place the content of db table into array... ex. Current Inventory Type Of Car: Fordremove but on the following page (after selecting items to delete) it just displays the word array for each field (

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread biorn
You didn't add the value part of the hidden element, ie. You were naming the field as an array with no value. if you want to pass this as an array of values, you would need to use: Give that a try and see if it works. HTH MB jas <[EMAIL PROTECTED]> said: > As of right now if you run th

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Yeah, tried that and it still isnt passing the contents of the array as a varible to the confirmation page for deletion. I am at a loss on this one. <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > You didn't add the value part of the hidden element, ie. > > >

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread biorn
When you call your $car_type in the second page, you need to set a variable starting at 0 and call it as $car_type[0] and loop through all of the values in the array. ie. $i=0; while ($car_type[$i]) { I have added more code below that should help. MB jas <[EMAIL PROTECTED]> said: > Yeah,

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
$i=0; while ($car_type[$i],$car_model[$i],$car_year[$i],$car_price[$i],$car_vin[$i]) { $i ++; } Is what I added and this is what is being output to the screen at this point... =0; while () { ++; } now i am still too new to php to understand why it is not putting the contents of the array into

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread biorn
One problem I see is that you are sending all of the values for all of your fields (except the id field) from the first page to the second page, not just the ones that are checked, so even if it was working properly, you would get a list of all items in the table, not just the checked items. Y

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Ok, I think I understand what you are talking about. So now I know what I need to accomplish, and would you happen to know of a good place to learn about something like this? For some reason this function keeps seeming to elude me and if you know of a good tutorial on how to accomplish this I wo

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Bjorn, I just wanted to thank you for giving me alot of insight into what I was trying to accomplish however, due to time restraints I have decided to do it a different way by pulling the entries into a select box that a customer can use to delete the different items. Once again, thanks a ton

Re: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread jas
Awesome... Thanks alot Natalie! I actually decided to pull the contents of the table into a select list as my option to delete the items, out of frustration. In any event I would love to take a look at your code to see a different approach to accomplishing my original problem. Thanks again every

[PHP-DB] Problem with file uploads

2002-02-25 Thread bgadelha
Hi, I'm using PHP4+Apache+Win2000 Professional. I'm having problem with file uploads. I wrote a simple test program and it works fine, but when i try to use it on my application, windows says something like "php generated an error and a log file is beeing created". When i look at the log file in A

[PHP-DB] using sendmail w/ windows

2002-02-25 Thread CrossWalkCentral
any one know how to use send mail with windows instead of linux. Will this work are their other options? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: PHP advice

2002-02-25 Thread David Redmond
You should enclose any string that you searching on within a ' and ' Your SQL query should look something like; $query = "SELECT * FROM auth WHERE password = '". $password ."'"; Cheers "Greg Lobring" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I dont und

RE: [PHP-DB] Delete selected files

2002-02-25 Thread Beau Lebens
your checkboxes should pass a value (probably just the filename) and you could perhaps name them all "filenames[]" or something, using the array trick in PHP, so that on the page you submit to, $filenames will be an array containing everything that was checked. you can then loop thru the array an

RE: [PHP-DB] Passing contents of array on as variables...

2002-02-25 Thread Beau Lebens
rather than all the hidden fields and stuff you guys are trying to do - why not just build the array variable you want, then save it into a session, on the next page, access the session variable and wallah - there's your array, still in tact and just as you left it (ie. containing all the info you

[PHP-DB] session problem on Netscape Vs IE, Help please!

2002-02-25 Thread david rakhmadi
Hi All, In my application i'm using sessions... I'm using PHP4.0.6 + Apache on linux redhat. when I upgrade PHP into PHP 4.1.1 I've got problem on the NETSCAPE that session is broken (unrecognized). but on the IE ..All running well... Any body know How to solve this problem??? Help me.. pleas