Using AW with PHP and MySQL


Does anybody have a working example of a AW using PHP with a MySQL database?

Or can anybody give me some advise on what I need to do? Like what fields I need to create in MySQL

Any help is much appreciated

Many thanks

August 29,
In regards to what fields you need in mySQL, thats totally up to you as the developer and what you're trying to accomplish with the application you are writing.

in regards to the rest...
i suggest you scroll down in the forums, not less than 3 days ago this topic was discussed in lenght with code examples and the like.

I also suggest using the FORUM SEARCH before askin a question.
August 29,
I always use the search function in all the forums I participate in and moderate thank you.

Which topic are you referring to anyway? The one about connecting Access to MySQL using ODBC or the topic about using Macromedia's ColdFusion with MySQL?

I've never used ColdFusion nor do I have any desire to learn it. I'm currently learning PHP and I'm starting to understand how it works so some help/advise and maybe some examples would be of great use to me.
August 29,
I've managed to get it working wooopeeee !!! :)
August 29,
I'm using it with tabs ".dynamic-tab-pane-control" on our intranet. Quite useful at the moment - looking into drag & drop of extra fields at some point.
August 29,
Here's How I've Done It.

require 'your_database_here.php';
$query2 = "SELECT * FROM equipmentlist ORDER BY Type, Id"; //Build The Query
$result2 = mysql_db_query($dbname, $query2, $link) or die("Cannot $query2"); //Run The Query

$num_rows2 = mysql_num_rows($result2);  //Get The Number Of Rows

while ($row2 = mysql_fetch_array($result2))  //Create An Array Of Data
  {$mydata[] = "[\"$row2[Id]\", \"$row2[Type]\", \"$row2[Status]\", \"$row2[Mmduser]\", \"$row2[Mmdpassword]\", \"$row2[Notes]\"]";}

$mydata = implode(",\n", $mydata); //Turn The Array Into A String

print "var myData = [\n".$mydata."\n"."];";

Down In The Bottom Section, You'll Find 'obj.setRowCount'. Use The Num Rows You Created Earlier Here.

obj.setRowCount(<?= $num_rows2; ?>);

Hope That Helps!
Rick Clark
October 7,

This topic is archived.

See also:

Back to support forum