Topic awaiting preservation: What's wrong with this query? (Page 1 of 1)

$query_showPosts = "SELECT jugador FROM parados where jugador != '".$remote_userName."' limit 1";

$result_showPosts = mysql_query($query_showPosts, $link);

$num_posts = mysql_num_rows($result_showPosts);

while ($row = mysql_fetch_array($result_showPosts)) {

	$query_juegos = "INSERT INTO match (jugador1,jugador2) VALUES ('".$row[0]."','".$remote_userName."')";

	if (mysql_query($query_juegos, $link)) {

		echo "<br>".$row[0]." vs ".$remote_userName."\n";

	}

	else{

		echo "huh?";

	}

							

}

It just returns the Huh? does not insert into the database or anything....

The conditions in the database are given for it to make the query.....

[This message has been edited by WarMage (edited 06-11-2002).]

$query_showPosts = "SELECT jugador FROM parados WHERE jugador != $remote_userName LIMIT 1";

I don't see why you would need to use single quotes around your data.

Maybe you should, maybe you shouldn't.

I already tried with quotes and without them...
weather with or without them doesn't work....

A sig should be here.....
But is not.

Well, let me do some more figuring. If you wouldn't mind posting the format of your DB as well I wouldn't mind using that as a jumping point.

I wanted to throw this code togeather for starters. Let you know what I am doing as I go through this. Maybe give you my train of thought.

The newer way that MySQL handles things is to keep the $db connection in memory, therefore you don't need to reference it every time you try to query it. Save a bit of code and a lot of confusion.

<?php

$database = "your db";





$connection = mysql_connect("localhost","username","password") or die ("Could not connect.");

$db = mysql_select_db($database,$connection) or die ("Could not select Database.");





$query_showPosts = "SELECT jugador FROM parados where jugador != '" . $remote_userName . "' LIMIT 1";





$result_showPosts = mysql_query($query_showPosts) or die ("Could not query.");

$num_posts = mysql_num_rows($result_showPosts);





/* Don't know why you were needing a while loop if you are only affecting one row */

$row = mysql_fetch_row($result_showPosts));





$query_juegos = "INSERT INTO match (jugador1, jugador2) VALUES ('" . $row[0] . "','" . $remote_userName . "')";

$result_juegos = mysql_query($query_juegos) or die ("Could not query");

if ($result_juegos)

	echo "<br>" . $row[0] . " vs " . $remote_userName . "\n";

else

	echo "huh?";



?>

You might want to make note:

The query is FALSE if a column to be selected does not exist.
The query is FALSE if you don't have permission to access the table.

and from the developers mouth:

quote:

---

Only for SELECT,SHOW,EXPLAIN or DESCRIBE statements mysql_query() returns a resource identifier
or FALSE if the query was not executed correctly. For other type of SQL statements, mysql_query() returns
TRUE on success and FALSE on error. A non-FALSE return value means that the query was legal and could be
executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly
possible for a query to succeed but affect no rows or return no rows.

---

[This message has been edited by WarMage (edited 06-11-2002).]

Hey WarMage!
Thanks for your help, let's see:

That script that you gave me was very useful to detect where is the problem since each step with the database is monitored in some way, but the problem is still there:
Could not query

So, as I am a smart guy ( ), I deduced that the problem is on the 'select' query:
$query_showPosts = "SELECT * FROM parados where jugador != '" . $remote_userName . "' limit 1 ";

Right?
Well, my database format: (or just the 2 tables affecting)

Table Parados:
jugador

Oh!! silly again!!
I have the 'insert' query, the problem could be there too!!
I'm checking.....

--------------------------------------
Edit:
Yes, the problem is in the insert query, but still dunno what is it:

$query_juegos = "INSERT INTO match (jugador1, jugador2) VALUES ('" . $row[0] . "','" . $remote_userName . "')";

[This message has been edited by Wakkos (edited 06-11-2002).]

I fact, if I make this:

$var = "WarMage";

$var2 = "Wakkos";

$database = "board";

		$connection = mysql_connect("host","user","pass") or die ("Could not connect.");

		$db = mysql_select_db($database,$connection) or die ("Could not select Database.");

	$query_juegos = "INSERT INTO match (jugador1, jugador2) VALUE('" . $var . "','" . $var2 . "')";

							$result_juegos = mysql_query($query_juegos) or die ("Could not query insert");

							if ($result_juegos) {

							echo "<br>".$var." vs ".$var2."\n";

							}

							else{

							echo "Huh?";

							}

It returns the ("Could not query insert"); message............

I'm using MySQL to manage my database, and for some strage reason the table MATCH was damaged, I cannot even delete it, but I created another table and everything is OK now!

Thanks for helping!!!!!

No problem, I am glad it worked out for you in the end.