Your query is invalid, hence $test is false rather than a result set. I
usually do if ($test = mysql_db_query( ... )) to trap this. Don't put quotes
around table or field names, in your case 'Port$p' should be just Port$p and
'Port$p'.date just Port$


        From:  sc [SMTP:[EMAIL PROTECTED]]
        Sent:  31 October 2001 00:56
        To:  [EMAIL PROTECTED]
        Subject:  php & mysql prob...


        i keep getting an error of: Warning: Supplied argument is not a
valid MySQL
        result resource in /datascripts/insertdata.php on line 17...

        Line 17 is: $row = mysql_fetch_assoc($test);

        and here is the rest of it (not all of it though):

        for ($p = 1; $p <= 24; $p++) {
        $test = mysql_db_query("melbourne", "SELECT * FROM 'Port$p' WHERE
        $row = mysql_fetch_assoc ($test);
        $yindata = $row['switchin'];
        $youtdata = $row['switchout'];
        $dinPort = '$inPort$p' - $yindata;
        $doutPort = '$outPort$p'  - $youtdata;

        Can anyone help me overcome this prob? i've prob missed something
        thinking but i cant seem to get it...



PHP General Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to