cross posted:
http://www.codingforum.net/showthread.php?t=61568
Thread closed
Jee
258 results in 0.1962 seconds.
-
you'll prob need to provide a user/pass too:
mysqldump databasename -u user -p > db.sqlLeave a comment:
-
That's not how auto increment works in relational db system. You won't find a way to do it easily. What happens if you have 1,2,3,4,5,6,7,8,9 and 10 and delete 6? The RDMBS (mysql) will just use 11 - as that creates a unique number that it knows hasn't been used before.
The only other...Leave a comment:
-
what he means on this query is:
SELECT bla, blabla, LEFT(foobar, 200) FROM table ORDER BY date_posted DESC LIMIT 1,2
the foobar is just a column name. This can be 'user', 'email' etc etc
the DESC is in relation to the ORDER BY
ORDER BY date_posted...Leave a comment:
-
try this:
ALTER table AUTO_INCREMENT = 1;
JeeLeave a comment:
-
As mentioned - probably better in the ASP Forum...
Moving
Leave a comment:
-
That is an inappropriate comment. There are many many helpful people on this forum who all help out free of charge - so please keep comments like this to yourself.
In regards to your problem, it is a simple PHP error you have - you could have solved this earlier had you spent time looking...Leave a comment:
-
I assume you are using DATETIME for your field type?
This this:
SELECT * FROM Jobs WHERE Dateposted > 2003-05-08 12:14:37 AND Dateposted < 2004-06-08 12:14:37
Regards,
JeeLeave a comment:
-
you could try this:
SELECT PLU, item_desc FROM table ORDER BY PLU ASC GROUP BY PLU
JeeLeave a comment:
-
It is probably in /etc/my.cnf
Try typing
locate my.cnf
to find it
jeeLeave a comment:
-
i assume you are using something like this:
$result = mysql_query("SELECT......");
$row = mysql_fetch_array($result);
Access it via:
$row["foobar"];
JeeLeave a comment:
-
If you are using PHP, there is already a function for this
...PHP Code:$string = "<b><i>hello</i></b>";
$string = strip_tags($string); //gives "hello"
//you can also strip certain tags
$string strip_tags($string,"<b>");
Leave a comment:
-
I'll move this to the Perl Forum
Leave a comment:
-
The + signifies they are on your buddy list - i just added you Mhtml, and it worked
Jee
Buddies with everyone
Leave a comment:
Leave a comment: