Recent content by camcim

Hello all, I'm currently working on a modified version of Macromedias Image Viewer. With the added features from tupps my movie now has auto play, stop, go to end slide (swf's) etc. At the moment i have the following code: <?xml version=&quot;1.0&quot;?> <Slides> <slideNode...

Thanks for the reply.... I want to refresh the one text field to display the newly updated data that was inserted into the database (via the form, not the location form but one that was in a popup window) This popup window has a form which inserts data into a mySQL database. This same popup...

Hi all, If i have the following: window.opener.location.reload(); can i pass a value along with the reload()? The reason for wanting this is because i am wanting to refresh only one text field from a form (the location page). Any ideas or suggestions? Cheers, camcim

Hi all, I'm currently fiddling around with a file upload script (which also emails me the file). It appears to be neally working except i am unsure as to what to name the $fileatt_type variable. At the moment it is set to &quot;csv&quot; but i don't think this is correct. I say this be it upload...

Hi all, I've been playing with this bit of code but can't seem to stop it from inserting the company_id twice. The company_id value is a unique number corresponding to the email (checkbox_email) Here is part of the code: if($email){ function mkpasswd($nochars=8) { mt_srand ((double)...

Hi all, Can anyone tell me how to make the following script more concise? There must be a better way than what i have so far. if($update_cat){ echo &quot;$total<br>&quot;; if($category_1){ $update_1 =&quot;UPDATE company_categories SET category_id='$category_1' WHERE comp_cat_id =...

Hi all, If i have the following: $sql = &quot;SELECT * FROM company_categories WHERE company_id='$id'&quot;; $result = mysql_query($sql); while($row = mysql_fetch_array($result)){ $comp_cat_id = $row[&quot;comp_cat_id&quot;]; $company_id = $row[&quot;company_id&quot;]...

Hi all, I can't seem to get this loop working properly. Here is the script: <? $sql = &quot;SELECT * FROM company_categories WHERE company_id='$id'&quot;; $result = mysql_query($sql); $total = mysql_num_rows($result); while($row = mysql_fetch_array($result)){ $comp_cat_id =...

Hi all, If i am using the following query: $sql_query =&quot;INSERT INTO movie_genre (movie_id, genre_id) VALUES (LAST_INSERT_ID(),'$genre_id')&quot;; $result = mysql_query($sql_query); how can i make the LAST_INSERT_ID() a variable? (inorder to use it later) Cheers, camcim

Hi all, Is this the proper coding for a function? If so, how do i call it later on in my script? If it is not, am i able to write such a function this way? function find_title(){ $result = mysql_query(&quot;SELECT * FROM help WHERE help_id = '$cat_id'&quot;,$db); while ($row =...

Let's assume that i do know the value of $movie_id. Eg: $movie_id = 3

Hi all, What would be the best way to write the following query? I have a table called movie_rating which contains two fields called movie_id and movie_rating. If there is no row associated with the movie_id field then i want it to echo that there is no row containing the movie_id value and if...

Thanks guys, that should get the ball rolling. Cheers, camcim

Thanks for the reply Richard. I'll try and clarify the situation. I have a page called genre.php that will contain the <a href=&quot;#&quot; onClick=&quot;navigate()&quot;>Rate</a> The genre.php page is a visable page to all users. This contains a list of different movies. However, in order to...

Hi all, Can anyone tell me of a way to complete this process? I currently have a page called genre.php On this page i have a link that opens a javascript popup window called member_rating.php (this page has a session_start() associated with it so that only members can rate topics). If the user...