XAMPP SQL/PHP HELP can anyone help me with this problem?

[Jack]

Hello

Im using XAMPP 1.7.4 beta 2 to test my applications. When I connect to mysql (which came with the XAMPP) using the mysqli_connect function it works because it does not display an error message from the or die(“not connecting”) function

But when i try to query the database and insert values it does absolutely nothing. The other problem I have is that I cant create a database with the mysql that came with XAMPP because i do not have privileges over mysql. and i cant set the privileges because i donnt know the master passord and user name aaaaaah I know the default passwor is “” and username is “root” but it doesnt work.

but what confuses the hell out of me is that when i add a database to Mysql localhost mysql doesnt show the database when i type in the show databases command but i can connect to it but not query it? what the hell,

is the beta version the problem?
can you send me code for a connection test?
can someone explain to me how i can install mysql so that xampp will still connect to that sql ?
or any help will be good.

[richei]

You’re confusing us, can you connect or not? if you don’t know the login, it should be in the php.ini somewhere.

[ErnieAlex]

Well, it sounds like you are connecting to the database, but that your queries are not processing.
So, as Richei and I have told many people before… SHOW US THE CODE…

Help us help you… LOL…

Create the smallest possible sample of your connection code and query for creating your table and post it to us. We can help you locate the problem…

[PHP_Person]

Google is your friend in this case… as quoted from http://answers.oreilly.com/topic/2557-mysqli-connect-vs-mysql-connect/:

"There are different opinions on which connector/extension is faster. Here is a simple guideline that you should follow:

If the MySQL database you are connecting to is <= 4.1.3, then use mysql_connect.
If the MySQL database you are connecting to is > 4.1.3, then use mysqli_connect.

Though you can use mysql_connect with newer versions there are certain functions you cannot access. This information was pull from:

PHP.net - go down to the section “What is PHP’s MySQL Extension?”.

CR"