There are further problems with the mySQL query:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near ') AND
CURDATE() <= DATE(FROM_UNIXTIME(1239508800)), 1, 0), IF(CURDATE() >=
DATE'
This is the whole query, what am
Ron Piggott wrote:
Let me try this is a different way.
What is the variable which I am able to retrieve? I am expecting the
result to be a 0, 1 or 2.
Your original problem was getting a parse error.
Your query is not php code - step 1 is to fix that.
Once you've done that, post the new
Ron Piggott wrote:
This is the actual code. What should I have?
Same as when you do a query normally.
$query = "SELECT ... WHERE ";
$result = mysql_query($query);
.
On Thu, 2009-09-24 at 13:20 +1000, Chris wrote:
Ron Piggott wrote:
The following code gives me this error message:
Ron Piggott wrote:
The following code gives me this error message:
Parse error: syntax error, unexpected ':'
in /home/thev4173/public_html/test.php on line 8
It is referencing the : that follows EasterDate (and will eventually get
mad at ChristmasDate)
mysql_connect('localhost',$username,$pas
The following code gives me this error message:
Parse error: syntax error, unexpected ':'
in /home/thev4173/public_html/test.php on line 8
It is referencing the : that follows EasterDate (and will eventually get
mad at ChristmasDate)
mysql_connect('localhost',$username,$password);
@mysql_select
WOW,
Both of your suggestions worked like magic. Thanks a lot Patrick
-Sashi
Patrick Price wrote:
I believe your problem is that on line 33 you forgot your closing double
quote in the echo statement.
Thanks
patrick
Sent from: Decatur Ga United States.
On Fri, Feb 13, 2009 at 10:02 PM, Sash
I believe your problem is that on line 33 you forgot your closing double
quote in the echo statement.
Thanks
patrick
Sent from: Decatur Ga United States.
On Fri, Feb 13, 2009 at 10:02 PM, Sashikanth Gurram wrote:
> Hi all,
>
> I have pasted the PHP code I wrote below. I do not know why, but I
Hi all,
I have pasted the PHP code I wrote below. I do not know why, but I am
getting the parse error: unexpected '>'. It says the error is on line
38. The exact line on line 38 is
* echo"\n*
Basically, I am trying to execute an sql query through PHP which tries
to extract data from the
On Tue, Apr 15, 2008 at 5:56 PM, Javier Viegas <[EMAIL PROTECTED]> wrote:
> Thanks Daniel i ´ve removed the unexpected else secction. Now it works but
> it tells me that there might be a syntax error on the query, this is good
> news because now i know i´m having connection with the database but
il 15, 2008 5:56 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] Parse error: syntax error, unexpected T_ELSE
>
>
> Thanks Daniel i ´ve removed the unexpected else secction. Now
> it works but
> it tells me that there might be a syntax error on the query,
> this i
Thanks Daniel i ´ve removed the unexpected else secction. Now it works but
it tells me that there might be a syntax error on the query, this is good
news because now i know i´m having connection with the database but also
there must be something wrong with the query.
$del_str = "DELETE FROM libros
On Tue, Apr 15, 2008 at 4:49 PM, Javier Viegas <[EMAIL PROTECTED]> wrote:
> Hi, i have this script wich basically connects to a database and delete a
> record according to the Id parameter given. The problem is that when i test
> it i get this error:
>
> *Parse error*: syntax error, unexpected T
Hi, i have this script wich basically connects to a database and delete a
record according to the Id parameter given. The problem is that when i test
it i get this error:
*Parse error*: syntax error, unexpected T_ELSE in *
/var/www/biblio/scripts/delete.php* on line *31
This is the script:
*
Wh
lt;[EMAIL PROTECTED]>
Reply-To: Chris Ramsay <[EMAIL PROTECTED]>
To: babu <[EMAIL PROTECTED]>
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] parse error in create statement.
Date: Tue, 14 Jun 2005 10:56:24 +0100
Check your placement of all the '.' for a start.
raz
On 6/14/
"$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT
IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED
ON USERS
ACCOUNT UNLOCK;
GRANT CREATE TABLE TO ".$adduser."
GRANT CREATE TRIGGER TO ".$adduser."
GRANT CONNECT TO ".$adduser.";
for the .'s
Also, correct me if I'm wrong, but this needs to be split into two
seperate query strings and executed seperately...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Check your placement of all the '.' for a start.
raz
On 6/14/05, babu <[EMAIL PROTECTED]> wrote:
> HI,
>
> Whats the error in this code.
>
> "$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT
> IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
> TEMPORARY TA
HI,
Whats the error in this code.
"$sqlstmt= "CREATE USER ".$adduser." PROFILE DEFAULT
IDENTIFIED BY ".$addpass." DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED
ON USERS
ACCOUNT UNLOCK;
hi
i had created an inventory management system..using
php on sqlitei can successfully insert the values
in it..but when i try to delete an item it is giving
me an error...i think there is some logical problem in
delete statement...
can anyone help me in figure out this error..
thanks in adv
hi,
i am trying to delete an item from inventory
management system done by using php on sqlite...
i had created a button 'delete' and when i submit a
value to be deleted from the table it is giving an error,i think there is some
problem
with delete logic ...
i am attaching the following codes:
Aravalli Sai wrote:
hi
this is php code for inventory management system
which is done using SQLite.this is an user
interface where an user wil giv values to the text
boxes and it should be saved in the backend database
which is sqlite..
but when i run this code on browser it is giving an
err
- Original message from Aravalli Sai : --
> but when i run this code on browser it is giving an
> error ... Parse error: parse error in
> /home/saravall/.HTML/inv.php on line 63
>
It would be helpful if you said what the parse error is and which line is 63.
> if(isse
hi
this is php code for inventory management system
which is done using SQLite.this is an user
interface where an user wil giv values to the text
boxes and it should be saved in the backend database
which is sqlite..
but when i run this code on browser it is giving an
error ... Parse error:
hi
this is php code for inventory management system
which is done using SQLite.this is an user
interface where an user wil giv values to the text
boxes and it should be saved in the backend database
which is sqlite..
but when i run this code on browser it is giving an
error ... Parse error
illed the query.
> -Original Message-
> From: John W. Holmes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 20, 2003 1:09 PM
> To: Dillon, John
> Cc: [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] Parse error on array and SQL query
>
>
> Dillon, John wrote:
>
> &
Dillon, John wrote:
> Tried that, doesn't work with:
>
> $query="INSERT INTO ReplyTbl VALUES ('" . $monster1 . "', '" .
> $monster2 .
> "', '" . $monster3 . "', NULL, NULL)";
>
> Don't suppose they use 'monster' as a reserved word...
How does it "not work" again??
--
---John Holmes...
Amazon Wish
Dillon, John wrote:
> On line 188 and similar:
> line 187$this=$altIDs[$i];
> line 188$query .= "ID='$this'";
>
> I get the error: Parse error: parse error in
> /home/jdillon/public_html/provreport.php on line 188
>
> Could this be because some sett
Dillon, John wrote:
On line 188 and similar:
line 187 $this=$altIDs[$i];
line 188 $query .= "ID='$this'";
I get the error: Parse error: parse error in
/home/jdillon/public_html/provreport.php on line 188
Could this be because some setting has been changed on my shared host?
$this is normall
, Richard [mailto:[EMAIL PROTECTED]
Sent: 20 November 2003 14:43
To: 'Dillon, John'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Parse error on array and SQL query
Speaking for myself only, I'm probably going to need to see more code than
this to be able to help. These two lines app
, 2003 9:16 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Parse error on array and SQL query
>
>
>
> On line 188 and similar:
> line 187$this=$altIDs[$i];
> line 188$query .= "ID='$this'";
>
> I get th
On line 188 and similar:
line 187$this=$altIDs[$i];
line 188$query .= "ID='$this'";
I get the error: Parse error: parse error in
/home/jdillon/public_html/provreport.php on line 188
Could this be because some setting has been changed on my shared
Hi Micella
You need to either slash-escape your insert query or use single quotes:
$query="insert into dene (day,start_time) values (\"2003.09.25\",\"22:30\") " ;
or
$query="insert into dene (day,start_time) values ('2003.09.25','22:30') " ;
steve
M|cella Erdem Efe wrote:
I am a new programm
($result))
should be
if ($result)
regards Henrik Hornemann
> -Oprindelig meddelelse-
> Fra: Mücella Erdem Efe [mailto:[EMAIL PROTECTED]
> Sendt: 26. september 2003 00:52
> Til: [EMAIL PROTECTED]
> Emne: [PHP-DB] parse error.
>
>
> I am a new programmer of PHP4.3.3 an MySql 3
I am a new programmer of PHP4.3.3 an MySql 3.23 .
When below script is executed
"Parse error: parse error, unexpected T_DNUMBER in c:\program
files\apache group\apache\htdocs\ilkdeneme21.php on line 17"
is being seen.
This may be very simple but I could not solve it.Could you help me for thi
[EMAIL PROTECTED] wrote:
IBI> I am having a problem with a parse error.
IBI> error:
IBI> Parse error: parse error, unexpected ')' in
IBI> /Users/timbest/Sites/cajunmikes/inc/menupage.php on line 75
IBI> Fatal error: Cannot instantiate non-existent class: menu in
IBI> /Users/timbest/Sites/cajunm
I am having a problem with a parse error.
error:
Parse error: parse error, unexpected ')' in
/Users/timbest/Sites/cajunmikes/inc/menupage.php on line 75
Fatal error: Cannot instantiate non-existent class: menu in
/Users/timbest/Sites/cajunmikes/TMPfj18cc2i20.php on line 7
The issue I am having
() round brackets round the condition {} braces around the 'do it' bit :)
HTH
Peter
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]
Sent: 27 February 2003 00:43
To: php
Subject: [PHP-DB] Parse Error
Hi there everyone,
I'm trying to run an if statement and inside
If statements use curly braces. Do this:
if ($packages == "1"){
if ($airporttransfer == "car")
$airporttransfer2 = "12.00");
if ($airporttransfer == "bus")
$airporttransfer2 = "10.00");
if ($airporttransfer == "none")
$airporttransfer2 = "0.00");
}
On Wed, 2003-02-26 at 16:42, Chris Payne w
Hi there everyone,
I'm trying to run an if statement and inside that have other if's, but it keeps
telling me I have a parse error on the first if in the if statement (The second if
down). Can anyone see what i'm doing wrong?
if ($packages == "1")(
if ($airporttransfer == "car")(
$airporttran
Thank you!! This appears to have solved it... I didn't even think of using
the "$message" variable instead of the "print()"... Sheesh... I still have
LOTS to learn!!
Chase
"Micah Stevens" <[EMAIL PROTECTED]> wrote in message
1038878012.23696.129.camel@tyrell">news:1038878012.23696.129.camel@
Remember, the print() function sends stuff to the browser. If you wish
to make the code output to the $message variable, you must use
additional assignment statements.
I made some quick changes to the code below, try that:
" . ", " ;
$to .= "Chase <[EMAIL PROTECTED]>";
$subject = "Price File
like you think it will.
Jim
---Original Message---
From: Chase
Date: Monday, December 02, 2002 04:34:18 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Parse Error...
There is a single quote and semicolon on the line under that I
thought would be defining the end of the assignment.
Sho
.
Your close, but it's just not going to work like you think it will.
Jim
---Original Message---
From: Chase
Date: Monday, December 02, 2002 04:34:18 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Parse Error...
There is a single quote and semicolon on the line under t
There is a single quote and semicolon on the line under that I
thought would be defining the end of the assignment.
Should I have used double quotes instead of single?
Chase
"Micah Stevens" <[EMAIL PROTECTED]> wrote in message
1038870535.23725.123.camel@tyrell">news:1038870535.23725.123.cam
There aren't any closing quotes on your $message variable or semicolon
to tell the parser that you're done with the assignment statement.
-Micah
On Mon, 2002-12-02 at 15:05, Chase wrote:
> When trying to execute the following script to send the contents of a table
> via "mail()" I am getting
When trying to execute the following script to send the contents of a table
via "mail()" I am getting this error...
Parse error: parse error, unexpected T_STRING in FILENAME.PHP on line 36
The portion of this code inside the HTML tags works great for displaying the
table on the screen, but when I
Hallo everybody,
I do have a little problem and can't come up with an answer. Can somebody
help me?
I would like to use two variables in a function, $database_viva and $viva.
$database_viva = "test";
$username_viva = "";
$password_viva = "";
$viva = mysql_pconnect($hostname_viva, $usern
According to your code, if the checkbox next to the word 'remove' is checked,
then the value of $cars passed to the form is "checkbox". Then in the
done2.php3 page, you are trying to delete where checkbox='array of values
listed'.
Is there a field in your database called checkbox? If so, wh
ld ($cars).
> 3- Rewrite your delete statement to delete the rows identified by the id
> column as "DELETE FROM $table WHERE id ='id'"; Of course in the page where
> you list the cars to be deleted associate each checkbox with the car's id.
>
> Hope this helps
Gurhan
-Original Message-----
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 1:02 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Parse Error
Here is the dump for the cars table...
test (
id varchar(30) NOT NULL auto_increment,
car_type varchar(30),
car_model v
> Jas..
> First of all you don't have the variable $cars assigned..
> Second of all, we still don't know what the "test" table looks like? Does
it
> only have one column with all the infos about cars populated in it???
>
> Gurhan
>
>
> -Original Me
AIL PROTECTED]]
Sent: Thursday, February 21, 2002 12:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Parse Error
Here is the code from the file that queries the db and pulls the current
contents of the db and provides a check box form for each record to delete
the items in the db. I dont know if this
l Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 12:26 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Parse Error
I hate to post this again but I have looked in a couple of php and mysql
books but cannot seem to figure this one out. I am getting a parse error
w
Here is the code from the file that queries the db and pulls the current
contents of the db and provides a check box form for each record to delete
the items in the db. I dont know if this will help but like I said before
any insight would be great. Thanks in advance.
Jas
Current
Inventory";
$
Is $cars an array field? If not, you are trying to compare $cars to an
list/array of values (I am not sure this would work even if $cars was an
array field) 'WHERE $cars
= "$car_type\",\"$car_model\",\"$car_year\",\"$car_price\",\"$car_vin\",\"$dlr
_num\"");'.
Normally, you would have to c
I hate to post this again but I have looked in a couple of php and mysql
books but cannot seem to figure this one out. I am getting a parse error
when trying to use php to delete records from a table. The error I am
recieving is as follows
Parse error: parse error in /path/to/php/done2.php3
AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Parse error
Can someone tell me why I am getting a parse error in this little snip?
Original value is $origVar";
$origVar += 25;
echo "Added a value, now it's $origVar";
$origVar -= 12;
echo "Subtracted a value, now
uot;.$origVar."";
?>
Cami
-Original Message-
From: Jennifer Downey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 2:33 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Parse error
Can someone tell me why I am getting a parse error in this little snip?
Original v
Can someone tell me why I am getting a parse error in this little snip?
Original value is $origVar";
$origVar += 25;
echo "Added a value, now it's $origVar";
$origVar -= 12;
echo "Subtracted a value, now it's $origVar";
$origVar .= " chickens";
echo "Final answer: $origVar";
?>
Thanks in adv
Hello,
Can anyone tell me what's wrong with line 68? I get a parse error on
line 68 trying to run this. The strange thing is that it doesn't
complain about line 54. Either I'm blind, stupid, or there's somehing
very wrong here. I've checked above line 67 too, but there doesn't seem
to be any miss
I'm working through the New Riders MySQL book and I get the following error
when running a php script, can someone help? Thanks, Matt -
Parse error: parse error in c:\program files\apache
group\apache\htdocs\genesis\dump_info.php on line 25
Here's lines 25 -
printf ("%s\n", htmlspecialchars
On Thu, 2001-12-13 at 23:49, Rob Day wrote:
As far as I can see, you're missing '; in line 360, unless it continues
further down and terminates the $message string there.
> Here is the offending code:
> 353 if ($moderation == "no"){
> 354 $message .= " checked";
> 355 }
> 356
> 35
ink this line is the one you have to worry about!
-Original Message-
From: Rob Day [mailto:[EMAIL PROTECTED]]
Sent: 13 December 2001 21:49
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] parse error
I've written a small script that processes a form from a webpage and sends
the su
Rob -
I think I see what you're doing: you're concatenating $message with something
else (the HTML output following line 357?). Problem is, you're just stating
the right hand side of what should be an assignment. The concatenation should
be:
$variable = $variable .= 'HTML output';
and it looks
iew, Texas, USA | -- John Powell
> -Original Message-
> From: Rob Day [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 13, 2001 3:49 PM
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] parse error
>
>
> I've written a small script t
I've written a small script that processes a form from a webpage and sends
the submitted data as an HTML e-mail that has the form all filled out
already. I've gotten smaller versions of this script to work without any
problem just to test the idea.I can't figure out why I'm now getting the
followi
uot;Roel Mulder" <[EMAIL PROTECTED]>
To: "Jelle Ferwerda" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 10, 2001 10:39 PM
Subject: Re: [PHP-DB] parse-error MySQL - PhP @ win2000
> Dag Jelle,
> Als je printf(); gebruikt moet je dit wel
Hi Jelle,
- Original Message -
I have recently installed an apache server, PhP4 and MySql on my win2000 machine (I
know, I should be running
linux; That will have to come with time). But now I am trying to learn PhP - MySQL.
When running the script
below I get the error message:
Parse
Dag Jelle,
Als je printf(); gebruikt moet je dit wel correct doen, met print(); zou
het goed moeten gaan.
Dus regel 24 wordt: print ($resultaat[0]);
(Excuse me muttering Dutch between the two of us :)
M.vr.gr.
Roel Mulder
At 21:32 10-11-2001 +0100, you wrote:
>Hi all,
>
>I have recently ins
Hi all,
I have recently installed an apache server, PhP4 and MySql on my win2000 machine (I
know, I should be running linux; That will have to come with time). But now I am
trying to learn PhP - MySQL. When running the script below I get the error message:
Parse error: parse error in c:\phpdev
... perm.inc on line 56
Hi all,
this message some ppl get when they try to connect to a mysql database.
i use php3 with phplib.
the problem is, when i try it over lan and with dialin over isdn, there
are no probs with win95, win98, winme and nt4.0 clients. neither with
ms-ie nor with netscape.
On Tue, Mar 13, 2001 at 07:56:31PM +0100, paauwe wrote:
> what is a parse error?
A simple search on dictionary.com came up with this definition for
parse:
Of fish, to have to remove the bones yourself. "I object to parsing
fish", means "I don't want to get a whole fish, but a sliced one is
oka
what is a parse error?
73 matches
Mail list logo