Re: php & mysql prob...
| From: | Mike Frazer | Date: | Wed, 31 Oct 2001 05:10:04 +0000 |
| Subject: | Re: php & mysql prob... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72966@lists.php.net to get a copy of this message | ||
I may be a little backward here but wasn't mysql_db_*() deprecated?
Keep in mind it was a long day at work and I'm tired. I could be on fire
right now and probably just want to open a window to cool off. :)
Mike
"Sc" <sven@gstar.com.au> wrote in message
news:20011031010249.52603.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
>