No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Hi, How can I delete from multiple tables? I'm using this query and its not working: "DELETE FROM table1,table2 WHERE $localTime > table1.Time OR $localTime > table2.Time"; What I hope to achieve is deleting rows from table1 and table2 where their Time Field is less than $localTime. Thanks very much.
|
|
|
Hi, I'm looking for some advice regarding creating a well-designed database site. The scenario is this: I have a main database that holds all my users' data, I'll call it UserData. Now I want to make a sort of Search By Category form, which will output those users from UserData …
|
|
|
Hi, I'm trying to create some rows in a table using php code. Its like this: [code] <table border="1" cellspacing="0" cellpadding="0"> <tr> <td width>some item</td> </tr> <?php echo drawRow(); // draw another similar row ?> </table> [/code] But it turns out that the row is drawn before the table. In …
|
|
|
Hi, I'm trying to connect to a database using MySQL. Very new at this. I already have an existing table consisting of 2 rows created using phpMyAdmin. The problem (not exactly) I'm facing is when i insert a new row, it seems to insert after the 2nd row, not at …
|