Re: mysql & php prob...
| From: | Chris Lee | Date: | Fri, 02 Nov 2001 01:17:24 +0000 |
| Subject: | Re: mysql & php prob... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73216@lists.php.net to get a copy of this message | ||
put the mysql_db_query in an if() statement, more likley then not your
select statement isnt returning any results.
--
Chris Lee
lee@mediawaveonline.com
"Sc" <sven@gstar.com.au> wrote in message
news:20011031005814.49017.qmail@pb1.pair.com...
> Hi;
>
> 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
> 'Port$p'.date='$yesterday'");
> $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 without
> thinking but i cant seem to get it...
>
> Thx.
>
> sc
>
>
>