Look into the LIMIT command, it will limit the number of rows in the result
set to the number you specify
-Original Message-
From: bill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 7:10 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: mysql query
function mysql_one_element
Ooops, for clarity, I shouldn't have named the result of the function row but
euro. It should be:
$euro=mysql_one_element(select euro from brandstofprijzen where id=2, euro);
Bill wrote:
function mysql_one_element($query, $element) {
// quickly returns just one element from a query
(mysql_error());
$row=mysql_fetch_array($result);
$euro =$row[0];
-Original Message-
From: bill [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 7:50 AM
To: David Buerer
Subject: Re: [PHP] Re: mysql query
Maybe I wasn't clear. The value returned should be called euro
Have you tried single quotes ' '?
David Banning [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
if I set test = Y;
then
if ($test == Y) {echo (it matches);}
seems to work while
if ($row[24] == Y) {echo (it matches);}
does not.
The row[24] mysql variable
cheers
Richard Lynch [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
If I insert a row's field's value using the PASSWORD() function, will I
need
to use it or another function to find that row using the same field?
You'll need to do this when somebody tries to log in later:
If I insert a row's field's value using the PASSWORD() function, will I need
to use it or another function to find that row using the same field?
You'll need to do this when somebody tries to log in later:
?php
$username = $_POST['username']; # Or $PHP_AUTH_USER or $_GET['username']
or ...
Alexander Ross wrote:
That first column is an auto_incrementing column so i don't want any data
INSERT INTO cast VALUES(DEFAULT, 'Rick', 'Blaine', 'Humphrey', 'Bogart',
'male');
I think you need to use NULL instead of DEFAULT... I'm not 100% sure. Just
try it :)
--
Kind regards,
Tim
--
-
From: Tim Stoop [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 6:00 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: mysql statement (still a semi newbie)
Alexander Ross wrote:
That first column is an auto_incrementing column so i don't want any
data
INSERT INTO cast VALUES
: Wednesday, August 14, 2002 11:00 PM
Subject: [PHP] Re: mysql statement (still a semi newbie)
Alexander Ross wrote:
That first column is an auto_incrementing column so i don't want any
data
INSERT INTO cast VALUES(DEFAULT, 'Rick', 'Blaine', 'Humphrey', 'Bogart',
'male');
I think you need
Well, you can do something like:
SELECT * FROM tablename
ORDER BY fieldname [ASC|DESC]
= [ASC|DESC] optional, put either of theses without the brackets.
//Elias.
Joel Colombo [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
This is a mysql question, cause i
To my knowledge it isn't possible to decrypt the PASSWORD function in
MySQL (you need to use MySQL ENCRYPT/DECRYPT for that). However, it's
possible to use PASSWORD on the user-provided string too. You could try
the following code:
$query=SELECT * FROM users where username='$PHP_AUTH_USER'
Christian Calloway em Friday 26 July 2002 17:30 foi agraciado com uma
resposta por:
Sorry this may be a little offtopic, but I am currently moving a site I
was developing from coldfusion+MSAccess to PHP+MySQL. I remembered reading
somewhere that there is a utility that will convert/transfer
Hello, I am stuck here. In the name of efficiency I want to lower the number
of callls to the database. So I am trying to give the most stringent query
possible. This is the problem: I have stored the surfers shopping cart,
where each item is stored as a session variable.Now on the database I
clipped
how about this curve... getting PHP to append a line to the apache log.
How about reading the documentation?
Deserved that for not being clear enough... see below.
My apologies if I missed the word access log or even assumed you meant
error log when you just said log.I shouldn't
Well, I think the solutions or ideas are maybe a bit too involved.
I was hoping that the errors I am interested in were already logged by
default to some obscure location, and I *could* if needed just go and
scrutinize them by hand.
But, it seems like a detailed (specially mysql) error log does
Thanks, but all these methods require modification of the scripts
already on the server, and it won't ensure any new script being written
by a user on my system to comply.
Are you all saying that there are no logs kept by default of errors
generated on php/mysql pages at all unless
still have the
problem of identifying which PHP page caused the MySQL error, though...
---John Holmes...
-Original Message-
From: PHPCoder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 2:23 AM
To: Richard Lynch
Cc: php-general
Subject: Re: [PHP] Re: MySQL - PHP combined log
clip
I want to be able to view a single log that contains the following:
clip
http://php.net/error_log
how about this curve... getting PHP to append a line to the apache log.
How about reading the documentation?
http://php.net/error_log
would much rather pump the clf formatted log sting
Thanks, but all these methods require modification of the scripts
already on the server, and it won't ensure any new script being written
by a user on my system to comply.
That is correct.
Are you all saying that there are no logs kept by default of errors
generated on php/mysql pages at all
update mytable set email = CONCAT(email,'[EMAIL PROTECTED]');
On Wed, 24 Jul 2002 11:00:48 +1200, Jason Morehouse wrote:
update mytable set email = CONCAT(email,'[EMAIL PROTECTED]');
On Wed, 24 Jul 2002 02:59:54 +1200, Shane wrote:
Greetings, is there a mySQL syntax command equivalent to
clipped
how about this curve... getting PHP to append a line to the apache log.
How about reading the documentation?
Deserved that for not being clear enough... see below.
My apologies if I missed the word access log or even assumed you meant
error log when you just said log.I shouldn't
Hi, tried this on mysql list, no luck:
I want to be able to view a single log that contains the following:
IP of user : page_name (PHP only): time/date: MySQL query ( 'select *
from xxx' etc.) : error msg from mysql/php if any
So it's almost a hybrid between apache and mysql with some extra's
clip
I want to be able to view a single log that contains the following:
clip
http://php.net/error_log
how about this curve... getting PHP to append a line to the apache log.
Currently we are exporting via fopen clf formatted logs for file uploads (whose
file sizes are not recorded by
Hi, i am writing a news management system in PHP, with comments, etc, and
i am wondering if theres a better way of structuring the tables to increase
speed and stability.
This is how i am structuring my tables:
Table 1 (news)
--
ID
Date
Author
Title
News
Hi, I installed php and mysql today and I'm trying to use phpMyAdmin but
I'm receiving the error message:
cannot load MySQL extension,
please check PHP Configuration.
I checked the php.ini and couldn't find anything related, my configure
command says '--with-mysql=shared,/usr' and I have no idea
In article 00e001c21db3$7b1b66a0$0a01a8c0@jcowart , [EMAIL PROTECTED]
(Jefferson Cowart) wrote:
Is there any way to return all the rows returned by a mysql query with
one command. Currently I have to run through a for or while loop the
same number of times as there are rows and take that row and
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Richard Lynch [mailto:[EMAIL PROTECTED]]
Sent: Sunday, June 30, 2002 5:41 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL fetch data
In article 00e001c21db3$7b1b66a0$0a01a8c0@jcowart , [EMAIL PROTECTED
Checked the archive and saw no difinitives... so... How come when I query
my clients mySQL DB and use NULL or NOW() as my default in a TIMESTAMP
record that it always comes up Jan 18, 2038?
Is the clock not set properly, or am I misunderstanding some basic
principal of the time stamp?
My
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I am using PHP and MySQL on a 2k dev box to be uploaded to a linux box
I have a piece of SQL
INSERT INTO `contracts` (`key`, `content`) VALUES (1,'blah blah blah
character 39 is a single speach mark '+CHAR(39)+' blah blah blah')
I just preg_replace(/\'/,\',$text) and all was good :o)
David Robley [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I am using PHP and MySQL on a 2k dev box to be uploaded to a linux box
I have a
I just preg_replace(/\'/,\',$text) and all was good :o)
That's what addslashes() is for. It handles single and double quotes,
backslashes, and nulls, so you won't have any problems...
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Wednesday, June 26, 2002, at 08:58 AM, John Holmes wrote:
I just preg_replace(/\'/,\',$text) and all was good :o)
That's what addslashes() is for. It handles single and double quotes,
backslashes, and nulls, so you won't have any problems...
Plus IIRC it's a C extension so it'll run
why don't you do a quick fix and just add addslashes again if obviously
there is no escap slash present right now?
Good luck,
Andy
--
http://www.globosapiens.net
Global Travellers Network!
David McInnis [EMAIL PROTECTED] schrieb im
not on auto increment...thats the point!
why would you need to get the #6 back anyway...
this is the fundementals of database theory... chances are the database is
using this autoincrement field as the PRIMARY KEY...in which case no
duplicates are allowed..
In terms of records...your id#7 has
also try to:
echo mysql_error();
after the select-query, it will tell you what went wrong.
Thomas
On Fri, 17 May 2002 18:45:07 +0100
[EMAIL PROTECTED] (Randum Ian) wrote:
Hi all,
I have got this code but I can get it to work, it doesnt make sense!
snip
?php
$host=localhost;
Try MysqlAdmin!!
Amit Singh [EMAIL PROTECTED] schreef in bericht
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi Folks,
I m trying to export data from mysql using 'SELECT * INTO
OUTFILE...' query into a '.csv' file.
It does happen successfully but I don't get the field values
(having
as reading from the file,
it'sjust open file, read file, close file, a lot
quicker.-Original Message-From: David Duong
[mailto:[EMAIL PROTECTED]]Sent: Monday, May 13, 2002 10:46 AMTo:
[EMAIL PROTECTED]Subject:
[PHP] Re: MySQL or FlatFileI am referring to whole PHP/Perl
files. It is necessary
I am referring to whole PHP/Perl files. It is necessary to load them as
much as 20+ times within the same hour what would be better MySql or
Flatfile?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
open file, read file, close file, a lot quicker.
-Original Message-
From: David Duong [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL or FlatFile
I am referring to whole PHP/Perl files. It is necessary to load them as
much
David Duong wrote:
To store large values (100k+) and load them as much as 6+ times within the
same hour what would be better MySql or Flatfile?
I think it really depends on the content. If you are storing 100K+ per
entry it sounds like it is probably something along the lines of an
[snip]
/path/to/php_to_excel.php/excel.xls
[/snip]
OK, that solves that problem and is easy to implement. The problem I have
now is creating pivot tables from the information. I'll use my previous
example;
SELECT RecordID, RecordDate, count(*) AS Quantity
FROM tblFOO
Group By RecordID,
Got it figured out --
To export table structure:
C: mysqldump -d {database name} {tables} sqltextfile.sql
Then to import the new Table Structure:
To import table structure / data
C: mysql {database name} sqltextfile.sql
Just a note: If you want to copy the structure of an
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I was just wondering if there was a way to connect to a MySQL server on a
server other than the one that your php script is on. I tried just putting
in the URL of the site in place of localhost but that didn't work. Is there
anything
In article 002401c1e10d$96850910$e700a8c0@horizon,
[EMAIL PROTECTED] says...
Hi guys,
I've been looking on the net and the php docs for a simple
mysql query solution, can someone please let me know
the best way to get the values of a query that only returns 1 record?
All the select
Dave,
Did you use the URL:
http://www.domain.com
Or did you use the fully-qualified domain name (FQDN):
www.domain.com
For connecting to the MySQL server, the connection functions expect an FQDN, not
a URL. But, you may already know that. Just checking.
Regards,
Barry C.
Hello,
You can just put disable_functions=mysql_pconnect in php.ini file.
--
Kind regards,
Yuri.
www.AceHoster.com Quality web hosting
Robert Abbate [EMAIL PROTECTED] ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi. I'm trying to disable persistent
You used first single quote and then double quote.
Replace
backup table table_name to '/var/lib/_backup/''
with
backup table table_name to '/var/lib/_backup/'
This should work.
Please let me know if that helped you.
--
-
Cirstoiu Aurel Sorin
Interakt Online Support
version of mysql is : 3.23.36 on linux redhat 7.0
-Original Message-
From: Cirstoiu Aurel Sorin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:50 PM
To: Roman Duriancik
Subject: Re: [PHP] Re: mysql
What MySQL version do you have installed
Excellent Man! Worked great.
Yuri Petro [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello,
You can just put disable_functions=mysql_pconnect in php.ini file.
--
Kind regards,
Yuri.
www.AceHoster.com Quality web hosting
Robert Abbate [EMAIL
On Tuesday 09 April 2002 20:23, Cirstoiu Aurel Sorin wrote:
You used first single quote and then double quote.
Replace
backup table table_name to '/var/lib/_backup/''
with
backup table table_name to '/var/lib/_backup/'
This should work.
Please let me know if that helped you.
This has
You can use an id field in your table structure that is set to auto
increment for each entry into database then just do a query on the id number
you wish to view... of course this would mean that you would need to create
a new field on your table but that should get you what you need.
Jas
--
In article [EMAIL PROTECTED], Phil Schwarzmann wrote:
$query = UPDATE table SET (var1, var2, var3) VALUES ($var1, $var2,
$var3) WHERE username='$username';
Im wondering cause I have an INSERT query
$query = INSERT INTO table (var1, var2, var3) VALUES ($var1, $var2,
$var);
Jason Whitaker wrote:
OK, I need to know is there a place where i can find out how to pull
information(TEXT) from a MySQL DB table and print where i place a variable
in a php page?
I have NO idea what your question is did you just want to echo something
from your MySQL db table inside a PHP
Hmm, I'm assuming you're paying someone to host your site? Can't you give
the hosting company a quick call or e-mail re: whether or not they offer
MySQL? They would probably know better than we would. ;)
-Andy
Thanks for the advice... But now I need to know what all this means:
Keep track of rows, and add images at rows 4 8. See below
Craig Westerman wrote:
The following lists 12 items from a fruits table.
$results = mysql_query(SELECT ID, date, appleprice, orangeprice, pearprice
FROM fruits);
$x=1;
while ($data = mysql_fetch_array($results))
{
?
$date = date (Y-m-d); #works?
:)
Jtjohnston wrote:
In MySQL, I have a date field that is formatted 000-00-00 Is there a
function in PHP I did not find yet that does this?
John
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Give us the exact error message, that probably will hold the answer.
Mike Frazer
Uma Shankari T. [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello,
I am trying to connect php and mysql with the following syntax
In article 013001c1aa20$d7db8d90$[EMAIL PROTECTED],
[EMAIL PROTECTED] says...
bleh, its not working
I'll take another approach,
If I use a count(*) query, it will return 1 record with a value, possibly 0.
what command can I use to grab it from $result ?
If you are still getting an
In article Pine.LNX.4.21.0201291202160.2265-
[EMAIL PROTECTED], [EMAIL PROTECTED] says...
Hello,
I have installed php3 in my system.I want to connect with mysql.I have
given this code
$link=mysql_connect(localhost,username,password) or die(could not
connect);
but it is giving
[EMAIL PROTECTED] wrote:
Hi everybody
I'm not sure it is the best place for my question.
Until now we were using PHP connecting to an oracle database. We are
looking to change for an opensource database for the new applications.
Do you know where I can find a recent and objective
Greg Conway wrote:
Hi all,
snip
So, my question is, how can I tell if PHP has been compiled with
MySQL support or not, and if not, how can I add it in without
breaking whatever's already there!! I presume PHP will be an RPM
(or even a .PKG?), so can I specify these options within RPM
Let's say you have this table, pseudo-coded:
TABLE table
tableid int auto_increment,
value text
;
You could run this query on it:
insert into table values ('','value');
And the id will be auto generated. Same would apply with:
inert into table (value) values ('value');
Mike
Phil
Does your query have a semicolon in it when you run it in PHP? Or did you
paste the below from a mysql session?
-p
On Thu, 17 Jan 2002, Brandon Orther wrote:
Hello,
I am trying to use mysql through php. When I try to run the following
query it does nothing. I am trying to figure out if
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 18, 2001 6:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL Native Function in PHP Query Not Working?
that command doesnt even work from the mysql command prompt for me, Ive
never used LAST_INSERT_ID(), but it dont work for me. try it on your
that command doesnt even work from the mysql command prompt for me, Ive
never used LAST_INSERT_ID(), but it dont work for me. try it on your mysql
command prompt.
--
Chris Lee
[EMAIL PROTECTED]
Ise [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello,
try
?PHP
phpinfo();
?
to see if there's any clues in there
make sure the mysql daemon is running (not sure how to do this)
see if you can connect using the MySQL client (not PHP). If you can then
MySQL is running ok
It sounds like the mysql exetension is damaged of missing. Check its in the
Maybe I'm reading your question wrong, but what you are asking isn't
possible and more importantly doesn't make sense.
I think you're thinking of a database table as you'd think about say an
excel worksheet (in that it's ordered). tables aren't ordered in that
way. Think about a table as
I figured out my question was a little illogical, I figured out how to get
what I needed with an insert and update statement. Thanks for those that
responded.
» Michael Krisher
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Greg,
You must specify the tablename :)
Like this:
UPDATE myTableName ...
or
mysql UPDATE persondata SET age=age+1;
For the official syntax visit mysql language reference at http://www.mysql.com at
http://www.mysql.com/doc/U/P/UPDATE.html
Kind Regards,
Richard Creech
[EMAIL PROTECTED]
SELECT * FROM mytable ORDER BY series,price;
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 03, 2001 4:27 PM
To: [EMAIL PROTECTED]
Subject: MySQL ORDER BY or PHP Sort?
I want to select about 25 rows from a table, and sort them by two
Don't forget LIMIT 0,25 (I want to select about 25 rows from a table...)
SELECT * FROM mytable ORDER BY series,price LIMIT 0,25
Mike
Rick Emery wrote:
SELECT * FROM mytable ORDER BY series,price;
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Monday,
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001 06:11:23 PM US/Mountain
To: Benjamin Pflugmann [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: MySQL ORDER BY or PHP Sort? Oops.
Here is the snippet of code that is presenting a challenge:
]
Subject: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001 06:11:23 PM US/Mountain
To: Benjamin Pflugmann [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: MySQL ORDER BY or PHP Sort? Oops.
Here is the snippet of code
-Original Message-
From: René Fournier [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 04, 2001 12:16 PM
To: Benjamin Pflugmann; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL ORDER BY or PHP Sort? Oops.
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001
What type of Excel file are you using? I'm assuming that you are using tab
or comma delimited files. These text or CSV files do not support multiple
sheets, and in fact do not support cell formatting or any of a number of
excel functions. Only native Excel files (*.xls) support mutliple
put the mysql_db_query in an if() statement, more likley then not your
select statement isnt returning any results.
--
Chris Lee
[EMAIL PROTECTED]
Sc [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi;
i keep getting an error of: Warning: Supplied
Hi!
Job Miller wrote in message
[EMAIL PROTECTED]...
yes, thank you though.
not in MyISAM tables, which is what mine are, and
again according the manual, you slow things down
significantly for transaction support.
Transactional InnoDB tables are actually faster in many
simple benchmarks than
I've found the best way is to set up a MyODBC link. You can download
MyODBC from http://mysql.com/downloads/api-myodbc.html
It's a bit complicated, but you get excellent results!
- Nikhil
Roman wrote:
Please help me, how to export mysql table to the xls table ?
Thanks for all
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Job Miller) wrote:
without save points and rollback what is the best way
to replace all records for a user that might have been
edited with their new values.
To clarify: are you aware that MySQL does have transaction support
available, or is
yes, thank you though.
not in MyISAM tables, which is what mine are, and
again according the manual, you slow things down
significantly for transaction support.
is it worth it? instead of my previously suggested
method of handling it? or is there something better?
--- CC Zona [EMAIL PROTECTED]
Try using a LEFT JOIN against the second table, returning only records with
no match.
Something like:
SELECT DISTINCT A.username
FROM user A LEFT JOIN task_assignment B
ON (A.username = B.username)
WHERE B.username IS NULL;
See JOIN syntax in MySQL documentation for more information:
On Wed, Oct 03, 2001 at 07:56:12AM -0600, System Administrator a.k.a. The Root of the
Problem wrote:
I will be forward this to [EMAIL PROTECTED] and hope that an answer could be
there.
On Wed, Oct 03, 2001 at 09:24:37AM -0400, Justin Hall wrote:
Dave:
We are getting closer to a
Tom: if you need to weed out duplicates you may try knowing which entries
duplicate themselves and how many times they are duplicated, why don't you
try.
SELECT seminar_name COUNT(*)
FROM student_table GROUP BY seminar_name
This will return the seminar_name field plus a COUNT field that will
Distinct is just a group by on all columns, so either of the queries
you showed should be pretty much the same. The difference
between the two shows up when you have multiple columns in
your select. ie
Select distinct id,name from table1;
and
Select id,name from table1 group by name;
do two
Depends on what you want to do.
For pumping out large amounts of data, it's a great tool. For forums and
simple content management, it works fine for most web sites. For handling
complex database transactions, not really.
Devin Pittman [EMAIL PROTECTED] wrote in message
[EMAIL
I've never heard of select distinct not working...
Is that the exact SQL you are using?
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time:
4.0.6, yes, douse this mean you have a possible solution -:)
At 06:54 A 23/09/01 , you wrote:
SpamCop - Report spam:
http://members.spamcop.net/mcgi?action=logreportid=10282302
I assume you mean PHP 4.06?
--
Billy Cravens
-Original Message-
From: Ben Edwards [mailto:[EMAIL PROTECTED]]
It would help if you gave us some more information. If you look in your
MySQL folder you will see a folder call include. In that folder there is
file call mysqld_error.h, this a list of some of the errors you will
encounter. This will help you track down the problems you are having, in
the
mysql_quory($Query);
typos
i can't also see more errors...
Niklas lampén [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Code:
?
$Query = UPDATE feRegUsers SET Constructor='2001-09-17',
Enertec='2001-09-17', Seatec='2001-09-17' WHERE ID LIKE '288';
:) It just started to work. World's a strange place. Maybe someone was doing
something to the server/php/mysql, dunno.
Niklas
-Original Message-
From: _lallous [mailto:[EMAIL PROTECTED]]
Sent: 17. syyskuuta 2001 15:03
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL query error
A create SQL statement is just an SQL statement.
Send it the same way you would send Select
You'll have to have the permissions set up right, so use mysql_error() until
you figure out what's going on.
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna
The timestamp data type is a special MySQL type that automatically updates
whenever you add or update a row in a table.
If you want timestamp to work when you add a row but not when you update a
row, you need to write your update statements like this:
UPDATE tbl_name SET vartochange=newvalue,
Nope,
MySql doesn't allow select within select...
try making two seperate queries...
Lizlynch [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
i have two tables here, i want to insert the customername from the Username
table and insert it into the Classification
You cant use a select statement withoug using a table name.
check out this
$query = insert into classification(customername) (select customername from username
where username='$username');
i cant answer ur second question, since i dont the
structure of your table
/sagar
original message
You cant use a select statement withoug using a table name.
check out this
$query = insert into classification(customername) (select customername
from username where username='$username');
Incorrect in mySQL you can do
mysql select 3+5;
returns 8
plus a whole lot of other functions that can
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Niklas lampén) wrote:
Can it cause any problems if mySQL query is very long? I have to compare
many words to many fields in my DB and I've done it like
Field LIKE '%searchword%' || Field LIKE '%searchword%' || Field LIKE
Hi Niklas,
You can use || or OR.
Secondly, huge list of values you say? Can this list be exploded by a
common denominator, like a space or comma? If so, consider this:
$list = // Huge list of words (array), separated by a comma.
$words = explode(,, $list);
$query = SELECT * FROM table WHERE
This would probably be a better question for a MySQL newsgroup...
Anyway, I am just talking off the top of myhead since I never did
anything like this, but i don't think copying DB files is the proper way
to move databases. I believe there is some MySQL dump utility you need
to create one
It depends... if you have a handful of records, you might start with a flat
file. but if you think you'll get to hundreds of records, go with a
database.
Even if all you want is a small array of data, go with a database.
If all you want is a simple array, you might consider use DBM files (Look
, and by the way, the only software writing experience I've had, was a
course in BASIC 23 years ago. Good luck.
- Original Message -
From: Emilio Panighetti [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 18, 2001 2:06 PM
Subject: [PHP] Re: MySql or flat database using PHP
201 - 300 of 308 matches
Mail list logo