Member Avatar for gikonyo

i want to display the auto increment field in mysql database no using php. using the code the output that am getting is zero in the $id field , what could i be missing
echo"<table bordercolor='#CCFF99' bgcolor='#FFFFCC'>";
echo "<tr bgcolor='#CCFF99'><td>Order No:</td>";
echo"<td bgcolor='#FFCC66'>$id</td>";
echo "<tr bgcolor='#CCFF99'><td>Topic:</td>";
echo"<td bgcolor='#FFCC66'>$topic</td>";
echo "<tr bgcolor='#CCFF99'><td>Category:</td>";
echo"<td bgcolor='#FFCC66'>$category</td>";
echo "<tr bgcolor='#CCFF99'><td>Urgency:</td>";
echo"<td bgcolor='#FFCC66'>$urgency</td>";
echo "<tr bgcolor='#CCFF99'><td>Spacing:</td>";
echo"<td bgcolor='#FFCC66'>$spacing</td>";

note this is just a section of the code that am using for display

  • 2 Contributors
  • 1 Reply
  • 102 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

Show the query and the table structure. And learn some CSS and how to avoid redundant coding.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.