Re: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-03 Thread David Robley
On Thu, 3 Feb 2005 13:49, Graeme wrote:

 I like the idea of a mysqli_queasy() function. Maybe it would allow you
 to sumbit SQL statements that don't conform to any standard? ;)
 
 graeme.
 
 Bastien Koert wrote:
 
 the second error is a misspelling in the mysqli_query command

 bastien

 Call to undefined function mysqli_quesry() in C:\Apache

Or it vomits on your monitor if there is a syntax error?

-- 
David

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread J. Connolly
I am getting the gollowing error message:
PHP Warning: mysqli_select_db() expects parameter 1 to be mysqli, string 
given in C:\Apache Group\Apache2\htdocs\PHP\_debug_tmp.php on line 5 PHP 
Fatal error: Call to undefined function mysqli_quesry() in C:\Apache 
Group\Apache2\htdocs\PHP\_debug_tmp.php on line 9

With the following code:
1?php
2//in order to connect
3$conn = mysqli_connect(localhost,root,67568);
4//inorder to designate database
5mysqli_select_db(php_example, $conn);
6
7//creating a table
8$sql = CREATE TABLE inventory (id int not null primary key 
auto_increment, item varchar(75));
9$result = mysqli_query($sql, $conn);
10echo $result;
11?

I am a total noob and am trying to copy this right out of a book (except 
the mysqli part which i had to struggle through on my own). I am using 
MySql 4.1.8 and PHP5 on Apache 2.0 server. Any help would be great.
Thank you,
jozef

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread Bastien Koert
mysqli_select_db progblem is that the arguements are reversed, should be 
$link, $dbname

the second error is a misspelling in the mysqli_query command
bastien
From: J. Connolly [EMAIL PROTECTED]
To: PHP list php-db@lists.php.net
Subject: [PHP-DB] Connecting To Mysql through php/mysqli
Date: Wed, 02 Feb 2005 10:39:37 -0500
I am getting the gollowing error message:
PHP Warning: mysqli_select_db() expects parameter 1 to be mysqli, string 
given in C:\Apache Group\Apache2\htdocs\PHP\_debug_tmp.php on line 5 PHP 
Fatal error: Call to undefined function mysqli_quesry() in C:\Apache 
Group\Apache2\htdocs\PHP\_debug_tmp.php on line 9

With the following code:
1?php
2//in order to connect
3$conn = mysqli_connect(localhost,root,67568);
4//inorder to designate database
5mysqli_select_db(php_example, $conn);
6
7//creating a table
8$sql = CREATE TABLE inventory (id int not null primary key 
auto_increment, item varchar(75));
9$result = mysqli_query($sql, $conn);
10echo $result;
11?

I am a total noob and am trying to copy this right out of a book (except 
the mysqli part which i had to struggle through on my own). I am using 
MySql 4.1.8 and PHP5 on Apache 2.0 server. Any help would be great.
Thank you,
jozef

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


RE: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread J. Connolly
Thank you Bastian, I found that the two variables were reversed right 
when your answer came in. The book i got is horrible.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


Re: [PHP-DB] Connecting To Mysql through php/mysqli

2005-02-02 Thread graeme
I like the idea of a mysqli_queasy() function. Maybe it would allow you 
to sumbit SQL statements that don't conform to any standard? ;)

graeme.
Bastien Koert wrote:
the second error is a misspelling in the mysqli_query command
bastien
Call to undefined function mysqli_quesry() in C:\Apache 

--
Experience is a good teacher, but she sends in terrific bills.
Minna Antrim
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php