Web Development Thread, MySQL syntax error in Coding and Web Development; I'm trying to make the display of computers not being used as mentioned in another thread.
I am using Webmans ...
18th February 2011, 04:23 PM #1
MySQL syntax error
I'm trying to make the display of computers not being used as mentioned in another thread.
I am using Webmans Login tracker for the script and database but I've got an error in the Mysql syntax which i can't seem to work out.
$computer = mysql_query("SELECT hostname_id FROM logins WHERE active = 1");
$computer_f = mysql_fetch_array($computer);
$computer_f_id = $computer_f['hostname_id'];
$lib = mysql_num_rows(mysql_query("SELECT hostname FROM hostnames WHERE hostname LIKE 'lib-%' AND hostname_id = $computer_f_id")or die(mysql_error()));
19th February 2011, 01:49 AM #2
- Rep Power
Can you show the actual error you're receiving? Syntax errors, usually give a good clue as to where the problem is.
By Lipjam in forum Scripts
Last Post: 15th September 2010, 12:15 PM
By leco in forum How do you do....it?
Last Post: 28th August 2010, 11:37 AM
By stu1892 in forum Windows 7
Last Post: 1st April 2010, 04:15 PM
By birchanger in forum O/S Deployment
Last Post: 24th July 2009, 05:02 PM
By ScottStevinson in forum How do you do....it?
Last Post: 8th September 2008, 02:01 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)