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
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 c
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
value1value2
b
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
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 S
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 int
Add
to your header, which will tell the browser not to cache the page, and use
the POST method
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED
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 softwar
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 PROTECT
"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. pro
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 Mail
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 Mail
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 Mail
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 are
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 Thu,
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)
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 pro
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,
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
#
# set values for Oracle (need to recompile mod_php with Oracle support)
#
export ORACLE_SI
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 PROT
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
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 adminis
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 [mail
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 PR
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, Me
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, Me
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 va
> 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
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 PR
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 w
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
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 (
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 c
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 $music_
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 pro
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 to get the original value, append the new stuff then do UPDATE.
--
Jason Wong ->
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
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
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
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 =
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);] variab
42 matches
Mail list logo
