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...?
You ought to tell your registration-page to redirect to itself right
after
July 6th? What are you talking about? Can you please give me more info
about that?
afan
Daniel Kullik wrote:
Note: You should checkout the thread 'Form Submission' started on July
6th since this is appearently not the best way to check if the user
hit the submit-button.
Daniel
--
PHP General
Afan Pasalic wrote:
Daniel Kullik wrote:
Note: You should checkout the thread 'Form Submission' started on July
6th since this is appearently not the best way to check if the user
hit the submit-button.
Daniel
July 6th? What are you talking about? Can you please give me more info
about that?
Afan Pasalic wrote:
July 6th? What are you talking about? Can you please give me more info
about that?
afan
Daniel Kullik wrote:
Note: You should checkout the thread 'Form Submission' started on July
6th since this is appearently not the best way to check if the user
hit the submit-button.
John Nichel wrote:
Afan Pasalic wrote:
Daniel Kullik wrote:
Note: You should checkout the thread 'Form Submission' started on
July 6th since this is appearently not the best way to check if the
user hit the submit-button.
Daniel
July 6th? What are you talking about? Can you please give me more
Oh!
:-)
Thanks...
John Nichel wrote:
Afan Pasalic wrote:
Daniel Kullik wrote:
Note: You should checkout the thread 'Form Submission' started on
July 6th since this is appearently not the best way to check if the
user hit the submit-button.
Daniel
July 6th? What are you talking about? Can you
Harlequin [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I've managed with a lot of help to get the PHP pages to echo the results
of
what a user put into a User Registration page. However, I'm still having
trouble getting the code right to actually commit the data on the
Registered
Torsten
I managed to work through it and this is the code:
$NewUserID=$_POST['TXT_UserID'];
$NewUserPassword=$_POST['TXT_UserPassword'];
$NewUserComments=$_POST['TXT_Comments'];
$query = mysql_query($sql);
$mysql_result = mysql_query ($sql, $Connection) or die (Invalid
Query - . mysql_error());
You're running the query twice. Take out that first line.
And I second the recommendation to please reply to the list and not
individuals unless they request it.
--
John W. Holmes [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
$query = mysql_query($sql);
$mysql_result = mysql_query ($sql, $Connection) or die (Invalid
Query - . mysql_error());
You're running the query twice. Take out that first line.
Michael, that's where your duplicate
Sorry about the Reply To Sender I was kind of busy and made that mistake.
I guessed from past experience of developing MS Access databases that I'd
assigned the primary key to the UserID which is fine but the duplicate
entries were a mystery.
Thanks for your help Torsten, John. I've cracked it
Craig. Thanks for the response and sorry I've been delayed in getting back
to you.
I put a new page together and dropped all the peripheral code and this is
what I ended up with:
?php
/* MySQL Connection Variables */
$host=localhost;
$user=arras_WebMaster;
$password=qwerty;
{
while($result = mysql_fetch_array($query))
{
echo $result['UserID'];
}
}
HTH,
Michael Egan
-Original Message-
From: Harlequin [mailto:[EMAIL PROTECTED]
Sent: 02 July 2004 09:34
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL QUERY Results Not Appearing[Scanned]
Craig
$result is an array that has to be fetched...try this
echo h3active members should appear here/h3;
$query = mysql_query(SELECT * FROM RegisteredMembers) or die(could not
execute query);
while($result = mysql_fetch_array($query)){
echo $result['YOUR_DB_FIELDNAME'];
}
change
I would have at least expected it give me 'margaret atwood' before it gives me
'margaret' and then 'atwood'.
Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I get results
in no real structured heirachy. Any thoughts?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH
John Taylor-Johnston wrote:
Sorry, MySQL question. Any takers? If I search for 'margaret atwood', I
get results in no real structured heirachy. Any thoughts?
SELECT ST,BT,AT FROM ccl_main WHERE MATCH (ST,BT,AT) AGAINST ('margaret
atwood' IN BOOLEAN MODE);h1Search font
I suppose it was mysql_close that was a problem but I am not secure. I am
new in this.
I have tryed to made registration page. I wish to that you can use one nic
name ony one time.
I hav use the following code:
body
?php include(header.inc);
if (isset($_POST['submit'])) { // Handle the form
Have you tried to specify the the handler of the connection, when you first
made the connection yo had somethig like:
$handler=mysql_connect(...);
...
...
...
mysql_close($handler);
Erik Gjertsen [EMAIL PROTECTED] ha scritto nel messaggio
news:[EMAIL PROTECTED]
I have problem with mysql_close
I
you should tell WHAT problem you have.
does it throw an error?
doesn't it work as expected ... ?
whats the matter?
thomas
On Sun, 20 Jun 2004 13:47:03 -0700 [EMAIL PROTECTED] (Erik Gjertsen) wrote:
I have problem with mysql_close
I dont understand why.
Are ther someone that have any
Whatabout :
mysql_fetch_array()
or
mysql_fetch_object()
Both gives you both the results and the names of the coloumns.
Maby I didnt get the question right but since nobody else mentioned it, .)
--
--
Kim Steinhaug
--
There are
There is an example in the User Contributed Notes on the
odbc_result_all() function page.
Scott Fletcher wrote:
I noticed there is no MySQL equivalent for odbc_result_all(), so it meant I
had to make a user-defined function from scratch. That part, I haven't been
able to do very well. Does
Some old piece of source i found in my libs:
function sql_dump_result ( $result ) {
$line = '';
$head = '';
while ( $temp = mysql_fetch_assoc( $result ) ){
if ( empty ( $head ) ) {
$keys = array_keys($temp);
$head =
'trtdb'.implode('/b/tdtdb',$keys).'/b/td/tr';
}
Ian Barnes [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
I am generating a mysql statement and then printing it to a formatted
field.
Here is my code:
$sql=SELECT * from tablename where name in ('Web','HTML','PHP') group by
name;
You are missing the closing quote here!
Hi,
Yes that was my mistake. But even with the code, it still doesnt display the
last one. If i didnt put a it wouldnt work at all.
Thanks,
Ian
-Original Message-
From: Torsten Roehr [mailto:[EMAIL PROTECTED]
Sent: 28 May 2004 13:56
To: [EMAIL PROTECTED]
Subject: [PHP] Re: Mysql
Jianping Zhu [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
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 see
Matt Palermo [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 structures and data in the dump. I know phpMyAdmin will do
On Wed, 24 Mar 2004 20:46:33 -0500, [EMAIL PROTECTED] (Andy B) wrote:
hi...
trying to figure out what is wrong here... the code is supposed to check an md5'd
password from a form and compare it against an md5'd password in a mysql table... for
some strange reason when i run the code below on
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
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. If any one has
gotten this to work, code you
You can't
well, not via PHP anyway. You would need to do a select first to establish
if any of these values exist in the database. Something like...
select first,last,email from mytable where first=x or last=y or email=z;
then check which one of first,last,email is non-empty.
BUT.. do you
Would advise mysql_fetch_row()
Angelo Zanetti [EMAIL PROTECTED] wrote in message
news:[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
make your column of type int column
-Original Message-
From: Ben Ramsey [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 7:52 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL: Order by
I assume number is a column name in your table. If so, I'm also
I assume number is a column name in your table. If so, I'm also
guessing that it's probably of a varchar (or some other character type)
datatype. Here's why: if it's a character, then ORDER BY will sort
alphabetically. The way it sorts number alphabetically is rather odd,
but it makes sense
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hi all,
I have a a timestamp in a DB (14 digits) that I want to display like I
want in my pages. I tried to use strtotime, mktime and date functions
with no success... it always return the current timestamp instead of the
one I have
did you also play with group by?
what does this return?
select * from `yourTable` group by `val1`
ciao SVEN
Petre Agenbag wrote:
Hi List
I've been trying to do something with one MySQL query, but I don't
think it is possible, so, I would need to probably do multiple
queries, and possibly
But what's your prob ?
When you say the second one seems to never be executed ...
Does the line:
$row = mysql_fetch_array($result2);
launches a Php Error ?
And pay attention, because you're using mysql_fetch_array and
mysql_fetch_row, be sure that
you are not treating the result in the same way
PROTECTED]
Sent: July 16, 2003 5:31 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL query problems
But what's your prob ?
When you say the second one seems to never be executed ...
Does the line:
$row = mysql_fetch_array($result2);
launches a Php Error ?
And pay attention, because you're using
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I know im probibly getting irritating to most of you :P but i thought i may
ask another thing that is on my mind!
I have a sql query bringing back 200 rows for arguments sake, From this i
would like an answer to 2 issues i have.
1)
Hello,
On 07/02/2003 04:05 AM, [EMAIL PROTECTED] wrote:
what command in linux , to see default direcktory instalation mysql
database dan mysql library
./configure ?
--
Regards,
Manuel Lemos
Free ready to use OOP components written in PHP
http://www.phpclasses.org/
--
PHP General Mailing List
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says...
I have the following code:
$sql = UPDATE class_sub SET desc = '$catdesc', sub_cat = '$subcatname'
WHERE id='$catid';
echo $sql;
$sql_result = mysql_query($sql);
if (!$sql_result)
{
echo PCouldn't update record!br/p;
Hy,
try with mysql_insert_id() [ if you've set the first field as index in
your table ].
Regards.
Harry.De [EMAIL PROTECTED] a écrit dans le message de
news:[EMAIL PROTECTED]
Hi,
if i insert into a mysql table a row e.g.
mysql_query(INSERT into TEST (testfield) VALUES ('This is a
What's up
Supposing that the filename of the you code is create_table.php.
Try tipping in the URL: create_table.php?nueva_base=prueba
EF.
---
Que tal
Suponiendo que el archivo del codigo se llama create_table.php.
Prueba poniendo el la URL: create_table.php?nueva_base=prueba
EF.
Felipe R.
Why not get MySQL to compare your date with today?
e.g.
select if(Booking_Date = curdate(),'booked','free') as Todays_Status ...
$Todays_Status = mysql_result($result,$i, Todays_Status);
echo you are $Todays_Status today;
I find it is much, much safer to only use the database for finding out
If I understand your requirement correctly I would say that you are looking
in the wrong place to protect particular table fields from the user; the
user gets access to the underlying database only through your 'application'
pages (ie. your php pages) - it is your coding of these pages that
try:
select
date_format(date_add(arrivaldate1, INTERVAL nights1 DAY), '%Y-%m-%d') as
dept_date1
from mytable
where
(date_add(arrivaldate1, INTERVAL nights1 DAY) BETWEEN '2003-02-01' AND
'2003-02-10')
regds,
-Original Message-
From: Dhaval Desai [mailto:[EMAIL PROTECTED]
Hi,
Thanx for yor reply. Well It worked for me with the same query when I used
HAVING instead of where. This is what I got from Mysql Database. However
the solution that you have showed is reall good as well.
Thanx
-Dhaval
From: Uttam [EMAIL PROTECTED]
To: 'Dhaval Desai' [EMAIL
, root, )||die(mysql_error());
i get
the message above about the error
- Original Message -
From: Hans Prins [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 21, 2003 11:07 AM
Subject: Re: [PHP] Re: Mysql DB connect failure
Would you care to explain to the rest
did you try:
print mysql_error();
Ml [EMAIL PROTECTED] schreef in bericht
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Currently I have some php code that displays a message if a connect to my
database fails. Is there anyway I
can get a more descriptive error message? So I can see exactly why
Where exactly would I put the print mysql_error() ?
Here is the code...
?php
@ $db = mysql_pconnect(localhost, test1, test1)
or
die(body bgcolor='#00'
br
div align='center'table border='22'trtd
img src='./images/dbdownw.jpg'
/td/tr/table/div
$db = mysql_pconnect(localhost, test1, test1) or die(mysql_error());
- Original Message -
From: ML [EMAIL PROTECTED]
To:
Sent: Friday, February 21, 2003 9:33 AM
Subject: [PHP] Re: Mysql DB connect failure
Where exactly would I put the print mysql_error() ?
Here is the code...
?php
Would you care to explain to the rest of the list how you intend to use
mysql_error () to return connection failure information?
It returns the text of the error message from previous MySQL operation
Description: string mysql_error ( [resource link_identifier])
Seems to me that without a
Would you care to explain to the rest of the list how you intend to use
mysql_error () to return connection failure information?
It returns the text of the error message from previous MySQL operation
Description: string mysql_error ( [resource link_identifier])
Seems to me that without a
You were right Prins, I got the error:
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
So I guess I need to investigate what this means now...
Thanks!
-ML
Hans Prins [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Would you care to
I see that its looking for mysql.sock in /tmp/mysql.sock
but I searched on my system and only found mysql.sock in /var/lib/mysql/
is there a section where I need to change this setting? or a conf file?
Hans Prins [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
From: ML [EMAIL PROTECTED]
To:
Sent: Friday, February 21, 2003 9:33 AM
Subject: [PHP] Re: Mysql DB connect failure
Where exactly would I put the print mysql_error() ?
Here is the code...
?php
@ $db = mysql_pconnect(localhost, test1, test1)
or
die(body bgcolor='#00'
Hi,
Saturday, February 22, 2003, 2:26:35 AM, you wrote:
M I see that its looking for mysql.sock in /tmp/mysql.sock
M but I searched on my system and only found mysql.sock in /var/lib/mysql/
M is there a section where I need to change this setting? or a conf file?
M Hans Prins [EMAIL PROTECTED]
Thanks for the comments everyone! eval() has just made my day :)
Cheers,
Daniel
Daniel Page [EMAIL PROTECTED] a écrit dans le message de news:
[EMAIL PROTECTED]
Hi,
Would it be possible to store PHP code in a MySQL table, then via a web
page, connect to the DB, recover the code that
Hi,
Tuesday, February 11, 2003, 7:39:16 AM, you wrote:
DP Thanks for the comments everyone! eval() has just made my day :)
DP Cheers,
DP Daniel
DP Daniel Page [EMAIL PROTECTED] a écrit dans le message de news:
DP [EMAIL PROTECTED]
Hi,
Would it be possible to store PHP code in a MySQL table,
Hello,
Can anyone help me with this simple query:
I want to limit to 1 the same names returned from the query like:
FROM:
SELECT gallery.design FROM gallery
buffet
buffet
buffet
buffet
barstools
barstools
barstools
barstools
barstools
barstools
barstools
http://www.php.net/manual/en/function.mysql-insert-id.php
Justin Garrett
Van Andel [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
m...
I have an application that updates two MySQL database tables. One table has
an auto_increment id field. I need to use this id to link to an entry in
Chris Shiflett wrote:
--- Cditty [EMAIL PROTECTED] wrote:
A co-worker is teaching me to move to the next level
in php. I have started using associative arrays for my
scripts, but I am having a problem using them to do an
insert into MySQL. Can someone give me an example of
how to do an insert
Cditty wrote:
A co-worker is teaching me to move to the next level in php. I have
started using associative arrays for my scripts, but I am having a problem
using them to do an insert into MySQL. Can someone give me an example of
how to do an insert to the database using these arrays? My array is
--- Cditty [EMAIL PROTECTED] wrote:
A co-worker is teaching me to move to the next level
in php. I have started using associative arrays for my
scripts, but I am having a problem using them to do an
insert into MySQL. Can someone give me an example of
how to do an insert to the database using
On Sat, 01 Feb 2003 10:26:10 -0600 [EMAIL PROTECTED] (Cditty) wrote:
A co-worker is teaching me to move to the next level in php. I have
started using associative arrays for my scripts, but I am having a problem
using them to do an insert into MySQL. Can someone give me an example of
how to
I'm running it in production since MySQL-4.0.2 and without any problems.
Thomas
On Wed, 22 Jan 2003 11:21:40 -0800 [EMAIL PROTECTED] (Joe Stump) wrote:
Anyone out there have anything to share as to using PHP4+MySQL4. I've been
hearing good things on the MySQL list about v4.0 and I'm
Perhaps setting the ini file socket info is bypassing php using the tcp port
directly. It should be going 'through' tcp/ip to get at the port mysql is
listening to and they talk through there. I'm on a windows box and have
limited experience with unix implementations, but on the one linux box I
Hi,
use mysql_list_tables();
HTH,
Bastian
Hacook schrieb:
I am really sorry but i can't find any good mySQL good mailing list...
How can i make a little php function to check if a table exists ?
Thanks a lot,
Hacook
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
Hello,
(B
(B"Peter" [EMAIL PROTECTED] wrote in message
(B[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
(B
(B...[snip]...
(B
(B the result of echo, $tmp is displayed as '0.0002'. What's wrong here?
(BThe
(B problem only occurs when the value is greater than a 1,000? Could the ','
(B
Thanks...the thing that I did wrong was I retrieved the number with
FORMAT(SUM(amount), 2), which formats the number and return it in the string
format...so that's what happened during the computation (it only took the
number prior to the ','. I miss the type-checking in C. :-)
Thanks,
-Peter
@
This might help
http://www.mysql.com/doc/en/Date_and_time_functions.html
Here is an example that uses date functions. The following query selects
all records with a date_col value from within the last 30 days:
mysql SELECT something FROM tbl_name
WHERE TO_DAYS(NOW()) -
[PLEASE do NOT reply-all to this message!]
Richard -
I hired Richard Lynch ([EMAIL PROTECTED]) to fix it for me and he did. It
appeared to be problems created by the new version of PHP and he had to
tweak some things to make it work. I'd talk to him.
Jeff
Richard [EMAIL PROTECTED]
Okay here is the new code and this is still not working.
?php
require(./config.php);
$sqlserver = $server1;
$sqlusername = $username1;
$sqlpassword = $password1;
$sqldatabase = $database1;
//**
$nam_bak=date('D,d-m-Y');
Can you have a filename with a
intranet
- Asesoría y Soporte Técnico
- Licenciamiento de Software
-Mensaje original-
De: Ken [mailto:[EMAIL PROTECTED]]
Enviado el: miércoles, 09 de octubre de 2002 22:36
Para: [EMAIL PROTECTED]
Asunto: Re: [PHP] Re: MySQL back up
Okay here is the new code and this is still not working
Okay, I took out all the reason for error, I took the variables out of the
code and replaced them with the actual values. I do not execute the gzip
function. All I get is an empty file. Also I made sure the back up directory
is set to 777.
Now phpMySQLAdmin will perform the same function, so
Here is the code I tired to use:
?php
session_start();
require(./config.php);
$sqlserver = $server1;
$sqlusername = $username1;
$sqlpassword = $password1;
$sqldatabase = $database1;
$nam=date('D,d-m-Y');
$db = mysql_pconnect($sqlserver, $sqlusername, $sqlpassword);
if (!$db)
{
echo
-Original Message-
From: Ken [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 7:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL back up
Here is the code I tired to use:
?php
session_start();
You don't need to start a session...
require(./config.php
: Ken [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 7:25 AM
To: [EMAIL PROTECTED]
Subject: [PHP] Re: MySQL back up
Here is the code I tired to use:
?php
session_start();
You don't need to start a session...
require(./config.php);
$sqlserver = $server1
Okay here is the new code and this is still not working.
?php
require(./config.php);
$sqlserver = $server1;
$sqlusername = $username1;
$sqlpassword = $password1;
$sqldatabase = $database1;
//**
$nam_bak=date('D,d-m-Y');
exec(mysqldump -u\$sqlusername\
Haven't really been following this thread but you may want to make sure that
1. mysqldump gzip are executable by apache
2. $backupdir is writeable by apache
3. You have taken into consideration your php safe mode settings
Cheers,
Owen Prime
http://www.noggin.com.au
Ken wrote:
Okay here is
Why don't you just do a hard backup of the files from the db. Find out the
location of the data folder where thd db saves its tables, perform a tar
cvzf data_folder and then pipe it directly to the user for download via
http.
Havent tryed it that way, but should work. Another thing would be
Why don't you just do a hard backup of the files from the db. Find out
the
location of the data folder where thd db saves its tables, perform a
tar
cvzf data_folder and then pipe it directly to the user for download
via
http.
Havent tryed it that way, but should work. Another thing would
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Hi All!
Anyone know how to code the MySQL command in PHP to make the database script
download to your local hard disk, without writing 100 lines of code?
I tried the mysqldump without any luck, but I think there is an easy way to
You know...maybe I should mention where this code is...
I have my main file which loads using 'require.once' a second file called
'everything.php'.
Inside everything.php is a class called 'mainclass' which is called by the
mail file.
This class ('mainclass') loads the MySQL class from the
Hi,
Thursday, October 3, 2002, 6:01:53 PM, you wrote:
O You know...maybe I should mention where this code is...
O I have my main file which loads using 'require.once' a second file called
O 'everything.php'.
O Inside everything.php is a class called 'mainclass' which is called by the
O mail
I thought someone might mention that, but that is actually correct.
The problem is that the variable assigned on the line
$this-DBLink[$MyVars[NAME]] = mysql_connect( $MyVars[HOST] ,
$MyVars[USERNAME] , $MyVars[PASSWORD] ); dissapears and can't be retreived
on the line mysql_select_db(
Here's a simplier version...and I'm still having a problem with it. It's
driving me insane!!! :)
class MySQL
{
function SET ( )
{
$this-MYVAR = Hello World!;
}
function RETREIVE ( )
{
print $this-MYVAR;
}
}
$helpme = new MySQL;
$helpme-SET;
$helpme-RETREIVE; /* Prints NOTHING */
-Original Message-
From: OrangeHairedBoy [mailto:[EMAIL PROTECTED]]
Sent: 03 October 2002 09:39
Here's a simplier version...and I'm still having a problem
with it. It's
driving me insane!!! :)
class MySQL
{
function SET ( )
{
$this-MYVAR = Hello World!;
}
Well, that's just a typo...of course there should be a () to make it call a
function...
The whole point to my postings is that I can't get the darn variable to stay
in place!!! Look where it says Prints NOTHING.
Does anyone know why it doesn't print Hello World???
::Lewis
Mike Ford [EMAIL
In my pages, I just format the date from the SQL query:
SELECT DATE_FORMAT(last_modified, '%m/%d/%Y %h:%i:%s %p') AS
last_modified (...)
Look up the DATE_FORMAT on mysql.com to get a list of the arguments.
Hope this helps!
-Jason
Bryan Koschmann - Gkt wrote:
Hello,
I have a table with
Hi Jason,
I had come across this earlier, and while I can get it to return
perfectly, I was more looking for something that I could do without having
to pull 2 queries. Err, well wait, I wouldn't have to would I? I have 4
columns:
idnum, title, date, news
I was just doing a select * from
No problem!
Refresh MY memory here.. I noticed you didn't return the DATE_FORMAT
column AS var .. is that working okay? I seemed to think that it
returned a long unwieldy column name.. maybe things are good.. let me
know :-D
--Jason
Bryan Koschmann - Gkt wrote:
Hi Jason,
I had come
This is what I am using here:
$db = DB::connect(mysql://$username:$password@$hostName/$databaseName);
if (DB::iserror($db))
die($db-getMessage());
$sql = SELECT idnum, title, DATE_FORMAT(date, '%W, %M %D \ %l:%i%p'),
news FROM newslist ORDER BY idnum DESC;
$query = $db-query($sql);
if
Christian Calloway wrote:
Can anyone suggest a strategy for importing data from MySQL to Access
(it sucks I know, but I have to do it for my work). I was thinking of
using a text-delimited file as an intermediate, but I am not quite
sure on the logistics.
You can use the Mysql-ODBC driver,
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
Can anyone suggest a strategy for importing data from MySQL to Access (it
sucks I know, but I have to do it for my work). I was thinking of using a
text-delimited file as an intermediate, but I am not quite sure on the
logistics.
I had the problem a few days ago.
Here's some software that makes it easy as clicking a button -
http://www.convert-in.com/sql2acc.htm
Be warned though, it's only free to copy table structure. It requires
registration to copy data.
Christian Calloway [EMAIL PROTECTED] wrote in message
[EMAIL
Thanks.
That's fine, it's either $55 for this or a couple of hundred to pay someone
to do it manually.
Go figure ;-)
Cheers,
Liam
- Original Message -
From: M1tch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 21, 2002 3:51 AM
Subject: [PHP] Re: MySQL Access
I
Hi Steven,
Some precisions : after taking a look at my mail, I noticed the very first
time I saw this error was with PHP 4.2.1 and MySQL 4.0.2 (reported on this
list on 27 june 2002).
Regards,
Jocelyn
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Jocelyn Fournier'
Hello Jocelyn and Steven,
Could either or both of you submit a bug report at http://bugs.php.net/? If
you follow the instructions there, it will greatly help us in tracking down
the issue!
Cheers!
Zak Greant
PHP QA Team
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
Hmm, do you use pconnect or connect?
I noticed someone changed our PHP script to use persistent connections
(likely why the server is running slower). I am wondering if a cancelled
connection is being reused or if it just is a more general bug in the
mysql client code in PHP
Sincerely,
I've always used pconnect.
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Jocelyn Fournier' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: 'Mysql' [EMAIL PROTECTED]
Sent: Friday, September 20, 2002 2:38 AM
Subject: RE: MySQL errors in newer PHP 4.2.3
Hmm, do you use
function mysql_one_element($query, $element) {
// quickly returns just one element from a query
$one=mysql_query($query);
// add error checking here if you wish
$r=mysql_fetch_array($one);
$thisvalue=$r[$element];
return($thisvalue);
}
$row=mysql_one_element(select euro from
101 - 200 of 308 matches
Mail list logo