Database Problem

Stefan0710

Hallo, I have a problem
On my site i heve PHP enabled and I started to work with PHP. Now I have 5 items in my database, and I want to put them in variables. How can I do that ???

With the following code, I only get the first ros of my database:

<?php
include( './MySQL/Connect.php' );
$Selection = "SELECT * FROM Art Where Active='Yes'";
$Query = mysql_query( $Selection, $ConnectionID );
$Art = mysql_fetch_object( $Query );

echo $Art->Title
?>

I want to have all of them (my number of rows changes frequently !!!

Stefan0710

I could start with counting the rows, and then creating the variables, or is there a better way.

P.S. I want to store them to variables to use them in flash.

treds1

ok you need to put in a while loop if you want to get more than one row

include( './MySQL/Connect.php' ); 
$Selection = "SELECT * FROM Art Where Active='Yes'"; 
$Query = mysql_query( $Selection, $ConnectionID ); 

while($myRow=mysql_fetch_array($QUERY))
{
$title=$myRow['title'];
echo $title;
}

Hope this is of some help

Stefan0710

Thats working', thanx.
Now, the only problem is i have to save them to individual variablels to load them in Flash.

Anyone ...

treds1

not sure about using flash but the data is saved to variable $title

not sure if this is what u ment

Stefan0710

It's the same as storing it in different variables, such as Title01, Titel 02 or something like that.

Stefan0710

Or like putting it in a table, where you use (I think) something like Title[$ID], where $ID is the rownumber.

treds1

is the same as storing in diff variables.

Not quite sure what you are tyring to do if you post a more detaised description ill see if i can help

Stefan0710

Another question, I want to put the links to some images in the database too. I saved them into the dataqbase, but how can I import them to the HTML-string (or is there a php string that shows a pucture).

Now I have this, but this won't work:
print( "<IMG SRC=".$Picture." WIDTH="250" HEIGHT="100">"

What's wrong ???

Stefan0710

Originally posted by treds1
is the same as storing in diff variables.

Not quite sure what you are tyring to do if you post a more detaised description ill see if i can help

I want to print it in a sort of table. How can I do that.

I think I have to use something like ID[01] and Title[01], etc.
where the [01] is incresing by one, til the maximum ($NumberOfRows = mysql_num_rows( $Query ))

How can I do that ???

treds1

the image problem is one ive had int he past you need to create a script to call teh images out of the database.
the variables will need to be changes as ive just copied and pasted soem code i allready have.

view.php

<?
include 'dbcon.php';


$image_brand = $_GET['image_brand'];
$image_name= $_GET['image_name'];

$result = mysql_query("SELECT * FROM image WHERE image_brand='$image_brand' AND image_name='$image_name' ",$db);


while($numRow = mysql_fetch_array($result))
{
$itype = $numRow['image_type'];
Header("Content-type: $itype");
$image =$numRow['image_data'];
$height=$numRow['image_height'];
$width=$numRow['image_width'];
echo $image;
flush();
}
?>

then to call the pic on the page you wish to view it

use something like

Stefan0710

The pictures are for later. Now I have a table with all the results from my database.
Now I want to convert the Title to a hyperlink. It works, bun when I move the mouse over the name, my cursor won't change into a hand, only when I click, the cursor become a hand. The link to the site is: Link

I used the following code:

<Html>
<Body>
<Table Align="Center" Cellspacing="0" Cellpadding="0" Border="1" Width="75%">
<tr>
<td> <b>Title</b> </td>
<td> <b>Text</b> </td>
<td> <b>Date</b> </td>
</tr>

<?php
include( './MySQL/Connect.php' );
$Selection = "SELECT * FROM Art Where Active='Yes'";
$Query = mysql_query( $Selection, $ConnectionID );
$NumberOfRows = mysql_num_rows( $Query );

while ( $Art = mysql_fetch_object ( $Query ))
{
    $ID = $Art->ID;
	$Title = $Art->Title;

print "<td> $Art->Title </td>";
print "<td> $Art->Text </td>";
print "<td> $Art->Date </td>";
print "</tr>";
}

?>
</Table>
</Body>
</Html>

treds1

not quite sure what u are acctually after can u give a more detailed description

Stefan0710

I alraedy worked it out. Now, als another question, is it possible to save some data includng uploading a picture. How should I do that ???

I have some textboxes in my file, but i haven't got a upload box yet.

The user has to fill in all the data, and then the data must be transferred to my database, and the file must be upladed too in a folder and the link to that picture (in: ./Pictures/filename.jpg) must be stored into that same table too.

treds1

take alook in the php manuel www.php.net under move_uploaded_file(i think thats right) also take a look at chap 18 in manual which is file uploading.

hope this helps