Hello Charles,
First I would like to thank you for responing, sec would you be
willing to help me get this dum code under php 4.3 and MySQL 3.23.58?
I am geting very confused and not to happy right now with this. I am
very very new to this stuff. I did it before and it was a long time
ago and did not get to far and can not find the files that did work
:(.
If you are willing to help me please either IM me or email me back
Sincerly,
Christopher & Missy
IM for yahoo is spiritssight
IM for AOL is mreyes2ce
IM for MSN is spiritssight with @ g mail . com
And email is sersory . access @ g mail . com
On 3/24/06, C.P. Web Designs <[EMAIL PROTECTED]> wrote:
> Well, while I have not personnaly used the new mysqli extensions, I
> note a few small issues with the script as posted.
>
> > $conn = mysqli_connect( "localhost", "UN", "PW", "DBN" ) or die(
> mysql_error() );
>
> While that line looks ok, the manual uses the following to check for
> a connection:
>
> /* check connection */
> if (mysqli_connect_errno()) {
> printf("Connect failed: %s\n", mysqli_connect_error());
> exit();
> }
>
> Now, in the CREATE TABLE block, you are missing the comma's that
> separate the field defs:
>
> > //Set variable to creat table if not existing
> > $sql = "CREATE TABLE IF NOT EXISTS nfnpdb-t
> > (
> > EIN int(11), <--- here
> > PNO varchar(70)
> > )";
>
> Just below that, you are making a NON mysqli query:
>
> > if( mysql_query( $conn, $sql )) {
>
> You should probably change that line to:
>
> /* Create table doesn't return a resultset */
> if ($mysqli->query($sql) === TRUE) {
> printf("Table nfnpdb-t successfully created.\n");
> }
>
> I hope that helps.
>
> -Charles
>
> --------------------------------------------------
> Charles Pelkey
> C.P Web Designs <[EMAIL PROTECTED]>
> http://cpdesigns.homeip.net/
> ICQ: 8294384
> AIM: cpwebdesigns
> Fax & voicemail: (928) 962-2939
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
> Community email addresses:
> Post message: [email protected]
> Subscribe: [EMAIL PROTECTED]
> Unsubscribe: [EMAIL PROTECTED]
> List owner: [EMAIL PROTECTED]
>
> Shortcut URL to this page:
> http://groups.yahoo.com/group/php-list
> Yahoo! Groups Links
>
>
>
>
>
>
>
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php-list/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
