[SOLVED] display by userid?

[abs0lut]

database structure

 

I need to display this

http://img301.imageshack.us/my.php?image=g1copydp0.jpg

then, next page

the iqids are the same with the first page

the only difference is the userid(the one who post) and the cost he posted..

http://img219.imageshack.us/my.php?image=g2copysi2.jpg

then next page

iqids are the same..

cost

userid3

 

and so on...

 

could you please help me??

 

[LooieENG]

mysql_query("SELECT * FROM table WHERE where=something ORDER BY cid DESC")

(or ASC for ascending order)

[abs0lut]

I need to display the userid together with iqids and the cost he posted in every page..

1 userid in every page..

[abs0lut]

please help me..

[Daniel0]

Something like this?

 

<?php
$db = new PDO('mysql:host=localhost;dbname=something', 'username', 'password');

$stmt = $db->prepare('SELECT iqid, cost, stotal FROM table WHERE userid = :userid ORDER BY stotal');
$stmt->execute(array('userid' => $_GET['userid']));

echo <<<EOF
<table>
<tr>
	<th>iqid</th>
	<th>cost</th>
	<th>stotal</th>
</tr>

EOF;

foreach ($stmt->fetchAll() as $item) {
echo <<<EOF
<tr>
	<td>{$item['iqid']}</td>
	<td>{$item['cost']}</td>
	<td>{$item['stotal']}</td>
</tr>
EOF;
}

echo '</table> ';
?>

[abs0lut]

Something like this?

 

<?php
$db = new PDO('mysql:host=localhost;dbname=something', 'username', 'password');

$stmt = $db->prepare('SELECT iqid, cost, stotal FROM table WHERE userid = :userid ORDER BY stotal');
$stmt->execute(array('userid' => $_GET['userid']));

echo <<<EOF
<table>
<tr>
	<th>iqid</th>
	<th>cost</th>
	<th>stotal</th>
</tr>

EOF;

foreach ($stmt->fetchAll() as $item) {
echo <<<EOF
<tr>
	<td>{$item['iqid']}</td>
	<td>{$item['cost']}</td>
	<td>{$item['stotal']}</td>
</tr>
EOF;
}

echo '</table> ';
?>

whats the use of EOF? I couldn't understand OOP.. please help me.

[Daniel0]

It's the heredoc syntax.

[abs0lut]

is execute a predefined function?

[abs0lut]

whats the use of this symbol ->  ??

[abs0lut]

bump.. please help me..

[mmarif4u]

It represents Classes and objects in OOP.

[abs0lut]

Something like this?

 

<?php
$db = new PDO('mysql:host=localhost;dbname=something', 'username', 'password');

$stmt = $db->prepare('SELECT iqid, cost, stotal FROM table WHERE userid = :userid ORDER BY stotal');
$stmt->execute(array('userid' => $_GET['userid']));

echo <<<EOF
<table>
<tr>
	<th>iqid</th>
	<th>cost</th>
	<th>stotal</th>
</tr>

EOF;

foreach ($stmt->fetchAll() as $item) {
echo <<<EOF
<tr>
	<td>{$item['iqid']}</td>
	<td>{$item['cost']}</td>
	<td>{$item['stotal']}</td>
</tr>
EOF;
}

echo '</table> ';
?>

I entered http://domain.com/file.php?userid=5 in the address bar of browser

the output is only the table header

iqid  cost  total

please help me..

[abs0lut]

I already solved it..