Hi all,
Iam doing a bilingual site in english and other in
Arabic.
I know that MySQL doesn't support unicode..and in
which format i have to store into the database...
can any one explain
Vasan S
__
Do You Yahoo!?
Make international calls
I have a database of bids on auctions that I keep separate from the auction
information. The problem comes when I attempt to generate a list of
auctions with highest bid information. I set the database for bids like this:
ANum, varchar(20), the auction number
Bidders, int(4), number of
On 17 Aug 2001 06:13:08 +, Munish Malhotra wrote:
Dear Sir,
Can you please tell me how to access data from a MySql database using a Bash Shell
Script i.e. how to connect to a MySql database and retrive records and to disconnect
from database.
I shall be very thankful to you.
Steve Edberg wrote:
Do these people even know what they mean by 'enterprise management
functionality', or did they just crib from an Oracle brochure? DO they
have any specifics about what they require?
Managers do that all to often when comparing software. They look at the
feature
Date |Thu, 16 Aug 2001 14:57:59 +0300
From |[EMAIL PROTECTED] [EMAIL PROTECTED]
Hello!
S I have a very interesting question.
S I have a program that works on 2 computers, using some king of p2p protocol.
S Each side is using mysql for work. How I can synchronise two databases on
S these
Date |17 Aug 2001 06:13:08 -
From |Munish Malhotra [EMAIL PROTECTED]
Hello!
M M Dear Sir,
M M Can you please tell me how to access data from a MySql database using a Bash
Shell Script i.e. how to connect to a MySql database and retrive records and to
disconnect from database.
M M I
Date |Thu, 16 Aug 2001 13:40:16 +
From |Brian Johnson Jaber [EMAIL PROTECTED]
Hello!
BJJ Dear Sirs
BJJ Hello, i have questions on mysql i create a table and i create an index key
BJJ in it i want to know how can i know in mysql if the date that i import it
BJJ into the table are fully
Matt Wagner writes:
Matt Wagner writes:
Jeremy Zawodny writes:
On Thu, Aug 16, 2001 at 06:00:16PM -0700, Jeremy Zawodny wrote:
Does anyone have the latest 3.23.41 I could grab a copy of?
I managed to fetch it from ftp.mysql.com. A copy is now available here
as well:
Sincerely,
Melinda Odom
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
www.mdesigner.org http://www.mdesigner.org/
***
Hosting, Ecommerce, $15/yr Domains
www.modom.adgrafix.com http://www.modom.adgrafix.com/
www.wsmdomains.com http://www.wsmdomains.com/
Toll free
On Mon, Aug 13, 2001 at 06:16:10AM +0100, Corin Hartland-Swann wrote:
I have also set tmp_table_size to 1024M, which according to the
manual should mean that temporary tables will be created in RAM
unless they're going to be bigger than that. When I do the following
query:
SELECT
[EMAIL PROTECTED]
Sincerely,
Melinda Odom
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
www.mdesigner.org http://www.mdesigner.org/
***
Hosting, Ecommerce, $15/yr Domains
www.modom.adgrafix.com http://www.modom.adgrafix.com/
www.wsmdomains.com
On Thu, Aug 16, 2001 at 03:57:02PM -0400, Brian Burke wrote:
All,
I'm hitting some stumbling blocks getting replication working, and
so I decided to join the list for support.
Welcome...
Here is what I'm trying to do:
GRANT FILE on dbname.tablename to user@% IDENTIFIED BY 'passwd';
Chris Boget wrote:
MySQL - as I said at our meeting, we would not be comfortable with this
as an enterprise strength solution. MySQL is unsupported freeware
As has already been pointed out, MySQL is commercially supported by MySQL
AB. What strikes me most significantly is that, if you purchase
Hi List,
I've a question about inserting values in tables with promary-keys.
I have two tables:
1. Table ( contains limits for testing )
- int limitId primary key
- int lowerlimit
- int upperlimit
- char(5) measureunit
- char(10) measurename
2. Table ( contains measured values )
- int
Hi everybody: here is a new version of moodss.
Check it out! (or at least the screenshots at
http://jfontain.free.fr/moodss3.gif or
http://jfontain.free.fr/moodss4.gif :).
### CHANGES ###
--- version 14.4 ---
all data tables now feature thinner separation lines so that more data
can be
On Friday 17 August 2001 07:13, Jim Lynn wrote:
I have a database of bids on auctions that I keep separate from the auction
information. The problem comes when I attempt to generate a list of
auctions with highest bid information. I set the database for bids like
this:
ANum, varchar(20),
Hi,
I have received mysql db files with extensions .frm, .ISD, .ISM
I was told that all I need to do is to put them in mysql data directory
and it should work ok. I have RH6.2 with mysql rpm and I cannot locate
where mysql data directory is.
Any idea how to locate it. I wish I had received
Frank Fisher writes:
Tyrone Mills wrote:
good. Maybe MySQL needs to charge support fees comparable to M$ and Oracle
to make these pinheads happier. Have a special support contract, don't offer
anything different, just call it something Corporate sounding and charge
10 times as much...
sachin shetty writes:
Hello
I get the following error message when i complie the source version of
mysql3.23.41.
checking character sets... configure: error: No number was found in
./sql/share/charsets/Index for the latin1 character set. This is a bug in
the MySQL distribution. Please
O'SULLIVAN JOHN writes:
Hi
I am just starting to write my first client with MYSQL 3.23.39 under RH
Linux 7.1 and I had the following code.
The code compiles fine but the call to mysql_query( ) fails with following
error
I used the exact same query at the MYSQL prompt and it worked
Fournier Jocelyn [Presence-PC] writes:
Hi,
I noticed an annoying behaviour with MySQL 4.0.0.
I have 11 tables with a lot of rows (about 1 Million and more) which are constantly
updated by a php script.
It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart,
some
Thanks for the input Heikki,
I got it the right version mysql-max-nt going now. The problem was that
winmysqladmin automatically started the wrong service- mysqld - so I had to
uninstall that service before it would recognise any changed I made in the
my.ini file done with winmysqladmin.
Now
hi folks,
i have a problem. i want to replicate a (master)database
which has no direct network connection to the slave.
the only way to get the data from the master to
the slave db is to 'ftp' them.
the databases are used in an internet environment so
i am searching for a solution without any
I had this error under win when using phpMyAdmin quite frequently.
It turned out that mysql creates temp files and somehow the
process terminates.
To get along, I dump the table, edit the sql file and reimport.
Never had a problem with this method.
Charles Mégnin schrieb am Freitag, 17. August
Hi Can anybody recomend me a Mysql replication webpage with feedback ?
- Original Message -
From: AJDIN BRANDIC [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 12:35 PM
Subject: find mysql
Hi,
I have received mysql db files with extensions .frm, .ISD, .ISM
I
hi
i found it /var/lib/mysql/
regards
Ajdin
On Fri, 17 Aug 2001, AJDIN BRANDIC wrote:
Hi,
I have received mysql db files with extensions .frm, .ISD, .ISM
I was told that all I need to do is to put them in mysql data directory
and it should work ok. I have RH6.2 with mysql rpm and I
[EMAIL PROTECTED] writes:
Hi all,
i am not sure if i am at the right list.
But i will ask my question anyway.
Here is the problem.
I have compiled Mysql version 3.23.41 with Forte 6 update 1 from Sun.
I have done this on a SPARC system and complied it 64bit.
I didn't
Eric,
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT? Then the problem
might be the consistent read. I have copied below a segment
from the InnoDB manual at www.innodb.com :
When you issue a consistent
At 11:50 17/08/2001 +0100, Bruce Scharlau wrote:
Hi!
Thanks for the input Heikki,
I got it the right version mysql-max-nt going now. The problem was that
winmysqladmin automatically started the wrong service- mysqld - so I had
to uninstall that service before it would recognise any changed I
Bruce,
the tablespace must be = 10 MB. You have only
specified 5M.
I tested with .41 and got the following error
message:
C:\trybuild\client_debugmysqld --console
InnoDB: Error: tablespace size must be at least 10 MB
010817 15:28:15 Can't init databases
Regards,
Heikki
Copied message:
Date |Fri, 17 Aug 2001 11:35:28 +0100 (BST)
From |AJDIN BRANDIC [EMAIL PROTECTED]
Hello!
AB Hi,
AB I have received mysql db files with extensions .frm, .ISD, .ISM
AB I was told that all I need to do is to put them in mysql data directory
AB and it should work ok. I have RH6.2 with mysql rpm
Thanks guys.
Just one thing, why isn't this somewhere in the docs?
A small note near the beginning of section 7.6.2 InnoDB startup options
would seem to be an ideal place.
cheers,
Bruce
At 03:30 PM 8/17/2001 +0300, you wrote:
Bruce,
the tablespace must be = 10 MB. You have only
specified 5M.
Bruce,
you are right. There is only a small note about the
10M limit in the options list in the manual.
I will add a note also right after Win option examples.
Regards,
Heikki
http://www.innodb.com
...
Thanks guys.
Just one thing, why isn't this somewhere in the docs?
A small note
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I have a table in my database that has one field named design_name. The
design_name is varchar(200) unique. After I created the table the need
appeared to have duplicates in this field. So I tried to remove the
Hi all
Ive got perl happily talking to mysql on an NT box, but I can't make it
happen on win98 - although on win98 I can connect just fine to mysql through
a dos box.
The obvious thing would have been no mysql driver for perl on the win98
machine, but both return these values:
ADO
ExampleP
Filip,
Sinisa's suggestion about user access rights to
the created data and log files might be the explanation.
At least one user is running on 64-bit Sparc, but
he uses gcc.
What does
ls -l
say about the data and log files and access rights?
Was InnoDB able to create them the right size?
Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert one or more '0', infront of all the numbers to make
sure that the length of each record
Could you tunnel threw on the FTP port to solve this?
Simon
-Original Message-
From: Bernd Becker - AGI [mailto:[EMAIL PROTECTED]]
Sent: 17 August 2001 12:16
To: [EMAIL PROTECTED]
Subject: 'managed' replication
hi folks,
i have a problem. i want to replicate a (master)database
which
Ciprian A. wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I have a table in my database that has one field named design_name. The
design_name is varchar(200) unique. After I created the table the need
appeared to have duplicates in this field. So
UNIQUE is an index property. You need to remove the index with
the drop command.
Ciprian A. schrieb am Freitag, 17. August 2001, 15:01:51:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I have a table in my database that has one field named design_name. The
Hi,
could you say me a way for link the .dbf files to mysql?
Ex.:
.dbf -- MySQL
files -- Server
thanks
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
I have the following problem:
When displaying a select * query from a table
I get the following: (just showing the end).
| | | 2928 | 1611100 |
| | | 2929 | 1251300 |
+--++--+--+--+
The last column is empty, which is normal but the
On Fri, 17 Aug 2001 15:13:22 +0200
Liana Wiehahn [EMAIL PROTECTED] wrote:
Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert
hi.
update Erf set PortionNumber = CONCAT('0', PortionNumber) where
LENGTH(PortionNumber) = 4;
update Erf set PortionNumber = CONCAT('00', PortionNumber) where
LENGTH(PortionNumber) = 3;
update Erf set PortionNumber = CONCAT('000', PortionNumber) where
LENGTH(PortionNumber) = 2;
update Erf set
Hello,
Can any one tell me why
$sql=SELECT * FROM table WHERE pcsort REGEXP '^.$parts[0].[0-9]';
(pcscot being a CHAR(10), $parts[0] being a single alpha charcater.)
works OK in 3.23 but not in 3.22.
I'm trying to find UK postcodes such as e17 but not ee17.
All the best,
Lee
On Fri, 17 Aug 2001, Heikki Tuuri wrote:
Problem resolved, thank you very much. It was indeed my missing a
concept, description below:
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT?
Yes, as it's two
Problem: I'm experimenting with using mysqldump to backup my data,
which seems to work ok. However, in recreating the tables I run into
a problem.
Using either LOAD DATA INFILE or mysqlimport methods I get the error
Error: Duplicate entry '102' for key 1
Field def: record_id SMALLINT
Is it possible to create a table,with say 200 feilds (named 1-200) using
phpmyadmin and then import a text file into this table and have the first
row of the text file as the feild names and rename the feilds names on the
table?
On Thu, Aug 16, 2001 at 10:38:46PM -0400, Xavier Leoncini wrote:
I have the following problem:
When displaying a select * query from a table
I get the following: (just showing the end).
| | | 2928 | 1611100 |
| | | 2929 | 1251300 |
Thanks everybody
Ravi's syntax worked and I'm on my way to have a nice weekend!:)
cheers
Liana
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 4:39 PM
To: Liana Wiehahn; [EMAIL PROTECTED]
Subject: RE: Manipulation of data - batch
I use webmin to administer my MySQL database on a Linux Slackware 8 box. I
installed MySql in /usr/local/mysql and got Webmin to see it. When I try to
connect, it needs an administrative login. I've tried the root login for the
system and it doesn't seem to do it. Any idea what the login might
Though i would give Innodb another go with the latest mysql-max RPM's (3.23.41) for
linux running on a Redhat machine. This is on a Compaq ML-370, 667Mhz with 1gig mem on
kernel 2.2.19. Disks are Raid-5. Huge performance difference between Innodb and MyISAM
for a simple table create (7 times
Hi people,
Anyone know how to get a field in one of my table in a form that any number
that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for
the cost instead of 0.2?
Or do I have to do this with the Server Side Language I'm using to format
the value? Or some extra SQL
May be a red herring, however this ate several hours, so...
..enjoy! :-
Description:
Possible problem with using the existing 3.23.41 SRC RPM distribution
This package may have some bug.
This is the source RPM package downloaded from mysql.com, with MD5-hash:
MySQL-3.23.41-1.src.rpm -- 91eb
On Fri, 17 Aug 2001, Christopher Teli wrote:
How can I check if an index exists on a table???
Is there some where I can query the admin tables?
SHOW INDEX FROM tablename
-
Before posting, please check:
On Fri, Aug 17, 2001 at 09:32:05AM -0700, Christopher Teli wrote:
How can I check if an index exists on a table???
Is there some where I can query the admin tables?
'DESCRIBE tablename' or 'SHOW COLUMNS FROM tablename'. Figure out
where it says 'index' for yourself :) (since I don't know
thank you, i was actually trying to access the table through C-API
and had trouble with show index when I used the following query.
show index from db.table
i will have to try
show index from table from db
thank you,
Chris
-Original Message-
From: Philip Mak [mailto:[EMAIL
show index from tablename;
This returns a result set listing all indexes on the table.
--Greg Johnson
-Original Message-
From: Christopher Teli [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 12:32 PM
To:
Dear Steve,
use TRUNCATE or ROUND. Manual:
http://www.mysql.com/doc/M/a/Mathematical_functions.html
Like: SELECT TRUNCATE(my_col, 2) FROM my_tbl
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee
Dear Chris,
How can I check if an index exists on a table???
The manual sais: SHOW INDEX FROM tbl_name [FROM db_name]
Check: http://www.mysql.com/doc/S/H/SHOW.html
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
try varchar.
pc schrieb am Freitag, 17. August 2001, 18:15:10:
Hi people,
Anyone know how to get a field in one of my table in a form that any number
that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for
the cost instead of 0.2?
Or do I have to do this with the Server
Hi everybody
I want to make backing up for my databases from the server into my pc, I
login to the server with the administrator username and password, how could
this backing up be done? and is there any risk that i should be aware of ?
is there any softwares that could be used for
The server doesn't look for a users .my.cnf.
This would only be useful for the client programs.
Fai wrote:
Does any body know how to prevent mysql server looking for user specific
optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in
his home directory to affect the
On Sat, 18 Aug 2001, Fai wrote:
Does any body know how to prevent mysql server looking for user specific
optional file ( .my.cnf)? So, user cannot put the optional file (.my.cnf) in
his home directory to affect the mysql server behaviour.
Even if user can put the optional file in his home
While there may be a way to manipulate this with MySQL, you may find
that the interface language is simpler. PHP and Perl both offer a
command 'printf' which allows you to heavily format a string or
number. Like:
printf(The price is $%.2f, today only, $sqlResultRow-amount);
would
On Fri, 17 Aug 2001, hanan khader wrote:
Hi everybody
I want to make backing up for my databases from the server into my pc, I
login to the server with the administrator username and password, how could
this backing up be done? and is there any risk that i should be aware of ?
is there
Daniel Woods noted this error:
Warning: MySQL Connection Failed: Access denied for user:
'mysite@localhost'
(Using password: NO) in
/home/mysite/public_html/phpMyAdmin/lib.inc.php3 on line 170
I have added users apache and mysite to /etc/group for
I've ran into a wall with the MAX() function when used with
DATE_ADD(). I'm posting to the list in hopes that someone has an idea,
comments, or suggestions for me. This is the problem at hand:
Given:
SELECT
(TO_DAYS(MAX(DATE_ADD(T.StartDate, INTERVAL T.Duration Day
-
Hi all,
We want to set up a user in mysql and allow him to send his queries to our database
from his server. (PHP)
The data in our database contains our other customers' as well as the guy who wants to
directly access it. We would like to check his queries before send it to the database.
Does any know how to fix this database replication problem.
Last Lines from Err File
010815 21:38:55 Slave thread exiting, replication stopped in log
'salem-bin.013' at position 6867
010815 21:38:55 Error running query, slave aborted. Fix the problem, and
re-start the slave
Dear Hanan,
try PhpMyAdmin (www.phpmyadmin.com). Nice and easy to backup databases
and tables, and easy to import from the backup SQL files. It's browser
based, so it's platform independent.
It's not secure, though
(http://www.securereality.com.au/studyinscarlet.txt), so make sure to
protect
If I am using the MATCH function to search within a field with a
FULLTEXT index, can I add additional qualifiers to refine that
search? For example:
SELECT *, MATCH (Description) AGAINST ('unique') AS score FROM
Tags.web WHERE MATCH (Description) AGAINST ('unique') AND
type='Record'
Will
Doc:
Try this...
SELECT C.domain, email, telephone, count(*)
FROM Customers AS C LEFT JOIN
Orders AS O ON O.domain=C.domain
GROUP BY C.domain, email, telephone ;
Cheers,
Kent
[fodder=SQL]
-
Before
Hi all,
We want to set up a user in mysql and allow him to send his queries to our
database from his server. (PHP)
The data in our database contains our other customers' as well as the guy
who wants to directly access it. We would like to check his queries before
send it to the database.
For
On 17-Aug-2001 pc wrote:
Hi people,
Anyone know how to get a field in one of my table in a form that any number
that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for
the cost instead of 0.2?
float(9,2);
Regards,
--
Don Read
On Fri, 17 Aug 2001, Mysql Mailing List wrote:
If he sends in select * from table, we would like the mysql actaully
execute select * from table where hisID=1000;
Basically, we want mysql database to screen the query sent from a certain
user, and apply some conditions on that query.
Is it
Kurt,
Warning: MySQL Connection Failed: Access denied for user:
'mysite@localhost'
(Using password: NO) in
/home/mysite/public_html/phpMyAdmin/lib.inc.php3 on line 170
I have added users apache and mysite to /etc/group for group mysql,
This message is broken into two parts because the MySQL list blocked it as being too
big!!!
Okay, here is the problem: everyone once in a while, say once or twice a day, my web
server running RH 7.2, PHP 4.0.6 and MySQL, will seem to freeze (from a web users
point of view). Upon SSH'ing
Greetings MySQLers!
This messages is about MySQL. (had to put that in for the spam filter)
I have a record in my database:
productID Title
4 This title has a ' in it.
In the database, this is actually stored as:
productID Title
4 This title has a \' in it.
I have a query:
[EMAIL PROTECTED] wrote:
On Thu, Aug 16, 2001 at 10:38:46PM -0400, Xavier Leoncini wrote:
I have the following problem:
When displaying a select * query from a table
I get the following: (just showing the end).
| | | 2928 | 1611100 |
| | | 2929 | 1251300 |
On Fri, Aug 17, 2001 at 06:54:59PM -0400, Ryan Shrout wrote:
This message is broken into two parts because the MySQL list blocked
it as being too big!!!
Okay, here is the problem: everyone once in a while, say once or
twice a day, my web server running RH 7.2, PHP 4.0.6 and MySQL, will
It may be that MySQL is simply spawning too many processes for your
machine to handle.
I might be wrong, but here's something to try:
1. Set MySQL max_connections to 45.
2. Set httpd MaxClients to 50.
That will limit the number of processes MySQL is allowed to start, and
also makes sure that
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) ||
On Fri, Aug 17, 2001 at 03:46:11PM +0100, Lee Denny wrote:
Hello,
Can any one tell me why
$sql=SELECT * FROM table WHERE pcsort REGEXP '^.$parts[0].[0-9]';
(pcscot being a CHAR(10), $parts[0] being a single alpha charcater.)
works OK in 3.23 but not in 3.22.
I'm trying to find UK
On Fri, 17 Aug 2001, Cal Evans wrote:
Select * from product where title = 'This title has a \' in it.';
This query does not work. Can anyone tell me how to build a query that will
return that title?
Are you sure you're not overlooking something? I just tried the following
commands and had
At 3:00 PM +0200 8/16/01, Theo Richel wrote:
I am a very dedicated user of Mysql, but I am somewhat disappointed that you
chose the dolphin for your logo because of the good nature of this animal.
In the New York Times (1999) I read: But scientists, following a trail of
bloody clues, are
I am having a problem with MySQL. I am seeking some advice on either what is wrong
or how to pursue the cause of this bug.
I am using Perl DBI to interface with MySQL and when i execute the
following statement:
$dbh = DBI-connect('DBI:mysql:database=dbmysql2', undef, undef,
{PrintError =0}) ||
I am in need of consultation services concerning my PHP scripts and MYSQL
database. if you are interested please email me at [EMAIL PROTECTED] or
[EMAIL PROTECTED] with credentials and how much you charge, and
whatever else I may need to know.
Here is my problem. I have a web server and a
I have data I create daily in MS Excel. I need to insert this data into
MySQL data base on my web server every night. Does anyone here have a VB
technique to upload to MySQL from Excel via a macro?
Thanks
Craig
[EMAIL PROTECTED]
Jeremy, it was included in PART #2 of the problem message. Did you get
that?
Ryan Shrout
Owner - Amdmb.com
http://www.amdmb.com/
[EMAIL PROTECTED]
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Ryan Shrout [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, August
Hi Everyone,
I have a few questions based on a scenario that was posed to me, and I have
no idea how to go about it...
For example, a multi-level / multilevel marketing project has the following
Membertable with 2 fields for a generated Account Number the first field
is Member's Unique
I'm a newbie to MySql / Php and heres what i'm trying to accomplish:
I have a set of hard coded links that each have a sql parameter value like
below:
a href=http://www.foo.com/agent_result.php3?$agent_id=9805;My Link
Text/a
I'm trying to pass that parameter into a query on another page and
I noticed that most if not all the mysql_fetch_object, and mysql_fetch_array
and mysql_fetch_row all have print in the while brackets...
what I want to do is to assign the result to a $variable first WITHOUT
printing the result, and reassigning the $variable into a second query,
before
93 matches
Mail list logo