I've always used pconnect.
- Original Message -
From: "Steven Roussey" <[EMAIL PROTECTED]>
To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "'Mysql'" <[EMAIL PROTECTED]>
Sent: Friday, September 20, 2002 2:38 AM
Subject: RE: MySQL errors in newer PHP 4.2.3
> Hmm, do y
Hmm, do you use pconnect or connect?
I noticed someone changed our PHP script to use persistent connections
(likely why the server is running slower). I am wondering if a cancelled
connection is being reused or if it just is a more general bug in the
mysql client code in PHP
Sincerely,
Stev
") or
die (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
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 que
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
function mysql_one_element($query, $element) {
// quickly returns just one element from a query
$one=mysql_query($query);
// add error checking here if you wish
$r=mysql_fetch_array($one);
$thisvalue=$r[$element];
return($thisvalue);
}
$row=mysql_one_element("select euro from brandsto
try to:
var_dump($row[24])
and see what happens?
it might be that the "Y" is stored as lowercase in MySql's table.
Elias
"David Banning" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> if I set test = "Y";
> then
>
> if ($test == "Y") {echo ("it matches");}
>
>
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.
> Th
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 la
>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:
In other words, you can *NEVER* "go backwards" from the password() function
output to
kt_key = '$produkt_key'";
hope it helps someone out ;o)
Schura
- Original Message -
From: "Tim Stoop" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 14, 2002 11:00 PM
Subject: [PHP] Re: mysql statement (still a semi newbie)
> Ale
Message-
> 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
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
--
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'
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
>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
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/transfe
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
>>
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."
>
>>>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 sho
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 equivale
>>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.
>http://php.net/error_log
>
>>would much rather pump the clf formatted log sting directly into the
>appropriate
>>apache log,
>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
>
>>>I want to be able to view a single log that contains the following:
>
>>
>>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 sti
QL. You'll 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: R
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 specifical
>>I want to be able to view a single log that contains the following:
>
>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 Apache's l
>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
> 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
> Titl
>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 n
>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?
>
Cal Evans
* 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@jcow
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
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'l
> 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: http://www.p
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
> >
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 bla
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 New
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 be
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!
>
>
>
> $host="localhost";
> $us
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
> (havi
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.
just 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
mu
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
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
i
[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, RecordDat
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} mysqldump -d mydb subscribers >subscribers.sql
** edit the "subscr
ss www.chessish.com <http://www.chessish.com>
--
From: Erik Price [SMTP:[EMAIL PROTECTED]]
Sent: 10 April 2002 15:00
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Re: mysql
...
Someone did suggest that you use an if statement, however
On Wednesday, April 10, 2002, at 07:45 AM, David Robley wrote:
>> 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 query examples on th
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. Ha
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 sel
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
> anythi
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 ha
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
>
>
> "Robe
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
What MySQL version do you have?
--
-
Cirstoiu Aurel Sorin
Interakt Online Support
http://www.interakt.ro/
"Roman Duriancik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have problem with backup and restore database in mysql.
>
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
ht
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
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
--
P
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,
> $
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
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:
>
> /home/chi
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))
> {
> ?
Get hold of phpmyadmin - it makes MySQL easier!
Are you logging on to MySQL as root from the computer on which mysql is
running and are you supplying a password? Even if the root password is
blank you still need to enter the password as blank I think!
"Roman Duriancik" <[EMAIL PROTECTED]> wrot
$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
>
> mysql_connect("localhost"
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 get
In article , [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 Fatal error: Call to undefined f
[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 objec
Greg Conway wrote:
> Hi all,
> 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 ins
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 Schw
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
[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,
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 a
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 um...
try
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
right folder etc and
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]
250.744
t
> on that?
>
> otherwise you'll have to use php
>
> -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: MySQ
EMAIL PROTECTED]
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
On Tue, 4 Dec 2001 11:46, René Fournier wrote:
> 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 s
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:
-
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,
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
criteria.
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 sheets.
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
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
>
>
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 t
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:
http:
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]>
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, o
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 di
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 dis
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
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: http://chatmusic.com/vol
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 PROTECTED]">ne
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=logreport&id=10282302
>
>I assume you mean PHP 4.06?
>
>--
>Billy Cravens
>
>-Original Message-
>From: Ben Edwards [mailto:[EMAIL P
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 MyS
:) 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
> 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'"
201 - 300 of 320 matches
Mail list logo
