|Shaba1||sorry other way around the foreign key was int(2) and the primary key in the table was int(3)|
just does not seem right to me. you are making the foreign key field smaller then the original key in the original table
|Antaeus||quick question: does mysqli_stmt_close() closes only the stmt or does it closes the connection also?|
anyone could help with an mysqli issue? i create the connection on beguin of script and close it in the end. Use 3 stmt in the midle but once i use mysqli_stmt_close to free the resources of the first stmt connections dies also
according to the manual mysqli_stmt_close should only close the stmt and not the connection itself. anyone?
!tell me about mysqli_stmt_close
|katami||Can somebody help me with inserting information into a table?|
I know this should be simple but I'm not getting it
I've done everything according to the tutorials i've found, and when I do it, I don't get any errors, just it doesn't do it?
|threnody||katami: paste your insert query and any error messages.|
|ofer0||how do I make a numeric MAX() on a VARCHAR column ?|
|ofer0||jef, thank you.|
Antaeus: dunno. what problem?
|Antaeus||all started with getting my connections to max in my mysql box|
using mysql 5.0.27 on a fedora 3 box with php 5. using mysqli
i create a connection with mysqli
with that connection i want to use several stmt's by using mysqli->prepare and only close the mysqli connection on the end of script
however, once i call the first stmt->close() the next stmt's all fail
i'll paste it on pastbin to show
|KalleDK||Hey how is it you grab only one name if it exists more than once in a row.. so | ab | ab | ag | au | would become |ab|ag|au||
use select distinct colname from table
|KalleDK||Thx looking it up (trying in my database now)|
Thx worked as intended :D
|malverian_||Hi all, is it okay to Ctrl+C a mysqlcheck -cr ?|
Also, is it okay to 'kill' a REPAIR statement from the mysql cli?
Or could this cause database corruption?
|malverian_||If anyone can help that would be awesome.|
can you compare the curdate to a value in a table and delete if it is older or newer?
|katami||no help to be found here|
|demoncorsair||this is a mysql channel right?|
|katami||they have a nack for ignoring you|