Re: [PHP] query order issue

2013-07-21 Thread Jim Lucas
On 7/20/2013 9:21 AM, dealTek wrote: Hi all, I have a page that starts with several mysql sql query searches and displays data below... then I added a form (with hidden line "do-update" value "UPDATE") on the same page with action to same page... then above other sql queries - I put... if

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Bastien
Bastien Koert On 2013-07-10, at 3:29 PM, Anthony Wlodarski wrote: > Is there anything that would prevent you from somehow uniquely knowing who > the user is uploading the file. For example you mentioned "client'. If you > know > who the client is you can append that to the filename or prepend

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Anthony Wlodarski
Is there anything that would prevent you from somehow uniquely knowing who the user is uploading the file. For example you mentioned "client'. If you know who the client is you can append that to the filename or prepend it, for the destination string (second parameter to the function call). That

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Jim Giner
On 7/10/2013 3:37 PM, Ajay Garg wrote: Thanks Jim and Anthony. Jim, You are right, your solution is doable. But one thing I am a little skeptical about, is what would be the percentage of the people willing to suggest a new name "immediately", versus the percentage of people who would like to c

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Ajay Garg
Thanks Jim and Anthony. Jim, You are right, your solution is doable. But one thing I am a little skeptical about, is what would be the percentage of the people willing to suggest a new name "immediately", versus the percentage of people who would like to cancel the current upload, and come back "

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Jim Giner
On 7/10/2013 2:15 PM, Ajay Garg wrote: Thanks Jim and Matijn for the quick replies. I will try to have a workaround. On Wed, Jul 10, 2013 at 11:09 PM, Matijn Woudt wrote: On Wed, Jul 10, 2013 at 7:21 PM, Ajay Garg wrote: Hi all. I have a requirement, wherein I need to allow vanilla u

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Ajay Garg
Thanks Jim and Matijn for the quick replies. I will try to have a workaround. On Wed, Jul 10, 2013 at 11:09 PM, Matijn Woudt wrote: > > > > On Wed, Jul 10, 2013 at 7:21 PM, Ajay Garg wrote: > >> Hi all. >> >> I have a requirement, wherein I need to allow vanilla uploads of files >> to a HTTPD

Re: [PHP] Query regarding temporarily-uploaded files

2013-07-10 Thread Matijn Woudt
On Wed, Jul 10, 2013 at 7:21 PM, Ajay Garg wrote: > Hi all. > > I have a requirement, wherein I need to allow vanilla uploads of files > to a HTTPD server. > > Any client can upload any number of files (one at a time). > Also, there is just one directory, where the files get stored > "finally" (t

Re: [PHP] query strings and other delights

2011-01-13 Thread Marc Guay
Give parse_str() a go. http://ca.php.net/manual/en/function.parse-str.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Query based on Server offset TimeStamp

2009-11-23 Thread Philip Thompson
On Nov 23, 2009, at 7:37 PM, Don Wieland wrote: > Hello, > > I have a mySQL database server in Florida USA (EST) and I want to do a query > on a record in California, USA (PST) 3 hours earlier using PST instead of EST. > > I would like to add to my CORE page that offset of the timezone so I can

Re: [PHP] Query Regarding a Player

2009-06-03 Thread Ashley Sheridan
On Wed, 2009-06-03 at 17:54 -0400, Eddie Drapkin wrote: > But it's client side software and you can't rely on it existing for general > use. > > On Wed, Jun 3, 2009 at 2:52 PM, Ashley Sheridan > wrote: > > > On Wed, 2009-06-03 at 09:18 -0500, haliphax wrote: > > > On Wed, Jun 3, 2009 at 8:14 AM,

Re: [PHP] Query Regarding a Player

2009-06-03 Thread Eddie Drapkin
But it's client side software and you can't rely on it existing for general use. On Wed, Jun 3, 2009 at 2:52 PM, Ashley Sheridan wrote: > On Wed, 2009-06-03 at 09:18 -0500, haliphax wrote: > > On Wed, Jun 3, 2009 at 8:14 AM, Hemant Patel > wrote: > > > Hi All, > > >I hope you all ar

Re: [PHP] Query Regarding a Player

2009-06-03 Thread Ashley Sheridan
On Wed, 2009-06-03 at 09:18 -0500, haliphax wrote: > On Wed, Jun 3, 2009 at 8:14 AM, Hemant Patel > wrote: > > Hi All, > >I hope you all are doing great.We are developing a application > > on our end and we got a problem with a Audio/Vedio player.As flash player is > > working well w

Re: [PHP] Query Regarding a Player

2009-06-03 Thread haliphax
On Wed, Jun 3, 2009 at 8:14 AM, Hemant Patel wrote: > Hi All, >            I hope you all are doing great.We are developing a application > on our end and we got a problem with a Audio/Vedio player.As flash player is > working  well with client side but it has limitation of file formats like it >

Re: [PHP] Query string question

2009-01-13 Thread Robert Cummings
On Tue, 2009-01-13 at 17:21 -0200, Jônatas Zechim wrote: > I have something like this on my site: > > mysite.com/índex.php?msg=Transa%25E7%25E3o+n%25E3o+autorizada > > i need to convert " Transa%25E7%25E3o+n%25E3o+autorizada" to "Transação não > autorizada". > > The letters ç ã, and others (é,

Re: [PHP] Query-within-a-query with mySQL/PHP

2008-10-25 Thread Greg Bowser
>Basically I somehow need to do a GROUP BY producer, and yet somehow at the same time, find out all the matching vintages (years), that go along with that group and return them the same time the producer group is returned. If I'm following you correctly, you have a column "year" in your group, and

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread celtic
Hi Jim, Actually, after I got the code working, I eliminated the 'exit' and skipped the empty query instead to the next block. Ahh! That cryptic header relocate: If the db conn or code is buggy fails, it redirects to a nice page telling the user that the db 'Is down for maintenance' or somesu

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread Jim Lucas
[EMAIL PROTECTED] wrote: Hi, In the following code, only the first row from query1 displays along with the display stuff from query3. The problem: query1 refuses to recurse to the next and following rows. It appears that the sub-queries in the main query cause the $row++; not to work. Is

Re: [PHP] Query refuses to recurse all rows {RESOLVED]

2008-05-28 Thread celtic
Thanks Wolf and Chris, That did the trick -- now I just have to clean up the order a bit. Amazing how another's view can see the problem so clearly -- I was way too close, what with otehr coding - should've seen it! Regards, Andre (celtic) On Wednesday 28 May 2008, Wolf wrote: > Chris wrote: >

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread Wolf
Chris wrote: $numrows1 = pg_numrows($result1); $row = 0; do { $myrow = pg_fetch_array($result1, $row); $numrows2 = pg_numrows($result2);

Re: [PHP] Query refuses to recurse all rows

2008-05-28 Thread Chris
> $numrows1 = pg_numrows($result1); > $row = 0; > do > { > $myrow = pg_fetch_array($result1, $row); > $numrows2 = pg_numrows($result2); >

Re: [PHP] Query in Query problems

2008-04-16 Thread Chris
VamVan wrote: Hello All, We many times encounter the situations of having Queries inside loop of another query. Many times we can solve the issue by query joins but there will be some situations where we cannot do it. For Example: function Change($id){ $qry_reg = "SELECT registrationI

Re: [PHP] query not working properly

2007-07-26 Thread Richard Davey
Hi Joey, Thursday, July 26, 2007, 1:36:37 PM, you wrote: > Hi everyone, > I'mt trying to do the below query which itself works correctly, but when I > add a order by statement just bombs. > $query = "select * from articles where ( {$now} BETWEEN startdate > AND enddate) and categoryid =

RE: [PHP] Query question

2006-10-30 Thread Ivo F.A.C. Fokkema
On Sun, 29 Oct 2006 23:04:27 -0600, Richard Lynch wrote: > On Sun, October 29, 2006 2:06 am, Beauford wrote: >> LOL, I don't know either. The format is - 01/01/2006. When I first did >> it I >> used 7, which should be right, but I ended up getting /2002 /2003, >> etc. So I >> went to 8 and all was

RE: [PHP] Query question

2006-10-29 Thread Richard Lynch
On Sun, October 29, 2006 2:06 am, Beauford wrote: > This is how I get the data and I have no control over the actual > layout of > the database. So I have to work with what I have. When you say it's "how you get the data" are they handing you a MySQL database that is this badly-constructed? Or ar

Re: [PHP] Query question

2006-10-29 Thread Ed Lazor
] Sent: October 29, 2006 4:30 AM To: Beauford; 'PHP' Subject: Re: [PHP] Query question I said that you have a problem,not that you caused it, and my observation might (hopefully) help newbies in the list. Satyam - Original Message - From: "Beauford" <[EMAIL

RE: [PHP] Query question

2006-10-29 Thread Beauford
bject: Re: [PHP] Query question I said that you have a problem,not that you caused it, and my observation might (hopefully) help newbies in the list. Satyam - Original Message - From: "Beauford" <[EMAIL PROTECTED]> To: "'PHP'" Sent: Sunday, October

Re: [PHP] Query question

2006-10-29 Thread Satyam
I said that you have a problem,not that you caused it, and my observation might (hopefully) help newbies in the list. Satyam - Original Message - From: "Beauford" <[EMAIL PROTECTED]> To: "'PHP'" Sent: Sunday, October 29, 2006 9:06 AM Subject: RE:

RE: [PHP] Query question

2006-10-29 Thread Beauford
to 8 and all was well. Beats me. B -Original Message- From: Satyam [mailto:[EMAIL PROTECTED] Sent: October 29, 2006 2:14 AM To: Beauford; 'PHP' Subject: Re: [PHP] Query question If that works then you have a problem: you are storing dates as a plain string ( varc

Re: [PHP] Query question

2006-10-29 Thread Satyam
t; To: "'PHP'" Sent: Sunday, October 29, 2006 7:05 AM Subject: RE: [PHP] Query question This is what I finally figured out, which works just perfectly. select count(date) as count, substring(date,8) as year from stats group by year; Thanks to all for the input. -Origin

RE: [PHP] Query question

2006-10-29 Thread Robert Cummings
On Sun, 2006-10-29 at 01:05 -0500, Beauford wrote: > This is what I finally figured out, which works just perfectly. > > select count(date) as count, substring(date,8) as year from stats group by > year; > > Thanks to all for the input. So what you're saying is that you're not using a date field

RE: [PHP] Query question

2006-10-28 Thread Beauford
: PHP Subject: Re: [PHP] Query question Look into the MySQL YEAR() function to extract the year from a specific date. Start here: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html On 10/28/06, Beauford <[EMAIL PROTECTED]> wrote: > > I posted this here as I figured

Re: [PHP] Query question

2006-10-28 Thread Joe Wollard
mething. Thanks -Original Message- From: Joe Wollard [mailto:[EMAIL PROTECTED] Sent: October 28, 2006 10:30 PM To: Ed Lazor Cc: Beauford; PHP Subject: Re: [PHP] Query question Agreed, this should go to a MySQL list. But in the spirit of helping I think the following should give you a good startin

RE: [PHP] Query question

2006-10-28 Thread Beauford
gured I'd need to use PHP to maybe put it in an array first or something. Thanks -Original Message- From: Joe Wollard [mailto:[EMAIL PROTECTED] Sent: October 28, 2006 10:30 PM To: Ed Lazor Cc: Beauford; PHP Subject: Re: [PHP] Query question Agreed, this should go to a MySQL list.

Re: [PHP] Query question

2006-10-28 Thread Joe Wollard
Agreed, this should go to a MySQL list. But in the spirit of helping I think the following should give you a good starting point. SELECT `year`, COUNT(`year`) AS `count` FROM `tbl` GROUP BY `year` ASC On 10/28/06, Ed Lazor <[EMAIL PROTECTED]> wrote: Use the mysql list :) On Oct 28, 2006, at

Re: [PHP] Query question

2006-10-28 Thread Ed Lazor
Use the mysql list :) On Oct 28, 2006, at 3:01 PM, Beauford wrote: Hi, I have a MySQL database with a date field and a bunch of other fields. The date field is in the format - 01/01/2006. What I want to do is query the database and create a table that shows just the year and how many in

Re: [PHP] Query DBF records using PHP

2006-09-07 Thread Chris
Rahul S. Johari wrote: Ave, Let¹s say I have a DBF file residing on my somewhere. It has 20 fields, and about 100 records. Is it possible for me to Query that DBF file, so I can search that database for a record and Display the row using PHP? Yes. http://www.php.net/manual/en/ref.dbase.php -

Re: [PHP] Query result column to array

2006-08-30 Thread Rafael Mora
Hi!! What I do is just this: $_ar = array(); while($_field = mysql_fetch_row($_result)) {$_aloft["$_field[0]"] = "$_field[1]";} while(list($_key,$_val) = each($_ar)) On 8/30/06, Christopher Watson <[EMAIL PROTECTED]> wrote: I'm looking for a native method for taking all of the value

Re: [PHP] Query for two fields with the same name

2006-04-19 Thread Richard Lynch
On Wed, April 19, 2006 5:55 pm, Kevin Murphy wrote: > $connection = "select * from connection, pr WHERE connection.area_id > = '$gateway_link' and connection.pr_id = pr.id"; > > Both tables have a field called ID but they have different > information in them. $row['id'] gets me the one from the tab

Re: [PHP] Query for two fields with the same name

2006-04-19 Thread admin
Maybe something like this : $connection = "SELECT t2.id AS idtwo, t1.id AS idone FROM connection AS t1, pr AS t2 WHERE t1.area_id = '$gateway_link' AND t1.pr_id = t2.id"; > This is probably a simple question, but I can't seem to find the > answer online. > > I'm using this query: > > $connection

Re: [PHP] Query for two fields with the same name

2006-04-19 Thread Jochem Maas
NOT a php question. Kevin Murphy wrote: This is probably a simple question, but I can't seem to find the answer online. I'm using this query: $connection = "select * from connection, pr WHERE connection.area_id = '$gateway_link' and connection.pr_id = pr.id"; doing "SELECT * FROM bla" is

Re: [PHP] Query : Facing Error

2006-03-08 Thread Jochem Maas
Rahul sharma wrote: I have installed php5 manually and pws also on Windows 98. I checked execute button of pws also. But the problem is, when i execute any php programe my browser show me following message This PHP CGI binary was compiled with force-cgi-redirect enabled. This means that a pa

Re: [PHP] query regard forms in PHP

2006-01-30 Thread Richard Correia
Another die hard question .. huh? Your all problems can be solved if you spend some time on http://weberdev.com. The answer to your question is www.weberdev.com/get_example-3927.html Thanks Richard Correia On 1/29/06, suresh kumar <[EMAIL PROTECTED]> wrote: > > hai, >i am having 3 fi

Re: [PHP] query regarding forms

2006-01-28 Thread Miles Thompson
At 11:20 AM 1/28/2006, suresh kumar wrote: hi, i am having 3 files Login.php,home.php and home1.php when i entered username and passwd in my first login page i want want i entered as username and passwd in my third page ie home1.php. A.suresh That'

Re: [PHP] query problem.

2006-01-24 Thread Brian V Bonini
On Wed, 2006-01-25 at 08:01, Angelo Zanetti wrote: > Hi guys. > > I got an entry in a field called emailfrom in my table (MySQL db). > > The data in that field is: Sams Bank <[EMAIL PROTECTED]> > > I then do the following to retrieve the info, using a DB class > > $recordset=$conn->Execute("SEL

Re: [PHP] query problem.

2006-01-24 Thread Richard Lynch
On Wed, January 25, 2006 7:01 am, Angelo Zanetti wrote: > The data in that field is: Sams Bank <[EMAIL PROTECTED]> . . . > Why does the < > cause that not to be displayed? or is it retrieving > it > correctly but not showing it because of the < > (which might be > conflicting with HTML tags? You h

Re: [PHP] query problem.

2006-01-24 Thread Silvio Porcellana [tradeOver]
Angelo Zanetti wrote: (...) Why does the < > cause that not to be displayed? or is it retrieving it correctly but not showing it because of the < > (which might be conflicting with HTML tags? When showing things in an HTML page it's always a good idea to use 'htmlspecialchars' (or htmlenti

Re: [PHP] query problem.

2006-01-24 Thread David Grant
Angelo, Angelo Zanetti wrote: > Why does the < > cause that not to be displayed? or is it retrieving it > correctly but not showing it because of the < > (which might be > conflicting with HTML tags? Look at the source! David -- David Grant http://www.grant.org.uk/ -- PHP General Mailing List

Re: [PHP] Query about gzinflate

2005-11-15 Thread Curt Zirzow
On Tue, Nov 15, 2005 at 09:28:22PM -0800, kumar kumar wrote: > HI > > How to uncompress compressed data with php://input > > Which one of the following is correct > > 1 .$unzip = gzinflate("php://input","r"); > $getdata = fopen($unzip."r"); > > 2. gzcompress("php://input","r"); > > $

Re: [PHP] Query regarding total count of pages in a site....

2005-11-08 Thread Richard Lynch
On Tue, November 8, 2005 7:28 am, Suresh Pandian wrote: > I need to find the number of webpages in a site.. > is there any inbuilt variables in php to find it. > Reply , if u have any valuable suggessions.. > thanks. In your own site? Or in somebody else's? And what counts

Re: [PHP] Query regarding total count of pages in a site....

2005-11-08 Thread Richard Davey
Hi Suresh, Tuesday, November 8, 2005, 1:28:47 PM, you wrote: > I need to find the number of webpages in a site.. is there any > inbuilt variables in php to find it. I need to find the number of socks in my washing basket. Does PHP have an inbuilt function to do it? No, of course it does

Re: [PHP] query regerding copying files using php

2005-10-05 Thread Jochem Maas
Suresh Pandian wrote: hello friends, i have a query in writng the content of one file to another. i attempted it. it only writes the html codings.it could not write the php scripts inside the file. Suresh - it helps if you desribe what you are trying to achieve _and_ why, this is because t

Re: [PHP] Query - Warning: Cannot modify header information

2005-09-30 Thread Emil Novak
You can simply avoid that by buffering the output: or (older versions of PHP): Emil Novak, Slovenia, EU -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Query - Warning: Cannot modify header information

2005-09-30 Thread Minuk Choi
Months ago when I kept encountering that problem, it was due to this. Suresh, in /home/gift1/public_html/home.php, do you have a space, an empty line, etc. ? that file should start with "I put double quotes to emphasize that there should be NOTHING before the PHP script start. -Mk Sures

RE: [PHP] Query - Warning: Cannot modify header information

2005-09-30 Thread Suresh Pandian
i checked the line before 61... it sends the image content type this is the code of image.php | | All rights reserved.| +-+ | PLEASE REA

Re: [PHP] query in php

2005-09-26 Thread Rory Browne
On 9/26/05, Suresh Pandian <[EMAIL PROTECTED]> wrote: > respected sir, Respect is a two way process. You are more likely to get a response if we respect you. We are more likely to respect you if you make some effort to solve your own problem, and outline the steps you took, and how they didn't wo

Re: [PHP] query in php

2005-09-26 Thread Jochem Maas
Suresh Pandian wrote: respected sir, i have a query about how to open a audio file and upload as well as download in a website using php. plz send me a tutorial help related to it. I always find these 2 sites very helpful when I need information on uploading and opening audio files: htt

Re: [PHP] QUERY TOKENIZER WAS Re: [new version] Re: [a proactive....

2005-09-12 Thread Jochem Maas
Jay Blanchard wrote: [snip] This is another rather hackish attempt at using the tokeniser. Which isn't perfect by a long shot, but I'm away home now so it'll have to do. I'd be interested to know what it makes of your queries. [/snip] This little slice of code is really well done, and I think

RE: [PHP] QUERY TOKENIZER WAS Re: [new version] Re: [a proactive....

2005-08-26 Thread Jay Blanchard
[snip] This is another rather hackish attempt at using the tokeniser. Which isn't perfect by a long shot, but I'm away home now so it'll have to do. I'd be interested to know what it makes of your queries. [/snip] This little slice of code is really well done, and I think that when it is combine

RE: [PHP] Query Returning Error

2004-10-13 Thread Ford, Mike
To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm > -Original Message- > From: Chris Dowell [mailto:[EMAIL PROTECTED] > Sent: 13 October 2004 11:57 > > Note also that you didn't quote the index you were using inside the >

RE: [PHP] Query Returning Error

2004-10-13 Thread Graham Cossey
Thanks Chris, that'll help keep my code a bit more 'compact'. (Sorry Harlequin, kinda hijacked your post here) Graham > -Original Message- > From: Chris Dowell [mailto:[EMAIL PROTECTED] > Sent: 13 October 2004 11:57 > To: [EMAIL PROTECTED] > Subject: R

Re: [PHP] Query Returning Error

2004-10-13 Thread Chris Dowell
You can get around this problem more easily by putting your variables inside curly brackets when they appear inside strings. See here: http://uk.php.net/manual/en/language.types.string.php#language.types.string.parsing.complex Or as an example: $Query01 = "SELECT * FROM Users WHERE UserID = '{

RE: [PHP] Query Returning Error

2004-10-13 Thread Graham Cossey
Besides adding $ to Query01, I have had little luck in the past when using $_POST or $_GET directly in an evaluated string. If you are still having problems, try something like: HTH Graham > -Original Message- > From: Harlequin [mailto:[EMAIL PROTECTED] > Sent: 13 October 2004 08:32 >

Re: [PHP] Query Returning Error

2004-10-13 Thread Jordi Canals
On Wed, 13 Oct 2004 08:32:17 +0100, Harlequin <[EMAIL PROTECTED]> wrote: > Morning all. > > this is such a basic question I'm embarrassed to ask but the query worked > fine a few minutes ago and now returns an error: > > I get an error: > > Parse error: parse error, unexpected '=' in sample.php

Re: [PHP] Query Returning Error

2004-10-13 Thread Jason Davidson
should Query01 have a $ in front of it, i assume its a var Jason "Harlequin" <[EMAIL PROTECTED]> wrote: > > Morning all. > > this is such a basic question I'm embarrassed to ask but the query worked > fine a few minutes ago and now returns an error: > > I get an error: > > Parse error:

Re: [PHP] Query Returning Error

2004-10-13 Thread Harlequin
Doh...! thanks mate. -- - Michael Mason Arras People www.arraspeople.co.uk - "Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Wednesday 13 October 2004 15:32, Harlequin wrote: > >> this is such a basic quest

Re: [PHP] Query Returning Error

2004-10-13 Thread Jason Wong
On Wednesday 13 October 2004 15:32, Harlequin wrote: > this is such a basic question I'm embarrassed to ask but the query worked > fine a few minutes ago and now returns an error: Change everything back to what it was a few minutes ago? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz O

RE: [PHP] Query Question

2004-08-11 Thread Karl-Heinz Schulz
To: 'Jason Davidson' Subject: RE: [PHP] Query Question Oops - it shows all the "eventdetails" for all the "events" -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 10:10 PM To: Karl-Heinz Schulz; [EMAIL PROT

Re: [PHP] Query Question

2004-08-11 Thread Jason Davidson
whats the error, are there any matching fields for the columns eventetail.event and event.id? Jason "Karl-Heinz Schulz" <[EMAIL PROTECTED]> wrote: > > Why does this query not work? > It should only show the eventdetails for the shown event. > > --

RE: [PHP] Query Results Question

2004-08-04 Thread Thijs Lensselink
It should be ` (back-ticks) not single quotes SELECT `ID`, `Vacancy Role`, `Vacancy Salary`, `Vacancy Location`, `Vacancy Type` FROM vacancy_details WHERE Publish = 'Yes' But you don't really need the back-ticks! Thijs Ford, Mike [LSS] wrote: > -Original Message- > From: Harlequin

RE: [PHP] Query Results Question

2004-08-04 Thread Ford, Mike [LSS]
-Original Message- From: Harlequin To: [EMAIL PROTECTED] Sent: 04/08/04 01:55 Subject: [PHP] Query Results Question I have the following query which should return just two rows: SELECT 'ID', 'Vacancy Role', 'Vacancy Salary', 'Vacancy Location', 'Vacancy Type' FROM vacancy_details WHER

Re: [PHP] Query Results Question - Solved

2004-08-03 Thread Harlequin
I know what's going to happen though Richard. I'll dump it in their site and it'll look terrible because they don't know how to use CSS effectively. But hey - that's part of the fun. Hyperlinks tomorrow though :| -- - Michael Mason Arras People www.arraspeople.co.u

RE: [PHP] Query Results Question - Solved

2004-08-03 Thread Richard Bewley
Looks good :) - Thank you, Richard Bewley [EMAIL PROTECTED] Equinox Systems and Development Website: http://www.eq-dev.com/ Also, please look at our webhosting services, specializing in business web hosting starting from $15 per

Re: [PHP] Query Results Question - Solved

2004-08-03 Thread Harlequin
Many thanks Richard. I have the table presenting neatly now, thanks for all your help with this one...! -- - Michael Mason Arras People www.arraspeople.co.uk - "Richard Bewley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
Curt. Thanks for the pointer and yes, I should be doing that and overlooked it this time. It's working now as I seem to be echoing the second record in the table and will plug away at getting the table defined. Thanks for all your help Curt. -- - Michael Mason Arr

RE: [PHP] Query Results Question

2004-08-03 Thread Richard Bewley
> I'm only selecting a few fields Richard as I want to try and drop them into an array and display in a table. > I know I'm probably going the long way around doing this but I need to learn from scratch exactly how to do it. > I appreciate your help and patience very much. > I've managed to get

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
I'm only selecting a few fields Richard as I want to try and drop them into an array and display in a table. I know I'm probably going the long way around doing this but I need to learn from scratch exactly how to do it. I appreciate your help and patience very much. I've managed to get the quer

Re: [PHP] Query Results Question

2004-08-03 Thread Curt Zirzow
* Thus wrote Harlequin: > Richard > > Thanks firstly for your help. I renamed the fields so the spaces are > underscores and amended your query but still receive an error: > > "not a valid MySQL result resource " > > Still tinkering though... All this tinkering and database schema's are simply

RE: [PHP] Query Results Question

2004-08-03 Thread Richard Bewley
> Richard. > Public. I changed it to "Publish". > But if I use a query window to interrogate the database I still get just two rows using the following query with field names not values for the row cell contents: > SELECT 'ID','Vacancy_Role','Vacancy_Salary','Vacancy_Location','Vacancy_Type' F

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
Richard. Public. I changed it to "Publish". But if I use a query window to interrogate the database I still get just two rows using the following query with field names not values for the row cell contents: SELECT 'ID','Vacancy_Role','Vacancy_Salary','Vacancy_Location','Vacancy_Type' FROM vaca

RE: [PHP] Query Results Question

2004-08-03 Thread Richard Bewley
> Richard > Thanks firstly for your help. I renamed the fields so the spaces are underscores and amended your query but still receive an error: > "not a valid MySQL result resource " > Still tinkering though... Can you paste me a.) Your database structure b.) The exact query you are using Als

Re: [PHP] Query Results Question

2004-08-03 Thread Harlequin
Richard Thanks firstly for your help. I renamed the fields so the spaces are underscores and amended your query but still receive an error: "not a valid MySQL result resource " Still tinkering though... -- - Michael Mason Arras People www.arraspeople.co.uk --

Re: [PHP] Query Results Question

2004-08-03 Thread Curt Zirzow
* Thus wrote Harlequin: > I have the following query which should return just two rows: > > SELECT 'ID', 'Vacancy Role', 'Vacancy Salary', 'Vacancy Location', 'Vacancy > Type' > FROM vacancy_details > WHERE Publish = 'Yes' > > As only two rows have Publish set to "Yes". > > yet even if I exe

RE: [PHP] Query Results Question

2004-08-03 Thread Richard Bewley
Hi, Take the spaces out of your field names, and then use this: - Thank you, Richard Bewley [EMAIL PROTECTED] Equinox Systems and Development Website: http://www.eq-dev.com/ -- PHP General Mailing List (http://www.php.net/) To

Re: [PHP] Query Query

2004-05-30 Thread Curt Zirzow
* Thus wrote The Digital E ([EMAIL PROTECTED]): > > $query="UPDATE $table_name SET company_name='$company', > first_name='$first_name', last_name='$last_name', address='$address', > city='$city', state_province='$state', postal_code='$postal', > office_phone='$office', fax_phone='$fax', email='

Re: [PHP] Query Query

2004-05-30 Thread Daniel Clark
Can you send more of the code? I looks good so far. >>This may be better suited to the MySQL lists, but I'd appreciate it if >>someone could help. I'm probably just missing something stupid here but >>have been coding non-stop for a week and need another set of eyes. >> >>Here's the line of co

Re: [PHP] Query Query

2004-05-30 Thread hitek
This may sound stupid, but are you actually EXECUTING the query? $doit = mysql_query($query); At 12:32 PM 5/30/2004, The Digital E wrote: This may be better suited to the MySQL lists, but I'd appreciate it if someone could help. I'm probably just missing something stupid here but have been coding

Re: [PHP] query strings, global variables

2004-01-21 Thread Matt Matijevich
while ($row = mysql_fetch_array($selection)){ if (section == $sectionName){ echo "" . $row["sectionName"] . ""; }else{ echo $row["sectionName"]; } thx Not sure if I understand you 100% but I think you could just either check the $_GET or $_REQUEST array. Something like this: i

Re: [PHP] $query works but i still get a returned error

2003-11-20 Thread PAUL FERRIE
So your saying i should be using POST rather than GET? "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > PAUL FERRIE wrote: > > > I am not sure what the problem is here. The script runs and deletes the > > relevent row but still returns "DATA from albums loaded > > ro

Re: [PHP] $query works but i still get a returned error

2003-11-20 Thread John W. Holmes
PAUL FERRIE wrote: I am not sure what the problem is here. The script runs and deletes the relevent row but still returns "DATA from albums loaded row id 658 did not get sent Error deleting row! Warning: Cannot modify header information - headers already sent by (output started at /home/pferrie/p

Re: [PHP] Query Batch

2003-11-18 Thread John W. Holmes
b b wrote: I am translating an MS-SQL application into mysql/php. I need to be able to send a batch of queries all at once. For example: $qStr = " Insert into A(name, address) values('$name', '$address') ; Insert into B(personID, department ...)values (@@identity, '$department');" ; $result= my

RE: [PHP] Query explanation

2003-10-29 Thread Pablo Gosse
On Wednesday, October 29, 2003 8:20 AM Robb Kerr wrote: > I am attempting to hack a tutorial from the Zend site. I have found the > tutorial/project to be excellent, but I don't completely understand what's > being done in the following Query statement. > > //query database, assemble data for sel

RE: [PHP] Query for MySQL

2003-06-30 Thread Jay Blanchard
[snip] I am looking to try and pull the last modified date out and display it. So lets say I have 1000 records. I want to only display the date of the last modified time, I dont care about the id or the name or anything. How do I query for that? [/snip] If you have a lst modified date column

Re: [PHP] Query mysql highest id number

2003-06-22 Thread Milan Reznicek
Try this SELECT * FROM table ORDER BY id DESC LIMIT 1 Milan - Original Message - From: "Chris Schoeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 22, 2003 12:05 PM Subject: [PHP] Query mysql highest id number > I want to make a query in

Re: [PHP] Query

2003-04-05 Thread Burhan Khalid
Ajay Lal wrote: Can you please spend some time with my doubt... My query is that ... Is there any option or function in PHP to implement automatic updation of web pages with the latest contents from other sites. Like news from news sites etc. Or do you have any idea about doing it. Thank you

Re: [PHP] query strings

2003-03-04 Thread Sunfire
query that gets the vars from modify button in addtolist.php hope this helps clear things up... - Original Message - From: "Jason Paschal" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 8:57 PM Subject: Re: [PHP] query strings > i

Re: [PHP] query strings(still broken)

2003-03-03 Thread Leif K-Brooks
Do you mind giving (some of) your code? Sunfire wrote: still broke - Original Message - From: "Leif K-Brooks" <[EMAIL PROTECTED]> To: "Sunfire" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 03, 2003 7:18 PM Subject: Re: [PHP]

Re: [PHP] query strings(still broken)

2003-03-03 Thread Evan Nemerson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 // UNTESTED $tArr = explode('&',$QUERY_STRING); foreach ( $tArr as $tVar ) { $a = explode('=',$tVar); ${rawurldecode($a[0])} = rawurldecode($a[1]); } ??? On Monday 03 March 2003 04:17 pm, Sunfire wrote: > tried everything except ses

Re: [PHP] query strings(still broken)

2003-03-03 Thread Leif K-Brooks
Are you trying to look at the query string itself? If so, spaces are invalid in URLs, so they are urlencoded. Try using $_GET/$HTTP_GET_VARS, or urldecode() it if you must. Sunfire wrote: tried everything except session vars and the query string is still broken... no matter what i do for some

Re: [PHP] query to Active Directory

2003-02-26 Thread Bill MacAllister
Hello, Should start off my saying I do not know about Active Directory specifically, but I have used the PHP LDAP support a lot against other directory servers. What I see straight off is that $user_dn does not look like a distinguished name. I would have expected something like: $user_dn =

  1   2   >