violinrocker

tnx... I joined two different codes to work as one and I really dont know what to remove and what to add in there... anyways... it works now... Tnx again for showing me my error =)

this code skips 1 row... where did I go wrong? <?php echo '<table cellspacing="5" cellpadding="3">'; $query = "SELECT * FROM videos ORDER by page_id DESC"; $pageid = $row['page_id']; $res = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_array($res); // Note that $res is mysql result id. // $i keeps track of the number of rows (<tr>). // In this example, you will get 12 items/cells in total = $i(4) * $j(3). for ($i = 3; $i < 3; $i++) { // New row starts. echo '<tr background="/images/transbg.png" >'; // $j keeps track of the number of cols (<td>). // In this example there will be 3 <td>'s per <tr> for ($j = 5; $j < 5; $j++) { // See if there is still a fetchable row in the result. if ($row = mysql_fetch_array($res)) { echo " <td width='123' valign='top' ><a href='Video/video.php?id=$row[page_id]'><img src='$row[thumb]' width='125' height='62' align='top' border='1'/></a><a href='Video/anime/video.php?id=$row[page_id]' class='style1'> {$row[title]} {$row[eno]}</a><a href='Video/anime/video.php?id=$row[page_id]'> </a></td>"; } // If not, show the dummy link. else { echo '<td><a href="submit.php">Submit Yours</a</td>'; } } // This row ends. echo "</tr>\n"; } echo '</table>'; ?>

TNX! works great I have one final problem (i think) if you dont mind $query = "SELECT * FROM friends WHERE username='$session->username'";$result = mysql_query($query) or die(mysql_error());while($row = mysql_fetch_array($result)) { //FIGURE OUT IF THE CURRENT FRIEND IS ONLINE $query2 = "SELECT * FROM active_users WHERE username='$row[friendname]'"; $result2 = mysql_query($query2) or die(mysql_error()); //IF THE CURRENT FRIEND IS ONLINE, SHOW CHAT LINK if($row2 = mysql_fetch_array($result2)) { echo "You have ".mysql_num_rows($result2)." friend/s online<br>"; } I used this code to show the number of friends online... problem is, when you have two friends online it also only shows 2 "you have 1 friend/s online"

I also like double queries more... I get confused with INNER JOIN... ummm another thing haha.... I want the image link to be lik 'no_image.png' if the avatar field is blank... I already know how to do it, but my old code kinda looks different and requires something else, BTW Thank you so much! cyberRobot

$query = "SELECT * FROM friends WHERE username='$session->username'";$result = mysql_query($query) or die(mysql_error());while($row = mysql_fetch_array($result)) { //FIGURE OUT IF THE CURRENT FRIEND IS ONLINE $query2 = "SELECT * FROM active_users WHERE username='$row[friendname]'"; $result2 = mysql_query($query2) or die(mysql_error()); //IF THE CURRENT FRIEND IS ONLINE, SHOW CHAT LINK if($row2 = mysql_fetch_array($result2)) { echo "You have ".mysql_num_rows($result2)." friend/s online<br>"; }} i want to check the number of rows that are in 'active_users' problem is... when 2 rows are in 'active users' the statement "you have 1 friend/s online" also doubles.. and it doesnt add up... there are 2 but it is shown separately

anyone?

Tnx! it works now... I hope you dont mind, but is it possible if we get another field from another table? like... we now have the list of friends that are also available at 'available_users' right? can we get 'avatar' from another table named 'users' wherein the 'username' field is the same with active friends? for example --'users'-- username name password avatar --------------------------------------------------------------------- smiley smiley ********* 78139.png

YES SIR! =)

uhhh how will you show the results? $row['what??] ?

I use jp77's login script... yeah when you login the username is added in 'available_users' and when you logout it is erased... in friends... the fields are 'username' and 'friendsname' the username that I want to use for "WHERE" is $session->username which is the 'username' field in 'friends' and the 'username's that I want to get from 'available_users' is from the 'friendsname' of 'friends' where the 'username' for 'friends' is the one logged in or '$session->username'

one problem friends.friendname = available_users.username WHERE username = '" . $session->username . in here its stating the 'username' from 'available_users' for "WHERE" right? what I want is get the available users from 'available_users' and then check 'friends' if any of those in 'available_users' are friends with '$session->username'

do i need to change friends.field and friends.field2?

for 'available_users' there are only two ..... "username" and "time stamp" while in 'friends' there is "id", "friendname" and "username" for 'friends' the guy who wrote the code for my friendsystem made an inverse of the input friendname and username whenever someone is added as a friend, (I can use 'OR' there and discard the double post right? anyway thats out of the topic) what I want is for example I have 2 friends listed in 'friends' named 'smiley' and 'jc' ... then 'smiley' is online and so his name is now on 'available_users'... now I want to list all my friends that are currently online

I would like to show the list of online friends by first showing the friends and then checking if they are online at another table named 'available_users' ... problem is i dont have any Idea how I would implement this... this is the code I am trying to do, it currently lists all friends, whether online or offline $query = "SELECT * FROM friends WHERE username='$session->username'"; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)){ echo "<a href=\"javascript:void(0)\" onClick=\"javascript:chatWith('$row[friendname]')\">Chat With $row[friendname]</a><br>"; echo "</br>";

whew.. thanks a lot... it works now... been fixing it for hours haha thanks again

i have this code and it doesnt seem to work.... when i remove "WHERE" it works $query = mysql_query('SELECT * FROM `friend_requests` WHERE `username` = `$session->username`'); echo "[<a href=\"newfriends.php\">Friend Requests(<font color='red' face='Arial'>".mysql_num_rows($query)."</font>)</a>]"

hi, I want the value of my textarea to contain the highest "episode number" from my database with a 'where title=$_GET[title] ....sorry for the details, I cant explain it well

TNX!! really appreciate it... works well

i want to remove the file extensions in my fetched rows for example i have http://blbla.com/file.exe i want it to look like http://blbla.com/file tnx

ive been trying many times to import my edited mysql table but it always has errors... until I tried to export directly from phpmyadmin and import it into the same phpmyadmin without editing it or anything but it also shows errors ... please help me

if i have in my fetched row "A summary or recap is a shortened version of the original. The main purpose of such a simplification is to highlight the major points from the original (much longer) subject, e.g. a text, a film or an event. The target is to help the audience get the gist in a short period of time." how do i limit the letters so that it would look like"A summary or recap is a shortened version of the original. The main purpose of such a simplification is to highlight the major points from the original..."

how do i order fields with mixed letters and numbers? i tried using ABC('title') but it shows... title 1 title 10 title 110 title 2 title 21 title B 1 title B 10 and so on... its like 1,10,11,12.. then 2,20,21,22... what I want is 1,2,3,4,5

i want to fetch rows wherein the only rows fetched are tthe ones with the same columns for example.. i have "folders" in my table and then in the table the "folders" have DC DN NS... what should i do so that rows with DC in their folders will be shown?

what do i put in my php page's $_GET code?

how do i make php get stuff from mysql.. i have a flashplayer that uses $_GET to get the flv link i have $flv_link = $_GET["flv"] and if i enter mysite.com/video.php?flv=linkhere.flv the player will play linkhere.flv... question is... how do i make a table in mysql that will contain the flv link and using page ids to fetch it so that i onlly have to use mysite.com/video.php?pageid= and not the long ?flv=falrwjgiljrgjldsfrglkjdfgjklfdg.flv