array question

[herghost]

If I want to enter some values into an array like so:

 

$newarray = array($_POST['v1'], $_POST['v2'], $_POST['v3']);
$commaseparated = implode(',', $newarray);
mysql_query("insert into table set valuess='$commaseparated'") or die('error: '.mysql_error());

 

Is there a way of having a value as 0? Ie sometimes the values will just be v1 and v2 and v3 will not be needed.

 

I hope this makes sense!

[the182guy]

I'm not sure what you mean.... could you explain in more detail? Your SQL statement is invalid because there is no 'SET' inside an INSERT INTO statement.

[.josh]

in your database > table where you setup the column you can assign a default value.

 

I'm kind of curious as to why you are hardcoding an array only to turn around and implode it though...why not just format it the way you want to to begin with...

[herghost]

Basically the amount of fields will be different each time.

 

Please ignore the sql statement for the time being, just quickly showing what I was tring to achieve.

 

as an example, say I am uploading details of a book, the book has its own unique identifier in a database, and an author. I then want to upload the chapter names, obviously each book has a different amount of chapters.

 

Hope that makes more sense

 

[Ken2k7]

Basically the amount of fields will be different each time.

Well that sums it up. Someone needs to take up a DB design course.

[herghost]

Basically the amount of fields will be different each time.

Well that sums it up. Someone needs to take up a DB design course.

 

Why?

 

When its inserted into the database it will all go in one field.

[Ken2k7]

Why?

 

When its inserted into the database it will all go in one field.

Say you want to look up what book has a certain chapter name. You'll have to grab ALL the entries, implode the string, loop the array.

 

Though if you had to say that, then you need to take a DB design course because you didn't know why. Not to be mean, but I'm just telling it like it is. Read Crayon Violent's post.

[herghost]

Ok,

 

well I dont want to be able to search the field, I just want to echo the result. Perhaps I should just have the user add all the chapters in a text box, one per line, store them all in one field and tehn just echo teh field?

[Ken2k7]

Ok,

 

well I dont want to be able to search the field, I just want to echo the result. Perhaps I should just have the user add all the chapters in a text box, one per line, store them all in one field and tehn just echo teh field?

Yeah. You would have one entry in the DB for each chapter.

 

The table should be:

id PRIMARY_KEY

book_id

chapter_name