hi printing sql in flash with php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
reecec
Forum Contributor
Posts: 218
Joined: Sun Apr 02, 2006 7:12 am

hi printing sql in flash with php

Post by reecec »

Hi i need help on this please

i have a dynamic text box in flash and i need it to display information from sql the colum (table status) and from the row that has (table1)

when im talking about table i dont mean table in a database, looks abit confusing talkin about diferent types of table


my dynamic text box has a var for coding VAR:table1

this is what i have as my flash AS:

// Loads the Variables
loadVariablesNum ("tablestat.php?table1="+table1, 0);



i have the PHP file but i think its rong

(this is tablestat.php)

<?php
$server = "localhost";
$dbuser = "reeceth_12";
$dbpass = "dell12";
$dbname = "reeceth_12";
$dbtable = "order";

// This connects to your database.
mysql_connect($server,$dbuser,$dbpass);
@mysql_select_db("$dbname");

$result = mysql_query("SELECT * FROM $dbtable");

##This sets the variables from the Database
$table1 = mysql_result($result,0,"table1");
##This sets the variables from the Database
$table2 = mysql_result($result,0,"table2");
##This sets the variables from the Database
$table3 = mysql_result($result,0,"table3");


print "table1=$table1&";
?>

i would be grateful if anyone could help

thanks in advance

reece

soz code tags werent working
Post Reply