Simple Problems With MySql

Oni

Heya!

I've been trying to create a pretty basic database function. The only problem is that I'm not sure what's the problem...Because it doesn't work! It gives me parse errors on all of the database executions

<?
@mysql_connect("localhost", "Alper", "deniz") or die("Could not connect to MySQL server!");
@mysql_select_db("si") or die("Could not select si database!");


//To create newest, biggest id
INSERT INTO tbl VALUES('BrinOnish','BrinOnish','BrinOnish','BrinOnish');

//Get the biggest id so we can use
$id = SELECT id FROM si WHERE username = 'BrinOnish';

//Delete id getter for next use
DELETE FROM si WHERE username='BrinOnish';


Print $id;


//INSERT INTO tbl(username,email) VALUES("$username","email");

?>

There are a total of 4 columns in the table and the password and all of the connection information is correct. The id is auto_increment. What This thing is trying to do is simply get the next user number in order of the last user.... More recent, bigger number.

Any ideas? :o

Thanks !

coreyp_1

One problem is that you cannot simply put a query string into your code. You have to call the appropriate functions. Instead of this:

<?
//To create newest, biggest id
INSERT INTO tbl VALUES('BrinOnish','BrinOnish','BrinOnish','BrinOnish');
?>

Use this:

<?
//To create newest, biggest id
$query = "INSERT INTO tbl VALUES('BrinOnish','BrinOnish','BrinOnish','BrinOnish')";
mysql_query($query);
?>

This should get you started on the right path.

Oni

So it looks something like this now:

Would I need to put query's for every single command also? Or...?
I had downloaded an ebook--"A Programmers Guide to Basic Php 4" or something like that. Well would anyone reccommend another book?
🙂

<?
@mysql_connect("localhost", "Alper", "deniz") or die("Could not connect to MySQL server!");
@mysql_select_db("si") or die("Could not select si database!");


<?
//To create newest, biggest id
$query = "INSERT INTO tbl VALUES('BrinOnish','BrinOnish','BrinOnish','BrinOnish')";
mysql_query($query); 

//Get the biggest id so we can use
$id = SELECT id FROM si WHERE username = 'BrinOnish';

//Delete id getter for next use
DELETE FROM si WHERE username='BrinOnish';


Print $id;


//INSERT INTO tbl(username,email) VALUES("$username","email");

?>

coreyp_1

yes, you must use the function mysql_query() each time.
no, I do not own any books to suggest to you. I learned by coming to these forums and trying to help others solve their problems. That was a few years ago. Now I'm back to PHP, and decided I needed to sharpen my skills again, so here I am!

I'm looking at your queries again, and they seem a bit confusing to me. What tables are you using, "si" and "tbl"?

Oni

<?
@mysql_connect("localhost", "Alper", "deniz") or die("Could not connect to MySQL server!");
@mysql_select_db("si") or die("Could not select si database!");


<?
//To create newest, biggest id
$query = "INSERT INTO tbl VALUES('BrinOnish','BrinOnish','BrinOnish','BrinOnish')";
mysql_query($query); 

//Get the biggest id so we can use
$query = "$id = SELECT id FROM si WHERE username = 'BrinOnish'";
mysql_query($query);  

//Delete id getter for next use
$query = "DELETE FROM si WHERE username='BrinOnish'";
mysql_query($query);  


//To test if it worked...
Print $id;


//If test passes then some other code here (Form Code)


//$query = "INSERT INTO tbl(username,email) VALUES("$username","email")";
//mysql_query($query);  

?>

Sorry...I don't have time to test because Im going to bed... That

Print $id;

is just there to see if the function works. Later on I'm going to at that part to some other code which I have made ready which isn't in php so it shouldn't cause any problems...

I'll try it all and give it a final lookover tommorow morning...Thanks for the advice 😃

coreyp_1

$id cannot be set strictly from the SQL query. You should probably use something closer to this:

//Get the biggest id so we can use
$query = "SELECT id FROM si WHERE username = 'BrinOnish' LIMIT 1";
$resource = mysql_query($query);  

$result = mysql_fetch_array($resource);

echo $result['id'];

Oni

<?
@mysql_connect("localhost", "Alper", "deniz") or die("Could not connect to MySQL server!");
@mysql_select_db("si") or die("Could not select si database!");


//To create newest, biggest id
$query = "INSERT INTO tbl VALUES('BrinOnish','BrinOnish','BrinOnish','BrinOnish')";
mysql_query($query); 


//Get the biggest id so we can use
$query = "SELECT id FROM si WHERE username = 'BrinOnish' LIMIT 1";
$resource = mysql_query($query);  

$result = mysql_fetch_array($resource);

echo $result['id'];  

//Delete id getter for next use
$query = "DELETE FROM si WHERE username='BrinOnish'";
mysql_query($query);  




//If test passes then some other code here (Form Code)


//$query = "INSERT INTO tbl(username,email) VALUES("$username","email")";
//mysql_query($query);  

?>

I get:

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\smile\databasework.php on line 14

I think that means that it didnt like mysql_query($query) as a resource?

coreyp_1

It means that mysql_query() is not returning a valid resource. The problem may be in the query line.

This is the structure I see in your code:
You have a database named "si".
You have two tables in this database, one named "si" and another named "tbl".

What doesn't make sense to me is that you are inserting a value into one table "tbl", but you are not specifying the column names. Secondly, you are then attempting to pull information from a different table, "si", and then delete the information from the second table, "si".

Is this what you are trying to do, or am I misunderstanding your code?

Oni

hehe lol I see.
Ya I fixed that...For some reason when I wrote this I must have thought I should write the database name instead of the table name....
It works now! The only thing is that I think that even If I delete the entry that I had put there just to see what the auto increment number would be...Well I think that even though I delete it the auto_increment keeps on going from the last number... So to get the number of users I'd have to divide the user id number by 2 because one of the 2 is the one I created for the new user...

Or maybe I'm mistaken and wasn't able to delete for some reason?

I could I suppose just make the user id numbers myself by adding 1 each time but that would just make the thing more complicated and all I wanted was something like this to get a number which wasn't random and which you could easilly find the number of users and such...

Well anyway...Thanks!! 🙂