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

need to apply an if/else statement to Tim Thumb script
Not sure how to work this. I essentially want to call a variety of image sizes based on which style

All possible combinations of Strings from table in PL/SQL
Hi,

I am trying to figure out how to build a list of all possible string combinations fro

How to show next and prev records
Hi all,

Sorry if this is simple, i'm very new to php, well, any programming language actually

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

Handling text changed in text box control using Ajax
I need to create a web form with a text box control. When someone types text into the textbox I nee

ASP.NET Validation Event Cycle
Hi,
I have asp button as follow:

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

Pipe email to PHP - get mail adress from MySQL - send?
Hi all,

this is the challenge:

1) Our faculty at the college where I'm employed includ

Header is not working in IE
Hi ! header function is not working in IE but it works in FF, Safari, Chrome. any help please. :