i don't know why its not calling the jfunc(), where did you put the javascript? can u put it on the head <head> section of the page, coz i dont know what's wrong here
ok...upon clicking the update button did it reload? can you paste the query string? i mean the url generated upon clicking the update. coz you will see there if what value are been passed, as i examined you code in order to reach the update and your echoed $sql we have to satisfy the if statement
if ((isset($_GET['action']))&&($_GET['action']=='UpdateResult'))
if clicking the update button regenerates this url mathleteresults.php?action=UpdateResult&athlete_id=187&event=100m swim&result=1:30
dude try removing your html code in your getList.php, just remain your php code
<?php
$q=$_GET["q"];
$con = mysql_connect('localhost', '********', '********');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("*******", $con);
$sql="SELECT * FROM resi_list WHERE id = '".$q."'";
$result = mysql_query($sql);
//php code. this loops through the table based on the variable sent.
while($row = mysql_fetch_array($result))
{
echo'<div id="imgDiv">';
echo'<div id="topimg"><img src='. $row['img1'] .' border=0></div>';
echo'<div id="botPics">';
echo'<div id="smallImg1"><img src=' . $row['img2'] . ' border=0></div>';
echo'<div id="smallImg2"><img src=' . $row['img3'] . ' border=0></div>';
echo'<div id="smallImg3"><img src=' . $row['img4'] . ' border=0></div>';
echo'</div>';
echo'</div>';
}
mysql_close($con);
?>
you dont need another html page inside an html page, and kindly remove the <div id="imgDiv">, coz the main page already had that div, and you dont have to create another inside of it.
just take extra careful when you use echo, if you use double qoutes, use single qoutes inside, if you want to use double qoutes then escape it, and if you use single qoutes it vice versa.
example
echo "<input type='text' name='txttest' />";
if you want to use double qoutes inside, escape them
echo "<input type=\"text\" name=\"txttest\" />";
if you use single qoutes on echo then you do the opposite
echo '<input type="text" name="txttest" />';
if you want to use single qoutes inside, escape them
echo '<input type=\'text\' name=\'txttest\' />';
but if you encounter concatenation, you can use single or double qoutes, it doesn't matter coz concatenation makes it outside the string
have you noticed? your result value is equal to the old result value which is $row. your result should be the value of the result textfield not the $row which is the old one. So let's use javascript to get the value of the result textfield.
put this in the head section of your html code
<script type="text/javascript">
function jfunc(athlete,event,res){
var result = document.getElementById('textres'+res).value;
window.location='?action=UpdateResult&athlete_id='+athlete+'&event='+event+'&result='+result;
}
</script>
just use my attached sql file, i already created that database for you just change the file extension to .sql ex. test2.sql and import it to your database via phpmyadmin
one thing is for sure.... your PHP tags is not parsed... maybe you have problem on your PHP server, or maybe you didn't put it the root directory or you didn't save it as .php
1st of all re-design your database... coz its very hard to join tables coz your not using foreign keys
paste this code in the SQL portion of phpmyadmin to test the query results
SELECT a.firstname, a.lastname, e.name, er.result, e.date FROM event_results er LEFT JOIN athletes a ON ( er.athlete_id = a.id ) LEFT JOIN EVENTS e ON ( er.event_id = e.id )
here just rename this to any name you want and append a .sql ex. test.sql and import it to phpmyadmin
if thats the case then that means that the 'result' field in one of your table is null or empty, are you sure that you named it as 'result' not 'results'. As i see you had 3 tables, if you really want me to help you. can you gave me your database schema so i can test it here. Coz i can just imagine here and visualize what are the data in your database. im not sure if you query is right.
from a developer's point of view... google is the best company in the whole world! from a very simple search engine. Now look at google. they had made so many things, google map, google translate, google chrome, google OS and so many more, they are a brilliant dev team and i idolized the people behind google projects. they are a bunch of genius people. I love google!
- when you cut your nails at night, it brings bad luck - when you see a black cat it brings bad luck - when you dream that you lost your teeth, someone in your family will die
i don't think the world will end, but i think a huge destruction will happen, but the earth is still in one piece.... hmmm the "fall out" game will come to life and the survivors will come out from their vaults, going to start from scratch, people will strive to live in an post-apocalyptic world ^_^
your FREEDOM OF EXPRESSION will lead to war, i am not against it, but it should be used appropriately. RESPECT each others religion as others will kill for it.
yeah i agree.... MAYBE itech7 is lying on screenshots, but i will totally agree on him on the page load, it takes a head ache waiting on page loads, good thing i can hover on threads to see its description before i click a thread i want to engage.
yeah i get what you mean dude like, the facebook share link, when you attach a link a small thumbnail of the site wil be displayed. i dont know that but i know how to get site contents and convert it so string.
<?php
$sql = mysql_query("SELECT user_id, gender FROM user_table WHERE user_id='".$user_id."'");
$row = mysql_fetch_array($sql);
$id = $row['user_id'];
$gender = $row['gender'];
$sql2 = mysql_query("SELECT user_id FROM user_table WHERE user_id!='".$id."' AND gender!='".$gender."'");
while($row2 = mysql_fetch_array($sql2)){
echo $row2['id']."<br />"; // test result, echoed only user_id, since you only want the opposite sex's id
}
?>
