StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POUsing a variable with a changing value in MySQL query?
primarykey
Id
8109631
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2011-11-13T04:36:30.287
FavoriteCount
0
LastActivityDate
2011-11-13T04:54:19.950
LastEditDate
2011-11-13T04:54:19.950
LastEditorUserId
1103669
OwnerUserId
1103669
ParentId
0
PostTypeId
1
Score
0
ViewCount
321
LastEditorDisplayName
text
Body
<p>I'm building a tagging system for a site I'm working on. I have a variable for the url of the image that changes as the user selects different pictures. I'm using a MySQL command to display 3 tags for the selected picture, but it isn't working if I give it that changing variable. However, if I manually insert a url of an image, the captions show. However, these will show no matter what picture you're on so that doesn't really help. If I store a url under a variable, that works too, but not with the one that changes all the time. </p> <p><a href="http://ewsprojects.com/~lyons" rel="nofollow">Here</a>'s the site.</p> <p>I know this isn't very easy to understand, so please let me know if you want me to try re-explaining something or if you want me to include some of the code. Thanks!</p> <p>EDIT: Ok, I'll retry here. First, here's the code:</p> <pre><code><?php $username = $_GET['username']; session_start(); $_SESSION['username'] = $username; //Database Information $dbhost = ""; $dbname = ""; $dbuser = ""; $dbpass = ""; //Connect to database mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); //Do the query $query = mysql_query("SELECT * FROM images ORDER BY idnum DESC LIMIT 5"); // Generate an array of all images. $images = array(); while($image = mysql_fetch_array($query)) { // Adds each image to the images array. $images[] = $image; } $image['filename'] = $current_image; $query_captions = mysql_query("SELECT * from captions WHERE image = '$current_image' ORDER BY idnum DESC LIMIT 3"); $captions = array(); while($caption = mysql_fetch_array($query_captions)) { $captions[] = $caption; } ?> <?php // Beginning attempt at a caption script. ?> <html> <head> <title>Home - Site in Development</title> <link rel="stylesheet" type="text/css" href="styles.css"/> <script type="text/javascript"> // Switches the url to view large image. function switchImageUrl(url, width, height) { var x = document.getElementById('caption_selection'); var y = document.getElementById('caption_input'); var z = document.getElementById('input_value'); x.style.display = 'none'; y.style.display = 'none'; z.value = ''; document.getElementById('center_frame').style.backgroundImage = 'url' + '(' + url + ')'; document.getElementById('center_frame').style.width = width; document.getElementById('center_frame').style.height = height; } </script>  <script type="text/javascript"> function selectionToggle() { var x = document.getElementById('caption_selection'); var y = document.getElementById('caption_input'); var z = document.getElementById('input_value'); if(x.style.display == 'block') x.style.display = 'none'; else x.style.display = 'block'; x.style.width = '75px'; x.style.height = '75px'; x.style.top = '0px'; x.style.left = '0px'; if(y.style.display == 'block') y.style.display = 'none'; else y.style.display = 'block'; z.value = ''; } </script> <script type="text/javascript"> function collectAttributes() { var cap = document.getElementById('caption_selection'); var cw = document.getElementById('cap_width'); var ch = document.getElementById('cap_height'); var cl = document.getElementById('cap_left'); var ct = document.getElementById('cap_top'); cw.value = cap.style.width; ch.value = cap.style.height; cl.value = cap.style.left; ct.value = cap.style.top; } </script> <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script> <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script> <script> $(document).ready(function() { $("#caption_selection").draggable({ containment : "#center_frame" }); $("#caption_selection").resizable({ containment : "#center_frame" }); }); </script> </head> <body onLoad="CalculateAllImageWidthes()"> <div id='account_links'> <?php if ($_SESSION['username']) { echo "Welcome $username!"; } else { ?> <a href='login.php'>Login</a> | <a href='register.php'>Register</a> <?php } ?> </div> <h1>Picture Captions</h1> <br/> <br/> <div id="left_bar"> Submit a picture <a href="upload.php">here</a>. <hr/> <h2>Top Images</h2> <br/> <div id="front_pg_images"> <?php foreach($images as $image) { ?> <a onClick="switchImageUrl('<?php echo $image['filename']; ?>', '<?php echo $image['width']; ?>', '<?php echo $image['height']; ?>')"><img src="<?php echo $image['filename'];?>" width="72px" height="58px" id="front_pg_thumbnail"/></a> <?php echo $image['name']." - by ".$image['submitter']; ?> <br/> <br/> <?php } ?> </div> </div> <div id="center_frame" style="width: <?php echo $image['width']; echo "px" ?>; height: <?php echo $image['height']; echo "px" ?>; background-image: url('<?php echo $image['filename'];?>')" > <?php foreach($captions as $caption) { ?> <div id="set_caption" style="width:<?php echo $caption['width'].'px';?>;height:<?php echo $caption['height'].'px';?>; left:<?php echo $caption['posleft'].'px';?>; top:<?php echo $caption['postop'].'px';?>"><?php echo $caption['text'];?></div> <?php } ?> <div id="caption_selection" style="display:none"> </div> </div> <div id="toggle_select_container"> <input type="button" id="toggle_select" onClick="selectionToggle()" value="Caption"/> <div id="caption_input" style="display:none"> <form action="postcaption.php" method="post" onSubmit="collectAttributes()"> <br/> <textarea name="caption_text" cols="27" rows="4" id="input_value"></textarea><br/> <input type="hidden" name="filename" value="<?php echo $image['filename'];?>"/> <input type="hidden" name="width" value="" id="cap_width"/> <input type="hidden" name="height" value="" id="cap_height"/> <input type="hidden" name="left" value="" id="cap_left"/> <input type="hidden" name="top" value="" id="cap_top"/> <input type="submit" value="Post Caption"/> </form> </div> </div> </body> </html> </code></pre> <p>It uses a JavaScript function to change the image when the user clicks on the thumbnail. Take note of the <code>foreach</code>. For everywhere else on the page, the <code>$image['filename']</code> has worked perfectly for similar uses, but it just isn't working when I try to use it with this.</p>
Tags
<php><mysql><url><variables>
Title
Using a variable with a changing value in MySQL query?
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMark Lyons
UserOwnerUserId
1. USMark Lyons
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.