Help with PHP to MySQL db connection

2004-09-29 Thread Andrew Lietzow
Hola, MySQL wizards. I'm using LAMP on Fedora Core 2. Some kind soul produced a tutorial on the net and the first script, birthdays_create_database.php, I am trying to use yields an error in the browser of: Couldn't connect to MySQL Here is the script. ---

Re: Adding hypertext data element into record ...

2004-09-26 Thread Andrew Lietzow
Thank you for your replies, Mos (and Sol): So, is there there a way to store the following in a data record? a href=http://mydomain.com/photos/acoolpic.jpg;My Cool Photo/a Mos Wrote: RE:The code only becomes clickable when viewed from a browser so you need to retrieve the html string from the

Adding hypertext data element into record ...

2004-09-25 Thread Andrew Lietzow
I've looked all over the mysql.org website, for data element/column types, and find no reference to storing data as a link to an html document or blob. I am thinking this can be done but need help with syntax. So, is there there a way to store the following in a data record? a

Re: Help with REPLACE INTO statement syntax

2002-05-27 Thread Andrew Lietzow
At 21:27 -0500 5/23/02, Andrew Lietzow wrote: Dear MySQL wizards, I have two tables, call them a and b. The database structure is identical. I want the records in b to overwrite the records in (REPLACE INTO) a. This is the statement that does NOT work. REPLACE INTO a SELECT b.* FROM b

Re: Servers Tables

2002-05-27 Thread Andrew Lietzow
of it, eh? -- Andrew Lietzow The ACL Group, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Newbie--Easy data loading question

2002-05-27 Thread Andrew Lietzow
issues. I don't lke setting a fill to 777 but prefer 755. Others can help with greater accuracy but this may be of some help for the future. Andrew Lietzow The ACL Group, Inc. On Friday 24 May 2002 08:44 am, Menard, Inc. Information Systems wrote: I figured it out but I'm a bit confused

Re: can't connect to server

2002-05-24 Thread Andrew Lietzow
, then come back here for your next assignment. :-) Ciao! Andrew Lietzow The ACL Group, Inc. On Thursday 23 May 2002 12:33 am, you wrote: Hello, I have the mysql server running. I can't connect to it though. It reads, Can't connect to local MySQL server through socket '/var/lib/mysql

Help using CREATE Temporary SELECT from two TABLES--Problem now solved

2002-05-24 Thread Andrew Lietzow
back to the drawing board on that one. We need more examples in the documentation. Does anyone post these? Should mere mortals like I be providing such examples without any quality control? Hope this routine can save someone else time and frustration... Ciao! Andrew Lietzow The ACL Group

Re: php+apache+mysql installation. Help!

2002-05-23 Thread Andrew Lietzow
Dear Andy, Here's a thought. Before you go much further, install Apache 2.0.36. It's easy to install and lots of improvements will be gained that you'll appreciate down the road, i.e. mod_ssl is preconfigured into the system. Andrew Lietzow The ACL Group, Inc. On Thursday 23 May

Help needed with CREATE Temporary Using SELECT TO TWO TABLES

2002-05-22 Thread Andrew Lietzow
table out to disk so that it becomes permanent? Alternatively, I might be able to use a JOIN statement but I can't use this with the mySQLMan, of which I am aware. TIA for any help, Andrew Lietzow The ACL Group, Inc. On Saturday 18 May 2002 11:41 am, mySQL list wrote: Hi

Search Query input works, but gives a blank page for results?

2002-05-19 Thread Andrew Lietzow
$q-end_html; } -- Andrew Lietzow The ACL Group, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

Script fails during MySQL access attempt.

2002-05-16 Thread Andrew Lietzow
line 18. main::(select.cgi:18): if ($q-param('field') eq ) {printform()} else {results()} Any ideas where I can find what is wrong with this code? Or a better way to access a mySQL database with a Perl Script? Examples? TIA, -- Andrew Lietzow The ACL Group, Inc

Re: Help with UPDATE and SET with two tables

2002-05-14 Thread Andrew Lietzow
exporting to a spreadsheet or another language -- I want to do this all within MySQL, if possible... That's my problem. TIA for any help... -- Andrew Lietzow The ACL Group, Inc. - Before posting, please check

Help with UPDATE and SET with two tables

2002-05-13 Thread Andrew Lietzow
. It seems like this should be a common thing to want to do but a gentleman yesterday on the SuSE list said that this may not be possible with MySQL. If not, can I write the Query results of the SELECT statement out to a new table and delete the original table? TIA for any help. Andrew Lietzow

Thanks to whomever... for the tip on mySQLMan...

2002-03-25 Thread Andrew Lietzow
eradicated them from the planet? Andrew Lietzow The ACL Group, Inc. alias Number 1 Plantsman at http://hostahaven.com - Original Message - From: Brian Bray [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 25, 2002 11:35 AM Subject: fulltext server as replication client

Re: Access denied for user: (from perl script)

2002-03-23 Thread Andrew Lietzow
would it not be unable to connect when using the perl install routine? TIA for any help. Andrew Lietzow The ACL Group, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http