Table Problem?

Fotan

I have a small database I have set up for a local store so they can display their inventory online. It's a single table with only 7 columns. My problem is with the item_number column.

I built an admin page so the owner could go in and add / delete / change items on her own. On the admin home page a list of items in the database comes up, each with an "edit" link. When you hit the edit link on an item with only numbers in the item_number field it works fine. When you hit edit on an item with a mix of letters and numbers (gs3001) in the item_number field it fails at

$result = mysql_query($query)

I have tried changing the field type, but it doesn't seem to make a difference.

Help?

Specs:
MySQL (whatever the latest stable version is)/ PHP 4.x running on a Linux server.

item_number fiels is designated VARCHAR(25) and is set to be a Unique key. I have tried it being key and not, have changed the field type to text, char, ... Nothing seems to make a difference.

Again, it works for all other items as long as there are no alpha characters in the item number, so I can't imagine it's the PHP.

TIA,

Matt

paulnaj

Hi Matt,

When you say it fails, what happens? Do you get an error message or a warning? If so, what does it say?

One debug tip is to echo the $query to the browser just before calling mysql_query() to check to see if it is a well-formed query.

Paul.

Fotan

Hi Paul. First, thanks for helping.

I did echo the variable used to query the database and all is well. The page does work with any item that doesn't include alpha characters.

Here is the query:

include("../includes/db_connect.inc.php");
$query = "SELECT * FROM inventory WHERE item_number=$edit_item";
echo "$edit_item <br>";
$result = mysql_query($query)
or die ("Unable to get item information from database");
$row = mysql_fetch_array($result);
extract($row);
?>

The message I get says "Unable to get item information from database" which leads me to believe that it's failing at

$result = mysql_query($query)
or die ("Unable to get item information from database");

Again, it works as long as there is no alpha characters in the item number.

Thanks again.

Matt

Kudose

 $query = "SELECT * FROM inventory WHERE item_number='$edit_item' LIMIT 0,1";

It is probably going haywire becuase there are no ' ' marks around the variable you're looking for..

Fotan

Thanks. One of these days I'm going to figure out where those stupid quotes are needed and where they're not...

Kudose

🙂

This should do you just perfect.

Zend: The other white meat.