On Tuesday 03 December 2002 23:09, Chase wrote:
> I am the first to admit that this question belongs on a MySQL newsgroup
> instead of here, but I can't seem to find a newsgroup that will answer
> me...
www.mysql.com
> Here is a newbie question. I am running a Win2K Advanced Server with IIS
> 5,
I did that and it didn't output anything...
- Original Message -
From: "Brad Bonkoski" <[EMAIL PROTECTED]>
To: "Stephen" <[EMAIL PROTECTED]>
Cc: "PHP List" <[EMAIL PROTECTED]>
Sent: Sunday, December 01, 2002 2:55 PM
Subject: Re: [PH
Perhaps you should try and do some error checking on the mysql_select_db()
function, like printing out mysql_error().
Also, for the permissions issues, mysql has a very comprehensive online
documentation on user permissions. Check them out, you may also wish to try
and connect to the database wit
> I'm displaying the content of a mysql table with autoincrement index.
I
> want to be able to select the each row from the table using the check
> boxes. In order to do that, i want to assign to each checkbox the
> name=index of selected row.
> I assign to the checkboxes the value of selected id,
http://www.phplens.com/ might be something you could use.
"Michael P. Carel" <[EMAIL PROTECTED]> wrote in message
002d01c295b8$f0301800$[EMAIL PROTECTED]">news:002d01c295b8$f0301800$[EMAIL PROTECTED]...
> hi to all;
>
> sorry for posting this mysql question again. im searching for a report
> buil
Hello,
"Snijders, Mark" <[EMAIL PROTECTED]> wrote:
> hello,
>
> For connection data between my site, and another site, I need to export my
> MySql data to a XML file.
>
> Does anybody know any excisting scripts for this? so I don't have to make
it
> all myself?
Have you checked the latest versio
>From now on ask this on a MySQL list, please.
> 1.How many tables can be created inside a database? There is a maximum
> number?
Only limit is how many files your file system will allow in one
directory.
> 2.Is it possible to erase a table?
Yes
---John Holmes...
--
PHP General Mailing Lis
On Friday 22 November 2002 02:12, Jule Slootbeek wrote:
> I have a problem,
> i know this is not the MySQL mailinglist, but i hope you guys can help
> me.
> when i type mysqladmin variables the port comes up as 0 and doesn't let
> people connect to my db remotely.
> does anyone know why this proble
In article <003001c28a86$cab1dce0$[EMAIL PROTECTED]>,
[EMAIL PROTECTED] says...
> I have php (as an apache module) and mysql up and running on Windows in the same
>computer, but they seem to be unconnected.
> How do I configure php.ini, my.ini, etc for a php script to find and query a
>database
SELECT DECODE(ENCODE('password', 'sec'), SUBSTRING("secret",1,3));
if you put quotes around substring function, mysql considere it as a string,
so I think you shouldn't.
After, are you sure that the correct table field name is the weirdthing
encoded by this function : ENCODE('password', 'sec') ???
> I'm using php with MySql.
> I'm migrating an php-oracle application to php-mysql. I need to know
if
> exists any function in mysql similar to the "to_char" or "to_date"
> functions
> of oracle; or "format" function of access?. These functions make a
date
> format or numeric format.
>
> ex: to_c
[snip]
if anyone is on the mysql list why do i keep getting this , i can post
anything dammit
To bypass the filter you must include one of the following words in your
message:
sql,query
[/snip]
Follow the directions to make sure the message gets to the list. My original
reply to this got bounced
Well, if both tables are in the same database:
select * from books inner join publishers on books.publisherid =
publishers.publisherid
this assumes that the key for the publisher is publisherid and that
publisherid also appears in the book table.
This gives you a result set that contains the a
> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
> but I only get the number 10, when the total should be around 100. So,
> can I get total matched rows without doing a separate query using
> count()?
You first have to get the whole result set without the limit OR make use
Have you tried out mysql function load_file() to upload directly your file
into the database without passing through php variable ?
Like this:
$result=MYSQL_QUERY("INSERT INTO master_products
(image_thumbnail,image_thumbnail_name,image_thumbnail_size,image_thumbnail_t
ype) VALUES
(load_file('$fo
Try adding header('Content-length: ' .strlen($data)); header
Darren McPhee wrote:
I have written 2 programs (which are very common PHP
programs) that A) Allows me to upload image files into a MYSQL database
using a simple form. And B) Allows me to retrieve and display the image
using a PHP scri
Yes...off topic...
Join the table with itself.
untested...
SELECT t1.shopnumber, t1.item from table t1, table t2 where t1.shopnumber =
1 and t1.shopnumber = t2.shopnumber and t1.item != t2.item
Something like that?? Play around with it...
---John Holmes...
- Original Message -
From: "
There are times, especially in highly dynamic situations, where backing up
and restoring of images and metadata from a database or for security
reasons, where storing the images within a database makes real sense.
Separating the physical storage areas for the two types of data (metadata &
images) a
Know that, believe that, been preaching that, but I just want to know just
in case.
Actually found the article.
-Original Message-
From: Rick Emery [mailto:remery@;emeryloftus.com]
Sent: Tuesday, October 29, 2002 8:46 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL and images
In order
In order to speed-up queries, it is suggested that you DO NOT store images in the
database. Rather, store the images in files and store file names in the database.
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 2002 9:32 PM
Su
On Thu, 17 Oct 2002, 1LT John W. Holmes wrote:
> > My logging application is feeding a MySQL database with data records
> > that are time stamped with GMT time. I would like to query the database
> > for records matching local time(eg. all records created on oct
> > 17,2002 local time). I woul
> My logging application is feeding a MySQL database with data records
> that are time stamped with GMT time. I would like to query the database
> for records matching local time(eg. all records created on oct
> 17,2002 local time). I would prefer if the records could be formated
> in local time
To the server.
On Thu, 17 Oct 2002, Smith, Benjamin wrote:
> Local to the client or local to the server?
>
> -Original Message-
> From: Jason [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 17 October 2002 3:26 PM
> To: php_gen
> Subject: [PHP] MySQL GMT --> Local time
>
>
>
> My logg
Local to the client or local to the server?
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 17 October 2002 3:26 PM
To: php_gen
Subject: [PHP] MySQL GMT --> Local time
My logging application is feeding a MySQL database with data records
that are time stamped w
Try something like:
Fields("AccountActivationDate"), 'l, F jS
Y H:i:s') ?>
THIS E-MAIL MESSAGE AND ALL ATTACHMENTS TRANSMITTED HEREWITH ARE TRADE
SECRET AND/OR CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE VIEWING AND
USE OF ADDRESSEE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED
RECIPIE
What Unix? and Version?
Timothy Hitchens (HITCHO)
[EMAIL PROTECTED]
HITCHO has Spoken!
-Original Message-
From: Jeff Schwartz [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 12 October 2002 9:40 AM
To: PHP List
Subject: [PHP] Mysql not functioning after upgrade to 4.2.3
I just upgr
I am just recompiling against your config for you to see for myself...
sometimes I find
it helps to compile the cgi or cli version ..eg remove the apxs config
then do a listing
of modules compiled in from the shell...
Won't be long...
Timothy Hitchens (HITCHO)
[EMAIL PROTECTED]
HITCHO has Sp
it has 4.1 down here i'm upgrading to 4.04 Pro beta to check it out
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, October 12, 2002 1:09 AM
To: 'electroteque'; [EMAIL PROTECTED]
Subject: RE: [PHP] mysql stored procedures
Hi,
>
Hi,
> when is this being implemented ?
Go and ask on the MySQL list. Version 5 was the last I heard.
Cheers
Jon
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Fri, 11 Oct 2002, electroteque wrote:
>-when is this being implemented ?
Perhaps in version 4.1 of the MySQL server.
Have a look near the bottom of this page...
MySQL 4.1, the following development release
http://www.mysql.com/products/mysql-4.0/index.html
>-
>-
>-
>---
>-PHP Genera
> > Are you using POST or GET for your form? Show some code...
>
> I use get. But I tried to post and look ok. Why this difference ?
>
> Christian,
>
You can only send so much data through GET, because the URL is limited
as to how long it can be. It may be different for each browser, but I
thi
> Are you using POST or GET for your form? Show some code...
I use get. But I tried to post and look ok. Why this difference ?
Christian,
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
> I have a form with a textarea. When I put a long text(one word page
for
> example), when I submit, the form is not submitted. I have to remove
> some line to submit. I don't have any limit in the textarea. The
content
> of this form is sorted in a MySQL database. I tried to set the field
> where
Look into the logs, they should be more verbose. How did you install the
three.
BB wrote:
>I seem to have a php-mysql problem on my new Sun Qube3 (RH Linux).
>php works fine, mysql works fine, apache works fine, only the combination of
>the three seems troublesome.
>php does not recognize comma
ok - thanks for all the replies. it looks like there are no real
drawbacks and plently of advantages in using MySQL instead of text files,
so i'll do the next project with it. one more question - is there a
concrete file that has the database in mySQL? like a file that I could
download and view
Hi Doug,
on 22/09/02 9:25 AM, Doug Parker ([EMAIL PROTECTED]) wrote:
> often i use text files at my data sources, delimted by the "|" symbol.
> i simply delimit the fields of each line, then when i need to open them,
> i open the text file, populate an array with each line, then explode the
> fi
Speed
Accessability
Features
Security
Performance
Simplicity
Reusability
Indexing
Record-Locking
To name a few.
however, in your situation, it's an existing application which is working
great and which no one has any complaints over. If it ain't broke, don't
fix it.
For your next application,
I was doing this too with good old AWK CGI scripts and text data files.
Once I imported the data into MySQL I said, "Well this is not much
benefit." Then I started sorting. Then I accessed the information from a
different application. Then I wrote a maintenance application so my
customer could
"Doug Parker" <[EMAIL PROTECTED]> wrote:
> i was wondering
> if there is anything i'm not thinking of that perhaps would push me to
> favor using php and mysql instead of the plain old text file.
It sounds like you're basically asking why one would want to use a
relational database. Standardiza
Well, one major advantage I have found using MySQL verses txt files is the
simple implementation of transactions, if you are doing multiple
transactions that are related, it is nice to simply "rollback" all other
statements if one fails or "commit" if they work. Of course you can do this
other way
Use this:
$result = mysql_query("SELECT PASSWORD(" . $_POST['password'] . ")");
$password = mysql_result($result,0);
or just use mysql_fetch_row() or AS in your query so you don't have to
recreate that complex column name.
---John Holmes...
> -Original Message-
> From: Murat Ö. [mailto
In (most) SQL servers there is no concept of 'row number'. Most DA's design
tables with a unique primary key. This can be used to identify the row form
all of the other rows but it is not the same as a 'row number'.
Since you are using PHP you can set a counter to 1 before your loop and then
incr
> $sql2_results = mysql_fetch_array($top_level);
I guess this must be in a loop otherwise your $sq12_results keep getting
overwitten; thus,
the last record will be shown at the end.
> $query_sql2_rows = mysql_num_rows($top_level);
>
> echo $query_sql2_rows;
> // echo's 2 rows
>
> print " cell
gt; for ($counter=0; $counter < $query_sql2_rows; $counter++) {
> $tabledata = mysql_fetch_array($top_level);
> echo "$tabledata[0]";
> echo "$tabledata[6]";
> echo "$tabledata[2]";
> echo "$tabledata[3]";
> e
Hello, Steve,
When you call mysql_fetch_array the first time, you are accessing the data
from the first row of your results and then moving the pointer to the next
row. So, when you call mysql_fetch_array the second time, it is already
starting with the second row of your results. Try something l
;
}
print "";
-Original Message-
From: Brad Bonkoski [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 3:34 PM
To: Steve Gaas
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL and Array's REALLY simple question but I'm not
GETTING it .. Ugh..
Well, when you
Well, when you run the command:
$sql2_results = mysql_fetch_array($top_level);
The first time, it automatically increments the result...
so you fetch the data bu do nothing with it...
so when you get to your loop, you are already at the second entry in
your database..
So, remove the first inst
Hi David,
in PHP, you can not access associative arrays with index numbers
(and your mysql row arrays will be of the associative kind).
But Chris posted a kludge recently:
//snip
Just for kicks ... here's something pretty ugly (I'd never use it), but
neat if you're interested (or somehow real
I did some more testing and I found that I forgot the first field in the
columns section of the Statement. So now it looks like this:
I also copy and pasted the statement into PHPMYADMIN and it worked fine. It
just doesn't work here
function AddSignupRequest($Signup_FName, $Signup_LName, $Si
>
>
> Is there a better way to do it?
>
> Randy
>
>
> - Original Message -
> From: "Rasmus Lerdorf" <[EMAIL PROTECTED]>
> To: "Randy Johnson" <[EMAIL PROTECTED]>
> Cc: "Rodrigo Peres" <[EMAIL PROTECTED]>
t; <[EMAIL PROTECTED]>
To: "Randy Johnson" <[EMAIL PROTECTED]>
Cc: "Rodrigo Peres" <[EMAIL PROTECTED]>; "PHP" <[EMAIL PROTECTED]>
Sent: Thursday, August 22, 2002 10:52 AM
Subject: Re: [PHP] mysql upate return false?
> mysql_affected
mysql_query($sql_statement) or die ("Couldn't run UPDATE statement");
Adam
On Thu, 22 Aug 2002, Randy Johnson wrote:
> I have a function
>
>
> update_trans();
>
>
> in a mysql_query() that processes an update, what could i check for to see
> if it was successful or not.
mysql_affected_rows()
On Thu, 22 Aug 2002, Randy Johnson wrote:
> I have a function
>
>
> update_trans();
>
>
> in a mysql_query() that processes an update, what could i check for to see
> if it was successful or not. The update only updates 1 row.
>
> Thanks
>
> Randy
>
>
>
> --
> PHP General
Using SQL or PHP?
> -Original Message-
> From: Djurovski Dejan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 15, 2002 11:42 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] MySQL to csv
>
>
> Hi
>
> Can someone show me how to export MySQL table to a csv file?
>
> Thanks!
>
>
>
> -
Assuming that you KNOW the structure of the table, this should do it... if
you needed something more open-ended to cope with ANY table, I'd have to
think about it a little more:
This is all off the top of my head, untested, with snippets lifted from the
manual, but it should give u the theory,
[snip]
Can someone show me how to export MySQL table to a csv file?
[/snip]
>From http://www.mysql.com/doc/en/SELECT.html
The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected
rows to a file. The file is created on the server host and cannot already
exist (among other things
Rasmus Lerdorf wrote:
>
> Sure it can.
I ran some test and it can't. If I run the same tests without using SSL
there is no problem. But if I go from an SSL to a non-SSL connection the
session variable stays registered but it loses it value somehow ...
> If the machine name is different make su
Sure it can. If the machine name is different make sure you set your
session.cookie_domain to something like .domain.com but other than that
there shouldn't be anything to it. As long as you propogate the session
id somehow to the script, when session_start() is called in that script it
will pic
I'm interested in finding out the answer to this since it seems that I
will need to implement my own session handler.
I need to pass session information from SSL connections to non-SSL
connections (albeit on the same server) and PHP doesn't seem to be able
to do this ...
Jc
--
PHP General
I'd have to say that I haven't done any controlled tests, but mysql can be
very slow when you are doing a lot of connections (correct me if I'm wrong,
but I think it executes requests in order?).
To be untechnical about it and only speak from experience (if I was a
typical internet user, I'd thin
U must write:
mysql_query(INSERT INTO cast SET Rick='$Rick', Blaine='$Blaine',
Humphrey='$Humphrey', Bogart='$Bogart', male='$male');
The stuff with the $ before them are variable that contain the info u
want to put into the word that don't have the $ those words are the
cells in your database.
Yes, thank you very much, I shouldn$B!G(Bt code late at night without any
caffeine in me.
- Vic
-Original Message-
From: @ Edwin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 12:29 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql error
Looks like
it's the WHERE clause, it's illegal there.
what are you trying to do? if you want to change the heading & paragraph
columns of every row in malibu_data where the page_name & par_id match
your values, this should be an UPDATE.
if you want to create a new record in malibu_data for every record
th
Looks like you're updating your table so instead of "INSERT INTO...", try:
"UPDATE malibu_data SET ..."
HTH,
- E
>
>I get this error:
>
>Error submiting paragraph.You have an error in your SQL syntax near
>'WHERE page_name='features' AND par_id='13' ' at line 1
>
>
>But my code, I think is fin
> Mmm.. think you misinterpreted my question...
>
>
> http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
>
> PASSWORD(str)
> how do you unPASSWORD(str) in PHP?
Basically, you don't.
Instead, what you do is use the password that was provided as user
input. You create a suitable
ECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2002 4:31 PM
Subject: Re: [PHP] MySQL password()
> Try doing on the first time this:
> $query="SELECT * FROM users where username='$PHP_AUTH_USER' and passwd
> =password($PHP_AUTH_PW)";
> then wi
>My server is running on shared server which has support for PHP 4.1.2. I
>installed mySQL for our shared server. I also installed phpMyAdmin. Both
>are running properly. But I am facing following problems
>
>1) If there is any error in the script - It is not getting displayed -
>screen is beco
>I am currently working on a website that is implemented using PHP and MySQL.
>
>The site currently has a simple search engine that allows a shopper to type
>in a search string that is stored in $search. For example, if a shopper
>types in 1972 Ford Mustang
>$string ="1972 Ford Mustang"
>
>Using t
Congrats! Good choice!
Take a look here:
http://www.convert-in.com/acc2sql.htm
or here:
http://www.google.com/search?hl=en&lr=&ie=ISO-8859-1&q=convert+access+databa
se+to+mysql
Jim Grill
Support
Web-1 Hosting
http://www.web-1hosting.net
- Original Message -
From: "Christian Calloway" <[E
> From: "Christian Calloway" <[EMAIL PROTECTED]>
>
> Sorry this may be a little offtopic, but I am currently moving a site I was
> developing from coldfusion+MSAccess to PHP+MySQL. I remembered reading
> somewhere that there is a utility that will convert/transfer (data and
> structure) a MSAcess
On Thu, Jul 25, 2002 at 02:51:13PM -0400, Anup wrote:
> 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 i
well, you could simply loop through the session vars and build the query as
you go.
$query = "SELECT * FROM Inventory WHERE";
// I'm assuming you keep your item numbers in a "items" or something similar
foreach ($HTTP_SESSION_VARS['items'] as $pid)
$subquery .= " ItemNumber = '$pid' OR ";
//
where that's the only
access they provide. It's very much a pain in the butt...
---John Holmes...
- Original Message -
From: "Justin French" <[EMAIL PROTECTED]>
To: "Peter" <[EMAIL PROTECTED]>; "kip" <[EMAIL PROTECTED]>;
<[EMAIL PR
I encountered that same timeout problem once, and I wound up just installing
my own copy of PhpMyAdmin in an .htaccess protected directory on the server,
and extending the time limit there. It only took about 10 minutes to set
up, and as an added bonus it was a more recent version of PhpMyAdmin t
utt...
---John Holmes...
- Original Message -
From: "Justin French" <[EMAIL PROTECTED]>
To: "Peter" <[EMAIL PROTECTED]>; "kip" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 11:29 PM
Subject: Re: [PHP] MySQL Backu
Can highly recommend doing it (and a whole lot more) with phpMyAdmin
(http://phpMyAdmin.net)
Justin French
on 24/07/02 1:04 PM, Peter ([EMAIL PROTECTED]) wrote:
> grab ur self a copy of myphpadmin or use mysqldump or just simply make a
> copy of the data dir or grab ur self a copy of mysql_
base and use this:
mysql -uuser -ppassword database_name < filename.sql
---John Holmes...
> -Original Message-
> From: Peter [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 23, 2002 11:04 PM
> To: kip; [EMAIL PROTECTED]
> Subject: RE: [PHP] MySQL Backup and Restore
&
grab ur self a copy of myphpadmin or use mysqldump or just simply make a
copy of the data dir or grab ur self a copy of mysql_front
> -Original Message-
> From: kip [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 24 July 2002 12:58 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP] MySQL Backup a
Or you can use the error_log functions within your function, instead of
fopen/fwrite/fclose.
---John Holmes...
> The easiest way to do this would be to write a wrapper function to
> mysql_query() that does the writing to the log file and also executes the
> query and returns the result set.
>
>
The easiest way to do this would be to write a wrapper function to
mysql_query() that does the writing to the log file and also executes the
query and returns the result set.
function my_mysql_query($query)
{
//assuming file would already be open...
global $fp;
$return = mysql_query(
>I have created a table which has a column called cost. How do I add up all
>the numerical data in the cost column and display that on a webpage?
--
Like Music? http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.ph
Justin French wrote:
> try add_slashes($string) before inserting into the database, or turn on
> magic quotes in php.ini
Or
Mysql_Escape_String()
http://www.php.net/manual/en/function.mysql-escape-string.php
Or
Mysql_Real_Escape_String()
http://www.php.net/manual/en/function.mysql-real-escape-
try add_slashes($string) before inserting into the database, or turn on
magic quotes in php.ini
justin french
on 15/07/02 5:57 PM, Wilbert Enserink ([EMAIL PROTECTED]) wrote:
> Hi all,
>
>
> has anybody ever seen this? And knows what it means?
> thx.
>
> You have an error in your SQL syntax
> can I use limit to show the 2nd record on without knowing
> how many more records there might be?
>
> also, what happens if I set the limit in a mysql statement
> (LIMIT 5,10), but there are only 3 results? 7 results?
My answer would tend to be that you should try it for yourself and
s
Alexander Ross wrote:
>
> can I use limit to show the 2nd record on without knowing how many more
> records there might be?
>
> also, what happens if I set the limit in a mysql statement (LIMIT 5,10), but
> there are only 3 results? 7 results?
This looks like a question that could be answered w
ðÒÉ×ÅÔ!
John Holmes wrote:
> Gesundheit
>>*if* that was on Oracle *and* the table was big you'd notice that your
>>performance goes down. Don't ask me why. And I never checked it on
>>MySql. But watch out for betweens. Check them.
>
> Yes, good point. I don't know if it matters in MySQL either, b
> ðÒÉ×ÅÔ!
Gesundheit
> 1LT John W. Holmes wrote:
> > How about
> >
> > SELECT * FROM table WHERE $current_shot BETWEEN start_shot AND
end_shot
>
> *if* that was on Oracle *and* the table was big you'd notice that your
> performance goes down. Don't ask me why. And I never checked it on
> MySql.
ðÒÉ×ÅÔ!
Alexander Ross wrote:
> I realize this isn't a php question, but I figured that someone here knows
> of a good mysql newsgroup and in the mean time someone here probaby knows
> the answer to my question.
>
> Can I set up a query like this:
>
> select * from table where start_shot <= $cu
ðÒÉ×ÅÔ!
1LT John W. Holmes wrote:
> How about
>
> SELECT * FROM table WHERE $current_shot BETWEEN start_shot AND end_shot
*if* that was on Oracle *and* the table was big you'd notice that your
performance goes down. Don't ask me why. And I never checked it on
MySql. But watch out for betweens
ohn Holmes...
- Original Message -
From: "Miles Thompson" <[EMAIL PROTECTED]>
To: "Alexander Ross" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 12:24 PM
Subject: Re: [PHP] mysql question
> Yes, though I'd probably add
Yes, though I'd probably add parentheses to make it clearer.
select * from table where ((start_shot <= $current_shot) and (end_shot >=
$current_shot))
Though that's probably not necessary. Make certain you have your less
than's and greater thans set the right way, I've often sat slack-mouthed
>Does MySQL support parameterized queries (e.g., "INSERT INTO table
>(Col1,Col2) VALUES (?,?)"), and if so, is there a PHP function that allows
>you to create and attach parameters to MySQL queries?
I don't believe MySQL supports that, so there's no PHP mechanism for it.
However, you *can* inser
You need to install php-mysql* too.
Jadiel Flores wrote:
>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 conf
Wilbert Enserink wrote:
> Later on in my script I'm calling the value of this column with php.
> $query="select * from tblA LEFT JOIN ";
it's been said over and over :) NEVER EVER write a select * query...
use syntax
Select
a.column1,
a.column2,
b.column1
from
tbl1 as a,
thx Jason,
now I understand the use of aliases in select queries.
Good ID:-)
Wilbert
- Original Message -
From: "Jason Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 04, 2002 11:38 AM
Subject: Re: [PHP] mysql/php how to retrieve the right
On Thursday 04 July 2002 17:23, Wilbert Enserink wrote:
> Hi all,
>
>
> I have to tables A and B.
> They boyh have a column with the same name.
>
> Now, I wrote this MySQL statement performing a left join.
> This results in a data set with rows consisting of 2 columns of the same
> name, in which
> Yep, I was using the DATE() function in PHP to convert a
> TIMESTAMP from a MySQL DB query. I was getting a year of
> 2038 because MySQL and PHP use different TIMESTAMP formats.
> $getmyTime = mysql_query("SELECT UNIX_TIMESTAMP(timestamp_col)
AS yournamehere FROM
> myDBnamehere WH
Yep, I was using the DATE() function in PHP to convert a TIMESTAMP from a MySQL DB
query. I was getting a year of 2038 because MySQL and PHP use different TIMESTAMP
formats.
There are several FUNCTIONS that convert the two TIMESTAMPS from one to the other,
(see comments in PHP manuals) but I w
Can you post some example code. I know that 2038 is the maximum for a MySQL
date column, but I don't know how you'd be setting it to that...
---John Holmes...
- Original Message -
From: "Shane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 12:38 PM
Subject: [PHP
Hi Shane,
use SYSDATE().
Mirza [EMAIL PROTECTED]
01.07.2002 18:38
> 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 s
1101 - 1200 of 1780 matches
Mail list logo
