Why Doesn't This Work?

artisticre

<?
$connection = mysql_connect("xxx","xxx","xxx")
or die("Couldn't make connection.");
$db = mysql_select_db("xxx", $connection)
or die("Couldn't select database.");

if ($submit)
{

$test = mysql_query("SELECT catID FROM category
WHERE tshirts.shirtname= '$DelShirtname'",$db);
}
echo $test;
?>

<form method="post" action="<?php echo $PHP_SELF?>">
<input type=text name=DelShirtname size=20>Delete:
<input type="Submit" value="Go">
</form>
</body>
</html>

Thora_Fan

What's happening when you try and run it? Anything? Nothing?
Could be any number of things. Looks to me like you are querying the database and not fetching any rows. Also looks like you didn't have a name for the Submit button (which is needed). I added these things in and reworked your code a little.

<?php

if ($_POST[submit]) 
{ 
  $connection = mysql_connect("xxx","xxx","xxx") or die("Couldn't make connection."); 
  $db = mysql_select_db("xxx", $connection) or die("Couldn't select database."); 

  $test = mysql_query("SELECT catID FROM category WHERE tshirts.shirtname= '$_POST[DelShirtname]'",$db);
  while($myRow = mysql_fetch_array($test))
  {
     echo "$myRow[catID]<br>";
  }
}
else
{
?> 

<form method="post" action="<?php echo $PHP_SELF; ?>"> 
<input type=text name=DelShirtname size=20>Delete: 
<input type="Submit" name="submit" value="Go"> 
</form> 
</body> 
</html>

<?php
}
?>

It's suggestable to use $GET and $POST when referring to variables passed via either of those methods.

artisticre

Here is what my code is now...basically what you gave me
I also want to assign the catID to a variable once it is pulled. How do you do that? Here is the error I am getting

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in line 8

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 9

<?php

if ($_POST[submit])

{

$connection = mysql_connect("xxx","xxx","xxx") or die("Couldn't make connection.");

$db = mysql_select_db("xxx", $connection) or die("Couldn't select database.");

$test = mysql_query("SELECT catID FROM tshirts WHERE tshirts.shirtname= '$_POST[DelShirtname]'",$db);
while($myRow = mysql_fetch_array($test))
{
echo "$myRow[catID]<br>";
}
}
else
{
?>

<form method="post" action="<?php echo $PHP_SELF?>">
<input type=text name=DelShirtname size=20>Delete:
<input type="Submit" name="submit" value="Go">
</form>
</body>
</html>

<?php
}
?>

Thora_Fan

The <b>Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in line 8</b> probably means that you have an error in your SQL. Try adding this:

$test = mysql_query("SELECT catID FROM tshirts WHERE tshirts.shirtname= '$_POST[DelShirtname]'",$db) or die(mysql_error());

That might help somewhat.