I am not sure to understand,
You want to retreive category from the existing job ? right ?
But if this is the case, what about the first record ? You won't have
any existing category, does not make sense ... (or you have to display a
select input and a free text input, then get the value from one of the
two fields ...)
I think you should create a jobCategory model whith one-to-many relation
to your job model, this is a simplier way and faster to execute :
job:
connection: doctrine
tableName: job
columns:
id_marchandise:
type: integer(4)
primary: true
autoincrement: true
job_category_id: integer
sub_category:
type: string(50)
relations:
jobCategory:
type: one
foreignType: many
onDelete: SET NULL
jobCategory:
columns:
name: string(128)
Belgacem TLILI wrote:
i have this class
job:
connection: doctrine
tableName: job
columns:
id_marchandise:
type: integer(4)
primary: true
autoincrement: true
category:
type: string(50)
sub_category:
type: string(50)
i would like have the data of this table in (of my database) like a
list of option in indexSuccess.php
like this in html
<select name="job[category]" id="job_category">
<option value="1">Petit Colis</option>
<option value="2">Moyen Colis</option>
<option value="3">Grand Colis</option>
//........the data from database
<option value="7">Petite Palette</option>
<option value="8">Moyenne Palette</option>
<option value="9">Grande Palette</option>
</select>
how can i do this
how can i build a doctrine request (DQL)
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
