karnegyhall Posted June 23, 2009 Share Posted June 23, 2009 The file is uploading, and there are no errors, but I'm not seeing any updates to 'tblatheletepics' can someone help me out? also, if you have any ideas for how to accomplish this, i'm game for those too. Thanks so much. </head> <body> <?PHP $ID = $_SESSION['SESS_MEMBER_ID']; $conn = mysql_connect("host", "db", "pwd*"); if (!$conn) { die('Could not connect: ' . mysql_error()); } $select = mysql_select_db('sportstalkadmin', $conn); if (!$select) { die('could not select db: sportstalkadmin ' . mysql_error()); } $result = mysql_query("SELECT strLastName FROM tblathletes WHERE intAthleteID='$ID'"); ?> <h1>Welcome <?php while($row = mysql_fetch_array($result)) echo $row['strLastName'];?></h1> <?php $displayimage = "SELECT strPicPath FROM tblathletepics WHERE intAtheleteID='$ID'"; $result1 = mysql_query($displayimage) or die('Error, query failed'); $row1 = mysql_fetch_assoc($result1); $img = $row1['strPicPath']; $displayvideo = "SELECT strVideoPath FROM tblathletevideos WHERE intAtheleteID='$ID'"; $result2 = mysql_query($displayvideo) or die('Error, query failed'); ?> <div align="left"> <p><img src="<?php echo $img;?>" height="200" width="200"/></p> <a href="sports-memberprofile.php">Edit/Create Profile</a> | <a href="sports-logout.php">Logout</a> <?php $displayvideo1 = "SELECT strVideoPath FROM tblathletevideos WHERE intAtheleteID='$ID'"; $result4 = mysql_query($displayvideo1) or die('Error, query failed'); $row4 = mysql_fetch_assoc($result4); $img4 = $row4['strVideoPath']; ?> Highlight Reel1<a href="'pop2.php?url="<?php echo $img4;?>"</a> <p> </p> <p> <a href="index.htm">..Home</a> </body> </html> Quote Link to comment Share on other sites More sharing options...
JonnoTheDev Posted June 23, 2009 Share Posted June 23, 2009 What INSERT/UPDATE queries. There are none! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.