Forum FAQForum FAQSearchSearch MemberlistMemberlist Forum ignore listForum ignore list RegisterRegister ProfileProfile Log in to check your private messagesLog in to check your private messages Log inLog in
MySQL create whole table

 
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side
View previous topic :: View next topic  
Author Message
hrv0j3



Joined: 03 Aug 2007
Posts: 34

PostPosted: 20.07.2008 00:21    Post subject: MySQL create whole table Add user to your forum ignore list Reply with quote

Pozdrav,

Naletio sam na jedan problem...

Naime ovako.. u mysql imam sljedece

Code:
CREATE TABLE IF NOT EXISTS `katalog_artikli_cijene` (
  `id` int(11) NOT NULL auto_increment,
  `id_artikla` int(11) NOT NULL default '0',
  `vrsta_stupca` text NOT NULL,
  `detalji_stupca` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

INSERT INTO `katalog_artikli_cijene` (`id`, `id_artikla`, `vrsta_stupca`, `detalji_stupca`) VALUES
(1, 1, 'sirina', '15'),
(2, 1, 'sirina', '20'),
(3, 1, 'sirina', '25'),
(4, 1, 'visina', '30'),
(5, 2, 'duzina', '15'),
(6, 2, 'duzina', '105'),
(7, 2, 'sirina', '30'),
(8, 2, 'sirina', '82');


i sad.. na temelju toga kad se otvori artikal "id_artikla=2" zelim kreirati tablicu koja ima stupce ovisno o tome koji stupci postoje za navedeni artikal...i da u tim stupcima pisu ispravni podaci...

napravio sam:
(test skriptu)
Code:
<?php

### kreacija tablice s mysql

include 'inc/config.php';

$query_stupci = mysql_query("SELECT DISTINCT vrsta_stupca FROM katalog_artikli_cijene WHERE id_artikla = '2'",$con);
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo '<tr>';
$stupci = mysql_num_rows($query_stupci);
while($red_stupci = mysql_fetch_array($query_stupci)){

echo '<td>'.$red_stupci['vrsta_stupca'].'</td>';

}

echo '</tr><tr>';

$query_redovi = mysql_query("SELECT * FROM katalog_artikli_cijene WHERE id_artikla = '2'",$con);
$redovi = 0;
while($red_red = mysql_fetch_array($query_redovi)){
$redovi++;

echo '<td>'.$red_red['detalji_stupca'].'</td>';
if($redovi == $stupci){ $redovi == 0; echo '</tr><tr>'; }
}
echo '  </tr>
</table>';

echo $stupci.'-r'.$redovi;
?>


sve super radi,ali redove ne ispise dobro.. tj. ispise sadrzaj 1 stupca u sadrzaju 2 stupca (logicki) .. shvacam u cemu je problem,ali ga neznam rijesiti.. znaci moram napraviti da upisuje podatke tamo di pripadaju.. kako da to izvedem?
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    mi3dot.org Forum Index -> Server-side All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group