Form population from database?

black_horizons

Hi there,

I'm wondering if anyone can help me "debug" the code. Thing is the update works ok, its meant to allow people to see whats currently in the fields, and then update them to new content. Any and all help greatly appreciated.

Roger_Ramjet

So what is the query, cos what you show ain't gonna work. If this script ain't showing the values in the text boxes then you've got to prove there is any data to display before you worry about your code not displaying it. I personally don't think there is any data in the first place = nothing for me to 'debug'

Debugging 101

Don't use the @ error suppression operator until your code goes live - then always use it
Always echo out the query to see what you are sending to the db BEFORE you send it.
Always echo out the num rows returned to check if you've got anything to display.
Use additional echos to track the values and execution of all control structures - work your way down through the code like that.

Do that and you'll have enough information to debug this.

black_horizons

Yes, there is data in the db. I entered it using the phpdb_edit backend thingy that came on the server. I know for a fact that its in the db. 'cause I have a results page that pulls the data out ok.

I am really a php novice, so if you could explain the four sentences above you there, i'd appreciate it, 'cause I haven't a clue what that all means!

black_horizons

hi again,

still no joy, i've echoed the $numrows, and it shows one record. The problem appears to be in displaying the value in the fields...

Roger_Ramjet

Try this then to see what yu've got

$row=mysq_fetch_array($result);
print_r($row);

black_horizons

eh...no joy...thats all i got...well..at the bottom of the page...which is where i put it.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/catalyticstudios.haisoft.net/httpdocs/blackhorizons/cms/edit.php on line 242

black_horizons

update: edited the $result to be "queryrd" which is the var name of my quer. nothing seems to be appearing though, where i have called the $row...weird??