14. juli 2004 - 17:43Der er
12 kommentarer og 1 løsning
Join to queryer
Hejsa,
Kan disse to queries joines til én?
$new_products_no = 1; $new_products_query = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 10") or die (mysql_error()); while($new_products_fetch = mysql_fetch_array($new_products_query)) {
$new_products_limit_query = mysql_query("SELECT * FROM prices WHERE product_id='$new_products_fetch[id]' ") or die (mysql_error()); $new_products_limit_check = mysql_num_rows($new_products_limit_query); if ($new_products_limit_check != 0) {
- Jeg vil have en liste ud over de 10 nyeste produkter, men kun de produkter der kan en pris tilføjet.
hvorfor indeholder "$new_products_fetch[id]" ikke id på produkterne i tabellen "products"?
$new_products_query = mysql_query("SELECT * FROM products JOIN prices ON products.id=prices.product_id ORDER BY products.date_added DESC LIMIT 10") or die (mysql_error()); while($new_products_fetch = mysql_fetch_array($new_products_query)) {
//Get top10 most popular reels $new_products_no = 1; $new_products_query = mysql_query("SELECT products.id as prod_id,products.series_id as prod_series_id,products.name as prod_name,products.type as prod_type FROM products JOIN prices ON products.id=prices.product_id ORDER BY products.date_added DESC LIMIT 10") or die (mysql_error()); while($new_products_fetch = mysql_fetch_array($new_products_query)) {
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
