Blank Variables

Kyoushu

2 problems:

ADD CODE - this creates a new row in the table, but all the variables are blank :S.so i effectively get an empty row created.

VIEW CODE - this outputs the row correctly (i manually entered one in phpmyadmin to test this), but it complains about an error that i have tracked down to being in the while loop where i copy the contents of each cell over to its own variable so i can echo it later in the loop.any help will be really appreciated, i've been stuck on this for 2 hours now!
thanks!

ADD code:

$date = addslashes($POST['adddate']);
$opponents = addslashes($POST['addopponents']);
$venue = $POST['addvenue'];
$result = addslashes($POST['addresult']);

$sql = "INSERT INTO badgresults2003 (date, opponents, venue, result) VALUES ('$date', '$opponents', '$venue', '$result') ";

$result = mysql_query($sql, $cid);

RETRIEVE CODE:

$query = "SELECT * FROM badgresults2003";
$result = MySQL_query($query);

while( $row = MySQL_fetch_array($result) ) {
$date = $row['date'];
$opponents = $row['opponents'];
$venue = $row['venue'];
$result = $row['result'];

//Output in loop
echo (" $date $opponents $venue $result ") ;
}

dalecosp

Probably the vars have no value when inserted.

Generally a first step in debugging is to insert echo() or print() statements (or even [man]print_r/man or [man]var_dump/man in the case of arrays) in between each step of the code and make sure values are being passed.

That said, it also doesn't look like you are testing for success in the db operations. Of course, that could just be 'cuz this is example code?

Kyoushu

yea, this is just where i know the errors are.they have code to check success, and the add code says it was successful,but when you look at the table, the variables it passed were blank.ive tried just echoing the variables like $date after transfering them, they are blank 🙁. but the form fields are definitely filled in.help!

dalecosp

var_dump($_POST) ???

Kyoushu

huh?confused, soz.ive been working out of tutorials to do what ive done so far, so please treat me as a complete newb 🙂.

dalecosp

OK, you unworthy newb!! :p (kidding! really!! come back!!!) 😃 😃

Seriously, if you'll put

var_dump($_POST);

at the top of the receiving script, you'll see the entire content(s) of the POST array, and that might help us determine if anything is actually being posted from your form to your handler script.

Kyoushu

lol, k, il come back 😛.thanks.

ok, done the var_dump, it says:

array(0){}

im guessing that's a bad thing.

dalecosp

Probably is a bad thing. At least, if you're expecting to POST something from a form. 😉

Does your HTML form (the one sending to this script) have the proper "method" set?

Kyoushu

oooh, my bad, typo in form.ok, so thats sorted the added, but the view.php is still screwed 🙁. lets have another feat of deduction please!(v grateful btw).

thanks.

dalecosp

Well, I'm a tad overdue to frost a birthday cake.

Also, you mention, but didn't post the "error" message in the output loop.

Kinda hard to "deduce" with no evidence!! 😃

Kyoushu

removed url

line17 puts it on the last line of what i posted - $result = etc.

evidence?and there was me thinking you just used majic 😛

dalecosp

Well, this error message ("Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/public_html/view.php on line xxx") is simply telling you that the query didn't return a valid resource ID.

One thing that might help: if you name a table field "result", under no circumstances should you name that variable $result when you are already using $result as the resource ID for the SQL query. Let's call it 'winner' or 'score' instead??

Next we just have to figure out why there's no $result returned from the query. You did connect to the db, right?

tigeress

I think the 1st problem is caused by the incorrect $sql string.I know the string between single quotes is not interpreted,so I think you can connect string and variable with ".",for example:
$query = "INSERT INTO usecase (casetype,target,condition,input,output) VALUES ('".$POST['casetype']."','".$POST['target']."','".$POST['condition']."','".$POST['input']."','".$_POST['output']."')";

Kyoushu

thanks tigress, but dalecosp has fixed both problems.dalecosp - im extremely grateful, thanks a lot, my errors seem really obvious now, i should have known about the variable at least, that was staring me in the face!once again, thanks.il come back when i know sumat bout php, try to give back to the community again!