PHP - A For Loop That Fetches Several Fields By Ajax From Database

Hello,

I've been trying this for hours now, looking at different examples and trying to change them to work for me, but with no luck...

This is what I am trying to do:

I have a simple form with:
- 1 input field, where I can enter a number
- 1 Submit Button

When I enter a number into the field and click submit, I want that number to be send to the php file that is in the ajax call, then the script will take that number and run a bunch of queries and then return a new number. I want that new number to be used to call the php script via ajax again, until no number is returned, or something else is returned like the word "done" or something like that, at which point is simply makes an alert or populated a div with a message...

The point is, that depending on the number entered it could take up to an hour to complete ALL the queries, so I want the script that is called to only run a fixed amount of queries at a time and then return the number it is currently at (+1), so that it can continue with the next number when it is called again.

I would like to use jquery, but could also be any other way, as long as I get this to work. I already have the php script completed that needs to be called by the ajax, it returns a single number when being called.

Thank you,
vb

Hi,

I own a website called www.gpstudios.com,  a flash games site.
I didn't design it myself, but since having it built a year ago, I understand pretty much all of the inne workings. I'm a game coder so php makes good sense to me.

Anyway, i woudl like to change the way a game info (instructions, description) is fetched.
Currently, we have 650 games in our database. The way all the info is gotten is through mySQL.
So, what I would like to do is take these lengthy instructions/description strings and put them each into a text file, within the folder destination of the game.

Currently though, we don't even have a folder destination for each game, which is also a problem. Some games have extra files, which our site-developers didn't account for. There are several games that we've had to manually put into folders because of this problem (two .xml files cannot be named the same in the same folder)

Also, if you go onto my website and click on a game, you get sent to playgame.php?id=xxx
The main thing I would like to change though (which I have attempted before, but not succeeded with) would be to change the url adress of the games to something more like: www.gpstudios.com/games/game_name/
This is how most game websites do it.

When I tried to do this myself, what I did was to simply create an index.php within the folder of one of the aforementioned games, and within this folder I wrote something as simple as:

include("../../../playgame.php?id=xxx");

But upon loading this page, I would receive a load of error messages regarding all the other includes and requires in the playgame.php.
So by inserting playgame.php?id=xxx in this deep folder, it destroys all other directory links elsewhere.
I investigated and found that inserting set_include_path($_SERVER['DOCUMENT_ROOT']) would fix the problem with all these links, but it didnt - while the page loads, it appears to ignore anything that isn't in the root directory, including images.
I tried the include method with loads of different files, and they just wouldn't load correctly if they used anything outside the root directory.

And my final wish would be to do all of this automatically.
To simply write a php file that I would run once and it would generate all the directories for me.
It would need to copy every single description and instructions from mySQL and put them within text files within directories which are named after the game.
I would then need to automatically create a load of index.phps for each individual game with some simple code similar to: include("../../../playgame.php?id=xxx");
Obviously it would be silly to create a load of unique index files with a hard copy of playgame.php, incase I want to give my site a makeover at some stage.


I'm asking alot aren't I?
Well I know that if I was given the code from another games website, I would understand it and it would be easy to implement, but unfortunately, despite searching, downloading and installing over 10 Flash Game arcade scripts, none of them used this method... despite their demo page showing that they do.


Mainly, all I need to know is how to is how to generate a php/text file, and then I need to know what method I would use for getting the playgame.php running correctly from  within a different folder.
I'm pretty sure I could do the rest on my own then.

Thanks!

$query = "SELECT painting, date1, date2, date3 FROM paintings WHERE artist_id = '$ar' ";
$result = mysql_query ($query) or die ("Invalid query: " . mysql_error ());
while ($row = mysql_fetch_assoc ($result)) {
   echo "The 3 sale dates for ".$row['painting']." are"$row['date......."
   echo "<br>";
}


Now within this while loop for each painting I want to echo out the 3 dates in order (sometimes date3 may be earlier than date1 or vice-versa).  How do I sort those three dates when I am already in the while loop?  Also how this work if one of the dates was blank?
Thanks.

  for($i=1; $i<=$round; $i++){
    print "<tr><td align='left' valign='top'><input type='text' name='number$i' maxlength='2' size='2' /></td>\n ";
    print "<td align='left' valign='top'><input type='text' name='score$i' maxlength='1' size='1' /></td>\n ";
	print "<td align='left' valign='top'><select name='team$i'>\n";
	print "<option value='-'>-<option>\n";
	print "<option value='Home'>Home<option>\n";
	print "<option value='Away'>Away<option>\n";
	print "</select></td></tr>";
  }

What I'm having trouble with is that for every option tag there is an empty option tag added. How do I get rid of those empty option tags? Thankful for any help.

Hi can anybody help I need to export and download tables from a database into a excel sheet. I have this code and it works what I need is to export specific fields and not just the whole table can anyone help modifying the code to export certain fields within the table please? Here is the code...
Code: [Select]
<?php
$host = 'localhost';
$user = 'user';
$pass = 'password';
$db = 'qdbname';
$table = 'tablename';
$file = 'export';

$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");

$result = mysql_query("SHOW COLUMNS FROM ".$table."");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
$csv_output .= $row['Field']."; ";
$i++;
}
}
$csv_output .= "\n";

$values = mysql_query("SELECT * FROM ".$table."");
while ($rowr = mysql_fetch_row($values)) {
for ($j=0;$j<$i;$j++) {
$csv_output .= $rowr[$j]."; ";
}
$csv_output .= "\n";
}

$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;
?>