Go Back   CodingForums.com > Search Forums

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 25 of 171
Search took 0.67 seconds.
Search: Posts Made By: 1andyw
Forum: MySQL 08-15-2012, 11:51 AM
Replies: 6
Views: 606
Posted By 1andyw
Resolved: Union Issue

Bingo, UNION ALL is the answer.
OP makes a problem go away, again.
My old eyes appreciate your help.
Thank you!
Forum: MySQL 08-15-2012, 01:16 AM
Replies: 6
Views: 606
Posted By 1andyw
Union Query Results Problem

Hi,
I have a union query with 8 select statements and a group by clause. This is incremented monthly with the new months data table added to the query. The query results do not increase when the...
Forum: PHP 07-03-2011, 07:05 PM
Replies: 12
Views: 646
Posted By 1andyw
This work? "INSERT INTO tablename...

This work?

"INSERT INTO tablename (`field1name`,`field2name`,`date`) VALUES ('somevalue','somemorevalue',CURDATE())";
Forum: JavaScript frameworks 06-30-2011, 01:16 PM
Replies: 4
Views: 415
Posted By 1andyw
[QUOTE=emericana;1106930]This is my code. ...

[QUOTE=emericana;1106930]This is my code.

<head>
<script type="text/javascript">
$(document).ready(function() {
('#ajaxnext').click(function () {
('#deal1').load('terms.php');
});
});
Forum: JavaScript frameworks 06-01-2011, 06:22 PM
Replies: 3
Views: 1,328
Posted By 1andyw
Abduraooft, I used your code and that solves...

Abduraooft,

I used your code and that solves the problem.

Thank you, again.

Andy
Forum: JavaScript frameworks 06-01-2011, 06:09 PM
Replies: 3
Views: 1,328
Posted By 1andyw
<?php error_reporting(E_ALL); echo<<<EOD ...

<?php
error_reporting(E_ALL);
echo<<<EOD
<form id="lunch_eligible" name="lunch_eligible" action="lunchupdatepost.php" method="post">
<select id="diner" size="20">
EOD;
include("conlocal.php");...
Forum: JavaScript frameworks 06-01-2011, 04:05 PM
Replies: 3
Views: 1,328
Posted By 1andyw
How to include white space in form select input

How can I include white space in a select form option value and have it sent via post still including the white space?
sql to populate table 'lunch':

>>>
$name=$lname . ", " . $fname;...
Forum: PHP 03-12-2011, 03:46 PM
Replies: 15
Views: 1,568
Posted By 1andyw
Bruce, Do you jquery? this came...

Bruce,

Do you jquery?



this came from: http://api.jquery.com/load/

Andy
Forum: MySQL 03-05-2011, 07:37 PM
Replies: 0
Views: 354
Posted By 1andyw
Forum: PHP 02-16-2011, 01:53 AM
Replies: 1
Views: 421
Posted By 1andyw
How to echo query results

Hi,

My query returns an array. My usual method of printing the results of a query is:
WHILE ($row=mysql_fetch_array($result)){
$ctVerified=$row['Verified'];
$ctNonVer=$row['NonVer'];...
Forum: MySQL 02-09-2011, 04:46 PM
Replies: 7
Views: 1,044
Posted By 1andyw
Matt, The <form> element is missing.

Matt,

The <form> element is missing.
Forum: JavaScript frameworks 02-07-2011, 06:40 PM
Replies: 6
Views: 1,212
Posted By 1andyw
Works perfectly and I can now understand why. I...

Works perfectly and I can now understand why.
I have printed this post for reference.
Thank you on all points.

Andy
Forum: JavaScript frameworks 02-07-2011, 05:34 PM
Replies: 6
Views: 1,212
Posted By 1andyw
I listed the select#status three times in the...

I listed the select#status three times in the jquery, just trying to find one that would pass info. Seems like the variable is just never created so there is no value to hook on to. The text fields...
Forum: JavaScript frameworks 02-07-2011, 02:40 PM
Replies: 6
Views: 1,212
Posted By 1andyw
I post the related form without selecting any...

I post the related form without selecting any option but it submits anyway.
Forum: JavaScript frameworks 02-07-2011, 09:45 AM
Replies: 6
Views: 1,212
Posted By 1andyw
Now to determine if select option is empty

I'm trying to validate a form select option. If select is ignored, an alert should be displayed. Select id is 'status'.
if($("select#status option").val()===''){alert("Make a selection in the Status...
Forum: PHP 01-05-2011, 02:13 PM
Replies: 1
Views: 437
Posted By 1andyw
How to trace message generated by mail()

My php mail() function correctly sends emails to several addresses. It skips my address on verizon.net. Simply disappears. Never arrives at Verizon. How can I trace the process to identify the...
Forum: PHP 12-26-2010, 04:42 PM
Replies: 8
Views: 1,040
Posted By 1andyw
What happened to those links you had listed in...

What happened to those links you had listed in the past?
Forum: PHP 12-24-2010, 04:19 PM
Replies: 5
Views: 729
Posted By 1andyw
Thanks. I followed your suggested link and...

Thanks.
I followed your suggested link and arrived at this solution:
Problem solved.

:)
Forum: PHP 12-24-2010, 03:44 PM
Replies: 5
Views: 729
Posted By 1andyw
Thanks, DJCMBear. That got me back in business. ...

Thanks, DJCMBear. That got me back in business.

This is a new warning for me:

I didn't find a listing for timezone in php.ini or httpd.config.
Happen to know what file I should look in?
...
Forum: PHP 12-24-2010, 03:04 PM
Replies: 5
Views: 729
Posted By 1andyw
No error reporting in upgrade to 5.3.4

Hi,

Lost my error reporting after upgrading apache, php and mysql.

Now running 2.2.17, 5.3.4, and 5.5.8.

Set the php.ini to

Write my script with
Forum: MySQL 11-16-2010, 07:34 PM
Replies: 23
Views: 1,934
Posted By 1andyw
Thanks, again.:thumbsup:

Thanks, again.:thumbsup:
Forum: MySQL 11-16-2010, 05:40 PM
Replies: 23
Views: 1,934
Posted By 1andyw
SELECT 'goods' AS donationType , d_id ...

SELECT 'goods' AS donationType
, d_id
, `date`
, goods
, NULL
FROM donor_gifts
WHERE ev_id = 7
UNION
SELECT 'receipts'
, d_id
Forum: MySQL 11-16-2010, 04:33 PM
Replies: 23
Views: 1,934
Posted By 1andyw
bazz, No, the column 'goods' is in the...

bazz,

No, the column 'goods' is in the donor_gifts table. The construction of the UNION select doesn't make sense to me, except when you involve identical information between tables. In this case,...
Forum: MySQL 11-16-2010, 03:44 PM
Replies: 23
Views: 1,934
Posted By 1andyw
bazz, It returned this: Andy

bazz,

It returned this:

Andy
Forum: MySQL 11-16-2010, 03:24 PM
Replies: 23
Views: 1,934
Posted By 1andyw
Old Pendant, Ran the new query with this...

Old Pendant,
Ran the new query with this result:

I'm still lost.
Showing results 1 to 25 of 171

 
Forum Jump

All times are GMT +1. The time now is 06:45 AM.