Help - CMS PHP / loadvars / MySQL

programming flash
1

Alright guys :slight_smile:
Just asking for a wee bit of help as iā€™m totally stuckā€¦
Basicly iā€™m in the middle of creating a cms system in flashā€¦ itā€™s not overly fancy, and itā€™s aimed at designers - so the main priority will be making it skinable - but itā€™ll be able to update sections with text / images via an admin panelā€¦ iā€™m not so much of a coder, more of a designer with a little bit of actionscript knowledge, so most of itā€™s built with various open-source projects iā€™ve ā€˜frankstienedā€™ together, but iā€™m having problems with some things, so I wondered if somebody would point me in the right direction.
Oh, and I fully intend to make this project open sourceā€¦ just need to make it work first :slight_smile:

First problemā€¦ (MySQL. Loadvars / PHP related)

the main sections on the front end draws info from a MySQL database, which has the following sections

id
creator
title
cat (catagory)
text (body)
date

Now basicly each page in the frontend needs to display the title, body, creator and dateā€¦ but hereā€™s the thing - each section has a different catagory - for example News / About - the former will only pull entries with the catagory ā€˜newsā€™ and the latter section will only pull the entries marked ā€˜aboutā€™ .

Iā€™ve got the basic php to pull it all in, but iā€™m not too sure if the catagory sorting should be (or could be) in the php or in the actual actionscriptā€¦ any suggestions :slight_smile:

<?
$server = "localhost";
$user = "root";
$pass = "root";
$database = "cms";
$tableName = "blog";
$conn = @mysql_connect($server,$user,$pass);
$database = @mysql_select_db($database,$conn);
$query = @mysql_query("SELECT * FROM $tableName ORDER BY posted desc");
$total_rows = @mysql_num_rows($query);
$counter = 0;
while($myNewsData = @mysql_fetch_array($query)){
     $id = $myNewsData["id"];
     $creator = $myNewsData["creator"];
     $title = $myNewsData["title"];
     $cat = $myNewsData["cat"];
     $link = $myNewsData["link"];
     $text = $myNewsData["text"];
     $date = $myNewsData["date"];
     $posted = strftime("%d-%m-%y", $myNewsData["posted"]);
     $counter++;
     print("&news_data$counter=$id|$creator|$title|$text|$date|$cat");
}
print("&total=$total_rows"); 
?>

The second problem is within the admin interfaceā€¦ the main edit panel looks like this

(sā€™cuse the ****ty name , it will be changed)

When you click the image button (the one with the two squares with the plus) a pop up appears with basicly options for image sizeing / alignment, but it requires the user to input the image location. What I want to do is add a photobrowser, so you can click a button beside the input and thisā€™ll pop up - or something like it once iā€™ve reskinned itā€¦

betriebsraumā€™s awesome file browser - http://www.betriebsraum.de/blog/2006/01/13/download-flash-8-file-browser/

Basicly I need to create a button so that when you select a pic, you just press an it and it will input the image url into the image location boxā€¦
anyone know what iā€™m on about ?
hope iā€™ve explained this clearlyā€¦

Any help will be just totally awesomeā€¦

Thanks

Liam