Hi Alex,
You seem to be struggling with both MySQL and PHP at the same time! Must
be generating high frustration levels. Have you got yourself a
tutorial/book to work from?
I'll go with Mike's suggestion, although I'd go for a 'one stop shop' in
MySQL - as long as we get the required result
hi, is here anyone how haves a solution for following problem:
$SQL = select * from [ReferencesComplete];
$result = mssql_query($SQL,$IDconnection); // this simple code let crash the
php.exe...
i've with a mysql no problems with this code but with MS-SQL comes this
error!!
i hope someone has
hi guys,
i wanna make a news letter as follows:
i sell items within certain categories,so whenever a buyer is registered he choose
some categories to contribute to my newsletter with:
whenever a new item is added within this category i send him an email with that.
i'm storing the mails in
hi,
i try to get some data from our ms-sql-server the following statement:
$SQL = SELECT * FROM [ReferencesComplete];
causes an error of the php.exe! i tried many various of this statement but
nothing helped. ether it came no error and the [$result =
mssql_query($SQL,$IDconnection);]
Hi All.
Thanx Lisi, it worked.
But more to come.
Have modified the code but, cant get the output i want.
$test= preg_replace ($search, $replace, $dokument);
while (list ($key, $val) = each($test)) {
if ($key = 5 || $key == 6) {
//do nothing
} else {
echo $key =
Does anybody know what this warning error means: REG_BADRPT?
Cami
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
basically it means that you have an invalid regular expression pattern in a
regex function.
i think it's something to do with the . * ? + symbols - but just take a good
look at your pattern and somewhere in there it is invalid :)
HTH
Beau
// -Original Message-
// From: Camelia Enderby
I would like to make it so that my helpdesk section can append entries in
their Master Station Log. Update replaces the entryany clues??
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Are there any consideration for a ODBC-Driver, which is able to handle the
return values of stored procedures in PHP?? We´re using the new ODBC driver
for the IBM DB2 which uses unixODBC and it works fine, even with stored
procedures which produce temporary tables.
For stored procedures which
Hi Barry,
Barry Rumsey wrote:
$query_id = mysql_query(INSERT INTO music_album VALUES
(NULL, '$music_artist.id' ,'$album' ,NULL ,NULL));
echo $artist_name and $album has been added to the
Could someone please point out what I'm doing wrong?
is the value of
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
hi guys,
i wanna make a news letter as follows:
i sell items within certain categories,so whenever a buyer is registered he choose
some categories to contribute to my newsletter with:
whenever a new item is added within this
In article 005301c1e6b4$b67afde0$af00a8c0@cami, [EMAIL PROTECTED] says...
Does anybody know what this warning error means: REG_BADRPT?
Cami
Perhaps if you could post the bit of code that causes it?
--
David Robley
Temporary Kiwi!
Quod subigo farinam
--
PHP Database Mailing List
On Wed, 2002-04-17 at 22:54, Miguel Carvalho wrote:
Or if that is not available for you to edit you could always try just
executing a statement to alter the session once a database connection
is established. This method is a little slower.
How slower? Very very slower? Can you give me
Thanks
Jason Wong [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
On Thursday 18 April 2002 16:51, Ron Allen wrote:
I would like to make it so that my helpdesk section can append entries
in
their Master Station Log. Update replaces the entryany clues??
You would have
Thanks David,
I have sorted it. I was reading the reg expresion from a database and
somebody added to the database something that I didn't make provisions for.
Took me a while to see what was wrong.
Thanks again.
- Original Message -
From: David Robley [EMAIL PROTECTED]
To: [EMAIL
The speed decrease is dependant on your setup. How fast your machines
are and how good your network is. I ran a few quick tests on our
servers and there seemed to be little effect on performance. The loss
of
performance was unmeasurable.
I see that it's a minor issue.
I'm not sure on
I am not sure if this is possible.
I have a database, and we fetch all the records and then list them.
What we need is the one field in the database to be able to be updated.
Now the field will have different values for each record. Is it possible to update
the table with lots of different
Hello,
Sp wrote:
Can someone with database expertise who has used metabase and adodb cut
through this rhetoric and give an objective view of these two packages.
From what I got from this convo is that metabase is slower but more portable
but adodb is faster but not as portable.
No,
Hello,
Sp wrote:
Can someone with database expertise who has used metabase and adodb cut
through this rhetoric and give an objective view of these two packages.
From what I got from this convo is that metabase is slower but more portable
but adodb is faster but not as portable.
No,
Hi Manuel, I still don't see a problem in others telling their experiences
with certain packages. If someone has just used metabase or has just used
adodb then I would like to hear how easy/hard it was to port to another
database.
-Original Message-
From: Manuel Lemos [mailto:[EMAIL
Barry,
All I saw was $artist_name variable that will be passed thru the form.. Can
you do a
echo $music_artist.id to see if it has a value ..
And you still need to get rid of $query_id = in the line that you are
trying to do insert.
Gurhan
-Original Message-
From: Barry Rumsey
Hey.
I am making a system to publish newsarticles, send newsletter and 12 -
14 other functions/modules.
I've been working on it for almost two years, therefore some of the code
is pretty old.
Now, I want to create a set of tables controlling what is beeing
displayed in the site's menu and
Not sure if you're asking whether you can append info onto the end of a
database field without having to get the previous information, but you can.
UPDATE table SET MyField=CONCAT(MyField,'Appended Text') WHERE Some_ID=5;
That would update the row identified by Some_ID = 5, and append Appended
Ron,
Are we talking about appending new values to the database tables? If yes,
you need to use INSERT INTO ... VALUES syntax ...
If you mean to append the new values to a file , then you need to open the
file in a mode.
Gurhan
-Original Message-
From: Ron Allen [mailto:[EMAIL
HI,
I use SuSE.6.4 with Ora.8.1.6/PHP.4.0.6.
For a while, it used to be PHP/4.1.2, but I reverted to PHP/4.0.6
because of other non-Ora related problems.
/etc/rc.d/apache startup script extract below
extract
#
# set values for Oracle (need to recompile mod_php with Oracle support)
#
export
Hi,
How can I import/Export data to MySQL database using PHP following formats:
EDI, Access, Excel ?
Where can I find information about this ?
Thanks,
Rosen Marinov
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi there,
I am still struggling with following problem:
There are two tables in mysql
1. city fields: ID, countryid, provinceid, city
containing 2.5 million entries.
2. province fields: ID, countryid, provinceid, provincename
Now there are some cities without a valid
I have a field in one of my tables called when, which is type timestamp.
I'm trying to use some of the date functions to get data from it, but it's
not working. The return from mysql_error() is not helpful. Any ideas?
Here's my query:
$query = mysql_query(select month(when) as month,year(when)
see http://www.mysql.com/doc/R/e/Reserved_words.html
Your column called 'when' is a reserved word.
Thats my first guess at your problem. I've come across this before with
MySQL accepting column names that are reserved words. Try changing the
column name to something else and try again.
On
It worked, thanks alot!
on 4/18/02 1:43 PM, Paul Edmondson at [EMAIL PROTECTED] wrote:
see http://www.mysql.com/doc/R/e/Reserved_words.html
Your column called 'when' is a reserved word.
Thats my first guess at your problem. I've come across this before with
MySQL accepting column names that
Hi to all,
I have form that users fill out and submit. What I'm trying to do is not to
let users to go back to the form after they have submmited, or if they go
bak, make the page expires.
Can someone please tell me or give an idea on how to do it?
Thanks in advanced
Nato
--
PHP Database
http://php.sitecreative.com/faq.php
-Original Message-
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 17, 2002 6:12 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] page expires
Hi to all,
I have form that users fill out and submit. What I'm trying to do is not to
Hi to all,
I have form that users fill out and submit. What I'm trying to do is not to
let users to go back to the form after they have submmited, or if they go
bak, make the page expires.
Can someone please tell me or give an idea on how to do it?
Thanks in advanced
Nato
--
PHP Database
Hi to all,
I have form that users fill out and submit. What I'm trying to do is not to
let users to go back to the form after they have submmited, or if they go
bak, make the page expires.
Can someone please tell me or give an idea on how to do it?
Thanks in advanced
Nato
--
PHP Database
Andy [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
I am still struggling with following problem:
There are two tables in mysql
1. city fields: ID, countryid, provinceid, city
containing 2.5 million entries.
2. province
Yes I see what I have done wrong. I named it music_artist instead of
nameing it music_artist.id
Sorry about that but thanks for the help. I think I'll need more help as
I'm still learning.
-Original Message-
From: Christian Schneider [EMAIL PROTECTED]
To: Barry Rumsey [EMAIL
Hi
The most universal way would be to export the table to CSV format. You can
then use
LOAD DATA INFILE phpMyAdmin to load it into the database.
http://www.mysql.com/doc/L/O/LOAD_DATA.html
HTH
Peter
---
Excellence in internet and open source
Add
META HTTP-EQUIV=expires CONTENT=0
META HTTP-EQUIV=Pragma CONTENT=no-cache
to your header, which will tell the browser not to cache the page, and use
the POST method
form action=script.php name=entryform method=post
HTH
Peter
---
Excellence in
IF there is a formula for the value of quantity eg Quantity = Quantity -1
(UPDATE table SET Quantity = Quantity-1 ) you need to do an update statement
for each row
EG UPDATE table SET Quantity = 9 WHERE Field = Book3
HTH
Peter
---
Excellence in
Dont think it made sense last time (too little coffee, too much work!)
try again
IF there is a formula for the value of quantity eg Quantity = Quantity -1
(UPDATE table SET Quantity = Quantity-1 )
IF there is no formual you need to do an update statement
for each row
EG
UPDATE table
there might even be some cool SQL you can use tho, which would avoid having
to get the data out and then put it back in again.
I *think* (don't quote me on this) I remeber seeing something like
UPDATE myTable SET myField = CONCAT(myField + 'new string of stuff here')
WHERE myID='1'
HTH
beau
mysql - Excel
what I do very often an what really works great is (escpecially when
customers need some download feature for db data for word/mail/excel
processing and have no sql/phpMyAdmin knowledge)
build a html data table using php:
// file download_table.php
table
?php while (...) ?
tr
I have simple db wik names, links and short (less then 1000 chars)
descriptions. I do offer a search (with the select like %variable%
method) but it seems to be very dumb, on single phrases it goes fine on
combined it it very bad.
Is there a way (link, advice) to spicy it up a bit so the user
hi
do you use OR and AND ?
select * from table where pasta like %spagetti% or pasta like
%macaroni%
?
eat pasta type fasta a écrit :
I have simple db wik names, links and short (less then 1000 chars)
descriptions. I do offer a search (with the select like %variable%
method) but it seems
44 matches
Mail list logo