Re: Updating mysql from php

[Peter Brawley]

You're using an obsolete API for mysql, mysql. Don't. It has already gone way in some PHP versions. Use mysqli.

> foreach ($dbo->query($quer2) as $noticia2) {

Two problems with this, First, read the manual page again for query(); it returns a result object, not direct results. Second, every mysql call that can throw an err needs error handling. So the above would need to become something like ...

$res = $dbo->query($quer2);
if( !$res ) exit( $dbo->error );
$a = array();
while( $a=$res->fetch_array($res) ) {}
if( $dbo->error ) exit( $dbo->error );
foreach( ...



Edited 1 time(s). Last edit at 03/14/2019 09:41AM by Peter Brawley.