PHP: How to write it the right way?

Germaris

Hi there!

This is a query of a PHP script I wrote which is supposed to return the number of rows for each different object present in the field nammed "list"

$query="SELECT list, count( * ) AS n FROM $table GROUP BY list HAVING ( n > 1 )";
//I don't know how to write the following
print (
// ? ? ? ? ? 
);

The result returned by this query is, FOR EXAMPLE, something like this

list n

ai 72
bg 325
he 127
etc...

I want to send this result to my Flash file

&ai=72
&bg=325
&he=127
etc...

but I don't know to write it the right way !!!

Many thanks in advance for your help !

bpat1434

well there are a few things;
1.) you need to call mysql_query() in there
2.) You need to itterate through the rows returned and create your querystring

<?php
$query = "SELECT list, count( * ) AS n FROM $table GROUP BY list HAVING ( n > 1 )";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
  print( '&'.$row['list'].'='.$row['n'] );

Hope that helps.

Germaris

bpat1434 wrote:
You need to itterate through the rows returned and create your querystring
<?php
$result = mysql_query($query);
while($row = mysql_fetch_array($result)) {
  print( '&'.$row['list'].'='.$row['n'] );

Good morning!

I gave it a try and it didn't work... :-(
If you have some Flash knowledge I could explain how my Flash File is prepared for receiving the results. I think it will help you for formatting the results in the PHP Scripts.
Don't you think so ?

Anyway, I already thank you for the time !

bpat1434

Well there's only two ways to get PHP values into FLash:
1.) FlashVars embedded in the HTML
2.) Serializing and unserializing data in Flash and PHP

WHich are you using?

Germaris

Wow! Shame on me!
I have so much to learn!
I'm frightened...

I really don't know.

Here is what I wrote in my .fla File :

displayStats = function () {
	_root.errorMsg.text = "GO";
	mySearch.unlock = "1";
	mySearch.onLoad = function(ok) {
		if (ok) {
			_root.aiFld.text = mySearch.ai;
			_root.adFld.text = mySearch.ad;
			_root.auFld.text = mySearch.au;	
                 _root.errorMsg.text = "OK";
		}
		else {
			_root.errorMsg.text = "BAD";;
		}
	};
	mySearch.sendAndLoad("search_stats.php", mySearch, 'POST');
};
_root.displayStats()

I think it hasn't been "serialized" nor "embedded"...

What do you think?
Have some mercy for the nerd...

bpat1434

You know what, you need to serialize the data prior to sending it out of PHP. So instead of printing the data, you need to first create a string, and then print the string.

I suggest you look at this tutorial about using PHP and Flash for dynamic data 😉 But basically, your PHP side would look like:

 $query="SELECT list, count( * ) AS n FROM $table GROUP BY list HAVING ( n > 1 )";
$rslt = mysql_query($rslt);
$cnt = 0;
$string = '';
while($row = mysql_fetch_array($rslt)) {
  $string .= 'list'.$cnt.'='.$row['list'].'&count='.$row['n'].'&';
}
// Remove trailing "&"
$string = substr($string, 0, -1);

// "Send" to flash:
echo $string;

Germaris

Oh yes, I know...

I already used $flashstring to send the data to the Flash file (in the general PHP Script of which I sent to you a piece).
But when I used this string it was for returning multiple lines of data each of one separated with a line break and ALL THE LINES WERE TO BE LOADED INTO A SINGLE DYNAMIC FIELD !!!
NOT INTO MULTIPLE DIFFERENT FIELDS as it is in our today problem...

And I used the code you provided, pasting it in the script, verifying it and it didn't work...
😕

This is very frustrating, indeed.
And I thank you very much for all the time you dedicate to my problem ! 🙂

bpat1434

You may try asking this over there on their forum as they're more focused on that type of issue and help 😉 Not that you can't get this information here, it's just I've exhausted my knowledge with Flashvars and all that. But Jorge Solis and the experts over there can really help you more than a general PHP group 🙂