Busy — Thu, 27 Nov 2003 03:11:39 +0000

$text = $_POST['text'];

dollar sign infront of the variable name, and single quotes inside the boxed brackets, not outside.

Just remember the method in the form MUST be post to use $_POST, if it's get, use $_GET

brady.k — Thu, 27 Nov 2003 01:33:53 +0000

now i'm getting nothing displayed at all! not even the html!

i changed the text='$text' to text='$_POST[text]' and same for date

Renegade — Tue, 25 Nov 2003 09:55:28 +0000

Yes even in a dB, where ever you need to use the variables. Where else does "it" know where to get it from?

brady.k — Tue, 25 Nov 2003 03:22:13 +0000

even in a dB?

necrotic — Tue, 25 Nov 2003 02:35:05 +0000

If they are submitted via form and its a POST form then you need to use $_POST['var'].

brady.k — Tue, 25 Nov 2003 00:45:38 +0000

the variables will be submitted via form, although I have been inserting them directly into the table

necrotic — Tue, 25 Nov 2003 00:40:45 +0000

How are you obtaining the variabls $data and $date? From the URL? If yes, try $_GET['data'] and $_GET['date']

brady.k — Tue, 25 Nov 2003 00:39:36 +0000

As I'm sure you suspected, it returned "Error Returned: Proper variables not set".

What does this mean? i have set the proper variables in both the dB and the php!

necrotic — Mon, 24 Nov 2003 20:02:32 +0000

Try this code:

<?php
$con = mysql_connect('locahost','user','pass') or die(mysql_error());
mysql_select_db('db',$con) or die(mysql_error());

if ((!isset($data))||(!isset($date))) {
    echo 'Error Returned: Proper variables not set.';
} else {
    $query = mysql_query(\"SELECT * FROM `news` WHERE data='$data' AND date='$date'\") or die(mysql_error());
    $result = mysql_fetch_array($query) or die(mysql_error());
    $text = $result['text'];
    $date = $result['date'];
}
?>

brady.k — Sun, 23 Nov 2003 16:38:54 +0000

it's telling me that mysql_fetch_array isn't a valid "result resource", and i checked php.net, it looks good to me....?!

i was told that you should send the xml header twice, or it will confuse the browser, and possibly screw up your presentation, but speaking of which, i just re-ran it, it had an error, got rid of the last declaration, and it works fine now. lol.