I don´t know what your class does ... but normally queries work like this:
open database
$qresult = query("select blah",$link_id);
// Now, in $qresult is a number with which you can go through your resultset
...
// For Example:
while ( $Recordset = ezi_fetch_array($qresult) ) {
print $R
You have two times the field "id"
Look at your query ... especially the Where-Clause ..
You only want to show Recordsets where id = id ...
=> In both columns is the same value ...
> -Original Message-
> From: Trevor Lanyon [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 27, 2001 2
Hello...
I'm trying to enter a fair amount of text into a mySQL database from
textfiles using PHP. I'm having some problems, and I hope someone can help
me. The table looks like this:
Name: rants
id : int auto_increment
date: varchar(8)
category: char(1)
title : varchar(75)
rt
Hi,
I have MS SQL 2 column which type is CHAR (in reason of contain more digit
of value). How could I write SQL statement to add or convert these 2
column value.
Thanks
Sommai Fongnamthip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
Fo
Hi!
On execute script
("TODAY"-24)';
$sth = ibase_query ($db, $stmt);
...
?>
I have error
InterBase: Dynamic SQL Error expression evaluation not supported in
./test.php
Why ? This is correctly SQL syntax
Regards
Alex
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-ma
I am new to the Linux environment - currently using IIS/PHP/Interbase.
What do I need in order to have Interbase running with PHP on a linux
7.1 platform? I have Interbase 6 installed and I have PHP 4.0.4pl1
loaded. The php.ini file has the extension interbase.so uncommented,
but I do not see a
Yep that was it. Thanks.
Thus spake Jason Brooke ([EMAIL PROTECTED]):
> > Anyone know if there's a trick to using PHP as a shell script and
> accessing postgres? I keep getting pg_exec not found yet it works in a
> browser. I'm using my normal abstraction class.
> >
> > All normal filesystem, st
> Anyone know if there's a trick to using PHP as a shell script and
accessing postgres? I keep getting pg_exec not found yet it works in a
browser. I'm using my normal abstraction class.
>
> All normal filesystem, string, etc functions are available. Just can't get
the pg functions to work.
>
> TI
Anyone know if there's a trick to using PHP as a shell script and accessing postgres?
I keep getting pg_exec not found yet it works in a browser. I'm using my normal
abstraction class.
All normal filesystem, string, etc functions are available. Just can't get the pg
functions to work.
TIA,
J
Hi Guys,
I am querying my MySQL database with this sql:
$q->ezi_query($db, "SELECT id FROM words WHERE word='$word'");
ezi_query() is just a class - an database layer so the databases can be
swapped.
Then I check the result to see if it worked. But all I get in the result is
Resource id #5 - t
Are you running php3 or php4? 'foreach' was added in php4, which might
explain your error. If you're running php3, try replacing that line with:
while(list($key,$email) = each($emails)) {
I don't know if this works in php3 or not, but would be worth a shot.
Rupert L. Hussey wrote:
> Hi Chris
Don't forget you can just as easily replace the ; with any character you may
be separating the email addresses using (for instance a comma)
Ryan
-Original Message-
From: Chris Hobbs [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 11:16 PM
To: PHP-DB List
Subject: Re: [PHP-DB] C
How about this:
Rupert wrote:
> Ok, this is my issue - hope someone can help. Suppose I also need to get
> this out of the way too - I am a Newbie (god..I hate that word...but it's
> true.grin!)
>
> Anyway, I have a list of email address that I want to dump into a database
> called (new
Ok, this is my issue - hope someone can help. Suppose I also need to get
this out of the way too - I am a Newbie (god..I hate that word...but it's
true.grin!)
Anyway, I have a list of email address that I want to dump into a database
called (news) - eg.
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[
What DB are you trying to use?
Alex
Jonathan Hilgeman wrote:
>
> I'm on a FreeBSD 4.2 box running Apache 1.3.14+OpenSSL with mod_php4
> (4.0.3). I am attempting to set up ODBC for this box, and it's giving me
> problems.
>
> First, I installed unixODBC (www.unixodbc.org), which went fairly smoo
Hi Jack,
The 'black box' you see is a newline, which can be removed by doing this:
$string=str_replace("\n","",$string);
$string=str_replace("\r","",$string);
That will replace \n (The newlines) and \r (The returns) with nothing,
getting rid of your problem. Hope this helps,
-Andy
Jack <[EMAIL PR
You could try returning the whole info with an alias
i.e.
select tbl_job.id AS jobno, tbl_job.name.id, tbl_job.job, tbl_name.* from
tbl_name, tbl_job where tbl_name.id = tbl_job.name_id;
You should then be able to refer to the tbl_job.id as jobno in any $row
function
i.e.
$jobnum=$row['jobno'
Since you're matching on "id", why does it matter which table it came from?
It came from both.
Perhaps, I do not understand your question.
rick
-Original Message-
From: Trevor Lanyon [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 1:13 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
Jonathan,
You should be getting some errors if the odbc_connect is failing - what are
they?
Typical problems include forgetting to set ODBCINI and LD_LIBRARY_PATH
envrionment variables in your script (via putenv(); )
Also, you may wish to use --with-iodbc instead of --with-unixodbc - it comes
wi
I'm on a FreeBSD 4.2 box running Apache 1.3.14+OpenSSL with mod_php4
(4.0.3). I am attempting to set up ODBC for this box, and it's giving me
problems.
First, I installed unixODBC (www.unixodbc.org), which went fairly smooth.
Second, I installed myODBC for UNIX via the ports directory, which also
tbl_job
---
id
name_id
job
tbl_name
id
first
last
SQL
---
select * from tbl_name, tbl_job where tbl_name.id = tbl_job.name_id;
I use mysql_fetch_object to retrieve a row from the above result set. I
have two objects, objName and objJob. The constructor for both objects
accept a r
I use DB2 and I have a Long Varchar field. I need use host variables to
insert.How I make is in php ?
Ex.: (this code not insert datas because descr=long varchar)
$query = "insert into tb_public values ('$cod','$descr','$codr')";
I need a function in php or a mode to declare host variabl
If it fails, and you type 'make' again it will pick up right where it left
off... which means it's bad memory or some other hardware problem usually.
Justin Buist
Trident Technology, Inc.
4700 60th St. SW, Suite 102
Grand Rapids, MI 49512
Ph. 616.554.2700
Fx. 616.554.3331
Mo. 616.291.2612
On Mo
Justin,
Thanks. It appears to happen in the same place each time I try (4 attempts
as its not that quick [about 1 hr each try]).
So should I download a new compiler (is it the gcc++ or if not, what?)?
George
- Original Message -
From: Justin Buist <[EMAIL PROTECTED]>
To: George Pitcher
One of a few things:
- Broken compiler. If it happens in the same place everytime it's
in the software.
- Out of memory. If you made it with something like 'make -j 200'
this is likely. If you only allowed a single g++ process to run with just
'make' this likely isn't the case.
-
If you're getting a literal "" in the file then I'd have to say you're
either typing one in the text box or have your HTML putting on in there
for you w/out knowing it.
If it's a new line or a carriage return in the file that's a different
matter. When somebody submits data to you in a or fiel
phpMyAdmin can do this also. Can dump the data and structure to SQL Statements. The
problem appears if the table for dumping is
100,000 rows or something bigger than the computer can get and start swapping.
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
header("Location: http://new.url.com/index.html"; ); exit;
This MUST be executed BEFORE any other data/html are displayed.
-Original Message-
From: Andrius Jakutis [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 26, 2001 4:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] go to another URL
Use "mysqldump" utility (see MySQL manual, section 14.5)
shell> mysqldump [OPTIONS] database [tables]
ORmysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
ORmysqldump [OPTIONS] --all-databases [OPTIONS]
-Original Message-
From: Andrey Hristov [mailto:[EMAIL PROT
Hi all,
Frustrated by failing compile: This is the message I get:
c++: Internal compiler eror: program cc1plus got fatal signal 15
make[3]: ***[field.o] Error 1
make[3]: Leaving directory '/usr/src/mysql-3.23.37/sql'
make[2]: *** [all-recursive] Error 1
make[2]: Leaving directory '/usr/src/mysql
See:
1)strip_tags
2)fgetss
3)preg_replace('|(<.*?>)(.*?)()|','\2',$string);
Example:
alabala";
$string=preg_replace('|(<.*?>)(.*?)()|','\2',$string);
echo htmlspecialchars($string);
?>
Produces :
alabala
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
99%
- Original Message -
F
Hi!
After upgrade PHP 4.0.4pl1 to version 4.0.6
This script not worked
('TODAY'-24)";
$sth = ibase_query ($db, $stmt,$res);
...
?>
InterBase: Dynamic SQL Error SQL error code = -206 Column unknown TODAY
in ./test.php on line
Not understand, but replace " -> '
("TODAY"-24)';
$sth = ibase_query
Dear all
I'm writing a script which will greb the data from a user input form into a
text file (txt file), but the problem is that when the data had passed to
the txt file, there will be some thing like the and black square appear
inside the file. This is affecting to display the data from that t
Try with
SELECT distinct title,filelocation,filename,ranking,summary
FROM pdf LEFT JOIN searchwords USING(id) LEFT JOIN words USING(id)
WHERE LCASE(words.word) LIKE LCASE('%$searchstr%') ORDER BY ranking DESC;
Have in mind that all text fields in MySQL except with added clause BINARY, or BLOBs
A
34 matches
Mail list logo
