[PHP-DB] Re: Nested SQL query problem...

Hello Srini, Don't speak english! :-) For example, what is the cost of 500 licenses of Product_ID 143 ? The slabs do not continue for an infinite number, hence I may only have slab pricing for 1-10, 11-100, and 101-200 with the assumption that if there are no higher slabs and I wanted say the

[PHP-DB] variables gone?

Dear All, I am probably doing something silly but I don't know what (story of my life). I have just upgraded to 4.2.1 and now all the variables I post in forms or in query strings are now coming up undefined errors and are in absent. I'm running PHP under IIS 4. What am I doing wrong? -- PHP

Re: [PHP-DB] variables gone?

In php.ini you need to turn register_globals on..you also might want to start using the $_GET, $_POST, $_SESSION global arrays ed At 02:49 PM 5/29/2002 +0100, Rob Fraser wrote: Dear All, I am probably doing something silly but I don't know what (story of my life). I have just upgraded to

Re: [PHP-DB] REGEX help.

On Wednesday 29 May 2002 06:55, Kevin Stone wrote: All I need to do is return anything matching the following pattern from a specific column in a table. This is how I'd write it in PHP if I were pulling the data from string. The string in this example is a direct copy of one of the column

[PHP-DB] multiple queries

Hi to all, I have a search form where users can search project by 'Project Name' after they type in the project name, they will select which project they will like to view from a drop down menu which contains: Management Approve, Pre-Approved, Management-Not-Approved, and Pre-Not-Approved

RE: [PHP-DB] variables gone?

Beginning in PHP 4.2.0, the normal behavior with respect to preloaded variables was changed (specifically, the default value of the register_globals configuration entry was changed from on to off). For details, see http://www.php.net/manual/en/language.variables.predefined.php ---

[PHP-DB] dropping one word from column entries

I'm having a problem with this and suppose I'm looking for a handout. :| I am displaying names of product categories. The names of the categories are: Bird Cages Cat Toys Chinchilla Housing Products Dog Leashes Ferret Housing Products Mouse Housing Products What I want to do when displaying

[PHP-DB] Re: multiple queries

What's wrong with this or something similar: $sql= mysql_query( SELECT * FROM project WHERE project_name = '$pro_name' AND ( final_approved = 'yes' AND '$project' = 'Management Approve' ORfirst_approved = 'yes' AND '$project' = 'Pre-Approved' ORect... ; $result =

Re: [PHP-DB] dropping one word from column entries

use: $name=Mouse Housing Products; $name=str_replace(Products,,$name); also the RTFM() function works too ed At 11:06 AM 5/29/2002 -0500, Jen Swofford wrote: I'm having a problem with this and suppose I'm looking for a handout. :| I am displaying names of product categories. The names of

[PHP-DB] Resource ID#2 ????

Ok here is my problem, I set this up so a user selects a name form a select box and that name or $user_id is then passed to this page so the user can edit the contact info etc. However it does not pull the selected $user_id and place each field into my form boxes, all I get is a Resource ID #2.

Re: [PHP-DB] dropping one word from column entries

Ed Gorski [EMAIL PROTECTED] wrote: use: $name=Mouse Housing Products; $name=str_replace(Products,,$name); also the RTFM() function works too I'd also trim it to get rid of any extra spaces that are left: $name = trim(str_replace(Products,,$name)); -- Stuart -- PHP Database Mailing

Re: [PHP-DB] Resource ID#2 ????

On Thursday 30 May 2002 00:17, Jas wrote: Ok here is my problem, I set this up so a user selects a name form a select box and that name or $user_id is then passed to this page so the user can edit the contact info etc. However it does not pull the selected $user_id and place each field into

[PHP-DB] FW: hello ... best schema to a forum

-Mensagem original- De: José Moreira [mailto:[EMAIL PROTECTED]] Enviada: terça-feira, 28 de Maio de 2002 15:14 Para: [EMAIL PROTECTED] Assunto: FW: hello ... best schema to a forum Importância: Alta im trying to figure out the best mySQL schema to create a forum on my website ...

Re: [PHP-DB] Resource ID#2 ????

If you look at the previously posted code at the bottom of the form there is a echo for the sql select statement that is echoing Resource id #2 on the page. Now that error is the correct field id number in the database, I am just not sure how to itemize the data from that table, at least I

RE: [PHP-DB] Resource ID#2 ????

I could be missing something, but it looks like you are using the result of the mysql_query as the actual result. It actually returns some weird identifier. To access the real info you'd have to use something like mysql_fetch_array to get it. Check out this and see if it helps:

[PHP-DB] Outlook Out Of Office

i know this List isn't for this, but I'm about to go on vacation and I don't want to AutoReply everytime someone posts to this list. Does anyone know how I can set Out Of Office to skip sending a reply when the mail was sent to [EMAIL PROTECTED] ? I looked at the rules and all of the actions

Re: [PHP-DB] Resource ID#2 ????

On Thursday 30 May 2002 00:41, Jas wrote: If you look at the previously posted code at the bottom of the form there is a echo for the sql select statement that is echoing Resource id #2 on the page. Now that error is the correct field id number in the database, I am just not sure how to

RE: [PHP-DB] Outlook Out Of Office

I couldn't find a way to exclude someone - even in the rules it didn't look like it had anything like that. It doesn't even look like you can skip it if you delete. You might want to try to the MS website - they have a pretty thorough FAQ and it's much better than the help that comes up with

[PHP-DB] Remote Update ONCE a day

Hi all, Two days ago I was requested to make a proyect for a non-profit company, and I'm doing the drwaings for the databases and programming which I will use. This company wants to run the program in a PC which will not hold the main DB (which will will at HQ), but they also not need the new

Re: [PHP-DB] Resource ID#2 ????

How can I get the form below to list the single record in a db that matches the request of $user_id? $table = auth_users; $record = @mysql_query(SELECT * FROM $table WHERE user_id = '$user_id',$dbh); while ($row = mysql_fetch_row($record)) { $user_id = $row['user_id']; $f_name =

[PHP-DB] mssql_connect problem

I removed some 'security' settings that Microsoft had recommended which had prevented Named Pipe connections to our Microsoft SQL server. Basically requiring everyone to use TCPIP connections. Which is very simple when using a sYstem DSN or ADODB or any number of ASP connection types. But the

RE: [PHP-DB] dropping one word from column entries

A cleaner option might be to do this before you get it to PHP at all, via your SQL query. Check out the string functions available, there are a number of substring-style things available, string position etc. HTH Beau // -Original Message- // From: Ed Gorski [mailto:[EMAIL PROTECTED]]

[PHP-DB] mysql exclusion in php

Hi there everyone, How can I do a search which excludes certain words if they put a - in the search string? I can do a search easily, but if they put a - infront of a word in the string, how can I then get MySQL to search all entries EXCEPT where the word with a - next to it appears? Thanks

RE: [PHP-DB] mysql exclusion in php

chris, you'll need to do a little PHP manipulation, perhaps (pseudo) if -word. (regular expression?) for each -word SQL .= NOT LIKE '%word% AND' endforeach endif for each other word SQL .= LIKE '%word%' AND endforeach strip trailing AND clean up SQL as

[PHP-DB] Truncated Data

Hello, I desperately need help... I've based my entire project on the use of input text boxes that can be read or edited. Its a web form that gets its data from mysql tables. For some reason when I write the code this way and use single quotes ('), everything after a single quote in the

RE: [PHP-DB] Truncated Data

htmlspecialchars() Beau // -Original Message- // From: Larentium [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 30 May 2002 10:40 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] Truncated Data // // // Hello, // // I desperately need help... I've based my entire project on // the