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

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

[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

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 -

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: Wednesday,

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

2003-03-19 Thread John W. Holmes
INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y 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

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

[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

[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

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 = UPDATE

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

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 able

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

[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

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:

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 search =

[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] 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] INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y you will get an array named DELETE. check for every element in array DELETE

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 olinux
Since this is not valid HTML - how would you accomplish this using valid HTML? INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y i.e. Yahoo mail does checkboxes like this: input type=checkbox name=Mid value=3398_926227_29517_1491_1405_0_273578_2841_2195311700

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? INPUT TYPE=CHECKBOX NAME=DELETE[?php echo message_id ?] VALUE=Y How is that not valid HTML? You could use: input type=checkbox name=delete[] value=?=$message_id? ---John Holmes... -- PHP Database

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

[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: ? $host = localhost; $uname = sniper; $pass =

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 =

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,

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

2003-03-19 Thread Max 'AMiGo' Gashkov
Should be: ? $host = localhost; $uname = sniper; $pass = starcraft; $database = SHA; $tablename = members; mysql_connect ($host, $uname, $pass); mysql_select_db ($database); $query = SELECT * from $tablename; $result = mysql_query ($query); while ($row = mysql_fetch_row($result)) { ...statements

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

[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