CRO8

where is the perl interpreter located?

super fantastic - thnx.

Hi All: I am setting up script formail so my client can have customers fill out a form, and info gets emailed to his email account, then customers receive a ‘thank you’ email. So I was wondering where is the location of TCH server’s send mail program? Thanks!

Thanks bruce. I'll check cpanel. Thanks

Hello all: Built a mysql dbase and using php to interact with it. My client now wants to have an option for people to enter their emails so he can send out special monthly offers. can someone recommend a script that stores emails with the intent on sending mass mailings either on a regular basis or whenever my client wants to send them? I am new to this and appreciate any advice. Thanks! CRO8

sounds good

thanks so muc for all your help- I got my page to work next up applying CSS. Thanks!

ok cool I will try it tonight. page link I provided will not work b/c I fiddled with code . . . Thanks!

hey thanks guys- weird how it displays fine in other browsers and not IE and Opera 7. Anyways, btrfld's idea seems to work in incrementing the results but I lose control over positioning . . . the results

huh, weird. Im on IE 6 and the results overlap eachother . . .

Hello all: I tried to use CSS to control page positioning for this line of code that prints results of a query, location is correct but it keeps printing over each other: >// simple loop to display all the results in the array if ($row = mysql_fetch_array($result)) { do { print "<div id='print_category'><center><b>" . $row['name'] . " " . "<font color='blue'><u>" . $row['offer_url'] . "</u></font>" . " " . $row['c_code'] . " " . "</b></center></div>" . "<br><br>\n"; } this page show that my results are printing in middle of page, on one line. I understand why. It keeps printing over each other. How can I get it to print on separate lines? Thanks!

Thanks guys. I think Robert has it. Let me explain. User logs on and sees homepage, where there is a menu on left side, banner ads up top. User clicks on "button 1" on left menu, the hyperlink passes "1" to my php page which returns results, but I want the results to be presented within a page with the same layout as homepage (left menu, banner on top, etc) so, to the user, nothing has changed layout wise, just that now there is new info in body of page- layout remaining the same. Makes sense? Let me go home tonight and play around and re-post. Thanks! *9 hours later, biz day ends* You know I put the code inside a <td></td> of a table and the page is blank, but when I view source I can see the correct results.

ok, I did a search on TCH for "tables and mysql" but found nothing. Anyway, making progress with my project. I have a mysql/php page presenting correct results But I want to incorporate tables on my page and create columns and rows for the info. I tried to put my code within a table and I get a blank page. What am I missing? What are the rules with using tables and php/mysql? Thanks!

ok thanks!

I would like to fwd all my AOL mail to my new Outlook. Now, how can I find out what AOL info to enter in incoming mail and outgoing mail? Or is there a way . . . Thanks!

nice- thanks Mike J. I'll give that a shot and see what I can do.

Hello All I must say I am impressed with TCH. Very nice. I am using php/mysql. My question involves the sql query in my .php file receiving the info passed from html file. Now this query works >$result = mysql_query ("SELECT column_1 FROM table_1 WHERE id LIKE '".$id."'"); This works fine. I pass an id of 1 and the correct table row prints. Now, if I am using multiple tables (see below)- I get error messages. Below is based off of what I am trying to do. I tried to replicate the code I am using as best I could- w/o actually revealing names of tables, etc. >$result = mysql_query ("SELECT column 1, column 2, column 3 FROM table 1, table 2, table 3 WHERE id = '".$id.2"' AND id = '".$id.3."' AND id.3 = '".$1."' ORDER BY column 1"); Can PHP read spaces in table names?

hey guys I'm in my dbase - thanks for everything

Thanks Rob- got to run to work I will get back to you later tonight. Thanks!

hey thanks - yeah I put cPanel-name_ before just the username and left the password by itself. Still not giving me access. I double checked and name/password/db is correct. I tried cpanel username and password still not giving me access. hey- just read Rob's comment. My username to enter cpanel is different than the registered user for the db.

ok I am still getting an error message saying acess is denied for user cPanel-name_xxxxx_xxxx@localhost Is this what you meant by adding "cPanel-name_" to the front of username and password? Thanks!

ahhhhh. I am not. I’ve been away for the weekend and have not looked at it but I think I am just using username and password by themselves. Let me put "cPanel-name_" before password and username and see if it works. I’ll re-post. Thanks!

Thank you Lisa- its does help but you know I just realized my partner already logged into cpanel and received a dbase username/password which I correctly used. We did create a dbase and entered some test info into it. Any other reason why I cannot connect? Thanks!

ok thanks Lisa- I'll follow your instructions and re-post with my progress. Thanks! CRO8

Hey guys- I’m trying to access my db using the code supplied by TCH in my welcome email. This is the code, with xxxx as password (I trust you guys but, well you know ) >$dbh=mysql_connect ("localhost", "xxxxxxx", "xxxxxx") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("xxxxxxx"); I get message saying "Access denied for user: 'xxxxx@localhost' (Using password: YES)" FYI The code I have from a hyperlink to the php file is as follows: <a href="Greg_couponpile.php?xxx=1"> Is my php file saved in correct Public_html folder? Hmmmmm. What am I missing? Thanks!