s0c0 Posted January 28, 2007 Share Posted January 28, 2007 I get this error:[quote]Fatal error: Call to undefined function mysqi_query() in /srv/www/htdocs/adduser.php on line 14[/quote]When attempting to run this query against my mysql database:[quote]mysqi_query($con, "CREATE TABLE chris (id MEDIUMINT(9) auto_increment primary key, track VARCHAR(50) not null, artist VARCHAR(50) not null, album VARCHAR(50), year SMALLINT(4), genre VARCHAR(50), filelink VARCHAR(150), playlist VARCHAR(50))");[/quote]The mysqli connection is working as I am able to perform a query which inserts into a table. Why am I unable to create a new table in the same database? I have created a special user for queries against this db and create_priv is on in the mysql.user table. Even when I try with root I get the same error! Any ideas? Let me know if more information is needed. Quote Link to comment https://forums.phpfreaks.com/topic/36033-solved-fatal-error-call-to-undefined-function-mysqi_query-in-srvwwwhtdocsadduser/ Share on other sites More sharing options...
trq Posted January 28, 2007 Share Posted January 28, 2007 Its mysqli_query() not mysqi_query(). Quote Link to comment https://forums.phpfreaks.com/topic/36033-solved-fatal-error-call-to-undefined-function-mysqi_query-in-srvwwwhtdocsadduser/#findComment-171007 Share on other sites More sharing options...
.josh Posted January 28, 2007 Share Posted January 28, 2007 or mysql_query() Quote Link to comment https://forums.phpfreaks.com/topic/36033-solved-fatal-error-call-to-undefined-function-mysqi_query-in-srvwwwhtdocsadduser/#findComment-171008 Share on other sites More sharing options...
s0c0 Posted January 28, 2007 Author Share Posted January 28, 2007 IDIOT! Where is the emoticon with the sign that just says stupid. Thanks for helping me debug that lol. Quote Link to comment https://forums.phpfreaks.com/topic/36033-solved-fatal-error-call-to-undefined-function-mysqi_query-in-srvwwwhtdocsadduser/#findComment-171028 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.