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> Link to comment https://forums.phpfreaks.com/topic/163361-insert-or-update/ Share on other sites More sharing options...
JonnoTheDev Posted June 23, 2009 Share Posted June 23, 2009 What INSERT/UPDATE queries. There are none! Link to comment https://forums.phpfreaks.com/topic/163361-insert-or-update/#findComment-862041 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.