MySQL - subqueries...

[noeffred]

PLease help me out this is really urgent! how do I get this SQL Query to run with MySQL. Due to the lack of support for sub-queries Ican't get the thing to work and I've got no idea how to make it run...

There are three tables:

Katalog - the names of the catalogues
Teile - the list of parts possible in the catalogues
VT_Katalog_Teile - the table where the two are linked together...

SELECT Katalog.Name, Teile.Teil
FROM Teile INNER JOIN (Katalog INNER JOIN VT_Katalog_Teile ON Katalog.id = VT_Katalog_Teile.ID_Katalog) ON Teile.ID = VT_Katalog_Teile.ID_Teile;

thanks for your support folks...

[Anon]

To get you started:

<form method="post" action="<? echo "$PHP_SELF"; ?>">
Description: <textarea cols="" rows="" name="description"></textarea><br><br>
Url: <input type="text" name="url" size="25">
<br><br>
<input type="submit" name="send" value="SEND">

<?
if ($send) {
$connection = mysql_connect ("host", "username", "password") or die ( "Couldn't connect to server.");
$db = mysql_select_db ("database_name", $connection) or die ( "Couldn't select database.");

$sql = "insert into links (description, url) values ('$description', '$url')";
$dosql = mysql_query($sql) or die("Couldn't execute query.");
}
?>

That's it as far as adding description and url to the database, into a table called "links". Sorry can't help with the output (pulling data out of database) - don't have time!

[Anon]

Sorry, I meant to post this to a different topic.

[[deleted]]

SELECT Katalog.Name, Teile.Teil
FROM Teile, Katalog, VT_Katalog_Teile
WHERE Katalog.id = VT_Katalog_Teile.ID_Katalog
AND Teile.ID = VT_Katalog_Teile.ID_Teile;

[noeffred]

thanks for the tip, but it doesn't seem to work, alle I get is a "Warning: Supplied argument is not a valid MySQL result resource in D:\aul\php23.php on line 5"

any hints?

<?
$link = mysql_connect ("localhost", "admin", "admin")
or die ("Could not connect to Database");
$result=mysql_query("SELECT Katalog.Name, Teile.Teil FROM Teile, Katalog, VT_Katalog_Teile WHERE Katalog.id = VT_Katalog_Teile.ID_Katalog AND Teile.ID = VT_Katalog_Teile.ID_Teile");
$number = mysql_numrows($result);
/
$j=0;
while (6>$j):
print mysql_result($result,$j,"Katalog");
print "<br>";
print mysql_result($result,$j,"Teil");
$j++;
endwhile;/
?>

vincent wrote:

SELECT Katalog.Name, Teile.Teil
FROM Teile, Katalog, VT_Katalog_Teile
WHERE Katalog.id = VT_Katalog_Teile.ID_Katalog
AND Teile.ID = VT_Katalog_Teile.ID_Teile;

[Anon]

mysql_num_rows($blah) instead of mysql_numrows($blah) 🙂

[noeffred]

thanks for your idea, but it didn't help, besides, both work as far as i have seen...

this seems to be a harder problem than I first thought it was... :-)

[[deleted]]

That error means your query failed for some reason.
Use some error checking and check if the query was executed. If it was not executed, do:

echo mysql_error();

that will tell you why your query failed.

[noeffred]

thanks man, if I could i'd hug for that!!