I have no idea how to fix this...

[synergy]

Here's my code:

$result = mysql_query("SELECT * FROM inventory",$db);

if ($myrow = mysql_fetch_array($result)) {

  echo "<table border=0>\n";

  do 
 	{
    echo ("
	<tr>
		<td height='2' rowspan='5'>
		</td>
		<td colspan='3' height='2'>
		</td>
	</tr>
	<tr>
		<td width='38%' height='17'>
			<?php $myrow['Year'];?>
		</td>
		<td width='22%' height='17'>
			<?php $myrow['Miles'];?> Miles 
		</td>
		<td width='22%' height='10' rowspan='3'>
		</td>
	</tr>
	<tr>
		<td width='38%' height='19'>
			<?php $myrow['Model'];?>
		</td>
		<td width='22%' height='19'>
			<?php $myrow['Price'];?>
		</td>
	</tr>
	<tr>
		<td width='38%' height='17'>
			<?php $myrow['Exterior_Color'];?> / <?php $myrow['Interior_Color'];?>
		</td>
		<td width='22%' height='17'>
			<?php $myrow['Stock_Number'];?>
		</td>
	</tr>
	<tr>
		<td colspan='3' height='2'>
		</td>
	</tr>\n");
	} 
    while ($myrow = mysql_fetch_array($result));
	echo "</table>\n";
	} 
else 
	{
	echo "None in inventory at this time.";	
}

?>

And the errors that I get:

Notice: Undefined index: 'Year' in c:\apache\apache\htdocs\inventory.php on line 31

Notice: Undefined index: 'Miles' in c:\apache\apache\htdocs\inventory.php on line 34

Notice: Undefined index: 'Model' in c:\apache\apache\htdocs\inventory.php on line 41

Notice: Undefined index: 'Price' in c:\apache\apache\htdocs\inventory.php on line 44

Notice: Undefined index: 'Exterior_Color' in c:\apache\apache\htdocs\inventory.php on line 49

Notice: Undefined index: 'Interior_Color' in c:\apache\apache\htdocs\inventory.php on line 49

Notice: Undefined index: 'Stock_Number' in c:\apache\apache\htdocs\inventory.php on line 52

I have a feeling that I'm way off.. I'm a newb so any help would be appreciated. Thanks.

[trooper]

you need to do the following

if ($myrow = mysql_fetch_array($result, mysql_assoc))

that will allow you to return an associative array (and hence your code will work further on.

HTH

GM

[synergy]

Notice: Use of undefined constant mysql_assoc - assumed 'mysql_assoc' in c:\apache\apache\htdocs\inventory.php on line 16

hmmm....

[altexis]

well... make sure that your table has these fields!!
Year, Miles, Model, etc..

then... since you are already in php script... why do you use the php tag?

I mean that

        <td width='38%' height='17'>
            <?php $myrow['Year'];?>
        </td>

could be just

        <td width='38%' height='17'>
            $myrow['Year']
        </td>

or even better:

        <td width='38%' height='17'>
            ".$myrow['Year']."
        </td>

also notice that you don't change lines in your produced html
you should put \r at the end of every line

[synergy]

Well of course I have those fields in my table. Again I'm a php newb, so as far as syntax goes I'm still in a very early learning stage.

Can you give me an example of the \r at the end of every line so I make sure I get it right the first time?

Also, I added ' ' around mysql_assoc, and it seems to work but isn't displaying anything from the database. It goes straight to the else and displays "None in inventory at this time". At least I don't have any errors 😛

[altexis]

first of all... let me correct myself.. its \n not \r

turn all your html related lines like this:

echo "        <td width='38%' height='17'>\n";
echo "            ".$myrow['Year']."\n";
echo "        </td>\n";
echo "        <td width='22%' height='17'>\n";
echo "            ".$myrow['Miles']." Miles \n";
echo "        </td>\n";

I think this is the cleanest way

[synergy]

I thought that you couldnt put " " between " "?

Wait I guess since I would be echoing the information instead of using the print, then I would be able to use the " ".. Sorry for my newbness 😛

[altexis]

don't speak about newbieness... i am kinda newbie too
I just have much experience with other languages and had a fast kick start with php

maybe I missed something here... you never know