violinrocker

whats wrong with this? $sql = "UPDATE `users` SET `css` = '$_POST[css]' WHERE `users`.`username` = '$session->username' LIMIT 1"; $sql2 = "INSERT INTO user_extension (username, sig) VALUES ($session->username, $_POST[sig]) ON DUPLICATE KEY UPDATE SET $username=$session->username, sig=$_POST[sig]"; if (!mysql_query($sql,$con)) {?>Attention!<? die('Error: ' . mysql_error()); ?><? } if (!mysql_query($sql2,$con)) {?>Attention!<? die('Error: ' . mysql_error()); ?><? }} ?>CSS & sig Success!<? } ?> ERROR Attention!Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET =Violinrocker, sig=janime' at line 3

okay so im not familiar with ON DUPLICATE KEY UPDATE. i googled it and i dont know how to apply it. i saw one that says it should be like this INSERT INTO TABLE (column1, column2, column3) VALUES (value1, value2, value3) ON DUPLICATE KEY UPDATE SET column1=value1, column2=value2, column3=value3"; how can i make it to work like... insert into table "thisname" but if there is already a data with name="thisname" even though other fields do not match itll update them... or if it works vice versa... update then if there is none... insert. sorry im a noob, please be patient with me

i dont know if i remember this right.... but months ago i found an article saying that UPDATE is nice since it can do INSERT if there is nothing to update... is this true? or is there other functions that can do this?

I want to get the top 5 rows with common keywords how can i do this? its like this $query = "SELECT adder,min(title)FROM shsh group by adder order by mysql_num_rows($q)";

what is wrong with this? it says i do not have the right syntax.... im assuming that i cannot use AND & OR together? $q = "SELECT * FROM here WHERE page_id='$_GET[id]' OR parent='$_GET[id]' AND default='0' ORDER by page_id DESC LIMIT 1"; okay so i tried changing "default='0'" to "mirror='0'" and it works.... im sure "default" is in my table though

im trying to do a multi insert form using for loop. the concept is specifying a number and then using it in the for loop. the loop then makes a number of fields depending on the specified number. after that i use another for loop to insert the grouped fields together. code for specifying desired number <? if ($_GET[num]=="") { ?><form name="form1" method="post" action="multiup.php?num=1"> <input name="num" type="text" value="10" maxlength="2"> <input type="submit" name="button" id="button" value="Submit"> </form><? } ?> <? } else { ?><form name="form2" method="post" action="multiup2.php"> <input name="adder" type="hidden" value=""> <input name="num" type="hidden" value="<? echo $_POST[num]; ?>"> code for displaying fields <? for ($i=1;$i<=$_POST[num];$i++) { echo "groupnumber<br /> <input name='eno$i' type='text' value='$i'> Thumb <input name='thumb$i' type='text'> link1<br /> ";} ?> the insert code <? if(isset($_POST['submit']) && ($_POST['submit'] == "Submit")) { $con = mysql_connect("lalalalala"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("kiphi_main", $con); for ($i=1;$i<=$_POST[num];$i++) { $title="$eno$i"; $sql="INSERT INTO articles (title) VALUES ('$_POST[$title]')"; } } if (!mysql_query($sql,$con)) {echo testest;}?> problem is i cant get it to work... should i try a different approach?

tnx, its the first time i heard that statement (or i wasnt paying any attention to it)... i googled it and I think it should solve my problem... Tnx

i want to fetch contributors in adding certain articles... so its like select contributors from table where id=id the table looks like this. title contributor ---------------------------------- art1 me art2 me art3 you art4 me art5 you I then need to echo the contributors... what do i do so that it echoes one name only once, no duplicates... thanks. I tried searching google but im not sure about my keywords

ohhhh Tnx for telling me that!

preg_replace( '#width="([^/\.]+)"#', 'width="100%"', $flv); $flv: width="600" height="438" id="veohFlashPlayerEmbed" name="veohFlashPlayerEmbed"></embed></p> preg_replace replace "width="600" " to "width=100%" the problem is... it erases " height="438" id="veohFlashPlayerEmbed" name="veohFlashPlayerEmbed""

<?php $title="juni/ngats.co.nr/hehe"; if ($title==([^/\.]+)/ngats.([^/\.]+).nr/([^/\.]+)) { echo it works; } whats wrong here? is it the wildcard? what do i need to do? it says it has errors with [... and then if i remove [] it will point out an error on ^

i have this code SELECT COUNT(*) as num FROM videos where title=$title and if the title has punctuation marks for example "psssh's psh" it would interpret it like 'SELECT COUNT(*) as num FROM videos where title=psh's psh ' right? and then it shows this error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's psh ORDER by (eno+0) DESC' at line 2 i dont know what to do, i tried changing ' and "... and adding ' and " also... i also need something that with work with other symbols like & / * etc.

^ thanks this works... was a big help giving out a suggestion instantly =D

problem is... it would not accept / as a delimiter and it doesnt want alphanumeric and backslashes...

the format of the initial link is http://bs.something.com/gghs-hc/09889/1442/importantparthere i want it to look like http://something.com/v/importantparthere i want to remove gghs-hc/09889/1442 (which are dynamic) i tried... $link = preg_replace( "http://bs.something.com/([^/\.]+)/([^/\.]+)/([^/\.]+)/", "http://www.something.com/v/", $link); but its having an error

im actually stuck with the checkboxes.... I echoed all the rows.... then placed checkboxes beside it...

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

how will i make ummm like.... I have an image field and a default image field.... if the image field is empty, get the default image field, and if both the image field and default image field is empty, echo no_image.gif.... but if image field has something in it, echo that thing and dont get the default image field and no_image.gif

I always get an error with this code... <?php $query="SELECT * FROM videos INNER JOIN alist ON videos.title=alist.title WHERE alist.title='$_GET[title]'"; $row = mysql_fetch_array($query)) { $title = str_replace( " ", "-", $row[title]); $eno = str_replace( " ", "-", $row[eno]); $title = str_replace( ".", "", $row[title]); $eno = str_replace( ".", "", $row[eno]); echo "if ($row['thumb'] == "") { while($r = mysql_fetch_array($result)) { echo "$r[lthumb]"; if ($r[lthumb] == "") { echo "http://www.janime.tv/banner.gif"; } else { echo "{$row[thumb]}"; }}"; } ?> what im trying to do is if the thumb from videos is empty, i will get the specified thumb from alist, and if there is no thumb in alist i will set the default 'no_image' link

haha... sorry about that, I found the error... i have ] near eno... works perfectly now... thanks

syntax error, unexpected ']', expecting '}'

*looks for edit post link* how do i replace the spaces with hyphens with every row... not just the replaced string of the latest row on all the rows?

$title = str_replace( " ", "-", $row[title]); $eno = str_replace( " ", "-", $row[eno]); while($row = mysql_fetch_array($result)){ echo "<table width='100%' border='0' bgcolor='#3B3B3B'> <tr> <th width='8%' rowspan='2' scope='col'><img src='$row[thumb]' alt='thumb' width='74' height='56' border='1'></th> <th width='92%' scope='col'><div align='left'><a href='http://janime.tv/{$row[page_id]}/{$title}/{$eno]}'>{$title} {$eno]}</a></div></th> </tr> <tr> <th scope='col'><div align='left'>watch anime</div></th> </tr> </table>"; } problem with this code is... for all the links only the latest row is used and replaced...

<input type="button" value="prompt box" name="B3" onClick="prompt('Prompt boxes allow the user to enter text or a value!','Enter your text here')"> I found this javascript prompt box code and thought that it would work great with my site, how do I use it with the following code to store data in my database? <?php $con = mysql_connect("host","user","pass"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("database", $con); $sql="INSERT INTO broken_links (r_title, page_id, r_date, r_expiry, r_message) VALUES ('$_GET[title]','$_GET[page_id]',NOW(), DATE_ADD(NOW(), INTERVAL 2 MONTH), $POST[r_message])"; if (!mysql_query($sql,$con)) { } echo "Your Report has been sent! thank you for sending a report, the administrators will fix it as soon as they see your report"; mysql_close($con) ?>

<?php echo $row[date]; ?> i use the code above to get the time and date the content on my pages are uploaded, but it shows the default timestamp... how do i make it to look like "feruary 19, 1992 5:38pm"?