Updating a row

[MFKR]

I've been working on the end parts of my "administrator menu" for my website and I can't figure out how to edit entries in mysql database

http://www.hamfriedchicken.com/admin/show.php

I would have the id be called up in the address and then the info is put into the textbox and all that kind of STUFF. Yeah...hope I can get some help.

[Der_Fisch]

you can every SQL database update like this:

update students
set    exams = 1,
       gpa = 5
where  student_id = 2;

hope that is enough... in case, come back and ask for more
😉

[MFKR]

Still confused...I'm still very new at this I understand what your getting at it would go out like ("UPDATE students set exams = 1, gpa = 5 where student_id = 2"); correct? Would "UPDATE $sqltable set band_name, genre, description, official_site, mp3_link where id=$id"; work? Hope that makes sense.

[Der_Fisch]

hmm, you must give everything a value... try this for eg

UPDATE $sqltable 
SET band_name = $band_name, 
       genre = $genre, 
       description = $desc, 
       official_site = $official_site, 
       mp3_link = $mp3_link 
WHERE id=$id

that would make sense...
because you can't leave something blank like you did:

UPDATE $sqltable 
SET band_name, genre, description, official_site, mp3_link 
WHERE id=$id

in case you won't put something in you must insert 'NULL'...
band_name = NULL will leave the name blank...

hope this helps you... 🆒

[MFKR]

and so for in the <input> and stuff i would set value to $band_name or whatever? and it should work?

[Der_Fisch]

i'm not sure what you mean... but i try to give you the right code...

$sql = "select * from $sqlTable where id='".$_GET["id"];
$Result = mysql_query($sql);
while ( $row = mysql_fetch_array($Result, MYSQL_ASSOC) )
{
  //added a field to your form to pass the ID to the next page, if you have a better idea, then make it so, its just an example, the field is hidden, but some browsers may show it, so it is also readonly
echo "<form action='editband.php' method='post'>
<span id=\"id\" style=\"visibility:hidden;\"> <input type='text' readonly value=". $_GET["id"] ." name='id'> </span><br>
Band Name: <input type='text' name='band_name' value='".$row["band_name"]."'><br>
Genre: <input type'text' name='genre' value='".$row["genre"]."'><br>
Description:<br>
<textarea name='description' rows='60' cols='65' wrap='virtual'>".$row["description"]."</textarea><br>
Official Site: <input type='text' name='official_site' value='".$row["official_site"]."'><br>
Mp3 Link: <input type='text' name='mp3_link' value='".$row["mp3_link"]."'><br>
<input type='submit' name='update' value='Submit'>
</form>";
}
mysql_close();

with this form, you must insert the "UPDATE"-querry on the 'editband.php'...
on this page your UPDATE should look like this

$update="
UPDATE $sqltable 
SET band_name = $_POST['band_name'], 
       genre = $_POST['genre'], 
       description = $_POST['description'], 
       official_site = $_POST['official_site'], 
       mp3_link = $_POST['mp3_link'] 
WHERE id=$_POST['id']";

this should work fine... have phun :p

[MFKR]

Nope...first part doesnt work doesnt even bring the textareas and stuff "form" up. hmmmm damn.

[Der_Fisch]

hmm, don't know why but i can think what it is...
i guess you just insertet the code without the includes...

and if not... then try to delete the <span> </span> tags... perhaps your browser isn't able to display the css information right and gets stuck there...

all other should work fine... and without any error or warning...

[MFKR]

Still doesn't work 😕 btw where do I put the $update ? right below before the mysql_close() or after that? I think it is something to do with the input and the "readonly" you have in there

[Der_Fisch]

as i said, put the

$update=" 
UPDATE $sqltable  

SET band_name = $_POST['band_name'], 
       genre = $_POST['genre'], 
       description = $_POST['description'], 
       official_site = $_POST['official_site'], 
       mp3_link = $_POST['mp3_link']  

WHERE id=$_POST['id']";

into your 'editband.php'
there you must execute it like the select!

do it this way

mysql_query($update);
echo ("Just updated the ". $band_name ." Entry!");

now everything clear?