Hi,
First mysql_fetch_row() returns an array so it doesn't make much sense to
compare it to 5. If you want to check tne number of records the query has
returned you should use mysql_num_rows() - like this
if(mysql_num_rows($result)=5){ }
or if you want to check the value returned by the query
Ah
I did not know that. Excellent.
Still does not get round the issue that MySQL in most default binary
distributions does not include SSL. Which I think is a shame, but then
again is probably a lib issue.
Thanks for that.
Greg
-Original Message-
From: Eamon Daly [mailto:[EMAIL
First let me say thank you for all the responses.
Now, let me say I'm not sure what exactly I need to
do. Explanation - Primarily I have absolutely no
experience with PHP , but I can learn, so that's
helpful :)
The thing I'm trying to figure out is what I need to
learn, because currently I'm
Having duplicates is not a problem.
As long as you don't have a UNIQUE index on it.
Something else is happening in your code that is putting out the HTML I
would guess.
P.S. It should be SELECT * FROM jspCart_products;
(your table, not your database)
B Wiley Snyder wrote:
Hello, hope this is
Right, I am not on any list for a line by line feed /
analysis. Actually I tried signing up twice yesterday
for the PHP general and never received email
confirmation. Anyway sure I'll find my way !
Thank you
Stuart
--- [EMAIL PROTECTED] wrote:
i would suggest that your questions would be more
- Original Message -
From: B Wiley Snyder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 1:56 AM
Subject: mySQL beginner question
Hello, hope this is the right list
I created a table with the following code
CREATE TABLE jspCart_products (
ProductID
I'm gathering by the lack of response that perhaps MySQL is incapable of executing a
count of the number of fulltext matches on 3 million rows.
I really thought that MySQL 4 was really suppose to be able to handle such a load
I still think my configuration may be to blame
?
- John
MySQL Administrator 1.0.11 has been released.
MySQL Administrator is a GUI management console for MySQL, with support
for tasks such as managing users, configuring MySQL, performing backups,
editing table definitions etc.
More information at:
At 02:36 PM 8/25/2004, you wrote:
Or maybe just bad practice. Thought before I go any
further I'll ask.
I have a few static tables that list out items and
the primary key is an assigned ID. Meaning I did
not set auto-increment. As I add items I will add the
associated ID number.
Now to the
I actually did make the switch to mnemonics (as
suggested by Rhino) I've gone slightly beyond 2
letters though due to the fact that some of my labels
might be more then confusing. I've tried to stick with
3 letters on average. It does seem like a better way
to go.
Stuart
--- mos [EMAIL
I'm a bit of a linux newbie and a newbie to replication, so I'll try to ask this
question simply...
we're using mysql 4 to do replication, and I notice on the master I have this from
using mytop:
Id User Host/IP DB TimeCmd Query or State
--
Alfredo Kengi Kojima said:
MySQL Administrator 1.0.11 has been released.
MySQL Administrator is a GUI management console for MySQL, with support
for tasks such as managing users, configuring MySQL, performing backups,
editing table definitions etc.
More information at:
Capable? I can't think if why it wouldn't be capable. From your posts I
assume your definition of capable in this case is a quick response.
Are you running 4.0 or 4.1? I think the indexing was changed in 4.1 so
it would give you better response. 5-20 seconds does seem long,
assuming your
Luke,
As far as I know you can't do that in mysql, it would have to be at the
kernel level. Replication threads, really don't use much cpu anyway at
least not on the master, since all it's doing is basically reading a binary
file.
Now the kernel itself does do something like you are talking
Hi, All:
I have a database which contains date attribute in string format
(like 2004-08-12). I want to genearte a report based on period time.
I use the syntax:
date1 ='2004-08-12'
date2='2004-08-18'
SELECT * FROM account WHERE (TO_DAYS(date) = TODAYS(date1)) and
(TO_DAYS(date) =
On Thu, 26 Aug 2004 11:31:46 -0500, Yong Wang [EMAIL PROTECTED] wrote:
I have a database which contains date attribute in string format
(like 2004-08-12). I want to genearte a report based on period time.
I use the syntax:
date1 ='2004-08-12'
date2='2004-08-18'
SELECT * FROM account
I believe you are not letting MySQL do enough work for you. The date
format is perfect, even as a string, to perform the comparison you are
trying to perform.
SELECT @currTime := NOW();
+-+
| @currTime := NOW() |
+-+
| 2004-08-26 12:48:16 |
I know the subject is not totally descriptive of the problem, but:
mysql -h -u *** -p*** mikerocks latest_distribution.sql
Is producing no results. I mean none, totally, no errors, nothing.
The host, user and pass are all correct (of course removed here for security
;) ) and have the
Can you run this from inside the monitor and see if any messages are sent to
the consol?
\. latest_distribution.sql
-Original Message-
From: Mike Morton
To: [EMAIL PROTECTED]
Sent: 8/26/04 12:05 PM
Subject: Mysql command line queries not working
I know the subject is not totally
Hi guys,
We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10 for a
very high volume site. We are evaluating the performance on our new server
AMD64 and it seems it's slow compared to Dual Xeon/MySQL 4.0.15/RedHat8 and
Dual Xeon/MySQL 4.0.18/Mandrake 10.
And it seems there are
OK, more debugging, and this is what I have come up with
The latest_distribution.sql file was NOT created via a mysqldump, but rather
via phpmyadmin export...
The comments from phpmyadmin are denoted with the '#' character
The comments from a true mysqldump are denoted with the '--'
I finally got Php/MySQL/Apache all set on Windows 2000 professional
workstation. I'm looking for various php templates that keeps track of
associates, quantity produced, hours for each quantity produced and so on.
Is there such a template out there on the web that I can use?
TIA,
Scott
--
- Original Message -
From: Scott Hamm [EMAIL PROTECTED]
To: 'Mysql ' (E-mail) [EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 2:37 PM
Subject: Template
I finally got Php/MySQL/Apache all set on Windows 2000 professional
workstation. I'm looking for various php templates that keeps
I have arranged some MySQL C API examples at
http://www.geocities.com/jahan.geo/mysql_c_by_example.html
Comments/ Suggestion welcome.
--
Aftab Jahan Subedar
CEO/Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
Hi!
I have got two tables: 'item' and 'propertie'.
Table 'item' has index column named 'id_propertie' which refers to one row
in table 'propertie'. Table 'propertie' has string column 'value'.
I want to get the value of colun 'value' from table 'propertie' which index
is same than in table
I'm running into a problem here where mySQL is saying
unknown column.
Education_table
TypeID Type
HS High School
CO College
MA Masters
SQL:
Select * from Education_table (and no the table is not
named table)
From: TypeID = Value , Type = Label
Choose High School
How many places have you looked? I would use a search engine (Google,
Yahoo, etc) and try various combinations of terms like PHP, Samples,
Production, Source code, sample, and so on. I would keep searching
until I felt confident that:
a) nobody else has posted any code for a series of web
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
I'm running into a problem here where mySQL is saying
unknown column.
Education_table
TypeID Type
HS High School
CO College
MA Masters
SQL:
Select * from Education_table (and no the table is not
named
Stuart Felenstein wrote:
SQL:
Select * from Education_table (and no the table is not
named table)
From: TypeID = Value , Type = Label
Choose High School
Error Msg:
Unknown column 'HS' in 'field list'
You need to show the exact SQL statement that you're sending. Obviously
SELECT * FROM
Okay ..got to be looking for id's with string, not
numerics.
Case closed.
Oi
Stuart
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
I'm running into a problem here where mySQL is
saying
unknown column.
Education_table
TypeID Type
HS High School
CO College
MA
Our DB in production currently has 2 innodb data files,
the second one (which is marked autoextend) has now
grown past 26 gigs. We are experiencing weird speed
problems with one of the tables. Even though there are
no rows in this table, performing any kind of select takes
about 2 minutes to
Greetings All.
I am currently running 3.23.14alpha and have just downloaded the 4.0.20 binary
version. I am running under the Slackware Distribution of Linux. I have a variety of
PHP related things running currently.
Without destroying the current databases and the current tables under the
Title: 4.1.3 and prepared statements
Hi all-
Is the MySQL C API for prepared statements working at all in 4.1.3? I'm trying to do a relatively simple select test, and I consistently get an error on execute = MySQL client run out of memory. But it's a singleton select of one column and the
Hi there,
I'm having a problem with MySQL within a Perl::DBI usage. I've turned it
upside-down and cannot find what it's related to.
My Perl script creates multiple databases and populates them with
tables. The problem appears when creating the second database (in the
foreach statement):
#
#
Looks like my attachment did not make it to the post. So here's the code in
question - any thoughts?:
code
#include iostream
#include cstdlib
#include cstring
#include cstdio
#include mysql.h
using namespace std;
int
main(int argc, char *argv[])
{
cout start up endl;
MYSQL *
As for programming skills, I'm pretty familiar with Java so I feel sure I
could write a suitable utility with that. In fact, unless I had a really
urgent need, I would prefer to write my own stuff just because I like
writing code
If you wanted to go the java route I suggest checking out
John,
From my experience it is a lot more on how big is your data, not necessarily
the amount of data. Which version of mysql are you running? Are you using
a mysql prepared version (you downloaded it from mysql.com). I'm using
4.1.3 and I have a table that has a char 68 with 29 million rows
Hi all,
Started a conversion from MyISAM to InnoDB; it's been almost two days and the
statement is still executing...
The (MyISAM) data table size is almost 4G. There were two reasons for this conversion:
to start supporting transactions and to avoid the 4G limit of MyISAM tables; this
Sergei,
I don't know much about innodb, but myisam doesn't have a 4 gig limit unless
you are using a dynamic type of table. If you are using a fixed table which
is by using int, char, etc... Not text, varchar, blobs.
As long as you don't use the last ones, you don't have a 4 gig limit.
As
Hi again, I'm inserting some test products into my new mysql database but
it only lets me enter so much? I thought BLOB would allow alot more
characters? Anyway, this was how I constructed the database.
CREATE TABLE jspCart_products (
ProductID int primary key,
CategoryID int,
ModelNumber
Hi Donny,
Thanks for your reply. This table only uses ints and floats, but the floats are
allowed to be null, which means, as far as I understand, that it's not a fixed row
length...
By the way, Paul DuBois writes about the 4G limit in MySQL, second edition, and does
not mention that fixed
- Original Message -
From: B Wiley Snyder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 10:31 PM
Subject: another newb question for you help...
Hi again, I'm inserting some test products into my new mysql database but
it only lets me enter so much? I thought
42 matches
Mail list logo