Windows 7 SP1; php 5.3.29; Apache 2.4.9; MySQL 5.6.17
$isr = mysql_unbuffered_query ( $is, $link_id );
if ($isr === false) {
...
}
if ($isr) {
$booking_id = '';
while ( $isv = mysql_fetch_assoc ( $isr ) ) {
$result ['id'] = $isv ['id'];
...
Second time through this loop I get the following
Dear List -
1] What function(s) do you use for error checking?
2] What are the settings for the parameter(s) in the functions?
3] Do you have different php.ini files for development and production?
Thank you.
Ethan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Tue, Jan 8, 2013 at 11:54 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
1] What function(s) do you use for error checking?
2] What are the settings for the parameter(s) in the functions?
3] Do you have different php.ini files for development and production?
On Thu, Jun 7, 2012 at 7:42 AM, OJFR misabe...@infomed.sld.cu wrote:
HI,
Snip rude text
OSAIN.
Hi,
You might want to read the PHP mailing list rules[1] and RFC 1855[2]
before posting to this mailing list again.
- Matijn
[1] http://www.php.net/reST/php-src/trunk_README.MAILINGLIST_RULES
HI,
I'M TRYING TO DEVELOP AN APP USING SYMFONY 2.0 AND PHP 5.4, BUT THE REAL
PROBLEM IS THAT MY DATABASES ARE IMPLEMENTED IN WINDOWS SERVER 2000 AND
THOSE ARE THE DATA SOURCE OF OTHER APPS ALREADY RUNNING SO I CAN'T EVEN
THINK ABOUT UPGRADING MS SERVER 2000 DUE TO SOME INCOMPATIBILITIES (I'VE
Hullo users,
I am using sqwebmail access my mails. I want to transfer to
squirrelmail .After installation of squirrelmail with postfixadmin I
can still access my mails using squirrelmail but I am having problems
with :
1. Change password (Changing your mailbox password)
Error:
ERROR:
On 2011-04-08, at 1:57 AM, Karl DeSaulniers k...@designdrumm.com wrote:
Ooops.
Sry, forgot an escape.
$q = UPDATE expiringleases SET Cricket_Region =
'.mysql_real_escape_string($Cricket_Region).', Market =
.mysql_real_escape_string($Market).' WHERE Search_Ring =
I am getting the following error when I try to use my edit.php script:
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 '' at line 1
I can't seem to find anything wrong with my syntax below.
Has anyone ever had
I believe this line should read..
ini_set('display_errors', 1);
Just something I think I caught. Might not be your solution though.
HTH,
Karl
On Apr 7, 2011, at 11:00 PM, Chris Stinemetz wrote:
ini_set('display_errors', '1');
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP
The two query statements are different - in one you quote $id and in the
other you don't.
It is definitely a mysql error so it's not the line you suggested.
Karl DeSaulniers k...@designdrumm.com wrote in message
news:6fe62364-f9fc-4612-8c5d-6ce48fc66...@designdrumm.com...
I believe this line
I am pretty sure it is in my code. I am just getting an error form one
of my echoes. Still can't get it to work correctly though. Any help is
greatly appreciated.
Thank you,
Chris
?php
/*
EDIT.PHP
Allows user to edit specific entry in database
*/
// creates the edit record form
// since
Hi Chris,
I believe you only need to do a htmlspecialchars when displaying data
as readable text that your retrieved from the database after inserting.
And probably some other situations as well, but I don't think you
need to do htmlspecialchars on the
mysql_real_escape data when inserting
Hi Chris,
Try this..
Or season to taste..
$q = UPDATE expiringleases SET Cricket_Region =
'.mysql_real_escape_string($Cricket_Region).', Market = .
$Market.' WHERE Search_Ring = '.mysql_real_escape_string($id).';
mysql_query($q) or die(mysql_error());
Best,
Karl
On Apr 8, 2011, at 12:13
Ooops.
Sry, forgot an escape.
$q = UPDATE expiringleases SET Cricket_Region =
'.mysql_real_escape_string($Cricket_Region).', Market =
.mysql_real_escape_string($Market).' WHERE Search_Ring =
'.mysql_real_escape_string($id).';
mysql_query($q) or die(mysql_error());
Best,
Karl
On Apr
Hi All,
I have 2 simple php pages. One with the form just like some sales voucher.
Another is to print in a proper format and to insert the form database into
mysql. When I enter some data in the sales voucher everything is going well,
however when it comes to the second php for inserting data
On 1 March 2011 10:25, nagendra prasad nagendra802...@gmail.com wrote:
Hi All,
I have 2 simple php pages. One with the form just like some sales voucher.
Another is to print in a proper format and to insert the form database into
mysql. When I enter some data in the sales voucher everything
Hi
I have a page that inserts data into a oracle table using a oracle
stored procedure via php. However when the php runs I get the following
error:
Warning: oci_execute() [function.oci-execute]: ORA-06550: line 2, column
7: PLS-00553: character set name is not recognized ORA-06550: line 0,
I am getting semi-ambiguous messages in the browser like:
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 '' at line 4
Is there a way in my PHP script to turn on a logging that is more
specific about which
put:
echo mysql_error();
right after the sql query.
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
On Apr 27, 2007, at 10:15 AM, Tim McGeary wrote:
I am getting semi-ambiguous messages in the browser like:
You
-Original Message-
From: Kevin Murphy [mailto:[EMAIL PROTECTED]
Sent: Friday, April 27, 2007 12:49 PM
To: [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] error logging MySQL syntax errors?
put:
echo mysql_error();
right after the sql query.
--
Kevin Murphy
plz remind to send to us your aplication.. the problem may cause from your
sintax don't match the version
- Original Message -
From: Tim McGeary [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Saturday, April 28, 2007 12:15 AM
Subject: [PHP-DB] error logging MySQL syntax errors?
I am
Hello,
I tried to run your SQL query with my private database and there
wasn't any problem. You can use primary key like your PHP code because I run
your SQL in the mysql command line succesfully. Did you connect root account
to your mysql server? If the account is root, there isn't any
im trying to create a database in a php file.i have MySql 5.0.33 PHP 5.2.1
this is the code i have in the php file
$con = mysql_pconnect(127.0.0.1,root,12345);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query(CREATE DATABASE mydatabase,$con))
{
echo
Hi,
I am trying to send an email to the user after he registers himself on the
website. The code is a DB code that
1) Inserts the data to DB table
2) Sends an email to the user with his details.
3) Passes on a Thank you page.
The code works fine without the email code. But I get this error
I am trying to use a program written in PHP but connect to an Oracle
database.
We have a function as follows:
function dbconnect($db, $username, $password)
{
global $siteadmin;
global $db;
// $bob = @mysql_connect($db, $username, $password);
Hi Janet,
This is a PHP 5 only function. Are you running PHP 5? If not, try using
ocilogon() instead. If you are running 5, then maybe the Oracle library
wasn't included when PHP was compiled.
HTH,
Tony
On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote:
I am trying to use a program
Hi Janet,
This is a PHP 5 only function. Are you running PHP 5? If not, try using
ocilogon() instead. If you are running 5, then maybe the Oracle library
wasn't included when PHP was compiled.
HTH,
Tony
On 9/26/06 2:13 PM, Janet Smith [EMAIL PROTECTED] wrote:
I am trying to use a program
Hello,
I got the following error message when calling a stored procedure on MSSQL
2000 server:
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to
be set for the connection. This ensures consistent query semantics. Enable
these options and then reissue your query. [20018]
The original message was included as attachment
Virus Warning Message
The virus (W32/[EMAIL PROTECTED]) was detected in the attachment
transcript.zip. The
attached File transcript.zip has been removed.
Nachfolgender Virus (W32/[EMAIL PROTECTED]) wurde im Attachment
From: Jordens Michiel [EMAIL PROTECTED]
To: php-db@lists.php.net, php-db@lists.php.net
Subject: Error testin MySQL
Date: Tue, 28 Jun 2005 15:51:42 -0700
Hello All,
Im trying to test MySQL.
The code that Im using is below.
html
head
titlePHPtest/title
/head
body
!--mysql_up.php --
?php
Error 0 means that there were no errors in the execution of the query. It
does not mean that the query actually returned results that you expect.
Bastien
From: Michiel Jordens [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Error testing MySQL
Date: Tue, 28 Jun 2005 10:23:55
Hello,
I'm starting to learn how to manage databases with
MySQL/PHP. The program is very basic but I have a
strange error: Resource id #3.
I read many things on Internet and understood that
others have this error because they are trying to echo
the pointer of the query and not the result itself.
The message that you receive is not an error, it
is a description of the object $result after the
query is done.
So, you will not get anywhere just by echo $result,
you have to process that information using one
of the mysql_fetch_array(),mysql_fetch_assoc(),
mysql_result().
In your case try :
Hello,
Thank you very much to Bastien Koert and Firan
Corneliu. You both solved my problem.
Shame on me!
_
Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos
- Original Message -
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Monday, March 14, 2005 6:20 PM
Subject: [PHP-DB] Error with Where Clause
I get only the table headings and text before and after the table, but not
the table, when I add the where clause as below. Without the where
clause
hello,
how can i use error_log( ) function
to capture the error occured in my server,
currently the Error warning is switched off
and i can't turn it on because it is in production server
the problem is the query miss some records,
and i didn't see it's error message
beside this code
I get only the table headings and text before and after the table, but not
the table, when I add the where clause as below. Without the where
clause, the table does come up but (as expected) is repetitive and very
long. I'm using a template that I've used many times. I've tried
changing
Hi,
I'm new to PHP; I installed version 5.0.3 using Apache 2 and Postgres 8 on
Win XP SP2. I have a connection class and one of its methods is:
public function EjecutaSQL($pe_textoSQL = )
{
return pg_query($this-id, $pe_textoSQL);
}
where $pe_textoSQL contains the SQL sentence. If
Chenri wrote:
i have a script that
update records with this construct:
while( ){
query_string='UPDATE ...';
updateRecord(query_string);
}
the problem is when there are wrong query_string (such as incorect syntax)
can i make sure that the other query, the next one after the
the PHP/DB error and
supply your own. What you want to do is preprend the db connection
function with `@' and add your own upon failure -- something like this:
?
$dbh = @mysql_connect($dbhost, $dbuser, $dbpass);
if (!$dbh) {
echo Please make sure you are connected to the Internet
Hi there everyone,
Thanks to everyone helping with connecting to a remote server, works
wonderfully now :-)
I do have a final question, had a look online but couldnt find what I
needed. Its hard to explain why, but basically individuals have my program
on their HD, the DB is on their HD
hi,
i am trying to delete an item from inventory
management sys. done by using php on sqlite...
i had created a button 'delete' and when i submit a
value
to be deleted it is giving an error...
i am attaching the following codes:
1)html(delete.html) code which is working..
2)php code(td.php)
try checking for the value
if (isset($_POST[op] != addpost)) {
or to supress the error, use the '@' symbol in fron of the $_POST or $_GET
if (@$_POST[op] != addpost) {
Bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] error
Date: Tue, 28 Sep 2004 06:58:10 EDT
Dear friends
[EMAIL PROTECTED] wrote:
Dear friends,
Script writes to database, however gives this error while on internet web
server, on local host doesn't give same error.
Any guidance, please
Thank you
-
Back to Main
Notice: Undefined index: op in
Dear friends,
I have a form with radio check boxes, on submission to Php snippet output
should be score ! if user clicks right answer, otherwise score-0
However it is repeatedly giving me score-1 irrespective of correct radio
button is clicked or incorrect radio button is clicked.
Any
?php
$variable = $_POST['R'] ; ---
if ($variable == 3) {
echo Score 1;
}
else {
echo Score 0;
};
?
Original code didn't get radio check box's value.
You can use $_POST[ ] .
--
Yasuhiro Saito
--
PHP Database Mailing List
Dear friends,
With 4 radio buttons and php snippet, it gives desired output, however when I
add second question in the html form and variable for the same like
$variable =$_POST['q'] in Php snippet
it gives me error.
I have pasted php code when it works and when it gives error.
Any guidance,
--- [EMAIL PROTECTED] wrote:
Dear friends,
With 4 radio buttons and php snippet, it gives desired output,
however when I
add second question in the html form and variable for the same like
$variable =$_POST['q'] in Php snippet
it gives me error.
I have pasted php code when it works
Dear Friends,
Want to get rid of this error, pasted below.
Line 19 comes at else statement.
Any guidance, please.
---
Parse error: parse error, unexpected T_ELSE in C:\HOME\doctorbush\quiz.php on
line 19
It doesn't like the };
On Sat, 2004-09-18 at 19:04, Mark wrote:
--- [EMAIL PROTECTED] wrote:
Dear friends,
With 4 radio buttons and php snippet, it gives desired output,
however when I
add second question in the html form and variable for the same like
$variable =$_POST['q'] in
echo Score 1;
You'll get an error here too...missing quotes ()
On Sat, 18 Sep 2004 22:07:37 -0700, Cole S. Ashcraft
[EMAIL PROTECTED] wrote:
It doesn't like the };
On Sat, 2004-09-18 at 19:04, Mark wrote:
--- [EMAIL PROTECTED] wrote:
Dear friends,
With 4 radio buttons
Dear friends,
Any guidance to the error , please.
--
---
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse error: parse error, unexpected
Hi,
--- [EMAIL PROTECTED] wrote:
Dear friends,
Any guidance to the error , please.
--
---
Warning: Unexpected character in input: '\'
(ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse
Dear friends,
Any guidance to the error , please.
Resubmitting,
--
---
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse error: parse error, unexpected
[EMAIL PROTECTED] wrote:
Any guidance to the error , please.
Resubmitting,
--
---
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse error: parse error,
In addition, please send your messages once and only once. I have two
copies of the same e-mail, both sent to the list successfully with two
different replies to both messages. You're more likely to get help if
you post and wait for a reply to your original message.
--
Peter Ellis - [EMAIL
hello, this is problably newbie question, but I can not understand why my count()
function doesn't work. I need to count how many items has a determinated customer
ordered ever.
1. I tired to get the array like this:
$una = $check[uname];
function orderquantity ($una) {
$pss =
You need to pass the functions a variable to work with because you've
specified parameters. Try:
$okuan = orderquantity($una);
Ditto for the other function call.
--
Peter Ellis - [EMAIL PROTECTED]
Web Design and Development Consultant
naturalaxis | http://www.naturalaxis.com/
On Tue,
1. I tired to get the array like this:
$una = $check[uname];
function orderquantity ($una) {
$pss = mysql_query(SELECT OID FROM orders WHERE
una = '.trim($una).') or die (mysql_error(Query
error on Order search));
while($pisao=mysql_fetch_array($pss)) {
return count($pisao);
Thank you, that got me in the right direction. The OCI.DLL file on my
system was an older version and dependency walker determined this. After
that it was a simple matter of finding the right file version.
Thanks!
Christopher Jones wrote:
Philippe wrote:
Well, the exact message is: Unable to
Philippe wrote:
Well, the exact message is: Unable to load dynamic library
php_oci8.dll: The specified procedure could not be found
If I remove the library the message becomes The specified module could
not be found. It seems to be able to find the library (all the paths
are correct) but it
Yes, and as I was writing earlier, the message talks about a missing
procedure. If I remove the file temporarily, the message talks about a
missing library. So I think it can find the file OK, but that this
php_oci8.dll file is the wrong version or that it is looking for an
additional DLL that
Hi,
I am experiencing the message in the title of this message when starting
or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
- Oracle Client 8i
If anyone has any information as to why this is happening and how I can
solve it, I would be very
Philippe wrote:
Hi,
I am experiencing the message in the title of this message when starting
or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
- Oracle Client 8i
If anyone has any information as to why this is happening and how I can
solve it, I
Thanks for your quick reply, Chris. My oracle 8i client setup does work
on XP independently of PHP. I can connect to Oracle using PERL, ODBC,
Java as well as a database management tool called Aqua Data Studio which
uses native connections.
Christopher Jones wrote:
Philippe wrote:
Hi,
I am
The error sounds like an environment problem. Check phpinfo()
to see what paths are being used - see the FAQ.
Chris
Philippe wrote:
Thanks for your quick reply, Chris. My oracle 8i client setup does work
on XP independently of PHP. I can connect to Oracle using PERL, ODBC,
Java as well as a
Well, the exact message is: Unable to load dynamic library
php_oci8.dll: The specified procedure could not be found
If I remove the library the message becomes The specified module could
not be found. It seems to be able to find the library (all the paths
are correct) but it seems that this
Is the file in c:\tools\php\extensions\php_oci8.dll ?
Hi,
I am experiencing the message in the title of this message when starting
or restarting Apache. I have the following configuration:
- Windows XP
- Apache 2.0.49
- PHP 4.3.6
- Oracle Client 8i
If anyone has any information as to why this
Hi,
We're trying to configure php to work with solid but we get the
following error in the output:
*
* Unable to locate /usr/home/solid/lib/libfex.so or
/usr/home/solid/lib/libfex.a
* Please correct this by creating the
Hi:
I understand that this list is about PHP but, may be, any webmaster can
help me.
Linux Suse 8.2.
I was installed apache, php and mysql, all working fine.
from prompt i write mysql and run correctly, i create the database, tables
and grant permisions to users. all right.
but, when i run
How do I get rid of the undefined variable errors I get on a new (default)
set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works on
the internet on my host providers server but I am running this on localhost.
I also get undefined offset error.
Regards,
John
From: Dillon, John [EMAIL PROTECTED]
How do I get rid of the undefined variable errors I get on a new (default)
set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works
on
the internet on my host providers server but I am running this on
localhost.
I also get undefined offset
From: Dillon, John [EMAIL PROTECTED]
How do I get rid of the undefined variable errors I get on a new (default)
set up of Apache 1.3.28/PHP4.3.2 (without re-writing the code). It works
on
the internet on my host providers server but I am running this on
localhost.
I also get undefined offset
From: Dillon, John [EMAIL PROTECTED]
Hm. Adjusted error_reporting to none. Why would I still get:
Forbidden
You don't have permission to access /method=post on this server.
--
--
Apache/1.3.28 Server at
Greetings!
Just want to ask you why is it that i cannot connect to my interbase =
(firebird on freebsd 5.1). I installed my PHP with the following =
configuration.
./configure --with-apxs=3D/usr/local/apache/bin/apxs \
--with-interbase=3D/opt/interbase --enable-mbstring \
I have a strange problem I am adding records into a MySQL db... there is
a description
column and everything works fine when I add a new record. When I try to edit
an existing
record it fails if I us an apostrophe ['] in the field. I thought that
addslashes would take care
of this but it is
]
Subject: [PHP-DB] Error updating db when using a '
I have a strange problem I am adding records into a MySQL
db... there is
a description
column and everything works fine when I add a new record.
When I try to edit
an existing
record it fails if I us an apostrophe ['] in the field. I
, August 21, 2003 2:38 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error updating db when using a '
I have a strange problem I am adding records into a MySQL db... there is
a description
column and everything works fine when I add a new record. When I try to edit
an existing
record it fails if I us
-Notice: Use of undefined constant data..
-Notice: Use of undefined constant mail...
-Undefined variable
Why in my scripts i always get error notice like this?
How can i solve this problem?
Thanks
You are referencing variables that you have not created (or perhaps
array indexes that don't exist). To suppress these messages, fix your
code to not do such things, or just put this at the top of your scripts:
error_reporting( E_ALL ^ E_NOTICE );
Or edit php.ini to make it happen globally:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 20:22
What I would like to do is somehow have a redundant error
check on the server
side and then display an error message above the form on the
main page should
fields be left blank or
Hello everyone,
I've been experimenting with checking for errors in data inserted into a table
using an html form. The main page displays the result of a select * from
the_table at the top of the page, with the form for inserting the data beneath.
The SQL for the insert occurs on a
-- Forwarded Message
From: David Shugarts [EMAIL PROTECTED]
Date: Thu, 26 Jun 2003 18:53:53 -0400
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] error checking question
Hi, David--
The question you are asking belongs to the topic or concept called form
validation and you will see lots
hello,
how can i get an error message to print in the color red as
in the code below?
thank you for your time, addison
$message_new = $zip is not a valid zip code.
Please try again.;
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
echo font color=red$message_new/font;
Is that what you wanted?
- Original Message -
From: Addison Ellis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 14, 2003 5:01 PM
Subject: [PHP-DB] error message print
hello,
how can i get an error message to print
Hi all,
I use the following:
1) Win XP.
2) Oracle personal eddition 8.1.6.0.0.
3) IIS.
4) php-4.2.3-Win32 runs in cgi mode.
When I retrieve a blob from my DB, I got the following error:
Fatal error: Call to undefined function: load() in
c:\inetpub\wwwroot\php1\ora52.php on line 6
So, what can I do to retrieve a blob in oracle?
Any one has a code for this.
- Original Message -
From: Mark [EMAIL PROTECTED]
To: Naif Al-Otaibi [EMAIL PROTECTED]
Sent: Thursday, November 28, 2002 4:37 PM
Subject: Re: [PHP-DB] Error in retrieving a blob from oracle DB.
Load() does
Hi people,
I dont know why but am stuck trying to debug this problem. I keep
getting error number 1100 (Table 'jobs' was not locked with LOCK TABLES)
from PHP when i try querying a mysql database. It has me stumped because
I am using the LOCK TABLES statement when locking the tables...but maybe
Jason Wong wrote:
On Monday 04 November 2002 12:10, Bob Lockie wrote:
You can suppress the error message on failure by prepending a
http://www.php.net/manual/en/language.operators.errorcontrol.php to
the function name..
How can you get the error string into a local variable?
Look at
You can suppress the error message on failure by prepending a
http://www.php.net/manual/en/language.operators.errorcontrol.php to
the function name..
How can you get the error string into a local variable?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Monday 04 November 2002 12:10, Bob Lockie wrote:
You can suppress the error message on failure by prepending a
http://www.php.net/manual/en/language.operators.errorcontrol.php to
the function name..
How can you get the error string into a local variable?
Look at the track_errors setting
would be nice if you would tell which line is 140
-Original Message-
From: Burgess [mailto:[EMAIL PROTECTED]]
Sent: donderdag 10 oktober 2002 11:14
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error query : mysql_result
Hi
I have used the mysql_result function to return some specific
Burgess [mailto:[EMAIL PROTECTED]] wrote:
Hi
I have used the mysql_result function to return some specific
information
from database. The information is returned as it should but
I keep getting
this error message:
Warning: Unable to jump to row 0 on MySQL result index 4 in
This usually means your query failed. Check for errors using
mysql_error().
---John Holmes...
-Original Message-
From: Burgess [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:14 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error query : mysql_result
Hi
I have used
sorry for posting this mail twice, but the first one doesn't appear on the
news server (posting with google, doesn't work...)
Hi,
when I insert a new record with a unique indexed attribute, which is
already in the table, I only get some php warnings:
Warning: MS SQL message: Cannot insert
On Sunday 28 July 2002 15:24, JJ Harrison\\ wrote:
In the mysql command line ; is used to signify the ending of the current
query
Yes, but executing MySQL queries through PHP requires that you leave out the
';'
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software
Hi
You have an error in your SQL syntax near ';
^
As far as I know MySQL doesn't require a trailing *;* at the end of
the query.
Regards
Conni
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It turns out phpMyAdmin actually splits up the queries and does them
singaly.
--
JJ Harrison
[EMAIL PROTECTED]
www.tececo.com
Cornelia Boenigk [EMAIL PROTECTED] wrote in message
00ef01c23580$2ed210c0$7f54fea9@zwerg98">news:00ef01c23580$2ed210c0$7f54fea9@zwerg98...
Hi
You have an error in
I do my SQL in phpMyAdmin or at the command line and it works fine.
When I try and do my query through PHP I get this(Source to show there are
no br etc in it):
Query failed: INSERT INTO article_keyword VALUES (3, 'earth', 8.94855);
INSERT INTO article_keyword VALUES (3, 'gases', 13.42282);
I am getting this error with a new install of PHP4.2.1 and Zend
Optimizer 1.3.1:
The file '/tmp/phpr4WYQY' must be in the database directory or be
readable by all
I just updated PHP and the Zend Optimizer, and it had worked previously
with PHP4.1.2,
Any ideas??
Thanks
--
PHP Database
1 - 100 of 172 matches
Mail list logo