Search:

As usual you pull your hair out, ask for help and suddenly the answer pops out of knowhere:

SELECT
SUM(a.net) AS net,
a.date
FROM
table_a a
WHERE
a.date = '2007-05-31'
AND b.counter > 0

I'm trying to get a calculation from my sql, which requires joining two tables in order to check the criteria of the rows. The problem is that the second table contains multiple rows and the SUM...

you could create a many to many table..

user_paintings
user_id
painting_id

Then you simply SELECT painting_id FROM user_paintings WHERE user_id = '<USERS ID>'

When the swf is loaded I use loadAndSend() to pass and XML string to a server script, the server script users this to gat the game data then returns the game data as XML.

In IE this works fine,...

Not sure about SSI but with PHP you can do this easily. Create a file called navigation.html, then copy the code for this part of the site into it, then in it's place in you pages put the line:
...

I am endeavouring to run a flash .swf which uses the xml.sendAndLoad() function. I have created the application and all works fine in Internet Explorer.

However when I load it in Firefox, although...

Assuming you are trying to seperate the words so as to split "My search string" so the query will look for "My", "search" and "string" you could do the following:



// Get array of key words...

try Freeola.com - Unlimited disk space / e-mail addresses. If you don't have a domian you can use one of theres (Free1000) domain names i.e.
ukdots.com - so yours would be myname.ukdots.com.
...

You could set it by default:
$main_page = "wordpress";
-Or-
$_REQUEST['main_page'] = "wordpress"

safest way would probably be to put this at the top of yout page:


if...

I would probaly create a class object, and instantiate a new copy for each branch in the tree, then use a recursive function to link them together, storing the a unique branch value in each object,...

If you search for PHP MS WORD you may find some sites offering a package for building word documents for you - I know there is one for Excel in the PEAR database,

Otherwise you can produce PDF...

I think you could send a packet of data 'message or whatever' by connecting to www.consultant.com by using fsockopen(), or fopen().

Depending on what you are trying to achieve?

if you split the date field for each quote into $day and $month, your if could be something like:


if ($day = date("d") && $month = date("m") {
... Found a match for today ...
} else {
......

Erm, your code looks a bit nasty - how about you do this,


$bgcolor = "white"; // Set bgcolor to white
while(!$rs_employeeqa->EOF) {

if (strcmp($bgcolor, "white") == 0) {
...

SELECT fields FROM table WHERE date >= [1st date] AND date <= [2nd date];

e.g. for all rows between 1st and 31st of January
SELECT fieldsFROM table WHERE date >= 2006-01-01 AND date <=...

check you php.ini file is correctly configured for sending mail, I think I remember reading somewhere that if some lines have not been commented out windows gets a bit confused i.e.

; For Unix...

You could just use a large image. and on the list page shrink it to fit:

<img src="image.jpg" height="10" width="10">

This will resize it explicitly to the stated sizes, to amintain aspect...

$space_position = strpos($dates," ");

You should find that $space_position will contain the strings index value for the space.

Therefore:


$month = substr($dates,0,$space_position);
$year...

Well twist my nipple nuts and send me to alaska, the answer was simply a matter of removing the line:

AND p.int_product_id = pci.int_product_id

once I had added the JOIN, well hope my...

As a quick addendum I just found this on Mysql site in the Reference Manual:



However it is still not returning records which are not in 'table2'?

The Query as it stands:


SELECT...

I am endeavouring to search across multiple tables in order to compile a search result listing. However some of the table I want to include in the search don't always contain data for a given...

I don't really recognise that message, as long as the column 'title' exists in table 'meeting' you should be ok, even though based on the previous SQL statements, you are not referencing this field...

Assuming your selection boxes, and 'go' button are within a form, and the button is of type submit, e.g.

<FORM action="your_php_file.php" method="POST">
<select name="sel_region">
<option...

Not sure if you've tested that but the servers I work with will detect all fields within the POSTed form as being set, even if they are blank. This may be browser dependant, but as you can't...

But you have to admint:

sx84r8772BGGM2sV8347a3267gfS4h5gy9Kj0H96923NUsGYrruSIY24kwQyinS5461Xh91s1b2U5e7GIX7l2U9CxKcIor5S46zk

is going to be hard to guess, although probably just as easy to...