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.
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.
why do you have to extract() the result? when you can already traverse the recordset via mysql_fetch_array. and when you do extract you dont use arrays anymore like $row coz extract() assign values to array indexes so instead of echo $row you use $content. you may try this
<?php
$query = sprintf("SELECT * FROM property_images JOIN property ON property.id = property_images.property_id ORDER BY property_images.id DESC LIMIT 0 , 30");
$result = mysql_query($query, $db) or die('Error, query failed');
if (mysql_num_rows($result) == 0) { echo "Error: property has no images. "; }
else {
while ($row = mysql_fetch_array($result)) {
header('Content-type: ' . $row['uploadedimage_type']);
header('Content-length: ' . $row['uploadedimage_size']);
echo $row['content']; } // end while
} // end else
?>
rajarajan was right... it's all about file permission. You must edit it either through ftp or explicitly define it using php chmod() function. set the permission to 0775
it wont display dude coz its a tag. i dont what kind of tag is that but you actually created it... try viewing the source code and youll see that your tag has been created.
I wanna say that im not lazy even since i've started posting in this forum..for your higher information, every single code or i mean syntax you've posted,i always try to search the meaning,the function of that code..i have a tutorial here PHP and Javascript.And if you didn't know,i learned..i've gained new knowledge in some of your code.Yeah i searched,but if i do not find any answer,i just post in this forum..and ask some help..and yeah,i copy the code here but not all the codes i've asked here were copy and paste..well, it's your opinion and view of point,but you can't see me while thinking,debugging all the codes..Ya,learning comes from asking,and when you ask,there's an explanation why..Just ask and you learn something new..im not a typical person that you know copy and paste the codes, i searched. study the all the PHP codes in w3schools,print it so that i have a hard copy here..tnx for your commented..
i really hope it's true as we are taking our time and effort on helping you here. About your error in search, you said that there's an error. can you show us the error?. coz. i didn't find any wrong in the code.
