Help - CMS PHP / loadvars / MySQL

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