Search the Community
Showing results for tags 'php mysql select'.
Found 2 results
-
I have a MySQL database. The table name is prodcat - it has 3 fields sku, category and codes. Some of the categorys have multiple items in it which is seperated by / for example: Ceramics/Sale Items or just Ceramics in the codes it looks like this: ceramics,saleitems or just ceramics Basically i want to loop through each sku in the prodcat table and every sku that is in ceramics I want it to echo an image. And if that sku is in multiple categories it needs to show the image no matter what category you are in. So if it is a ceramic item that is also on sale I want the image to appear in both those categories I've tried this multiple ways and can get a partial result but can not get it completely the way I want it. Basically I can get it to give me the result in one category but it won't give me the result in both categories. Thanks for the help.
-
i am creating a drop box list with php and mysql to select data from the database . table name : specialization fields: specialization_id, specialization_name function ================ function specializationQuery() { if(isset($_POST['username'])) { $specialization = mysql_real_escape_string($_POST['specialization']); $specData = mysql_query("SELECT specialization_name FROM specialization WHERE specialization_id = '$specialization'"); while($recordJob = mysql_fetch_array($specData)) { echo'<option value="' . $recordJob['specialization_name'] . '">' . $recordJob['specialization_name'] . '</option>'; } } } i want that in the user table iit must contain the **specialization _id** but this selection from the specialization table did not work can anyone help me ???
