Discussion :

[Invité]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
if(!empty($_GET['cat'])) {
    $smarty->assign('showfiles','yes');
	$files_id = array();
	$query_files = mysql_query('SELECT ch_code, ch_title, fn_image, fl_original, fl_updated, fl_old, fl_corrupted, fl_uploading, fl_soon, fl_error, fl_new, ch_director, ch_actors, ch_keywords, dt_movie, dt_update, fn_image, count_dl, server_id, lb_site, server_name FROM video v, server s WHERE v.server_id = s.server_id AND v.category='.$_GET['cat'],$db);
	while ( $data = mysql_fetch_assoc($query_files) ){
		array_push($files_id,$data);
 
	}
	$smarty->assign('files_id',$files_id);
}

bonjour,

quel est le probleme avec ma requete ?

j'ai ce message

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\www\tamilrip\admin\admin.php on line 16

[Invité]

salut

mysql_error() et copier/coller de la requete dans phpMyAdmin

[Invité]

Error

SQL-query: Documentation

SELECT ch_code, ch_title, fn_image, fl_original, fl_updated, fl_old, fl_corrupted, fl_uploading, fl_soon, fl_error, fl_new, ch_director, ch_actors, ch_keywords, dt_movie, dt_update, fn_image, count_dl, server_id, lb_site, server_name
FROM video v, server s
WHERE v.server_id = s.server_id
AND v.category =3
LIMIT 0 , 30

MySQL said: Documentation
#1052 - Champ: 'server_id' dans field list est ambigu

[Invité]

Problème reglé merci beaucoup