Re: [PHP-DB] SQL Help?

Hi Barry-- First, I want to see if I understand what you mean, then I'll take a shot at some SQL to solve the problem. I take it you have two tables, "a" and "b". They may look something like this: Table: a id name --- -- 001 Bob 002 Ted 003 Mary 004 S

RE: [PHP-DB] exit query

thanks.. works perfectly! :) M >>-Original Message- >>From: Chris Hobbs [mailto:[EMAIL PROTECTED]] >>Sent: 17 August 2001 00:37 >>To: PHP-DB List >>Subject: Re: [PHP-DB] exit query >> >> >>Chris Hobbs wrote: >>> exit; >> >>Except, you'll want to remove that - doh! >> >>-- >>Chris Ho

Re: [PHP-DB] exit query

Chris Hobbs wrote: > exit; Except, you'll want to remove that - doh! -- Chris Hobbs Silver Valley Unified School District Head geek: Technology Services Coordinator webmaster: http://www.silvervalley.k12.ca.us/~chobbs/ postmaster: [EMAIL PROTECTED] -- PH

Re: [PHP-DB] exit query

Why not: if (!$searchtype || !$searchterm) { echo "You have not entered any details. Please go back and try again."; exit; } else { // print out results } // print out rest of html file... Mark Milaszkiewicz wrote: > > hiya. i'm currently working on a really basic search function f

[PHP-DB] exit query

hiya. i'm currently working on a really basic search function for my website and am using this code trim($searchterm); if (!$searchtype || !$searchterm) { echo "You have not entered any details. Please go back and try again.";

[PHP-DB] Re: SQL Help?

Sorry, forgot to mention that I'm on an Oracle 8.1.6 db... Thx, Barry "Barry Prentiss" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > Here's another SQL query problem: > > How do I construct a query that returns 1 if a value is present and zero if > i

[PHP-DB] Re: Proper Case NOT lower case

Keith: You want to RENAME tables where applicable, and ALTER the respective columns to the desired case. Both are done through queries. The MySQL Manual has detailed info on using these commands. Gerald Jensen - Original Message - From: "Keith Spiller" <[EMAIL PROTECTED]> To: "Php-db" <

Re: [PHP-DB] HTML editors

Microsoft DHTML Editing Control: http://activex.microsoft.com/activex/activex/ Maybe that will help? It's probably the same thing Francisco mentioned, but now you don't have to "look" for it at least. I suggest you download the demo here too: http://msdn.microsoft.com/downloads/samples/interne

[PHP-DB] Re: Opps: Proper Case NOT lower case

If by 'proper case' you mean what I call 'title case' - First word capitalized, conjunctions etc. in lower case, last word capitalized - I posted a PHP script for just that a few days ago: http://marc.theaimsgroup.com/?l=php-general&m=99778991424637&q=raw It sounds like you're using PHP - vers

[PHP-DB] SQL Help?

Hi, Here's another SQL query problem: How do I construct a query that returns 1 if a value is present and zero if it is not, for a list of values returned in another query? i.e. select a.id, a.name, c.selected from table-with-id-and-name a, (select 1 as selected from another-table b if a.id

RE: [PHP-DB] HTML editors

Try to use the DHTML edit control form Microsoft. Got to msdn.microsoft.com. -Original Message- From: Ian Grant [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 9:37 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] HTML editors Hi, I'm looking for something similar to eWebEdit Pro

Re: [PHP-DB] Opps: Proper Case NOT lower case

Buy a good book (PHP 4 Bible)!! read some tutorials!! And CHECK the manual.. found at www.php.net what else did you think people created if for.. http://www.php.net/manual/en/ref.strings.php gives you all string manipulation fun stuff you want. ucfirst() is the solution. And last but not leas

Re: [PHP-DB] Proper Case Conversion

It's a bad habbit to crosspost!! strtolower() stroupper() sql mysql Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: mkdir permissions and AllowOverride

Hi Taylor, * Taylor Fletcher [Thu, 16 Aug 2001 09:16:23 -0700]: > Im getting a permission denied when I try to mkdir. What I can deduce > is that PHP is running under the user nobody through apache. I need to > be able to add the web root to the directories that user nobody can > use. The Docume

[PHP-DB] Opps: Proper Case NOT lower case

-Opps: I meant to say I would like to convert to Proper Case, rather than lower case or UPPER CASE. I'm reading data from a mysql table that is entirely in uppercase letters. I'd very much like to convert them to Proper Case. After searching a while, I found that there is are php commands to

RE: [PHP-DB] Proper Case Conversion

ucfirst(strtolower($field)); > -Original Message- > From: Keith Spiller [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 16, 2001 12:41 PM > To: Php-db > Cc: MySQL > Subject: [PHP-DB] Proper Case Conversion > > > Hello, > > I'm reading data from a mysql table that is entirely in >

[PHP-DB] Proper Case Conversion

Hello, I'm reading data from a mysql table that is entirely in uppercase letters. I'd very much like to convert them to lowercase. After searching a while, I found that there is are php commands to convert text strings between upper and lower case, but I was unable to find anything that can c

RE: [PHP-DB] PHP IRC channel?

On efnet, you can go to #php HTH Sam Masiello Software Quality Assurance Engineer Synacor (716) 853-1362 x289 [EMAIL PROTECTED] -Original Message- From: Brian Tegtmeier [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 16, 2001 12:15 PM To: [EMAIL PROTECTED] Subject:[P

RE: [PHP-DB] determining the value of an auto-incremented field (mysql)

Hello!! Try this echo mysql_insert_id(); This will show if it IS really auto generating a number... Also include..order_number='$order_number' in your insert statement...There will be no vaule...It will make one...then echo the mysql_insert_id() This worked for me... Dan > --

Re: [PHP-DB] determining the value of an auto-incremented field (mysql)

Here is the page for the information on this function: http://www.php.net/manual/en/function.mysql-insert-id.php mysql_insert_id() being a function, the () after the name are necessary. HTH Maureen Kenn Murrah <[EMAIL PROTECTED]> said: > I'm sorry to be so obtuse, but I still don't get it .

Re: [PHP-DB] determining the value of an auto-incremented field (mysql)

I'm sorry to be so obtuse, but I still don't get it ... I've tried: $sql = "INSERT INTO orders set products_ordered='$products', ordered_by='$username', company='$company', address_1='$address_1', address_2='$address_2', city='$city', state='$state', zip='$zip', attn='$attn', special_instruction

RE: [PHP-DB] determining the value of an auto-incremented field (mysql)

Say... You can us it after you do your insert...then do something like. echo ("Your new Order Number is") . mysql_insert_id . (" Please write this down\n"); Your whatever you want. Dan > -- > From: Kenn Murrah > Sent: Thursday, August 16, 2001 12:29 PM

Re: [PHP-DB] determining the value of an auto-incremented field (mysql)

- Original Message - From: Kenn Murrah <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 17, 2001 1:17 AM Subject: [PHP-DB] determining the value of an auto-incremented field (mysql) [snip] > Having done so, how can I immediately determine the value of order_number > for

[PHP-DB] determining the value of an auto-incremented field (mysql)

Greetings: A no doubt elementary question, but using PHP and MySQL, I'm inserting a record into a table, with a field, order_number, being auto incremented ... something like: $sql = "INSERT INTO orders set products_ordered='$products', ordered_by='$username', company='$company', address_

[PHP-DB] Re: [PHP] MYSQL_SOCKET

Or just specify the socket path right in your mysql_connect() call. -Rasmus On Thu, 16 Aug 2001, Jay Paulson wrote: > well i just compiled php again and that still didn't solve the problem... i > guess i just need to keep recompiling php until i get that variable set to > the right thing? > > t

[PHP-DB] HTML editors

Hi, I'm looking for something similar to eWebEdit Pro (http://www.ewebeditpro.com), but a lot less costlier! The idea is using a HTML form to write articles to a PHP/MySQL-driven dynamic site. Obviously, people can cut and paste HTML into a tag, but having a WYSIWYG editor in place of the tag w

[PHP-DB] mkdir permissions and AllowOverride

Im getting a permission denied when I try to mkdir. What I can deduce is that PHP is running under the user nobody through apache. I need to be able to add the web root to the directories that user nobody can use. There is a default line in the httpd.conf that has AllowOveride set to None. If

[PHP-DB] PHP IRC channel?

What's up everybody? I was sitting at my computer today and was just wondering if there was an IRC chat channel for PHP itself as in develoment and coding help. Let me know if there is one. Thanks! :) -- ___ FREE Personalized E-mail at Mail.com ht

[PHP-DB] Re: [PHP] MYSQL_SOCKET

well i just compiled php again and that still didn't solve the problem... i guess i just need to keep recompiling php until i get that variable set to the right thing? thanks, jay - Original Message - From: "Rasmus Lerdorf" <[EMAIL PROTECTED]> To: "Jay Paulson" <[EMAIL PROTECTED]> Cc: <[

Re: [PHP-DB] MYSQL_SOCKET

yes i'm actually getting the MYSQL_SOCKET variable and it's looking for the mysql.sock file in /tmp however it's placed in the /var/lib/mysql directory and I don't know how to change this. I've looked in the php.ini but didn't see anything about it. I've also looked for the my.cnf file and it's

Re: [PHP-DB] Update info from form to MySQL. No error but no Update

Cato, Cato Larsen wrote: > str_replace("'",""",$appearance) don't forget that the correct html entity for ' is " so let that line be str_replace("'",""",$appearance) Markus Bertheau Cenes Data GmbH -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED]

[PHP-DB] Removal of HTML formating

Use n12br() with the output from your DB to your webpage: $content = n12br($content); echo $content; HTH :-) Russ On Thu, 16 Aug 2001 09:02:44 -0500 John Roach <[EMAIL PROTECTED]> wrote: > > > -- Hello, > > I have a mysql db with a largetext field defined. When users enter > data, it dro

[PHP-DB] Removal of HTML formating

-- Hello, I have a mysql db with a largetext field defined. When users enter data, it drops all of the blank lines, so paragraghs run together. Is there a way to display the output with out it being formated in html? It works fine if you insert for each blank line. It of course drops any inden

RE: [PHP-DB] Connection to Oracle8i

Rafael, I am assuming you can connect to your Oracle server from your client (using net8 for example). Did you recompile PHP with Oracle OCI support on your web server? Run and see if there is a section on Oracle OCI. If not, that may be at least part of your problem. Remember that Oracle and

Re: [PHP-DB] Update info from form to MySQL. No error but no Update

Hey Jason! I got it working thanks to a print SQL command. But could you give me an example on how to use htmlspecialchars() in my case? What would this line become? $appearance = str_replace("'",""",$appearance) Best regards Cato http://www.oia.f2s.com -- PHP Database Mailing List (http:

Re: [PHP-DB] Update info from form to MySQL. No error but no Update

- Original Message - From: Cato Larsen <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 16, 2001 4:54 PM Subject: [PHP-DB] Update info from form to MySQL. No error but no Update > Hi! > I've set up a form that allows members to update they'r profile when they > wish. >

Re: [PHP-DB] how can save image in mysql

if were you i wouldn't do it. operations on database uses a lot of servers procesor power. if you put everything into database some day it will be very slow to use it anymore. the best seems solution with keeping the ath to the file and just put it into html or just reed width fopen. it will be

RE: [PHP-DB] how can save image in mysql

I have a personal dislike to storing binary data in a database. What I do is upload the file to a specific place on the server and then insert a link into the database as the URL to the file. There's loads of places you can find upload examples - try www.thickbook.com or www.phpbuilder.net HTH :

[PHP-DB] how can save image in mysql

Hi all How can save a image in a field of mysql table with use php language ? thanks for answer Mad Nas -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [

[PHP-DB] Update info from form to MySQL. No error but no Update

Hi! I've set up a form that allows members to update they'r profile when they wish. After much debugging I got it working without any errors. The problem though was that it won't update the info in the MySQL database. Any ideas what I may be doing wrong? Cato Some source: mailto:[EMAIL PROTEC

Re: [PHP-DB] using is_uploaded_file($userfile1)??

- Original Message - From: <[EMAIL PROTECTED]> To: PHP DataBase-List <[EMAIL PROTECTED]> Sent: Thursday, August 16, 2001 5:45 AM Subject: [PHP-DB] using is_uploaded_file($userfile1)?? > Can someone tell me why this works in PHP4.0.3pl1 on one server and not in PHP4.0.6 on a different ser

[PHP-DB] Re: extracting a form data from a cookie

I say we nuke it from orbit. That's the only way to be sure. Besides who gives a damn anyway. ff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] Re: extracting a form data from a cookie

I say we nuke it from orbit. That's the only way to be sure. Besides who gives a damn anyway. ff -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] Re: [PHP] MYSQL_SOCKET

> the variable MYSQL_SOCKET is set to /tmp/mysql.sock and i need it to > be /var/lib/mysql/mysql.sock is there anyway i can set this variable > in php? >From http://php.net/mysql_connect : resource mysql_connect ([string hostname[:port][:/path/to/socket] [, string username [, string password]