First off, when starting a new topic, don't reply to message and
then change the topic.
* Thus wrote Karam Chand:
Hello,
Recently lot of MySQL clients try to overcome host
based privilege system of MySQL by using PHP tunneling
method.
In this method they call up a PHP file in the server
update...
as a short test... i created a resource --
$link = mysql_connect(foo.)
and used the $link to process a query against my mysql db...
i then attempted to create a session var consisting of the $link value...
$_SESSION['db'] = $link, and verified that it actually contained the
Please do not hijack threads.
bruce wrote:
hi...
if i create a site that hits a back mysql db...
i don't want to do a mysql_connect for every page that has to access the db.
so the question is where should the mysql_connect occur. also, if i were to
do it once when the app starts, is the
in
another page
ideas/comments welcome..
thanks..
-bruce
-Original Message-
From: Marek Kilimajer [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 10, 2004 4:42 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql and session vars...
Please do not hijack threads
On Sunday 11 July 2004 07:59, bruce wrote:
not sure what you mean by hijacking...
FYI:
You have started a new thread by taking an existing posting and replying to
it while you changed the subject.
That is bad, because it breaks threading. Whenever you reply to a message,
your mail client
On Sunday 11 July 2004 10:03, bruce wrote:
i'm trying to get a better understanding of how to implement persistent
connections with mysql in either perl/php
basically i'm trying to solve the issue of whether a web app has to
essentially perform a new mysql_connect on every page that's going
--- Curt Zirzow [EMAIL PROTECTED] wrote:
First off, when starting a new topic, don't reply to
message and
then change the topic.
Sorry. But I just didnt remember the email addy so I
took that way :).
* Thus wrote Karam Chand:
Hello,
Recently lot of MySQL clients try to overcome
On Thursday 08 July 2004 09:59 am, Harlequin wrote:
I have a user registration form that asks new users to register. However,
Do I post the MySQLconnection string in the page they are completing or in
the later page that the data is posted to, or both...?
I don't think I understand your
Harlequin wrote:
I have a user registration form that asks new users to register. However, Do
I post the MySQLconnection string in the page they are completing or in the
later page that the data is posted to, or both...?
Not sure I follow what you're asking, but you only need to open a
connection
Hi Frank,
I think you could use
window.location=test.php?time=xxx
in the onUnload instead of opening a new window.
Eric
On Mon, 5 Jul 2004 14:08:14 -0400, Frank Voorburg
[EMAIL PROTECTED] wrote:
Hi,
Any help with the following is appreciated. I want to use php to store the
time that a
Harlequin wrote:
sql == INSERT INTO RegisteredMembers
(TXT_UserID,TXT_UserPassword,TXT_Comments,TXT_FurtherComments)
VALUES('.$NewUserID.','.$NewUserPassword.','.$NewUserComments.','.$NewUserFurtherComments.');
This should be $sql = ... and then you need to run the query with
$result
Michael
just wanted to thank you through the group for your time.
U R A Star...!
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
-
Michael Egan [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Have a look at the mysql
Glad to be of help. I'm sure there will be many more occasions when I'm badly in need
of assistance.
Cheers,
Michael
-Original Message-
From: Harlequin [mailto:[EMAIL PROTECTED]
Sent: 02 July 2004 13:55
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL QUERY Results Not Appearing[Scanned
Have a look at the mysql functions in the PHP manual - i.e.
http://uk.php.net/mysql_query
I'm also certain this question has been raised fairly recently on the list. All
mysql_query is going to do is either open up the resource or not. You'll need to use
something else to display the data.
No other way. Use one query to count the total record and then another
query for limiting
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[snip]
Is this right? Is there other efficent way to do it?
What about if data changes (i.e. new records are added) while the user
browses through pages?
[/snip]
on each page do a:
SELECT count(*) FROM table WHERE your_condition
this will give you your total number of results
--
PHP General
* Thus wrote Erik Gjertsen:
I have problem with mysql_close
I dont understand why.
Are ther someone that have any proposal?
...
$query = SELECT usrid FROM users WHERE username;
$result = @mysql_query ($query); //Run the query
...
}
mysql_close();
stab dark=true
perhaps
On Sun, 20 Jun 2004 19:05:31 +0200, Gerben [EMAIL PROTECTED] wrote:
when I call mysql_fetch_row() I get an array, but this Array doesn't have
the fieldnames as array-keys.
I've seen several codes from others where they use something like
print $row['key'];
'key' simply needs to be the
when I call mysql_fetch_row() I get an array, but this Array doesn't have
the fieldnames as array-keys.
I've seen several codes from others where they use something like
print $row['key'];
This doesn't work on my server. Is this because my server-software is too
old or am I using the
Use mysql_fetch_assoc() for fieldnames
when I call mysql_fetch_row() I get an array, but this Array doesn't have
the fieldnames as array-keys.
I've seen several codes from others where they use something like
print $row['key'];
This doesn't work on my server. Is this because my
Ryan Schefke [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I'm pulling a date in the datetime format via a MySQL query. Using PHP
I
would like to check if that date is prior to today's date. Can someone
please help with this quick question.
You could convert it to a
[snip]
I had MySQL up and running. One glaring problem is that the
hostname in
the 'user' table of 'mysql' database show it as 'localhost'. I thought
it
would look better if I change it to '127.0.0.1' instead. I haven't got
that
connection to work with IP address, so mysql_connect() doesn't
Scott Fletcher wrote:
Hi!
I had MySQL up and running.
If it's not broken don't fix it.
--
Raditha Dissanayake.
-
http://www.raditha.com/megaupload/upload.php
Sneak past the PHP file upload limits.
--
PHP General Mailing List (http://www.php.net/)
Security rank higher than this
Raditha Dissanayake [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Scott Fletcher wrote:
Hi!
I had MySQL up and running.
If it's not broken don't fix it.
--
Raditha Dissanayake.
-
Scott Fletcher wrote:
Security rank higher than this
How can connecting to localhost be more or less secure than connecting
to 127.0.0.x ?
Hi!
I had MySQL up and running.
If it's not broken don't fix it.
--
Raditha Dissanayake.
Scott Fletcher wrote:
Security rank higher than this
Use mysql socket and you are safe.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
* Thus wrote Marek Kilimajer ([EMAIL PROTECTED]):
Scott Fletcher wrote:
Security rank higher than this
Use mysql socket and you are safe.
iirc, by default mysql uses the socket if you connect via
localhost/127.0.0.1 and tcp any other way.
Although a mysql list probably would be more
Looks like the mysql module for php is not loaded.
Is extension=mysql.so included in the php.ini.
Nunners wrote on vrijdag 4 juni 2004 14:07:
I've just installed Fedora Core 2, including I believe both PHP
MySQL.. However whenever I try and run something that connects to
MySQL, it comes up
Run: rpm -q php-mysql
From the command line as root and see if it is there, if not go out and
download the fedora rpm with that in the title, since that would be the
missing piece.
HTH,
Robert
-Original Message-
From: Nunners [mailto:[EMAIL PROTECTED]
Sent: Friday, June 04, 2004 8:07
On 23-May-2004 Russell P Jones wrote:
I just want to print out a table from mySQL. Thats it. into an html
table.
Column 1 | Col 2 | Col 3
-
Val 1| val 2 | val 3
Val 4| val 5 | val 6
any ideas on how to do this?
if ($res = mysql_query($qry)) {
--- Russell P Jones [EMAIL PROTECTED] wrote:
I just want to print out a table from mySQL. Thats
it. into an html table.
Column 1 | Col 2 | Col 3
-
Val 1| val 2 | val 3
Val 4| val 5 | val 6
any ideas on how to do this?
Sure, this is a fairly common
My apologies, I accidentally clicked some key
combination in Yahoo that sent off my message before I
finished. Here we go again:
while ($row = mysql_fetch_array($sql_result))
{
$col_1 = $row['column1'];
$col_2 = $row['column2'];
$col_3 = $row['column3'];
$val_1 = $row['value1'];
On Thu, 13 May 2004 17:53:20 -0400, Jianping Zhu
[EMAIL PROTECTED] wrote:
I have mysql table call com. One colum of table com will store
user's comments. Because user-provided comment might be too big to fit in char(255),
i
use blob. but when i try to see it by use phpmysqladmin, i can only
Try
http://freshmeat.net/projects/phpmysqlbackupro/
Regards,
Hatem
- Original Message -
From: Matthew Oatham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:30 PM
Subject: [PHP] MySQL backup
Hi,
I am using MySQL database accessed via myphp admin - there is an
From: Matthew Oatham [EMAIL PROTECTED]
I am using MySQL database accessed via myphp admin -
there is an export option which allows me to export the structure
and data to an sql file but this is a manual procedure is there
anyway to automate this via myphp admin i.e. using a cron job?
The
Mmmm my provider doesn't give me access to this area !
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: Matthew Oatham [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 6:40 PM
Subject: Re: [PHP] MySQL backup
From: Matthew Oatham [EMAIL PROTECTED]
I
Matthew Oatham wrote:
Hi,
I am using MySQL database accessed via myphp admin - there is an export option which allows me to export the structure and data to an sql file but this is a manual procedure is there anyway to automate this via myphp admin i.e. using a cron job?
Thanks
Use a cron and
Matthew Oatham wrote:
Mmmm my provider doesn't give me access to this area !
To what area? mysqldump, or cron?
--
John C. Nichel
KegWorks.com
716.856.9675
[EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
From: Matthew Oatham [EMAIL PROTECTED]
I am using MySQL database accessed via myphp admin -
there is an export option which allows me to export the structure
and data to an sql file but this is a manual procedure is there
anyway to automate this via myphp admin i.e. using a cron job?
This should be in a mysql newsgroup.
Bill Green wrote:
HI. I've been using mySQL 4.0.13, php4.3.4, and phpMyAdmin2.5.5 on Mac
OS 10.3.3 as a learning/testing/development environment for a couple
of months now - no problems, works great.
I've created more than a few mySQL databases and tables,
I just tested it and yes, the Michal function runs on Windows and Linux.
Just must write the path in the proper format for the OS you're using.
Regards,
Jordi.
Matt Palermo wrote:
Will this work on both a Windows and Unix server?
Michal Migurski [EMAIL PROTECTED] wrote in message
news:[EMAIL
I just tested it and yes, the Michal function runs on Windows and Linux.
Just must write the path in the proper format for the OS you're using.
Holy smokes, that's good news. :) Spreading dis-information is my price
for not having the first clue about windows.
Will this work on both a Windows and Unix server?
Michal Migurski [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Is there an easy way to do a mysql dump routine written in php? I
basically want to write a function to backup a database and have it
create all the neccessary
Will this work on both a Windows and Unix server?
No, it's most assuredly a unix-only thing.
-
michal migurski- contact info and pgp key:
sf/cahttp://mike.teczno.com/contact.html
--
PHP General Mailing List
sorry but I solved it
select version();
for those of you who didnt know.
-Original Message-
From: Angelo Zanetti [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 10:19 AM
To: [EMAIL PROTECTED]
Subject: [PHP] mysql version
SOrry for off topic post, but how does one determine the
select version as version; if used directly in the server (i.e. mysql)...
if you want to use it in php:
$query=select version() as mysql_version;
$result=mysql_query($query) or die();
if(!$result){
echo cant determine mysql version;
} else {
//whatever you want to do with it
}
- Original
Is there an easy way to do a mysql dump routine written in php? I
basically want to write a function to backup a database and have it
create all the neccessary structures and data in the dump. I know
phpMyAdmin will do this for me, but I want to write a function to do
this incase the server
();
//and the msg itself if we want
$ErrorMsg=mysql_error();
return false;}
else{return $link;}}
or however the best way goes for that...
- Original Message -
From: Curt Zirzow [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 1:35 AM
Subject: Re: [PHP] mysql connect
On Wednesday 14 April 2004 07:12 pm, Andy B wrote:
function Connect($host, $mysqluser, $mysqlpwd){
$link=mysql_connect($host, $mysqluser, $mysqlpwd)
if(!$link){ return false; }
else { return $link; }}
should i keep it like this or is it better for the function itself to deal
with error
* Thus wrote Greg Donald ([EMAIL PROTECTED]):
On Wednesday 14 April 2004 07:12 pm, Andy B wrote:
function Connect($host, $mysqluser, $mysqlpwd){
$link=mysql_connect($host, $mysqluser, $mysqlpwd)
if(!$link){ return false; }
else { return $link; }}
should i keep it like this or is it
* Thus wrote Andy B ([EMAIL PROTECTED]):
hi
i have this function inside a class that im writing that eventually i want
to put inside a package of my own... the function goes like this: (comment
block included):
/**
*function Connect: open connection to database.
*
[EMAIL PROTECTED]
();
//and the msg itself if we want
$ErrorMsg=mysql_error();
return false;}
else{return $link;}}
or however the best way goes for that...
- Original Message -
From: Curt Zirzow [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 1:35 AM
Subject: Re: [PHP] mysql connect
I don't know if this is the root of your problem or not, but I tried running
PHP 4.3.5 on my Win2K box and it crashed a lot. I found out that if you
have PHP configured to run as a SAPI module there are stability issues with
that version (this bug has been reported). I think the CGI install
Five wrote:
Windows 98 se
When using the dos window command line for mysql commands everything works fine except
if I try to use the paste function to paste
pre-typed commands, the window freezes. This is aaannnoooyyyiiinnnggg.
This is PHP -- MySQL is down the hall to the left.
--
PHP General
Hello,
Wednesday, March 31, 2004, 1:43:17 AM, you wrote:
F When using the dos window command line for mysql commands
F everything works fine except if I try to use the paste function to
F paste pre-typed commands, the window freezes. This is
F aaannnoooyyyiiinnnggg.
Get yourself a copy of MySQL
Andy B wrote:
mysql_query(select * from rnjresort.users where username='$username' and
pwd=md5($password));
//see if user exists..
if(mysql_affected_rows()==0){
You're not assigning the query result to a variable.
$result = mysql_query( ... );
Then, mysql_affected_rows() is not going to return
[EMAIL PROTECTED] (Bigmark) wrote in
news:[EMAIL PROTECTED]:
I have a sports tipping script and instead of using the admin to close a
round off or input results ,would it be possible to do it via an email.
Mark
This can be done on a Unix style system by creating a mail alias which
pipes
Brent Clark wrote:
Hi all
for some reason I seem to be having a problem having to do a look up in a mysql table
and the take the result of that query and then perform the right action.
Basically I need to do a look up for a file
for example
10006547.pdf.
I then need to:
if no letter
What happens when you try to use the mysql client on the web machine,
to connect to the production database server? Does it work? If yes, what
lines are you using to connect to your DB with PHP?
On Wed, 2004-03-17 at 14:54, Cameron B. Prince wrote:
Hey guys,
I've been developing my site on a
Hi Adam,
What happens when you try to use the mysql client on the
web machine, to connect to the production database server?
It works:
bash-2.05# pwd
/usr/local/mysql/bin
bash-2.05# ./mysql -h 192.168.1.44 -u web -P 3306 -p
Enter password:
Welcome to the MySQL monitor. Commands end with ;
So what error prints out when you try and connect from PHP?
On Wed, 2004-03-17 at 15:03, Cameron B. Prince wrote:
Hi Adam,
What happens when you try to use the mysql client on the
web machine, to connect to the production database server?
It works:
bash-2.05# pwd
So what error prints out when you try and connect from PHP?
Could not connect : Can't connect to MySQL server on '192.168.1.44' (2)
Not very helpful huh?
Any ideas?
Cameron
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Change your server address, to leave off the port number.
Any different?
On Wed, 2004-03-17 at 15:07, Cameron B. Prince wrote:
So what error prints out when you try and connect from PHP?
Could not connect : Can't connect to MySQL server on '192.168.1.44' (2)
Not very helpful huh?
Any
Change your server address, to leave off the port number.
Any different?
$DBhost = 192.168.1.44;
$DBuser = web;
$DBpwd = user;
$DBreg = registration;
$DBconf = config;
# setup database handle and load configuration data
$dbh = mysql_connect($DBhost, $DBuser, $DBpwd)
or die(Could not
What does your MySQL error log say on your production database server?
It should be in the var directory named something .err.
On Wed, 2004-03-17 at 15:16, Cameron B. Prince wrote:
Change your server address, to leave off the port number.
Any different?
$DBhost = 192.168.1.44;
$DBuser
What does your MySQL error log say on your production database server?
It should be in the var directory named something .err.
These are SunFire 210 Solaris boxes. The MySQL is installed from binary. It
doesn't write a log by default as best I can tell, but I did find something.
The MySQL on
I would think the mysqlclient library would be backwards compatible, but
it's possible I guess. I'm kind of out of ideas, as the can't connect
error without something like a bad username or password message, seems
to indicate a TCP/IP communication failure.
On Wed, 2004-03-17 at 15:26, Cameron
I would think the mysqlclient library would be backwards
compatible, but it's possible I guess. I'm kind of out of
ideas, as the can't connect error without something like a
bad username or password message, seems to indicate a TCP/IP
communication failure.
Well, after thinking more
When you compile PHP --with-mysql=/path/to/mysql you will use the
libs from the installed MySQL dist , when using the bundled MySQL
libs by compiling --with-mysql you can use MySQL feature even if
you haven't installed on your maschine.
Am Samstag, 13. März 2004 19:24 schrieb Karl Timmermann:
So
No, there are no plans to bundle the client library with PHP5. We are
bundling SQlite instead. That of course doesn't mean any less support for
MySQL. The MySQL extension, 2 of them in fact in PHP5, will still be
there and you simply build it against your own copy of the MySQL client
library.
[snip]
I just can't find the forum for any mysql.
[/snip]
http://www.mysql.com/doc/en/Mailing-list.html
[snip]
anyways maybe someone run into this kind of problem, i'm saving in a db
records of company and in a column i have numbers i.e 1,2,12,31,32 so
if want to search a company that has
or just read the manual at mysql.com ..
Jay Blanchard [EMAIL PROTECTED] wrote:
[snip]
I just can't find the forum for any mysql.
[/snip]
http://www.mysql.com/doc/en/Mailing-list.html
[snip]
anyways maybe someone run into this kind of problem, i'm saving in a db
records of company
[snip]
or just read the manual at mysql.com ..
[/snip]
Top posting.
What's annoying?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Monday 08 March 2004 15:53, res0b8b6 wrote:
I am trying to use any of the image functions with image data from a
mysql database. I can get these functions to work from files on the
server but for some reason, not out of the database.
imagecreatefromstring() ?
--
Jason Wong - Gremlins
Five [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
I've been learning php/mysql by uploading my scripts to a php/mysql enabled website.
It's getting to be a drag uploading each script change to check if it works.
I think this can be done but wanted to double check before starting
[snip]
I can tell you if you install the server, install php using the windows
installer, and then try to run a php script, nothing happens
[/snip]
You cannot do it with the Personal Web Server. Might I recommend that
you download Apache for Windows? Then you can use PHP all day long.
--
PHP
Hey all.
I've developed a site builder application that allows my clients to build/maintain
their sites without my having to deal with tedious web design tasks.
The current version has some problems, however.
To resolve these issues I've switched over to an MVC (Model-View-Controller)
Five [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]
I've been learning php/mysql by uploading my scripts to a php/mysql enabled website.
It's getting to be a drag uploading each script change to check if it works.
I think this can be done but wanted to double check before starting
I think you've just answered your own question here:
I get a Can't Connect to MySQL Server error. I am not sure if it is
localhost, since my webserver is on a different machine with a different
name. The MySQL installation is on a different machine, separate from
the web server with its own
[snip]
How can I improve on the above to give specific error information.
[/snip]
Use mysql_error() http://www.php.net/mysql_error
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am prepared to be wrong (but I'm too lazy to go and try it)...
does MySql return a detailed enough error message to detect *which* field
caused the problem. IIRC, I don't think it does.
Anyway *if* it does it will be in here...
http://www.mysql.com/doc/en/Error-returns.html
DUP UNIQUE I
Hello Alessandro,
Friday, February 20, 2004, 1:31:02 PM, you wrote:
AV `code` int(20) default NULL,
AV so that seems that mysql has created a completely wrong key for this row!
AV my question is: is there a limit for the integer part of the index, or a bug
AV any suggestion would be very much
hi,
this is a php message board.
Logan McKinley wrote:
I am using MySQL (4.0.17) and am getting errors with the following SQL
statement originally writen for MS products.
SELECT
survey_questions.Question_ID,
First(survey_questions.Question_Text) AS FirstOfQuestion_Text, == this line
returns
If you can use Dreamweaver, you must use one extension to make this. Is very simple.
http://www.macromedia.com/cfusion/exchange/index.cfm
-
zerof
-
Pushpinder Singh [EMAIL PROTECTED] escreveu na mensagem
news:[EMAIL PROTECTED]
hello everyone.
I am using PHP and MySQL on my website.
Use mysql_result and u can use mysql_fetch_object, mysql_fetch_array also.
The following example will show u how to do it with mysql_result which will
retrive one row only.
From PHP Manual:
?php
$link = mysql_connect(localhost, mysql_user, mysql_password)
or die(Could not connect:
From: Angelo Zanetti [EMAIL PROTECTED]
I have a query which returns only 1 row, which of the following would be
the
best to get the value from the resultset:
mysql_result()
mysql_fetch_field()
mysql_fetch_row()
the resultset only returns 1 column, so basically its only 1 field i get
from
John Taylor-Johnston mailto:[EMAIL PROTECTED]
on Wednesday, February 04, 2004 9:48 PM said:
When I order by number, it echoes 1,2,3,4,5,6,7,8,9,10 and hten jumps
to 100...199 before it comes back to 11-19. Any way of ordering that
differently?
Sounds like your 'number' column is not
Thanks all. That solved the problem. I should have realised it. Still
learning ... :)
--
John Taylor-Johnston
http://compcanlit.ca/
Sounds like your 'number' column is not actually a number but a string.
Change it to type INT and that should fix it.
Chris.
--
PHP General Mailing List
Jason Giangrande wrote:
UPDATE link SET hits = hits+1 WHERE website_link = '$link'
$link is the website link that was clicked on.
The query works fine. The problem is if $link is a website that does
not exist in the database mysql_query(); still returns true even though
nothing was updated.
On Wednesday 28 January 2004 12:05, Jason Giangrande wrote:
I have the following query.
UPDATE link SET hits = hits+1 WHERE website_link = '$link'
$link is the website link that was clicked on.
The query works fine. The problem is if $link is a website that does
not exist in the database
Well let me try and describe a simplified version of what I am doing. I work
for a group of analysts, and they analyse technical products. Each products
has about 300+ fields associated with it, and each product is vastly
different from the other. Let's say the product foo has a table fields
Christian,
I did a bit of digging in the MySQL docs to try and find the limits on
number of fields in a table, etc. Didn't have much luck. I would not worry
about thousands, or even hundreds of thousands of rows in a table for two
reasons. First MySQL is becoming a heavier-duty database, and
Hey Mike,
That is almost exactly what I am doing. I have a table, lets say
product_fields which describes each characteristic/field of a product
(with N possible fields). A definition of a field includes, its name (as the
customer see's it), its type, a named-reference to the field in the data
From: John Taylor-Johnston [EMAIL PROTECTED]
Sorry, don't want to be off-topic, but have found something curious about
MySQL 4.0.16-standard.
It does not seem to prioritise properly. Searching for 'English Canada'
(as opposed to +English +Canada)
gives me all instances of both words but does
Christian,
A red flag is flying.
Usually, when people start talking about how the number of tables will
multiply in an application, there is a problem with the design of data
structures. If that's the case, now is the time to fix it.
Miles
At 05:35 PM 1/15/2004 +, Christian Calloway
I have a question
I have to select a group of person i.e
$query = SELECT * FROM table WHERE id = 10;
my question is that can we order order in random mode?? or do we have to
program it in php
any help is appreciated
Not a PHP question, but if you're using MySQL version 3.23.2 or later,
Hi
Add records with this code.
?php
$name=isset($_POST['name']) ? $_POST['name'] :'';
$address=isset($_POST['address']) ? $_POST['address'] :'';
if (!empty($name)) {
mysql_connect($server,$user,$pass) or die (Error conecting);
mysql_select_db($dbnamn,$conection) or die (no db .$dbnamn);
$query =
Hello Ashley,
Monday, January 12, 2004, 8:21:01 PM, you wrote:
AMK What I'd like to do is search for records that are between
AMK 2004-01-09 and 2004-01-04. The time is to be ignored, just the date is
AMK what I need to search by. Is there a way to do this within an sql
AMK query, or do I
From: Ashley M. Kirchner [EMAIL PROTECTED]
I need to query for record within a certain date stamp. The
datetime field contains the createdon information that i need and is in
the following format: 2004-01-11 21:40:50
What I'd like to do is search for records that are between
Richard Davey wrote:
RD SELECT whatever FROM table WHERE date_column_name BETWEEN '2004-01-09
RD 00:00:00' AND '2004-01-04 23:59:59'
Actually sorry, inverse the seconds (put the 00:00:00 onto the lower
date, the 4th) so it encompasses the whole period. You might actually
be able to not even
701 - 800 of 1710 matches
Mail list logo