stupid error!!

MatttWithOneT

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/virtual/site13/fst/var/www/html/tryout.php on line 17

I keep getting that, for reasons I can't figure out. My code for that goes:

$query = "CREATE TABLE poop (age INT)";
mysql_query($query, $link)
or die ( "couldn't add info: " . mysql_error() );

That's not what I want, but even that simple crap brings up the warning. I don't understand what I'm doing wrong! Someone please help!

cschotch

I used to get something similar but then I had to do a primary key for one of them and it worked....
but my question is have you defined a valid database in the script

hand

Did you select a database? I know: what a question, but did you?

Could you connect to mySQL without errors?

I'm not sure that you posted line 17

MatttWithOneT

Yeah, I'm positive it is selecting and opening the database. I don't know I've been working on this all day!

cschotch

post all the lines of your script inside the

tags up to line oh say the 25th line and we will take a look at it...
is it giving any other error messages or is that the only 1

MatttWithOneT

This is the code:

<?php

include('zaos_engine.php');
$connect = new zaos();
$connect->connect();


$query = mysql_query("CREATE TABLE poop (age INT)", $link)
	or die ( "couldn't add info:  " . mysql_error() );
if($query)
	echo "<p>It worked.</p>";


?>

and this is the function connect() i wrote in my class:

function connect() {

    $link = @mysql_connect('localhost', $user, $pass);
        if($link)
        	echo "connected";
        if(!$link) {
        echo "<p>" .
        	  $this->error['no_connect'] .
              mysql_error() .
              "</p>";
              }
    $db = "zaos-warriors_net";
    mysql_select_db($db, $link)
    	or die ("<p>Database unavailable:  " . mysql_error() ."</p>");
    if(mysql_select_db($db)) {
    	echo "<p>Database opened. </p>";
        }
}

cschotch

I rewrote it but because I did not have the class you had had to write it a little differently.....hopefully you can adappt it to your class. I ran it on my local apache/MySql machine and it worked everytime....

<?php
$user = 'user';
$pass = 'password';

function connect() {

    $link = @mysql_connect('localhost', $user, $pass);
        if($link)
            echo "connected";
        if(!$link) {
        echo "<p>" .
              $this->error['no_connect'] .
              mysql_error() .
              "</p>";
              }
	$db = 'name_of_table';		  
    mysql_select_db($db)
        or die ("<p>Database unavailable:  " . mysql_error() ."</p>");
    if(mysql_select_db($db)) {
        echo "<p>Database opened. </p>";
        }
}
// call of function..I dont think your function call was working
connect();

$query = mysql_query("CREATE TABLE poop (age INT)") or die ( "couldn't add info:  " . mysql_error());

if($query)
	{
    echo "<p>It worked.</p>";
	}
else
	{
	echo 'Nothing happened';
	}
?>