Syntax problem again..
Posted: Tue Jul 13, 2010 4:01 am
Problem with this line:
$tipomus is string.
The error in Remote Server:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prolatin/public_html/sml/to.php on line 124
In Local Wamp Server work OK.
This line work Local and Remote:
So, the problem in Remote is ... but don´t know why.. Thx..
Code: Select all
$result = mysql_query("SELECT TEMA, ARREGLO, AUTOR, RITMO, ARCHIVO, FECHA, NUEVO, CLASE from TEMAS where CLASE like \'%'.$tipomus.'%\' order by TEMA"); }
while($row=mysql_fetch_assoc($result)){
//.....continue the code......The error in Remote Server:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/prolatin/public_html/sml/to.php on line 124
In Local Wamp Server work OK.
This line work Local and Remote:
Code: Select all
$result = mysql_query("SELECT CLASE, TEMA, RITMO, AUTOR, ARREGLO,FECHA, NUEVO FROM temas ORDER BY tema");Code: Select all
like \'%'.$tipomus.'%\'