Jump to content


Photo

Query Issue?


  • Please log in to reply
2 replies to this topic

#1 Codeman0013

Codeman0013
  • Members
  • PipPip
  • Member
  • 20 posts
  • LocationCentral Illinois USA

Posted 22 September 2006 - 05:40 PM

Hey I'm having a slight problem with my query of my php databse. It works but for some reason the code is messing up my css and totally enlarging the text until it submits the first time. After the first submit it works fine everything goes back to normal? here is my code any suggestions?


mysql_select_db($database_conn_dj, $conn_dj);
$query_rs_productcategory = "SELECT productCat_id, productCat_name, industry_id FROM tbl_productcat WHERE industry_id = '$_GET[industry_id]' ORDER BY productCat_name";
$rs_productcategory = mysql_query($query_rs_productcategory, $conn_dj) or die(mysql_error());
$row_rs_productcategory = mysql_fetch_assoc($rs_productcategory);
$totalRows_rs_productcategory = mysql_num_rows($rs_productcategory);

mysql_select_db($database_conn_dj, $conn_dj);
$query_rs_product = "SELECT products_id, products_name, productCat_id FROM tbl_products WHERE productCat_id = '$_GET[productCat_id]' ORDER BY products_name";
$rs_product = mysql_query($query_rs_product, $conn_dj) or die(mysql_error());
$row_rs_product = mysql_fetch_assoc($rs_product);
$totalRows_rs_product = mysql_num_rows($rs_product);


Remember to always look for those dang ; they can be a killer!

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 22 September 2006 - 05:46 PM

it's not going to be your query.. it's going to be the html output like table formatting and so on fancy posting full code?
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 EmperorDoom

EmperorDoom
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 22 September 2006 - 05:47 PM

I don't see any reason why your mysql code would mess up the css.. perhaps the problem is in the html or php? If you have any unclosed <table></table> tags that sometimes messes things up. You should post the code for your form especially the bit near the submit button.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users