help with variable

Posted on 16th Feb 2014 07:03 pm by admin

I've got a problem, i want to echo some images depending on the $id, however for me to get that id i have to extract it from a query. So i've done that, but i want to extract all id's (not just 1), so i can echo images for all them ids (not just echo the images based on 1 id), so I did a while() loop, however doesnt seem to work

My code:

Code: <?php
include "connect.php";
$user = "Peter";
$sql = mysql_query("select * from game_main where user = '$user'");

while($row = mysql_fetch_array($sql)){
$id = $row['id'];
}
//do i have to do foreach $id as something??

$views = mysql_num_rows(mysql_query("SELECT userip FROM game_views WHERE sub_id = '$id'"));
$sql3 = mysql_query("select monthstamp from game_monthlyfeatured where first = '$id'");
$num3 = mysql_num_rows($sql3);
$sql4 = mysql_query("select weekstamp from game_weeklyfeatured where first = '$id'");
$num4 = mysql_num_rows($sql4);
$sql5 = mysql_query("select daystamp from game_dailyfeatured where first = '$id'");
$num5 = mysql_num_rows($sql5);
$sql6 = mysql_query("select date from site_featured where id = '$id'");
$num6 = mysql_num_rows($sql6);
if($num3 == 1) {
?>
<img src="../images2/game/game_awards_1monthly.gif" width="20" height="20" />
<?php
}
if($num4 == 1) {
?>
<img src="../images2/game/game_awards_topweekly.gif" width="20" height="20" />
<?php
}
if($num5 == 1) {
?>
<img src="../images2/game/game_awards_topdaily.gif" width="20" height="20" />
<?php
}
if ($views > 1000) {
?>
<img src="../images2/game/game_awards_1000views.gif" width="20" height="20" />
<?php
}
if ($views > 25000) {
?>
<img src="../images2/game/game_awards_25000views.gif" width="20" height="20" />
<?php
}
if ($num6 > 0) {
?>
<img src="../images2/game/game_awards_modpick.png" width="16" height="16" />
<?php
}

?>
Hope someone can help, thanks

Your Answer:

Login to answer

Other forums

Why does my crawler script suddenly end with no error?
Hi.

I have written a web crawler script. It will visit a large number of URL's with cURL.

file downloaded can't be read !!
<?php
$fileName = 'mypic.jpg';
$mimeType = 'image/jpeg';
header('content-dispositio

Problem with creating FI documents
Hi, Experts!

when i create Fi doc. with standart transaction, i ve been had such problem

How can i steam a video on my PHP site? (non YouTube)
Basically I have a PHP site and don't want to give page rank to YouTube. I just want to stream a bas

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t

Members Only
Hi all, for my website i have a members area only which on members can veiw, but at the moment anyon

Can't find the problem (no error message)!
OK, here's the deal. This code is really weirdly formatted (sorry!) and hard to understand, so I'm g

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

Multiple forms on the same page (safari)
Hello everyone,

I have 3 forms on the same page, that opens in a new window and submits to a

IMAGE - SERVER SIDE scripting help...
How to receive pixel data of an image and buid a bitmap file on the server using the HTTP POST metho