[PHP-DB] Making tree menu

2003-03-19 Thread Daniel Harik
Hello guys I make following query: mysql> SELECT b.type, a.link AS parent_link, b.link AS child_link FROM bookmarks AS a, bookmarks AS b WHERE a.id = b.parentid order by parent_link; and here is result ++-++ | type | parent_link | child_link

RE: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread olinux
[ and ] are illegal characters. #javascript Here are a couple links. Looks like the solution is in parsing the form headers. try some google searches for 'checkbox array javascript php' Here's an interesting one: http://jscript.dk/faq/php.asp usually the only solution offered is how to work wi

Re: [PHP-DB] Not seeing whats wrong with code

2003-03-19 Thread Max 'AMiGo' Gashkov
Should be: MD> Hello, MD> I am trying to write a script that conects to mysql, then SHA database. Then I need to list ALL the rows of table members. It sais there is a error on line 18. The while statement is on line 18, MD> and I cant firgure out whats wrong with it: MD> $host = "localhos

RE: [PHP-DB] Not seeing whats wrong with code

2003-03-19 Thread John W. Holmes
You're missing a semi-colon... I'll leave it up to you to find. :) ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -Original Message- > From: Mike Delorme [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 20, 2

Re: [PHP-DB] Not seeing whats wrong with code

2003-03-19 Thread David Smith
Mike Delorme wrote: Hello, I am trying to write a script that conects to mysql, then SHA database. Then I need to list ALL the rows of table members. It sais there is a error on line 18. The while statement is on line 18, and I cant firgure out whats wrong with it: $host = "localhost"; $uname =

[PHP-DB] Not seeing whats wrong with code

2003-03-19 Thread Mike Delorme
Hello, I am trying to write a script that conects to mysql, then SHA database. Then I need to list ALL the rows of table members. It sais there is a error on line 18. The while statement is on line 18, and I cant firgure out whats wrong with it: Thanks, Mike Delorme

[PHP-DB] Re: Thumbnails

2003-03-19 Thread Mike Mannakee
What you'd be looking at there would be a custom script. Have a look at the image functions of PHP. It can be done, but I think you'll find it easiest to figure it out and write it yourself. Mike "Miguel brás" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi there gents, i looke

RE: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread John W. Holmes
> Since this is not valid HTML - how would you > accomplish this using valid HTML? > > > > VALUE="Y"> How is that not valid HTML? You could use: ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread olinux
Since this is not valid HTML - how would you accomplish this using valid HTML? > VALUE="Y"> i.e. Yahoo mail does checkboxes like this: olinux > "John W. Holmes" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED] > > > > VALUE="Y"> > > > > > > > > > you will get an array named

Re: [PHP-DB] Is the query I need even possible?

2003-03-19 Thread Bob Hall
On Wed, Mar 19, 2003 at 07:37:46PM -0500, Mike Mannakee wrote: > I have a table that looks like this: > > page_idvisitor_idtimestamp > ... > 13 20030101060522 > 58 20030101060512 > 2

Re: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread Foong
oh yes, Sorry my mistake should be: if($val == 'Y') Foong "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > VALUE="Y"> > > > > > > you will get an array named DELETE. > > > > check for every element in array DELETE > > > > foreach($_POST['DELETE'] as $message_id

[PHP-DB] Is the query I need even possible?

2003-03-19 Thread Mike Mannakee
I have a table that looks like this: page_idvisitor_idtimestamp ... 13 20030101060522 58 20030101060512 26 20030101060634 73

Re: [PHP-DB] SELECT * FROM Command *REVISED*

2003-03-19 Thread Mark
--- Michelle Whelan <[EMAIL PROTECTED]> wrote: > > -Ok, this is what I have. I hope this is what you are looking for. > I'm looking to format this search results page so that the > results come back with the entire entry that also matches the > zipcode that was searched. > > ex: zipcode sear

RE: [PHP-DB] SELECT * FROM Command *REVISED*

2003-03-19 Thread Gary . Every
SELECT * FROM tablename WHERE zipcode='$zipcode' ORDER BY entered_date; Gary Every Sr. UNIX Administrator Ingram Entertainment (615) 287-4876 "Pay It Forward" mailto:[EMAIL PROTECTED] http://accessingram.com > -Original Message- > From: Michelle Whelan [mailto:[EMAIL PROTECTED] > Sent: W

[PHP-DB] SELECT * FROM Command *REVISED*

2003-03-19 Thread Michelle Whelan
-Ok, this is what I have. I hope this is what you are looking for. I'm looking to format this search results page so that the results come back with the entire entry that also matches the zipcode that was searched. ex: zipcode search = 90210 results for 90210 are: contactname phone numbe

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

2003-03-19 Thread Matthew Moldvan
I am assuming English isn't your first language. Yes, fuck is definitely swearing, cursing, or whatever else you would like to call it. And yes, it is considered rude in our culture. :D So there. :) Matthew Moldvan. System Administrator Trilogy International, Inc. http://www.trilogyintl.com --

RE: [PHP-DB] Login and link back...

2003-03-19 Thread John W. Holmes
> I am curious about what you guys may have along the lines of best > practices for forwarding from a URL to a login, and then jumping back to > the > original URL automatically. I have several separate applications that all > need to utilize the same login mechanism. I want the user to be

RE: [PHP-DB] Login and link back...

2003-03-19 Thread Gary . Every
Have you thought about using BASIC AUTH in Apache? That way, you don't even need to build a login page, just authenticate each page. Here's what we use: Note that some of the functions used in this script are not included, and need to be commented out or a function written for them. It's rather se

RE: [PHP-DB] Problem retrieving/updating data from InterBase

2003-03-19 Thread May, Patrick
Vincent, > currently I'm working with an Interbase 6.0 database and I > want to insert > some text (and eventually a picture) to a blob field. I've found the > following php code: > > $bid = ibase_blob_create(); > ibase_blob_add($bid, "test"); > $comments_blob = ibase_blob_close($bid); > $sql =

[PHP-DB] Thumbnails

2003-03-19 Thread Miguel Brás
Hi there gents, i looked all web for a good script to create a image thumbnail at the time I make the upload to server and DB. I mean, i have a form with some fields. One of it is the imagepath. I store here the image path so i can display the full image on a third page. Now what i want is to

[PHP-DB] Login and link back...

2003-03-19 Thread NIPP, SCOTT V (SBCSI)
I am curious about what you guys may have along the lines of best practices for forwarding from a URL to a login, and then jumping back to the original URL automatically. I have several separate applications that all need to utilize the same login mechanism. I want the user to be able to

RE: [PHP-DB] SELECT * FROM Command

2003-03-19 Thread Hutchins, Richard
Mark is right, but here's something that may get you started: You need to do a query that looks something like: "SELECT * FROM search WHERE zipcode=".$_POST["zip"].""; Where $_POST["zip"] would be replaced by whatever method and variable you're using to get the search criterion into the query str

RE: [PHP-DB] Re: deleting records using a checkbox

2003-03-19 Thread John W. Holmes
> > > > you will get an array named DELETE. > > check for every element in array DELETE > > foreach($_POST['DELETE'] as $message_id => $val) { > if($val ==1) { You mean if($val == 'Y') ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. h

Re: [PHP-DB] Passing variable with previous next

2003-03-19 Thread Achieve IT
Oops, I have actually defined $address_region = $HTTP_POST_VARS['address_region']; , I forgot to include in the snip in the first posting. Thanks, Declan. - Original Message - From: "mike karthauser" <[EMAIL PROTECTED]> To: "Achieve IT" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednes

Re: [PHP-DB] Passing variable with previous next

2003-03-19 Thread mike karthauser
on 19/3/03 9:32 am, Achieve IT at [EMAIL PROTECTED] wrote: > $company_name = $HTTP_POST_VARS['company_name']; You also need $address_region = $HTTP_POST_VARS['address_region']; Else you arent going to be able to pick up the variable or its value. -- Mike Karthauser Managing Director - Brights

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 wro

[PHP-DB] Re: MySQL and Cyrillic

2003-03-19 Thread Edwin Boersma
You have to put these lines in your html-page: 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 as different. How can set default charset to win1251 or cp1251? I use My

[PHP-DB] Passing variable with previous next

2003-03-19 Thread Achieve IT
Hello, I am working on a page that first collects a variable using POST, and which then uses same in the page which processed this variable. Everything works fine if I run the page with the variable already set (i.e. do not send it via POST from the page which calls the script. I have included what

[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

RE: [PHP-DB] SELECT * FROM Command

2003-03-19 Thread Snijders, Mark
guess it is hard to answer this with so less information first show us how the table defenition is... how it is build up and then which fields you want to show to the user! then I or others can help you much more!! ___ Mark Snijders, Developer Atos Origin Groene

[PHP-DB] SELECT * FROM Command

2003-03-19 Thread Michelle Whelan
Hi, I have a question about how to display results. I am using PHP with a mysql database through yahoo webhosting. I've created a form (html & javascript) that lets the user post data to one of the tables in my database. On a separate page, I've created a form that will do a SELECT * FROM