Re: [PHP-DB] Getting SQL queries from existing DB
Get and install phpMyAdmin. It can dump to you, the stucture, the data or both. Then save them from the browser(better with lynx because you can get the source of a page piped). And pipe it to another "mysql", or use it in another phpMyAdmin. Andrey Hristov IcyGEN Corporation http://www.icygen.com 99% - Original Message - From: "Adriana Matiaskova" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 26, 2001 12:39 PM Subject: [PHP-DB] Getting SQL queries from existing DB > Does anyone have some scripts/program for creating SQL queries from existing MySQL >database? I mean, it will create queries like CREATE TALBES... to be able to make Database with the same structure. Thanks. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] DISTINCT in SQL query
Hi Guys,
I am retriving information based across three tables, here is the SQL
statement
SELECT DISTINCT title, filelocation, filename, ranking, summary FROM pdf,
words, searchwords WHERE words.id = searchwords.word_id AND pdf.id =
searchwords.pdf_id AND LCASE(words.word) LIKE LCASE('%$searchstr%') ORDER BY
ranking DESC;
The only problem is, the return set has duplicated rows. But I think I may
have a problem in the words table. I am indexing pdf files and they each
have upto 15 search words, but some of the rows in the words table aren't
words, but instead three or four words, ie.
script (this is a word in one row)
server script (these words are in the second row)
So the query is picking up script in both cases due to the %% in the LIKE
clause, is there anyway to remove the duplicate rows or do I have to have
only one word in each row in the words table?
Hope this makes sense... let me know if it doesn't and I'll re-write it ;)\
Thanks
Scott.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] mysql select where problem
select * from shows where date >= '$year-$month-01' and date <=
'$year-$month-$lastdayofthemonth'
- Original Message -
From: "Matt Nigh" <[EMAIL PROTECTED]>
To: "php-db" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 7:09 AM
Subject: [PHP-DB] mysql select where problem
hello again,
i'm stuck with this mysql query and can't seem to get it right
// start code
$result = mysql_query("select * from shows WHERE date >= '" . $year . "-" .
$month . "-" . ("00") ."' AND where date <= '" . $year . "-" . $month . "-"
. ("31") ."'");
// end code
and yes, $year and $month are both defined earlier in the code.
essentially what i want to do is have the 'date' field be equal or greater
than -**-00 (ex. 2001-08-00) and equal or less than -**-31 (ex.
2001-08-31). i need this so that it selects only the given records within
that given month.
if anyone can help or at least point me in the right direction, i'd really
appreciate it. i've looked at the mysql docs and haven't found anything for
what i'm looking for.
thanks in advance,
Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] mysql select where problem
hello again,
i'm stuck with this mysql query and can't seem to get it right
// start code
$result = mysql_query("select * from shows WHERE date >= '" . $year . "-" . $month .
"-" . ("00") ."' AND where date <= '" . $year . "-" . $month . "-" . ("31") ."'");
// end code
and yes, $year and $month are both defined earlier in the code.
essentially what i want to do is have the 'date' field be equal or greater than
-**-00 (ex. 2001-08-00) and equal or less than -**-31 (ex. 2001-08-31). i need
this so that it selects only the given records within that given month.
if anyone can help or at least point me in the right direction, i'd really appreciate
it. i've looked at the mysql docs and haven't found anything for what i'm looking for.
thanks in advance,
Matt
[PHP-DB] Re: oracle 9i + apache
Maybe some problems with libraries ... Add Oracle libs to /etc/ld.so.conf and run ldconfig ... (RedHat distribution, I do not know where is the config file on Suse ...) [EMAIL PROTECTED] >>> "TDuquette" <[EMAIL PROTECTED]> 24.8.01 19:23 >>> Hi As anyone sucesfully compiled php4 with OCI suport as an apache module on a Oracle 9i database ? if so i would be very intersted by some tips on how make it work. i couldnt make it , on a linux Suse7.2, kernel 2.4.4 i have been able to suceffuly compile php statically, making a symlink from libclntsh.so.9.0 to libclntsh.so.8.0 if i run "php" as a comand interpreter for a script ,the script will sucefully use OCI8 function. hoever this does not seam to work for a php apache module. apache wont start (at least for me) i tried on the oracle apache java server, or on the suse pre installed one .. i olso tried to compile php on this sytem, but using withOCI="dir to an old copy of oracle8" so it would really link with the v8 librarys ... it dont works neither. i havent tried yet to make php as static lib to build apache with it as a static build-in module. but this is not really an option i can have on production for that system.(i have to use a third-party apache binary) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: go to another URL
"Andrius Jakutis" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> What is the command in PHP coding, to order go to another URL?
header("Location: newurl");
Note that this must be sent before any
of the message body.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] for what?
"Alexandre Santos" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Donald Fei wrote:
> >
> > When i execute the following codes:
> > > $db=dba_open("database.db","c","db2");
> > ?>
> > an error occurs:
> > Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line
2
> Have you compiled PHP with support for that? I don't think so...
>
> Alex
My PHP runs under:
Windows 2000 Professional + Apache/1.3.20 + PHP4.0.6 + MySql3.23.32
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: help me with DBA
Donald Fei wrote:
>
> When i execute the following codes:
> $db=dba_open("database.db","c","db2");
> ?>
> an error occurs:
> Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line 2
Have you compiled PHP with support for that? I don't think so...
Alex
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] help me with DBA
When i execute the following codes: an error occurs: Warning: no such handler: db2 in D:\Inetpub\WebSite/dba_test.php on line 2 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] go to another URL
Hello, What is the command in PHP coding, to order go to another URL? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Getting SQL queries from existing DB
Does anyone have some scripts/program for creating SQL queries from existing MySQL database? I mean, it will create queries like CREATE TALBES... to be able to make Database with the same structure. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: Re: [PHP-DB] Error with in_use() from Beginning PHP4 book.
See http://php.weblogs.com/adodb_csv You create a proxy on Windows server and query access via the Windows server. "Vijay Anand" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... how to access MS Access database using adodb in unix -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: PostgreSQL connections within classes & collisions.
I have very smilar code and they are working for me. I'm using - PHP4.0.6 and PHP4.0.7RC1 - PostgreSQL 7.1.3 They are built from source. Your PHP might be linked against older libpq(?) than your PostgreSQL? -- Yasuo Ohgaki Justin Buist wrote: > I recently did a re-install of PostgreSQL and php4 on Debian, which has > broken some development code here. None of the actual code has changed in > days, which I can verify against the CVS tree, so I know it's one of two > things: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: PostgreSQL connections within classes & collisions.
I have very smilar code and they are working for me. I'm using - PHP4.0.6 and PHP4.0.7RC1 - PostgreSQL 7.1.3 They are built from source. Your PHP might be linked against older libpq(?) than your PostgreSQL? -- Yasuo Ohgaki Justin Buist wrote: > I recently did a re-install of PostgreSQL and php4 on Debian, which has > broken some development code here. None of the actual code has changed in > days, which I can verify against the CVS tree, so I know it's one of two > things: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
