Matthew Newby wrote:
> I am having trouble with the pg_fetch_result function when trying to access
> a boolean field in a PostgreSQL database. Here's the code snippet:
It's a spec.
PostgresSQL's boolean is returned as 't' or 'f' and both are string.
Test as string.
--
Yasuo Ohgaki
--
PHP Da
try phpMyAdmin - nice and easy, although i'm pretty sure there is a direct
command line.
// -Original Message-
// From: Dr. Indera [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 4 September 2002 12:21 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Upload csv file into mysql
//
//
//
Hello,
Is there a way to upload data in a csv file into a mysql table?
Thanks
Indera
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I got it to work My problem was I didn't put include in function. So the
class file should be like this
link = mysql_pconnect($sqlhost,$sqluser,$sqlpasswd);
if (!$this->link) {
printf("Could not connect to sql server");
}
mysql_select_db($sqldatabase);
}//end of function connect
}//end of c
try this.
- Original Message -
From: "Bryan McLemore" <[EMAIL PROTECTED]>
Newsgroups: php.db
To: "PHP LIST" <[EMAIL PROTECTED]>
Sent: Tuesday, September 03, 2002 9:27 PM
Subject: mysql_connect
I'm trying to connect using the sample code in the php documentation. IT
however dies every
In article <000c01c253b2$506d7530$0101a8c0@fwcmain>, [EMAIL PROTECTED]
says...
> I'm trying to connect using the sample code in the php documentation. IT however
>dies every time. If someone could please help me? Thanks.
>
> Bryan
>
Can you show the code you are using, and any error message
can't you just make the name of the file include a unique identifier of some
sort, or store each user's files in a different directory or something, to
make sure that they can't overwrite each other's (or their own) files?
Or would that not work in your app?
HTH
Beau
// -Original Message--
I'm trying to connect using the sample code in the php documentation. IT however dies
every time. If someone could please help me? Thanks.
Bryan
I must concur, Chapters 28 & 29 are worth the price of the book!
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ignatius Reilly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 03, 2002 9:49 AM
To: [EMAIL PROTECTED]; Matt Zur
Subject: Re: [P
I do have the same problem since I did update to the newest version of
phpmyadmin.
This seems to be a bug in the new release since everything was working ok
before the update. guess those guys are gonna release a .1 version pretty
soon.
andy
"Kasper" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
These should be helpful:
http://zc8.net/zc8/shownews.php?articleid=93
http://zc8.net/zc8/shownews.php?articleid=95
http://zc8.net/zc8/shownews.php?articleid=98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi I made this.
link = mysql_connect($sqlhost,$sqluser,$sqlpasswd);
$select = mysql_select_db($sqldatabase,$this->link);
}
}
?>
link);
$row = mysql_fetch_array($result);
echo "$row[title]"
."$row[firstname]";
?>
What I'm trying to do is make a function or class that I can call u
We are developing Web applications on Red Hat 7.3, Apache (latest), PHP
(latest), Microsoft sql (latest) to display customer, inventory, and order
pages. Looking for very strong PHP consultant experienced with MS sql to
help with knotty problems. Near Los Angeles or Pacific Time Zone is a plus.
Hi there, I've been hunting thru the net trying to find some info on
inserting data to multiple tables.
I have two tables (LookupTable and MainTable):
LookupTable(
FirstID
SecondID
)
MainTable(
ID
Name
Address
etc
etc
)
Once I insert data into the MainTable I want to also insert the ID from th
I'd endorse "SQL for Smarties", plus just about anything else JC has
written on SQL.
Another good book is "The Practical SQL Handbook" by Bowman, Emerson &
Darnovsky, ISBN 0-202-44787-8
For a tutorial have a look at Julie Meloni's at http://www.thickbook.com.
They are "single issue" tutorial,
Try
SELECT name, COUNT(*) AS nb
FROM mytable
GROUP BY name
ORDER BY nb DESC
Ignatius
"RClark" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello all,
>
> I have a MySQL database with some 2 million rows in it. I am counting
all
> of the different names
For a SQL tutorial, I would recommend that you get yourself a copy of Joe
Celko's "SQL for smarties".
Best investment I ever made. Everything you need to know is there.
Bon courage!
- Original Message -
From: "Matt Zur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, Septembe
Hello all,
I have a MySQL database with some 2 million rows in it. I am counting all
of the different names in one column. How to I get these to come out in
descending order, with the most numbers of one event at the top and going
down from there?
Thanks in advance,
Ron Clark
--
PHP Databa
Just one more to throw on the fire:
Pretty basic tutorial that covers a lot of topics. If you buy the book,
there's a little more depth. On my first day working with PHP/MySQL, I had
basic pages up and running.
http://www.webmasterbase.com/article/228
Incidentally, this same question was asked
http://www.mysql.com/doc/en/Tutorial.html is a good place to start with the
mysql functions in the php manual.
http://www.devshed.com/Server_Side/ has a number of on line tutes amongst
others.
phpbuilder also is useful. The normalisation article is a good first step; it
is at
http://www.phpbui
On Tue, 03 Sep 2002 08:56:43 -0400
Matt Zur <[EMAIL PROTECTED]> wrote:
> Can someone point me in the direction of an online tutorial for php
> mysql that covers the following:
http://www.phpbuilder.com
http://www.devshed.com
http://www.devarticles.com
Well, if you do not find something here :-
Right well that's what I'm asking I need a tutorial and haven't found a
good one.
-Matt
Rasmus Lerdorf wrote:
> Most of this stuff is actually just SQL and has little to do with PHP. So
> look for an SQL tutorial. From the PHP side all you need to know is
> mysql_connect(), mysql_select_db(),
Most of this stuff is actually just SQL and has little to do with PHP. So
look for an SQL tutorial. From the PHP side all you need to know is
mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().''
All queries are sent to the database via mysql_query(). It doesn't matter
to
Can someone point me in the direction of an online tutorial for php
mysql that covers the following:
- Teaches me how to use php to access mysql
- Creating a db that is structured to be efficient
- How to add, modify, and delete records in a database
- How to search for records
- How to filter r
this function doesnt work
function query($sql)
{
return mysql_query($sql, $this->mysql_link) or die("query
failed: $sql");
}
but this one does
function query($sql)
{
$mysql_result = mysql_query($sql, $this->mysql_link) or
d
Hi, id'like to know the opinion about to ensure external file integrity.
Scenario: A web application that uses binary files( images, PDF's ).
On the database ( postgresql 7.2.2 ) i store the filename of the files.
The files ( images only ) are taken from an internal machine when needed(
via ftp
> >
> > To insert the record I use this code:
> > $sSql = "INSERT INTO myTable (time_in ) VALUES ( getdate() )";
>
> try something like
> $sSql = "INSERT INTO myTable (time_in ) VALUES ( getdate() ); SELECT
> @@IDENTITY";
>
> works with the Perl DBI at least.
>
> :-)christian
>
But if I get the I
27 matches
Mail list logo