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, , I am trying to use yields an error in the browser of: < Couldn't connect to MySQL > Here is the script. --- Birthdays Create Database $dbho

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? http://mydomain.com/photos/acoolpic.jpg";>My Cool Photo <>Mos Wrote: RE:>>The code only becomes clickable when viewed from a browser so you need to retrieve the html string from the datab

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? http://mydomai

Re: Newbie--Easy data loading question

2002-05-27 Thread Andrew Lietzow
't bump into permissions 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

Re: Servers & Tables

2002-05-27 Thread Andrew Lietzow
n't get out 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 req

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

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

2002-05-24 Thread Andrew Lietzow
. 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, Inc. On Wednesday 22 May 2002 09:17 am, Andrew Lietzow wrote: > Dear My

Re: can't connect to server

2002-05-24 Thread Andrew Lietzow
ables, do some simple selects, 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

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

Help with REPLACE INTO statement syntax

2002-05-23 Thread Andrew Lietzow
with the last the conditional statement reversed. MySQL doesn't like my syntax. The field names in A are identical to B. TIA for any help. -- Andrew Lietzow The ACL Group, Inc. - Before posting, p

Re: Help a newbie please

2002-05-23 Thread Andrew Lietzow
ffered in HTML through your browser. Maybe you'll get so good so quickly that you can come back here and help people like me with technical questions! Good luck! Oh, and no one here will kill you. Flame you, maybe, but not "kill you". Ciao! Andrew Lietzow The ACL Group, In

Help needed with CREATE Temporary Using SELECT TO TWO TABLES

2002-05-22 Thread Andrew Lietzow
tatement and then write the temporary 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 1

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

2002-05-19 Thread Andrew Lietzow
matches found in database"; push (@table,$q->th(["ML_ID", "Cultivar", "Reg_Status", "Section","Class","ML_ITG_ID","Registrant"])); # Loop through all the matches and store them in @table for (my $i = 0; $i <

Script fails during MySQL access attempt.

2002-05-16 Thread Andrew Lietzow
itialized value in string eq at select.cgi 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?

Re: Help with UPDATE and SET with two tables

2002-05-14 Thread Andrew Lietzow
, that is where I am. I'm trying to avoid 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. -

Help with UPDATE and SET with two tables

2002-05-13 Thread Andrew Lietzow
ble, etc. 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.

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

2002-03-25 Thread Andrew Lietzow
e easier to hang all of the illegally intruding b*$#(@+s until we 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 PROTE

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

2002-03-23 Thread Andrew Lietzow
e at the command line, why 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/m