Hello all,
I have an error and I will be darned if I know why. Here is the code:
?php
require '/path/to/database/connection/class/db.php';
$table = portfolio;
$portfolio = mysql_query(SELECT * FROM $table,$dbh);
while ($sections = mysql_fetch_array($portfolio)) {
list($id, $2d, $3d, $web,
Why don't you try this instead:
while(list($id, $2d, $3d, $web, $prog, $tut,
$proj)=mysql_fetch_array($portfolio))
{
do whatever..
}
the list construct only works with numerical arrays and it might not like
the $section array (doesn't it get stored as number indicies AND column
On Tuesday 28 May 2002 21:15, Jas wrote:
Hello all,
I have an error and I will be darned if I know why. Here is the code:
?php
require '/path/to/database/connection/class/db.php';
$table = portfolio;
$portfolio = mysql_query(SELECT * FROM $table,$dbh);
while ($sections =
I'm trying to use PHP with Informix support.
If I use Apache with dynamic modules, I get the following
error when I try to load the Apache server:
Cannot load /usr/local/apache/libexec/libphp4.so into
server: /opt/informix/lib/esql/libifgen.so: undefined
symbol: stat
Apache loads if I use
Howdi guys
any help on this would be greatful
I have a page that submits to this script with a value of search
but when I submit it gives me an error Parse error: parse error in
/var/www/html/ul/mysql_fetch_array.php on line 11
anyhelp here would be greatful, I dont see what the error could
One thing I noticed quickly. You have too many opening ( on the line that
says:
while (($row = mysql_fetch_array($result, MYSQL_ASSOC))
3 opening and 2 closing.
This would cause a parse error. Without knowing which line is line 11, it is
hard to say if there is anything else.
I am trying to create the following table using PHPMyAdmin:
CREATE TABLE IF NOT EXISTS ayny(
organization varchar(50) NOT NULL,
subtitle varchar(50) NOT NULL,
img varchar(20) NOT NULL,
width varchar(5),
height varchar(5),
link varchar(30) NOT
, April 08, 2002 11:11 AM
Subject: [PHP-DB] Error creating new table
I am trying to create the following table using PHPMyAdmin:
CREATE TABLE IF NOT EXISTS ayny(
organization varchar(50) NOT NULL,
subtitle varchar(50) NOT NULL,
img varchar(20) NOT NULL
11:11 AM
Subject: [PHP-DB] Error creating new table
I am trying to create the following table using PHPMyAdmin:
CREATE TABLE IF NOT EXISTS ayny(
organization varchar(50) NOT NULL,
subtitle varchar(50) NOT NULL,
img varchar(20) NOT NULL,
width
AM
Subject: Re: [PHP-DB] Error creating new table
Worked like a charm, thanks.
How do I avoid varchar if I the size of the text will vary with each
entry?
It's going to be a pretty small database anyway so I'm not that worried,
but how often do I optimize the table to avoid fragmentation
I can't use sql command insert into but I can use select and it
condition.I use DSN that provide by ODBC and use MS-Access as source file.
my code :
$connect = odbc_connect(sosdb,,) or die (can not connect)
; -successfult
$order_trans_detail_sql = insert into order_trans_detail
: Penockio [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 12, 2002 12:51 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error insert into MS-access through ODBC not aviable
I can't use sql command insert into but I can use select and it
condition.I use DSN that provide by ODBC and use MS
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 07, 2001 4:28 PM
Subject: [PHP-DB] Error help needed
Hi there everyone,
I've just reinstalled Windows 2000 for the second time, and I am still
getting errors when I try to read MySQL databases - especially from within
Myadmin (But also
Executing from a script file I continue to receive the following errors when
compiling PHP4:
System: SuSE 7.1, latest Apache PHP source
./myphpmakefile: --with-apache=/usr/local/src/apache/apache_1.3.22: No such
file or directory
./myphpmakefile: --with-config-file-path=/www/conf: No such file
On SuSE 7.1
Latest PHP and Apache source
using --with-apxs with PHP configure
receive noted error.
Anyone solve this?
Saw thread in PHPbuilder about removing stub.c and remaking, that provided
an error stating stub.c was required.
Thanks
Greg
--
PHP Database Mailing List
I got this message when i call the php script,
Fatal error: Call to undefined function: mysql_connect() in
/home/jaelee/public_html/test01.php on line 6
what's wrong?
thx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
-Original Message-
From: Jae [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 12:18
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error on connecting to mysql database
I got this message when i call the php script,
Fatal error: Call to undefined function: mysql_connect() in
/home/jaelee
thx a lot
Jason Wong [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó
01c14646$74b41ae0$[EMAIL PROTECTED]">news:01c14646$74b41ae0$[EMAIL PROTECTED]...
-Original Message-
From: Jae [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 12:18
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error on co
Hi folks.
I am getting a bizarre error when trying to insert CLOB data into my
Oracle 9i database. (Using PHP4 on Apache 1.3.20) Error refers to a
missing 'comma'?! Here is the exact error:
Warning: OCIStmtExecute: ORA-00917: missing comma in
/www/htdocs/Etrack/oracle_operations.php on line 52
a look back to the last mail I sent you about a
month ago for more info.
Regards,
- Paul -
- Original Message -
From: Muciño Zúñiga Marco Antonio [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 28, 2001 7:28 PM
Subject: [PHP-DB] Error making php with informix
Hi, I'm trying
Have you tried typing this SELECT statement directly into MySQL? If not,
try it; MySQL may indicate a more precise error.
rick
-Original Message-
From: Alex V.Varavva [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 1:03 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error in SQL
Hi, I'm trying to install php-4.0.6 in my SCO Unix box but when I run the
make command I get the next error:
/bin/sh ../libtool --silent --mode=link gcc -g -O2 -o libZend.la -lifsql
-lif
asf -lifgen -lifos -lifgls -lnsl_s -lcrypt_i -lgen -lsocket -lnsl -lsuds
-ltinfo
-lprot -lx -ltinfo -lc
Hi!
After upgrade PHP 4.0.4pl1 to version 4.0.6
This script not worked
?php
...
$db = ibase_connect ($DB_WWW, $USER, $PASS,'WIN1251');
$stmt=SELECT YPID FROM TOP_TODAY WHERE DT('TODAY'-24);
$sth = ibase_query ($db, $stmt,$res);
...
?
InterBase: Dynamic SQL Error SQL error code = -206 Column
Hi!
On execute script
?php
...
$db = ibase_connect ($DB_WWW, $USER, $PASS,'WIN1251');
$stmt='SELECT YPID FROM TOP_TODAY WHERE DT(TODAY-24)';
$sth = ibase_query ($db, $stmt);
...
?
I have error
InterBase: Dynamic SQL Error expression evaluation not supported in
./test.php
Why ? This is
See http://php.weblogs.com/adodb_csv
You create a proxy on Windows server and query access via the Windows
server.
Vijay Anand [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
how to access MS Access database using adodb in unix
--
PHP Database Mailing
Hi Wrox guys and all,
Can anyone help me out on this??
I've been using this code for quite some time now. I got it from the
Beginning PHP4 by Choi, Kent, Lea, Prasad, and Ullman. All those times, I
don't get any errors UNTIL tonight! :(
I am now getting this error message:
Warning: Supplied
how to access MS Access database using adodb in unix
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[Please reply to: [EMAIL PROTECTED], thanks...]
Hi Wrox guys and all,
Can anyone help me out on this??
I've been using this code for quite some time now. I got it from the
Beginning PHP4 by Choi, Kent, Lea, Prasad, and Ullman. All those times, I
don't get any errors UNTIL tonight! :(
I am now
On Mon, Aug 13, 2001 at 03:38:50PM -0700, John Telesh wrote:
I have created a form which I cannot duplicate the error which is coming up
only sometimes. An affiliate to my client had received emails regarding the
following error:
The requested method POST is not allowed for the
I have created a form which I cannot duplicate the error which is coming up
only sometimes. An affiliate to my client had received emails regarding the
following error:
The requested method POST is not allowed for the URL/index.html
The page this is running on is called maxout.php and it is a
Hi all
I have a searchbox that throws a wobbly when certain characters are
entered into it - basically the user is supposed to enter a
space-delimited list of words to search for, and then I create an array
from it and turn it into an OR etc query.
What I initially did was replace all commas
);
without violating any holy regex laws :)
// -Original Message-
// From: Dave Watkinson [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 8 August 2001 3:18 PM
// To: PHP-DB List (E-mail)
// Subject: [PHP-DB] Error checking and escaping before running a query
// (MySQL)
//
//
// Hi all
)
Subject: RE: [PHP-DB] Error checking and escaping before running a query
(MySQL)
Dave,
sounds like you are on the right track, but rather than use the
comparatively bulky regular expression engine, why not just the
light-weight
string function
str_replace( ,, , $searchbox );
(see String
Ok, I've downloaded the source code, and ran the
/configure --with-sybase=/opt/sybase-11.9.2/. When I got to do the make
on it, I get these errors:
/home/ksayre/downloads/php-4.0.6/ext/sybase/php_sybase_db.h:67:22:
sybfront.h: No such file or directory
Hi everybody,
All of the sudden I got an error one of mysql tables.
Got error 127 from table handler.
Can't browse it not even from phpmyadmin get the same error. Anybody had
this before? What do I do to recuperate my table?
I really appreciate any help,
Thanks,
Cami
--
PHP Database Mailing
-
From: Cami
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 8:56 AM
Subject: [PHP-DB] Error 127
Hi everybody,
All of the sudden I got an error one of mysql tables.
Got error 127 from table handler.
Can't browse it not even from phpmyadmin get the same error. Anybody had
Thanks everybody for pointing me to the right place.
I manage to recover it.
Thank God.
Cami
-Original Message-
From: Cami [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 19, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error 127
Hi everybody,
All of the sudden I got an error
you know i did this last week and can't remember the functions is used.
i had exactly the same problem but had to dump the records as plain text
files.
i used get_html_translation_table . if you look at the example in the
compiled html help file for php there is a section of code that uses this
I can connect my oracle server from apache with php function
OCILogon(user,pwd,dbname);
without problems...
but sometimes when i reload the same web page i get the ORA-24327 error
OCISessionBegin: Error while trying to retrieve text for error ORA-24327
My machine is a Sun solaris
whit APACHE
,
address, and sid. In other words, ORCL is shorthand notation for all of the
TCP/IP info and then some.
I hope this makes sense,
Anthony
-Original Message-
From: sang [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 9:32 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] error ORA
I have installed NT4+PHP+ORACLE8.0.4+APACHE in my computer.
I want to access ORACLE server to another computer from web server.
It is ok to access ORACLE SERVER with PERL, but i cannot access using PHP.
The first error is ora-12514 , but i change, change and change, now it is
always
ORA-12699
PROTECTED]
Subject: [PHP-DB] error ORA-12699
I have installed NT4+PHP+ORACLE8.0.4+APACHE in my computer.
I want to access ORACLE server to another computer from web server.
It is ok to access ORACLE SERVER with PERL, but i cannot access using PHP.
The first error is ora-12514 , but i change, change
machine is trying to access an Oracle database
on
itself, because no connect string was specified.
Lemme know if this helps,
Anthony
From: sang [EMAIL PROTECTED]
Date: Wed, 27 Jun 2001 18:59:31 +0900
To: [EMAIL PROTECTED]
Subject: [PHP-DB] error ORA-12699
I have installed NT4+PHP+ORA
What it means?? I see it in a SQL Query from MSSQL 2000
Server: Msg 8152, Level 16, State 9, Line 1
String or binary data would be truncated.
The statement has been terminated.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
Hi,
Warning: MySQL Connection Failed: Unknown MySQL Server Host '0f2scom' (2)
in
/web/sites/139/gamie/www.game-boy-advance.f2s.com/addartikel.php on line
22
Unable toconnect to database
[...snip...]
mysql_connect(db.game-boy-advance.f2s.com,*,**) or die(Unable
toconnect to
Hi!
We use a informix IDS2000 server on a linux machine together with php 4.05
on Apache. As a test we wrote the following script:
?php
$conn_id = ifx_connect(unipps,informix,sqLOpen);
if (! $conn_id)
{
echo connection failed;
}
$ergebnis = ifx_query(select ident_nr from personal,
Hi Paul,
thanks for your fast reply. Maybe you could help me again :-) We are working
a lot with informix, so we thought to know every Programm, but isql is
completely unknown. Is this a special programm?
We have executed this select with a sql-editor on the server also as with
dbaccess, on
, 2001 3:40 PM
Subject: Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query
on a informix database on linux
Hi Paul,
thanks for your fast reply. Maybe you could help me again :-) We are
working
a lot with informix, so we thought to know every Programm, but isql is
completely
every time i get this error:
Warning: MySQL Connection Failed: Unknown MySQL Server Host '0f2scom' (2) in
/web/sites/139/gamie/www.game-boy-advance.f2s.com/addartikel.php on line 22
Unable toconnect to database
this is de code(ther are dutch line's in it because this code is for an
dutch site):
Hi,
I wanted to configure PHP w/ Sybase support in our Solaris box. So, I have
installed FreeTDS.
When I ran the configure command in PHP, I got the following error messages:
checking whether the C++ compiler (c++ -R/usr/ucblib -L/usr/ucblib
Hi, I have the follow error when i try to connect to Oracle 7.3.3.
Warning: Oracle: Connection Failed: ORA-12154: TNS:no se ha podido resolver
el nombre del servicio in
C:\Inetpub\wwwroot\websuperII\pruebas\ConexionOracle.php on line 7
Error conectando a la base de datos.
Please help me
You're right, no row was returned by the query when i did tried to fetch it. So
I suppose the next viable thing to do is to figure what went wrong with the
query.
Thanks
CC Zona wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] ("Shahmat Dahlan") wrote:
Hmmm not sure -
You could try to strip out much of the sql by simply using:
$sqlstmt ="SELECT * FROM stock_in, equip, vendor";
$sqlstmt.="WHERE equip.id=equip_id and vendor.id=vendor_id and
equip.id='$id'";
$sqlstmt.="ORDER BY equip.id ASC";
# print $sqlstmt;
$result=mysql_query($sqlstmt);
#
$sqlstmt ="SELECT stock_in.id, equip.equip_type, ";
$sqlstmt.="equip.brand, equip.model, ";
$sqlstmt.="vendor.name, stock_in.po_no, ";
$sqlstmt.="stock_in.vendor_sales_no, stock_in.cust_po_no, ";
$sqlstmt.="stock_in.serial, stock_in.warranty, stock_in.date_received,
";
$sqlstmt.="stock_in.remark,
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] ("Shahmat Dahlan") wrote:
$result=mysql_query($sqlstmt);
# print $result;
$row=mysql_fetch_array($result)
extract($row);
If I do the above, I get the results below:
Warning: Wrong datatype in call to extract() in
Hi,
cookies are sent as header information. This means you can't send
any output (html-tag, whitespaces before ?php) at all before
sending cookie/header information.
As your error message tells you the output already started in line 4.
Move the cookie-part from line 6 to the beginning and it
Mauricio Junqueira wrote:
Mauricio Junqueira wrote:
Hello, this is my first attempt to query and print a result coming from a
database, in this case interbase6.
I got the following error: InterBase: Dynamic SQL Error SQL error code =
-504 Cursor unknown in maingeral.htm on line 8
Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90
And I have just 89 lines
Here are the last linse from index.html:
?php
if ($verify ==7){
$connection = mysql_connect("localhost", "user", "password")
or die("Cannot connect");
$db = mysql_select_db("rating" ,
Hello, Dan
You did not close { } statement.
DG Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90
DG And I have just 89 lines
DG Here are the last linse from index.html:
DG ?php
DG if ($verify ==7){
DG $connection = mysql_connect("localhost", "user", "password")
DG
Dan,
I think you're missing the end quotes (") here:
...
where image='$arr_Images[$randID]' " ;
...
At 10:57 PM 4/6/2001 +0300, Dan Guja wrote:
Parse error: parse error in /home/httpd/.../htdocs/index.php on line 90
And I have just 89 lines
Here are the last linse from
Mauricio Junqueira wrote:
Hello, this is my first attempt to query and print a result coming from a
database, in this case interbase6.
I got the following error: InterBase: Dynamic SQL Error SQL error code =
-504 Cursor unknown in maingeral.htm on line 8
Here's the code:
?
If just comment the following lines, everything works Please help...
I'm getting nut !!
? include("php/header.php");
ibase_pconnect(BANCO,DBUSER,DBPASSWD)
or die ("script language='javaScript' alert('" . ibase_errmsg() .
"'); /script");
$stmt = "select count(*) from
I am getting a parse error for the return line every time I try and view
the page. Can anyone tell me why? The code is below.
$results = "select req, source, number from orders where req=" .
$GLOBALS["req"] . ", source=" . $GLOBALS["source"] . ",
number=" .$GLOBALS["req"] . "";
if
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] ("Jason Bell") wrote:
Hello! I'm writing a script that validates a form It creates users in a
mysql table, where there are 2 unique columns 'username' and 'email'.
I'm putting mysql_error() into a variable, but I don't want the end user
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Liz Bander) wrote:
I am getting a parse error for the return line every time I try and view
the page. Can anyone tell me why? The code is below.
$results = "select req, source, number from orders where req=" .
$GLOBALS["req"] . ",
Hi--
When I run the following code:
if($myrow = pg_fetch_array($result,0)) {
echo "ok...";
} else {
die(include("../sqlerror.inc"));
}
I get this error message:
"Warning: Unable to jump to row 0 on PostgreSQL result index 2 in
/html/rccd/remodel/display.php on line 27"
Please
I'm baffled (again )
In my mql database I'm doing:
SELECT cl_login FROM client WHERE cl_login = "xxx";
and if "xxx" exists I get the result xxx while if it doesn't exist I get an
empty string.
In PHP I'm doing
$querytest = "SELECT cl_login FROM client WHERE cl_login = '$txtLogin';";
: Tuesday, March 13, 2001 5:05 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Error prevention
I'm baffled (again )
In my mql database I'm doing:
SELECT cl_login FROM client WHERE cl_login = "xxx";
and if "xxx" exists I get the result xxx while if it doesn't exist I get an
empty
Michael Rudel wrote:
Hi Martin,
... you forgot to 'mysql_fetch_row' or 'mysql_result'. Read about it in
the PHP-Manual in the MySQL Functions.
Thanks Mike (and everyone else who pointed this out),
Sometimes you're blind.
When you think you pass the "complete-and-utter-newbie" phase
/downloads.php
Siggy
- Original Message -
From: "Devang P. Shah" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, December 31, 2000 11:13 PM
Subject: [PHP-DB] Error in accessing the database through MySQL
Dear Sir/Mam,
I
Hi,
While I try to connect to SYBASE server i recieve "Message from server is invalid"
Where I can get description of retrieved error ?
Thanks,
wangjing
When a database connection fails, how do I detect that in my script so I can
skip all the rest?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
101 - 172 of 172 matches
Mail list logo