Ell20

I just commented the line out as it was useless anyway. I think its fixed. Thanks for your help!

Line 239 of scpoints.php is: echo $payment_gross; Thanks for the help

Nothing is output to the browser in the whole script. Im working on the IPN script for paypal. There is no white space and there is no HTML in the file at all. Cheers

Hi, I keep getting this error on my script and I have no idea why: 0.010.01 Warning: Cannot modify header information - headers already sent by (output started at pointy/scpoints.php:239) in /pointy/scpoints.php on line 280 Warning: Cannot modify header information - headers already sent by (output started at pointy/scpoints.php:239) in pointy/scpoints.php on line 455 Line 280:}else{header('Location:pointsback.php');} Line 455: header("Location:../pointsback.php"); Appreciate any help

I guessing this method is a taddddd tricker? haha

Hi, On my website I have an optional membership which users can purchase. I know how to set up a buy it now button using the paypal.com website. However by doing it like this there is no way of knowing which user made the payment. How can I pay the session - user_id through the payment so that I know who has paid then update the users table to say they have paid? Thanks for any information

Anyone?

I have set it up with an extra value in the DB which stores 0 upon registration and the redirect to the page however what dont no how to do is to set this value to 1 once they have seen it. Cheers

Hmm, how would you do that? Because you need to query the database to see if its 0 or 1 then if its 0 update it else just leave it? Cheers

Hi, I have made a login script which redirects. However depending on whether this is the first time they have logged in depends on which page they get redirected to. This is all working fine but how do I update the database on page load so that they get redirected to the other location from then on? Cheers

Surely even if I do that it still dosent solve the static nature of the html file meaning I would need a html file for each video uploaded!

I tried that but it still dosent seem to work in IE?? With this method surely it wont work as there are lots of videos uploaded thus the .html file is static with the name entered into the page? Cheers

Basically I have this at the moment which prints out the links: <?php $sql4 = "SELECT video_name, description FROM videos WHERE user_id = '$userid' AND validate = '1'"; $result4 = mysql_query($sql4); $i = 1; while ($row4 = mysql_fetch_assoc($result4)) { $video = $row4['video_name']; $description = $row4['description']; echo "<a href=\"../uploaded_videos/{$video}\" title=\"{$description}\" target=\"_blank\">Link $i</a>"." "; $i ++; } ?> This opens a pop up window which plays in Mozilla but not IE. So what I think I need is like a YouTube kind of thing where its embedded into a page and it plays the video in a little pop up window. Cheers

Thanks for the info but thats not really what im looking for I dont think.

Hi, My users can upload videos to my site and stores the name of the video into the database. Is there anyway in which I can create a series of links for each of the videos they have uploaded (I can do this with while statement) which when clicked opens a popup with the embedded video? Ive had a look on around but couldnt find much. Any help would be appreciated Cheers

DONE IT! Thank you so much for your help!! The code in case you were wondering: <?php $sql = "SELECT group_name, picture_name FROM pictures WHERE user_id = '$userid'"; if ($result2 = mysql_query($sql)) { if (mysql_num_rows($result2)) { $group = ''; while ($row = mysql_fetch_array($result2)) { if ($group != $row['group_name']) { $group = $row['group_name']; $i = 1; echo '<br>'; echo "<b>$group</b>: "; } $picture = $row['picture_name']; echo "<a href=\"../uploaded_files/{$picture}\" target=\"_blank\">Link $i</a>"." "; $i++; } } } ?>

I took the GROUP BY off the original SQL statement and it has now printed: Link 1, Link 2 etc just the links are all the same at the moment! Thanks for your help!

This is the code which I am using, the code you posted: $sql = "SELECT group_name, picture_name FROM pictures WHERE user_id = '$userid' GROUP BY group_name"; if ($result2 = mysql_query($sql)) { if (mysql_num_rows($result2)) { $group = ''; while ($row = mysql_fetch_array($result2)) { if ($group != $row['group_name']) { $group = $row['group_name']; $i = 1; echo '<br>'; echo "<b>$group</b>: "; } echo "<a href=\"../uploaded_files/{$row['picture_name']}\" target=\"_blank\">Link $i</a>"; $i++; } } }

Output: picture_id = 13 user_id = 15 group_name = Sexy picture_name = 1207168305-4.jpg picture_id = 12 user_id = 15 group_name = Sexy picture_name = 1207168305-3.jpg picture_id = 11 user_id = 15 group_name = Sexy picture_name = 1207168305-2.jpg picture_id = 14 user_id = 15 group_name = Sexy picture_name = 1207168305-1.jpg picture_id = 15 user_id = 15 group_name = Test picture_name = 1207222691-2.jpg picture_id = 16 user_id = 15 group_name = Test picture_name = 1207222691-1.jpg Code: $result = mysql_query("SELECT * FROM models INNER JOIN Users ON Users.user_id = models.user_id LIMIT $from, $max_results") or die(mysql_error()); $found = false; while ($i = mysql_fetch_array( $result )) { $found = true; $userid = $i['user_id'] ?> <table width="80%" border="0" align="center" cellpadding="0" cellspacing="2" class="tiny"> <tr> <td width="28%" rowspan="9" align="center"> <?php if($i['pic'] == "") { echo "No Profile Picture Yet"; } elseif ($i['pic'] != "" && $i['validate'] == 1) { ?> <a href="../profileimages/main/<?=$i['pic']?>" target="_blank"><img border="0" src="../profileimages/thumbs/<?=$i['pic']?>"></a><?php } elseif ($i['pic'] != "" && $i['validate'] == 0) { echo "Profile Picture Pending"; } elseif ($i['pic'] != "" && $i['validate'] == 2) { echo "Profile Picture Declined"; } ?></td> <td width="25%"><div align="left"><strong>First Name/Nickname:</strong></div></td> <td width="47%"><?=$i['username'];?></td> </tr> <tr> <td><div align="left"><strong>Sex:</strong></div></td> <td><?=$i['sex'];?></td> </tr> <tr> <td><div align="left"><strong>Sexual Preference:</strong></div></td> <td><?=$i['sex_pref'];?></td> </tr> <tr> <td><div align="left"><strong>Member Type:</strong></div></td> <td><?=$i['account_type'];?></td> </tr> <tr> <td><div align="left"><strong>DOB:</strong></div></td> <td><?=$i['dob'];?></td> </tr> <tr> <td><div align="left"><strong>Social Status:</strong></div></td> <td><?=$i['sex_status'];?></td> </tr> <tr> <td><div align="left"><strong>Referrals:</strong></div></td> <td><?=$i['referals'];?></td> </tr> <tr> <td><div align="left"><strong>Friends:</strong></div></td> <td><?=$i['friends'];?></td> </tr> <tr> <td><div align="left"><strong>Rating:</strong></div></td> <td><?php if ($i['rating'] > 0) { echo $i['sex_status']; } else { echo "0"; }?></td> </tr> <tr> <td><strong>Submitted Pictures:</strong></td> <td colspan="2"> CODE FOR PICTURES GOES HERE </td> </tr>

Just noticed something else as well, not sure if its related, but the link dosent actually work. Its only pointing to /uploaded_files, not /uploaded_files/picturename Thanks

O right how annoying for some reason its only displaying Link 1 and not carrying on. Pictures Table: picture_id user_id group_name picture_name Thanks

I have had a go but still learning really so struggling. Basically what you have done is right but it also needs to loop through the pictures and display the link for each of the pictures in the group. So say Group 1 has 5 pictures it should print out; Group 1: Link 1, Link 2, Link 3, Link 4, Link 5 Really appreciate all the help.

Yeah thats required. Basically the system is as follows; While statement to displays all users profiles Within that while is this statement which displays the groups following by all the pictures in that group for each user Cheers

Excellent for the links, thanks. Its not per user its per group. So each user can have many groups, which we have working, then within each group there can be many pictures? Thanks

Thanks for the help. However at the moment its only printing the first picture of each group out whereas there can be upto 10 pictures per group? Also is it possible to adapt the code to display Link 1, Link 2 incrementing rather than the actual picture name? Thanks alot