Re: [PHP] $query help :(

2003-01-08 Thread Jason Wong
On Thursday 09 January 2003 08:07, - \[ Paul Ferrie \] - wrote: > Hi again guys i have run into another problem :( > > i am trying to build a user poll (flash+php+mysql) > I have the interface all sorted but i have a problem with my add new poll > php file. > When i hit the update poll button in fl

RE: [PHP] $query help :(

2003-01-08 Thread Timothy Hitchens \(HiTCHO\)
AIL PROTECTED] > -Original Message- > From: - [ Paul Ferrie ] - [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 9 January 2003 10:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP] $query help :( > > > Hi again guys i have run into another problem :( > > i am trying

[PHP] $query help :(

2003-01-08 Thread - \[ Paul Ferrie \] -
Hi again guys i have run into another problem :( i am trying to build a user poll (flash+php+mysql) I have the interface all sorted but i have a problem with my add new poll php file. When i hit the update poll button in flash it seem that everthing has work and it' send back a msg saying all went

RE: [PHP] php $query help

2003-01-06 Thread Cesar Aracena
Cesar L. Aracena [EMAIL PROTECTED] [EMAIL PROTECTED] (0299) 156-356688 Neuquén (8300) Capital Argentina -Mensaje original- De: - [ Paul Ferrie ] - [mailto:[EMAIL PROTECTED]] Enviado el: lunes, 06 de enero de 2003 10:16 Para: [EMAIL PROTECTED] Asunto: [PHP] php $query help Here is my pro

Re: [PHP] php $query help

2003-01-06 Thread Leif K-Brooks
What the heck is if($name == $name){ supposed to mean? I've never seen a variable that's not equal to itself... :-) - [ Paul Ferrie ] - wrote: > Here is my problem > >I have created a user login system (flash+php+mysql) >And it just about works > >Here's the prob when i go to register as a new u

[PHP] php $query help

2003-01-06 Thread - \[ Paul Ferrie \] -
Here is my problem I have created a user login system (flash+php+mysql) And it just about works Here's the prob when i go to register as a new user the code wont properly check to see if the username already exsist's in the DB, I am pretty sure the problem lies in my first $query PHP:-

RE: [PHP] MSSQL/PHP Query Help

2002-06-12 Thread Leotta, Natalie (NCI/IMS)
AM To: [EMAIL PROTECTED] Subject: [PHP] MSSQL/PHP Query Help Hey guys... I'm currently using PHP, FreeTDS, and Sybase libraries to access a database on an MS SQL 2000 server. Things are going fine, except for my more complex queries. Here is an example: SELECT Servers.Name, Nics.MAC FROM Se

[PHP] MSSQL/PHP Query Help

2002-06-12 Thread Michael
Hey guys... I'm currently using PHP, FreeTDS, and Sybase libraries to access a database on an MS SQL 2000 server. Things are going fine, except for my more complex queries. Here is an example: SELECT Servers.Name, Nics.MAC FROM Servers INNER JOIN Nics ON Servers.ServerId = Nics.Server WHERE ((

Re: [PHP] Query help needed

2001-11-29 Thread Miles Thompson
It looks OK, but I have lousy track record of writing out "perfect" sql which doesn't work. Syntax looks OK. 1. What does it look like if you write out the update statement, assign it to a var and then echo the var? 2. Can you try it at the console? 3. Try " or die(mysql_error) ;" to see if yo

AW: [PHP] Query Help Needed

2001-11-29 Thread Martin Lucas
PROTECTED] Betreff: Re: [PHP] Query Help Needed error message is 'Invalid Query'. "Douglas McKenzie" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Could be that the value you're trying to insert doesn't match up wi

Re: [PHP] Query Help Needed

2001-11-29 Thread Payzillee
error message is 'Invalid Query'. "Douglas McKenzie" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Could be that the value you're trying to insert doesn't match up with > the field type in the database - you know, putting a word in a number > field. What exac

Re: [PHP] Query Help Needed

2001-11-29 Thread Douglas McKenzie
Could be that the value you're trying to insert doesn't match up with the field type in the database - you know, putting a word in a number field. What exactly is the error message? Payzillee wrote: >Hi, could anyone tell me what is wrong with this Insert query? I get an >'Invalid query' err

Re: [PHP] Query Help Needed

2001-11-29 Thread Payzillee
I've got my names, web addresses etc. set up as Varchar and my telephone/fax numbers as Bigint. Special interests field as text. Only other field in the database is an auto increment number field. "Michael Hall" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >

AW: [PHP] Query Help Needed

2001-11-29 Thread Martin Lucas
: Payzillee [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 29. November 2001 12:37 An: [EMAIL PROTECTED] Betreff: [PHP] Query Help Needed Hi, could anyone tell me what is wrong with this Insert query? I get an 'Invalid query' error but I can't see the problem at all. All the fields mat

Re: [PHP] Query Help Needed

2001-11-29 Thread Michael Hall
Do those field names need single quotes too? Can't remember right now ... Are there any datatype problems (wrong kind of datatype for a field)? What about a semi-colon at the end? Mick On Thu, 29 Nov 2001, Payzillee wrote: > Hi, could anyone tell me what is wrong with this Insert query? I ge

[PHP] Query Help Needed

2001-11-29 Thread Payzillee
Hi, could anyone tell me what is wrong with this Insert query? I get an 'Invalid query' error but I can't see the problem at all. All the fields match exactly what is in my database, it's all in lowercase too. Cheers. mysql_query ("INSERT INTO listserve (title, surname, forename, job_title, o

[PHP] Query help needed

2001-11-29 Thread Payzillee
Hi, could anyone tell me what is wrong with this Insert query? I get an 'Invalid query' error but I can't see the problem at all. All the fields match exactly what is in my database, it's all in lowercase too. Cheers. mysql_query ("INSERT INTO listserve (title, surname, forename, job_title, o