sql error in chatbox on tbdev

Started by codex, December 05, 2017, 03:00:05 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Tundracanine

this line will never work..
$res = mysql_query($GLOBALS["___mysqli_ston"], "SELECT * FROM shoutbox ORDER BY shoutbox.sticky ASC, date DESC LIMIT 200") or sqlerr(__FILE__, __LINE__);
has to be
$res = mysqli_query($GLOBALS["___mysqli_ston"], "SELECT * FROM shoutbox ORDER BY shoutbox.sticky ASC, date DESC LIMIT 200") or sqlerr(__FILE__, __LINE__);

mysql support itself be removed in latest phps version and replaced with mysqli
If wanting support help please put bare min info like
Os:
U-232 Version:
Php Version:
Tracker type: like xbt or php
Saves on asking more questions just so people can help someone.

Mindless

#2
Can't expect to use mysqli extension when that codes using mysql_query, mysqli_query($GLOBALS.... is correct syntax.

codex

SQL Error

in /home/jiotorrents/public_html/shoutbox.php, line 320


the line 320 is as follows

$res = mysql_query($GLOBALS["___mysqli_ston"], "SELECT * FROM shoutbox ORDER BY shoutbox.sticky ASC, date DESC LIMIT 200") or sqlerr(__FILE__, __LINE__);

what is easy can anyone help