Creat1ve Posted June 21, 2008 Report Posted June 21, 2008 (edited) Manam torrentam lec errors SQL Error Unknown column 'ip' in 'where clause' in C:\Program Files\xampp\htdocs\include\bittorrent.php, line 256 Šeit it tā 256 līnija $res = mysql_query("SELECT * FROM bans WHERE ip = $nip") or sqlerr(__FILE__, __LINE__); Edited June 21, 2008 by Creat1ve
Pentiums Posted June 21, 2008 Report Posted June 21, 2008 to rindiņu aizstāj ar šito rindiņu $res = mysql_query("SELECT * FROM bans WHERE ip = '$nip'") or sqlerr(__FILE__, __LINE__);
Creat1ve Posted June 21, 2008 Author Report Posted June 21, 2008 Nesanāk! Tapat tas errors SQL Error Unknown column 'ip' in 'where clause' in C:\Program Files\xampp\htdocs\include\bittorrent.php, line 256
bubu Posted June 21, 2008 Report Posted June 21, 2008 Doh.. tev jau tak pateica, kur ir vaina: bans tabulā nav 'ip' kolonnas...
n0r3k Posted June 26, 2008 Report Posted June 26, 2008 (edited) to rindiņu aizstāj ar šito rindiņu $res = mysql_query("SELECT * FROM bans WHERE ip = '$nip'") or sqlerr(__FILE__, __LINE__); tas neatrisina problēmu, ka tabulā nav kolonnas. un pareizi būtu $res = mysql_query("SELECT * FROM bans WHERE ip = '".$nip."' ") or ... Edited June 26, 2008 by n0r3k
andrisp Posted June 26, 2008 Report Posted June 26, 2008 n0r3k, ko noziimee "pareizi" ? Vai tad viņa variants nestrādātu ? PS. Man pasham ari labaak patiik izdaliit mainiigos no stringa, bet tas jau nenoziimee, ka tas ir pareizais veids un visi citi - nepareizi.
Recommended Posts