mysql select?

[Hrvoje]

I need to select all fields from two tables and echo that data.

Fields are the same in both tables but has different data.

 

 

<?PHP
include "dbconnect.php";

function pretvoriDatum($mysqlDatum)
{
$tmp=explode("-", $mysqlDatum);
$datum=$tmp[2] . "." . $tmp[1] . "." . $tmp[0];
return $datum;
}

$sql="SELECT * FROM novosti A, dogadanja B";
if (!$q=mysql_query($sql))
{
echo "Error" . mysql_query();
die();
}
if (mysql_num_rows($q)==0)
{
echo "No data</div>";
} else {
?>
<?PHP
while ($redak=mysql_fetch_array($q))
{
?>



<?php echo $redak["a.naslov"]; ?>

<?PHP echo $redak["a.slika"]; ?>

<?php echo $redak["b.tekst"]; ?>

<?php echo $redak["a.objavio"]; ?>

<?PHP echo pretvoriDatum($redak["b.datum"])?>


<?PHP
}
}
?>

 

 

Please help, I don't know how to do that

[BlueSkyIS]

it looks like you're doing it. is there an error or a problem??

[Hrvoje]

When I echo

 

<?php echo $redak["a.naslov"]; ?>

 

Error is:

 

Notice: Undefined index: a.naslov

[BlueSkyIS]

that means there is no such thing as $redak["a.naslov"]

 

i would take a closer look at $redak:

 

print_r($redak);

[Hrvoje]

I don't understand this  :-\

[BlueSkyIS]

update your code to look like this, so you will see what is in $redak

 

while ($redak=mysql_fetch_array($q))
{
print_r($redak);

[Hrvoje]

Now i have all data in one table

[sasa]

'a.naslov' is not same as 'A.naslov'

you use alias A

[Hrvoje]

Ok, thanks...

 

But when I put:

 

<?PHP
include "dbconnect.php";

function pretvoriDatum($mysqlDatum)
{
$tmp=explode("-", $mysqlDatum);
$datum=$tmp[2] . "." . $tmp[1] . "." . $tmp[0];
return $datum;
}

$sql="SELECT * FROM novosti A, dogadanja B";
if (!$q=mysql_query($sql))
{
echo "Error" . mysql_query();
die();
}
if (mysql_num_rows($q)==0)
{
echo "No data</div>";
} else {
?>
<?PHP
while ($redak=mysql_fetch_array($q))
{
?>


<?php echo $redak["A.naslov"]; ?>





<?PHP
}
}
?>

 

Again have an error

 

Undefined index: A.naslov

[BlueSkyIS]

if you print_r($redak) as suggested, you'll see the contents of $redak, including the available keys/field names.

[Hrvoje]

Thanks everyone, I figured now

 

You make my day