digitalgod

you can either find a hosting company that already offers that service or you can get your own VPS and install it yourself, which by the way isn't a very easy install...

well got it work by populating an invisible list box and grabbing those values, not exactly the best way but if anyone has a better proposition please let me know!

you mean .flv right? you need a server that has ffmpeg installed and a few other codecs

also how can I collect the information for the user created drop down? Should I just use ajax and store it in a temp table until the form is submitted or..?

hmm well what I meant was processing the form here I'll give you an example of what the form looks like <form name="newcatalog" id="newcatalog" action="" class="forms" method="post"> <h2>Question 1</h2> <li> <label for="title">Question<em>*</em></label> <input type="text" name="title" id="title" class="text" /> </li> <div id="multiple_categories"> <li> <label for="multiple image categories">Multiple Image Categories</label> <input type="checkbox" name="categories" id="categories" /> </li> <li id="add-categories" style="display:none"> <label for="multiple image categories">Add Categories</label> <ul id="browser" class="filetree"> <?php display_categories(); ?> </ul> </li> <li id="categories-added" style="display:none"><label for="Categories Added">Categories Added</label> <select id="all_categories" name="all_categories" multiple="multiple" height="5"> </select> </li> </div> <li> <label for="Create Drop-Down">Create Drop-Down</label> <input type="checkbox" name="dropdown" id="dropdown" /> </li> <li> <label for="Add value">Add value</label> <input type="text" name="addToDropdown" id="addToDropdown" /><a href="#"><img src="images/add.gif"></a> <select name="dd_values" id="dd_values"> </select> </li> <li><label for="submit"></label> <button name="add" id="add">Add another question</button><input class="submit" type="submit" value="Create catalog"/> </li> </form> For now when a user adds a category it goes in all_categories for him to see and when he adds an option for the drop down it goes in dd_values. I need to be able to collect all of that information for several questions (depending on how many questions were added) So how should I collect all that information?

Ok this might be a bit hard to explain but it I'll give it my best shot! I have a panel where a user can create questions, and he can add as many questions as he wants. Each question has the option to include images as answers, those images are taken from categories, so for example a user can choose to include these categories; carpet, wood, stone. He can also create his own drop downs for each questions by simply typing whatever value he wants and it will add itself. All this is already done, the user can simply press on Add Another Question and fill it up again, my only problem is how to collect all of that data. I could make all of the elements arrays but I don't think that would work because I still need to collect all of the image categories for each question as well as all of the drop down (if a drop down is created ) entries for each question. I just need help with the logic behind all of this, I can't collect all of the information for 1 question quite easily but when more questions are added I'm not exactly sure how to collect them.

it still doesn't work, I'll try to figure it out later on, I'll put it on my to do list. thanks for your help akitchin!

thanks for the tip! Here I'll show you what I mean by unnecessary markup: <ul id="browser" class="filetree"> <li><span class="folder">main</span> <ul> <li><span class="folder">sub-main</span> <ul> <!-- unnecessary --> </ul> <!-- unnecessary --> </li> </ul> </li> <li><span class="folder">main #2</span> <ul> <li><span class="folder">test #2</span> <ul> <li><span class="folder">test #4</span> <ul> <li><span class="folder">test #5</span> <ul> <!-- unnecessary --> </ul> <!-- unnecessary --> </li> </ul> </li> </ul> </li> <li><span class="folder">test #3</span> <ul> <!-- unnecessary --> </ul> <!-- unnecessary --> </li> </ul> </li> </ul>

thanks akitchin! I've always hated recursives... my only problem though is that it creates unnecessary markup ( I'm a neat freak as well as a web standards freak hehe) but I've lost so much time trying to get those damn <ul> tags to close at the right place that I don't really mind. One question though, is there a way to keep the generated markup nice and clean, because right now it prints everything on one line and adding \n isn't helping...

anyone? I'm really going crazy trying to get this function to work

hey ignace, that actually won't echo out anything because main folders have no parent_id so they're parent_id value is 0 if that makes any sense... That's why I had $level, to keep track of how deep it goes in one branch that table image_category has image_category_id | parent_id | title | description | created

hey guys, I'm trying to build a recursive function to display all of my categories and subcategories but I keep running into some logic problems... what I basically need it to do is echo something like this <li><span class="folder">Folder 1</span></li> <li><span class="folder">Folder 2</span> <ul> <li><span class="folder">Subfolder 2.1</span> <ul id="folder21"> <li><span class="folder">Subfolder 2.1.1</span></li> </ul> </li> <li><span class="folder">Subfolder 2.2</span></li> </ul> </li> so main folder that don't have any children are between <li></li> tags, folders that do have children have <ul></ul> before the closing </li> I can't figure this out and I know it shouldn't be that hard but it's getting late and I'm extremely tired... this is what I have right now and it's no where near what I want it to do function recursiveTree($parent, $level) { $result = mysql_query('SELECT * FROM image_category '. 'WHERE parent_id="'.$parent.'";'); $result_count = mysql_num_rows($result); // display each child while ($row = mysql_fetch_array($result)) { $new_level = $level + 1; if ( $new_level == 1 ) { echo '<li><span class="folder">'.$row['title'].'<ul>'; } else { echo '<li><span class="folder">'.$row['title']; if ( $result_count == 1 || $result_count == $new_level ) { echo '<ul>'; } else { echo '</li></ul>'; } } recursiveTree($row['image_category_id'], $level+1); } }

hmm I see what you mean, makes perfect sense. here's what I've been doing $sql_clients = "SELECT * FROM client"; $result = mysql_query($sql_clients); $clients_count = mysql_num_rows($result); if( isset($_GET['a']) && isset($_GET['id'])) { $action = stripslashes(mysql_real_escape_string($_GET['a'])); if ( $action == "del" ) { $cid = stripslashes(mysql_real_escape_string($_GET['id'])); $sql_delete = "DELETE FROM client WHERE client_id = '$cid'"; $delete_result = mysql_query($sql_delete); $sql_delete2 = "DELETE FROM client_address WHERE client_id = '$cid'"; $delete_result2 = mysql_query($sql_delete2); } } so I guess I should just switch them around instead. edit works perfectly, thanks!

hey guys, I have a script where users can add/remove clients, my problem is that when a person clicks on delete, the page refreshes, the row gets deleted from the db but it still shows that client in the html table, the info will disappear only after a page refresh. I'm pretty sure it's a cache problem but I have no idea how to fix this.. any suggestions would be greatly appreciated!

thanks accident, can't believe I didn't see that... note to self, sleep more!

hey guys, I'm trying to verify events that will start between curdate() and 31 days later. so far this is my query but it doesn't seem to work SELECT id, main_image FROM events WHERE member_id = '$_SESSION[members_id]' AND DATE_ADD(CURDATE() ,INTERVAL 31 DAY) >= start where start is the date and time of when the event starts. I keep getting events that have already passed with that query and I don't understand why... I just need to select all dates that start between now and 31 days later... any ideas??

hey fenway, I tried using a left join but I kept getting double entries ( if not more), most likely my query wasn't good. which option would save more resources?

I think you're mixing up a few things what he means is that you're calling mysql_connect while you have no information stored in your variables. I don't know if you're using a form to connect to a database but if you are then add the if statement that micro added. Otherwise manually input your connection variables like for example $mysql_server_name = 'localhost' etc

SELECT id,username FROM members WHERE email IN ( '$list' ) AND id NOT IN ( SELECT members FROM friends WHERE owner =18489 ) thanks sasa!

could have simply used what I posted earlier $someName = stripslahes(mysql_real_escape_string($_POST['some_name'])); // or to remove whitespaces $someName = trim(stripslahes(mysql_real_escape_string($_POST['some_name']))); but yeah that's good

exactly, if you'll be using that variable to insert it in a database I would suggest you'd use mysql_real_escape_string in order to protect yourself from sql injections

so something like this? games +-------+-------------+ | id | title | +-------+-------------+ | 1 | The HULK | +-------+-------------+ achievements +-------+-------------+---------------------+--------------------------+-----------+ | id | gameid | name | description | picture | +-------+-------------+---------------------+--------------------------+-----------+ | 1 | 1 | Achievement #1 | bla bla bla | img1.jpg | +-------+-------------+---------------------+--------------------------+-----------+ obviously you do 1 achievement per row and you assign it a gameid that way you can join the tables together hope that helps

oh snap... I really am tired so yeah what sasa said should do the trick

I'm not sure I understand what you mean, what columns are you selecting and what is it that you want to be displayed?

$query = "SELECT...."; $result = mysql_query($query) or die(mysql_error()); while( $row = mysql_fetch_array($result) ) { echo $row['columnname']; }